Distributed transaction management for database systems with multiversioning

摘要

The subject disclosure relates to a distributed transaction management technique that ensures synchronization between participating nodes in a global or distributed database transaction. The technique leverages a commit protocol that uses local clocks at the respective participating nodes. Participants in a global transaction are configured to utilize the same commit timestamp and logical read time and can advance their respective local clocks to establish this synchronization. In one embodiment, distributed commit utilizes a modified version of two-phase commit that includes an extra phase to collect commit timestamp votes from participants. Additionally, a heartbeat mechanism can be used to establish loose synchronization between nodes. In another embodiment, a node can respond to a remote transaction request by returning a list of nodes involved in generating the result of the transaction and the types of access used by such nodes in addition to the transaction result itself.

主权项

1. A transaction management system, comprising:
logic configured to:
collect commit time votes from a plurality of nodes that participate in a transaction,facilitate synchronization of a commit timestamp used by the plurality of nodes based at least in part on the commit time votes, wherein the commit timestamp is used by the plurality of nodes in committing the transaction to enforce atomicity of the transaction, andfacilitate synchronization of a plurality of local clocks associated with the plurality of nodes in conformance with the commit timestamp; and at least one processing unit configured to execute the logic.