The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Jun. 04, 2013
Filed:
Jun. 23, 2008
Kapil Surlaker, Santa Clara, CA (US);
Ravi Krishnamurthy, Sunnyvale, CA (US);
Krishnan Meiyyappan, Fremont, CA (US);
Alan Beck, Campbell, CA (US);
Hung Tran, Sunnyvale, CA (US);
Jeremy Branscome, Santa Clara, CA (US);
Joseph I. Chamdani, Santa Clara, CA (US);
Kapil Surlaker, Santa Clara, CA (US);
Ravi Krishnamurthy, Sunnyvale, CA (US);
Krishnan Meiyyappan, Fremont, CA (US);
Alan Beck, Campbell, CA (US);
Hung Tran, Sunnyvale, CA (US);
Jeremy Branscome, Santa Clara, CA (US);
Joseph I. Chamdani, Santa Clara, CA (US);
Teradata US, Inc., Dayton, OH (US);
Abstract
Embodiments of the present invention provide fine grain concurrency control for transactions in the presence of database updates. During operations, each transaction is assigned a snapshot version number or SVN. A SVN refers to a historical snapshot of the database that can be created periodically or on demand. Transactions are thus tied to a particular SVN, such as, when the transaction was created. Queries belonging to the transactions can access data that is consistent as of a point in time, for example, corresponding to the latest SVN when the transaction was created. At various times, data from the database stored in a memory can be updated using the snapshot data corresponding to a SVN. When a transaction is committed, a snapshot of the database with a new SVN is created based on the data modified by the transaction and the snapshot is synchronized to the memory. When a transaction query requires data from a version of the database corresponding to a SVN, the data in the memory may be synchronized with the snapshot data corresponding to that SVN.