DISTRIBUTED DATABASE TRANSACTION PROTOCOL
First Claim
1. A method, implemented at least in part by a coordinator node comprising a processing unit and memory, the coordinator node being in communication with a first worker node and at least a second worker node, for facilitating database transaction processing within a database environment, the method comprising:
- receiving local transaction tokens from the first and the at least a second worker nodes;
determining a synchronized transaction token using at least the local transaction tokens from the first and the at least a second worker nodes; and
sending the synchronized transaction token to the first and the at least a second worker nodes.
1 Assignment
0 Petitions
Accused Products
Abstract
Technologies are described for facilitating transaction processing within a database environment having a coordinator node, a first worker node, and at least a second worker node. The coordinator node receives local transaction tokens from the first and the at least a second worker nodes. The coordinator nodes determines a synchronized transaction token using at least the local transaction tokens from the first and the at least a second worker nodes. The coordinator node sends the synchronized transaction token to the first and the at least a second worker nodes.
-
Citations
20 Claims
-
1. A method, implemented at least in part by a coordinator node comprising a processing unit and memory, the coordinator node being in communication with a first worker node and at least a second worker node, for facilitating database transaction processing within a database environment, the method comprising:
-
receiving local transaction tokens from the first and the at least a second worker nodes; determining a synchronized transaction token using at least the local transaction tokens from the first and the at least a second worker nodes; and sending the synchronized transaction token to the first and the at least a second worker nodes. - View Dependent Claims (2, 3, 4, 5, 6)
-
-
7. A server comprising a processing unit and memory, wherein the server is configured to operate a first worker node of a database system, the first worker node being in communication with a coordinator node, and the database system further including at least a second worker node, wherein the server is further configured to perform database transaction processing comprising:
-
for each of multiple periodic intervals; retrieving a local transaction token maintained by the first worker node; sending the local transaction token to the coordinator node; and receiving a synchronized transaction token from the coordinator node; receiving a multi-node database statement; determining the local transaction token based at least in part on the synchronized transaction token received from the coordinator node; and after determining the local transaction token for a defined number of times, the defined number of times being at least one time, executing the multi-node database statement, wherein the determined local transaction token indicates data versions visible during the execution of the multi-node database statement. - View Dependent Claims (8, 9, 10, 11, 12, 13, 14, 15)
-
-
16. One or more tangible computer-readable media storing computer-executable instructions for causing a server programmed thereby to perform database transaction processing within a database environment using data manipulation language (DML) statements, the server implementing a first worker node of a database system, the first worker node being in communication with a coordinator node, and the database system further including at least a second worker node, the database transaction processing comprising:
-
receiving a multi-node database statement; without waiting to synchronize a local transaction token maintained by the first worker node with a global transaction token maintained by the coordinator node, executing the multi-node database statement, wherein the local transaction token indicates data versions visible during the execution of the multi-node database statement; forwarding at least a portion of the multi-node database statement to the at least a second worker node; and receiving execution results from the execution of the at least a portion of the multi-node database statement at the at least a second worker node. - View Dependent Claims (17, 18, 19, 20)
-
Specification