×

Index page with latch-free access

  • US 10,558,636 B2
  • Filed: 04/27/2016
  • Issued: 02/11/2020
  • Est. Priority Date: 04/27/2016
  • Status: Active Grant
First Claim
Patent Images

1. A computer-implemented method, comprising:

  • receiving a request from a read query to access one or more records of a database table implementing an index on one or more columns of the table, wherein the index comprises an index page that includes a slot array and a header comprising an update pointer;

    locating one or more updates prepended to the index page by locating a most recently prepended update indicated by the update pointer;

    generating a local offset table with entries updates in the slot array and the located one or more updates;

    determining an isolation level that indicates whether the read query is precluded from accessing new prepended updates received after the read query; and

    providing latch-free access to the one or more records to the read query from the local offset table based on the isolation level, wherein an update query has concurrent access to the one or more records;

    while performing the accessing, concurrently applying an update from an update query by prepending the update to the located one or more updates;

    determining to regenerate the local offset table for the read query based on the isolation level and information of each prepended update; and

    maintaining the generated local offset table when the isolation level precludes reading the prepended update or records requested by the read access are absent from the information,wherein at least one of the receiving, locating, generating, and accessing are performed by one or more computers.

View all claims
  • 1 Assignment
Timeline View
Assignment View
    ×
    ×