Please download the dossier by clicking on the dossier button x
×

Database system with transaction control block index

  • US 9,824,134 B2
  • Filed: 11/25/2014
  • Issued: 11/21/2017
  • Est. Priority Date: 11/25/2014
  • Status: Active Grant
First Claim
Patent Images

1. A method for implementation by one or more hardware data processors forming part of at least one computing device, the method comprising:

  • handling a first transaction in a database, the first transaction comprising a plurality of operations on at least a first record in the database, and the first transaction being handled concurrently with at least a second transaction;

    assigning, to the first record, a first timestamp, the first timestamp being a temporary timestamp corresponding to the first transaction, the first timestamp being converted from the temporary timestamp to a final timestamp by at least performing a commit operation with respect to the first transaction, and the converting from the temporary timestamp to the final timestamp comprising;

    entering a commit lock;

    determining a commit timestamp by at least increasing, by a first increment, the value of the commit timestamp generator;

    issuing a write memory barrier;

    setting, based at least on the commit timestamp, the final timestamp for the first record;

    increasing, by a second increment, the value of the commit timestamp generator value; and

    releasing the commit lock; and

    determining that the first record is available as part of a consistent view for the second transaction, the determining being based at least on a second timestamp of the consistent view being higher than the first timestamp of the first record; and

    in response to determining that the first record is available as part of the consistent view for the second transaction, including the first record in the consistent view for the second transaction, the inclusion of the first record in the consistent view enabling the first record to be accessed by the second transaction.

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