Invention Grant
- Patent Title: Systems and methods of increasing database access concurrency using granular timestamps
-
Application No.: US13909928Application Date: 2013-06-04
-
Publication No.: US09747310B2Publication Date: 2017-08-29
- Inventor: Wilson Cheng-Yi Hsieh , Alexander Lloyd , Eric Hugh Veach
- Applicant: Google Inc.
- Applicant Address: US CA Mountain View
- Assignee: GOOGLE INC.
- Current Assignee: GOOGLE INC.
- Current Assignee Address: US CA Mountain View
- Agency: Morgan, Lewis & Bockius LLP
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/30

Abstract:
A method reads and writes data from a database table. Each row in the table has a primary key and multiple non-key columns. Each non-key column has one or more column values, and each column value has an associated timestamp that identifies when the column value was stored. The timestamps associated with the column values in each non-key column provide a unique order for the column values. A read transaction is initiated to read from a first non-key column of a first row. A write transaction is in progress that is updating a second non-key column of the first row, where the second non-key column is distinct from the first non-key column. The write transaction holds a lock on the second non-key column of the first row. The method concurrently reads the data from the first non-key column and writes a new column value to the second non-key column.
Public/Granted literature
- US20140006458A1 Systems and Methods of Increasing Database Access Concurrency Using Granular Timestamps Public/Granted day:2014-01-02
Information query