Snapshot isolation support for distributed query processing in a shared disk database cluster
AssigneeSybase, Inc.
InventorsSurendra Kumar Vishnoi, Colin Florendo
Life of this patent
Estimating the term…
Abstract
System, method, computer program product embodiments and combinations and sub-combinations thereof for snapshot isolation support for distributed query processing in a shared disk database cluster are provided. The embodiments include the forming of object identification data in a leader node of query execution in the shared disk database cluster. At least one fragment of the query execution is distributed to at least one worker node in the shared disk database cluster, and the object identification data is utilized for multiversion concurrency control during query execution by the leader node and at least one worker node.
Claims17
A method for snapshot isolation support for distributed query processing in a shared disk database cluster, the method comprising:
- forming object identification data in a leader node of query execution in a shared disk database cluster;
- distributing at least one fragment of the query execution to at least one worker node in the shared disk database cluster;
- and
- utilizing the object identification data for multiversion concurrency control during query execution by the leader node and at least one worker node, wherein the obiect identification data includes an object identifier, an object version identifier, and an update identifier, and wherein the update identifier is an unique update number within a transaction corresponding to the object version identifier.
A shared disk database cluster (SDC) system with snapshot isolation support for distributed query processing comprising:
- shared-disk storage;
- and
- a plurality of data processing nodes coupled to the shared disk storage and including a leader node of query execution that forms object identification data and distributes at least one fragment of the query execution to at least one worker node, the object identification data utilized for multiversion concurrency control during query execution by the leader node and at least one worker node, wherein the object identification data includes an object identifier, an object version identifier, and an update identifier, and wherein the update identifier is an unique update number within a transaction corresponding to the object version identifier.
A non-transitory computer-usable medium having instructions recorded thereon that, if executed by a computing device, cause the computing device to perform a method comprising:
- forming object identification data in a leader node of query execution in a shared disk database cluster;
- distributing at least one fragment of the query execution to at least one worker node in the shared disk database cluster;
- and
- utilizing the object identification data for multiversion concurrency control during query execution by the leader node and at least one worker node for snapshot isolation support in the shared disk database cluster, wherein the object identification data includes an object identifier, an object version identifier, and an update identifier, and wherein the update identifier is an unique update number within a transaction corresponding to the object version identifier.
Dependencies are inferred from the claim text.