Distributed Transaction Management With Tokens

摘要

A system, method and computer product for managing distributed transactions of a database. A transaction manager is provided for each of a plurality of transactions of the database. Each transaction manager is configured to perform functions that include generating a transaction token that specifies data to be visible for a transaction on the database. The database contains both row and column storage engines, and the transaction token includes a transaction identifier (TID) for identifying committed transactions and uncommitted transactions. A last computed transaction is designated with a computed identifier (CID), record-level locking of records of the database is performed using the TID and CID to execute the transaction, and the plurality of transactions of the database are executed with each transaction manager.

主权项

1. A computer-implemented method for managing transactions of a database, the method comprising:
generating, by a transaction manager, a transaction token specifying that changes to the database by some of a plurality of transactions are visible to a transaction associated with the transaction manager and that changes to the database by others of the plurality of transactions are not visible to the transaction associated with the transaction manager, the transaction token including a maximum visible computed identifier for identifying a plurality of committed transactions and a plurality of uncommitted transactions; and performing record-level locking of records of the database using the transaction token to execute the transaction.