Transforming transactions to increase parallelism when replicating
AssigneeOracle International Corporation
InventorsJoydip Kundu, Mahesh Girkar
Life of this patent
Estimating the term…
Abstract
Techniques are provided for replicating data on computer systems, including database systems. The operations of a group of transactions are rearranged to be executed in another set of transactions. A transaction in the other set of transactions may be executed independently of the timing of the execution of any other transaction from the set, so long as the set is committed as a group.
Claims22
A computer-implemented method for replicating operations of transactions, the method comprising the steps of:
- arranging a plurality of operations in a first plurality of transactions into groups of operations;
- executing each group of said groups of operations in a particular transaction of a second plurality of transactions;
- wherein each group of said groups is executed independently of when any other group from said groups of operations is executed;
- wherein said plurality of operations include a first operation and a second operation in one transaction of said first plurality of transactions;
- wherein a transaction of said second plurality of transactions includes said first operation but does not include said second operation;
- wherein a transaction of said second plurality of transactions includes said second operation but does not include said first operation;
- and
- after executing the second plurality of transactions, causing all of said second plurality of transactions to be committed as a group.
A computer-readable medium carrying one or more sequences of instructions for replicating operations of transactions, wherein execution of the one or more sequences of instructions by one or more processors causes the one or more processors to perform the steps of:
- arranging a plurality of operations in a first plurality of transactions into groups of operations;
- executing each group of said groups of operations in a particular transaction of a second plurality of transactions;
- wherein each group of said groups is executed independently of when any other group from said groups of operations is executed;
- wherein said plurality of operations include a first operation and a second operation in one transaction of said first plurality of transactions;
- wherein a transaction of said second plurality of transactions includes said first operation but does not include said second operation;
- wherein a transaction of said second plurality of transactions includes said second operation but does not include said first operation;
- and
- after executing the second plurality of transactions, causing all of said second plurality of transactions to be committed as a group.
Dependencies are inferred from the claim text.