×

Systems and Methods of Increasing Database Access Concurrency Using Granular Timestamps

  • US 20140006458A1
  • Filed: 06/04/2013
  • Published: 01/02/2014
  • Est. Priority Date: 06/04/2012
  • Status: Active Grant
First Claim
Patent Images

1. A method of reading and writing data from a database table that has a plurality of rows, each row comprising a primary key and a plurality of non-key columns, wherein each non-key column comprises one or more column values, each column value has an associated timestamp that identifies when the associated column value was stored, and the timestamps associated with the column values in each non-key column provide a unique order for the column values that comprise the non-key column, the method comprising:

  • initiating a read transaction to read from a first non-key column of a first row in the database table, including determining that a write transaction is in progress that is updating a second non-key column of the first row in the database table, wherein the second non-key column is distinct from the first non-key column and the write transaction holds a lock on the second non-key column of the first row of the database table; and

    concurrently reading the data from the first non-key column and writing a new column value to the second non-key column.

View all claims
  • 2 Assignments
Timeline View
Assignment View
    ×
    ×