Patent ID: 7111023

Claim:
A method for synchronous change data capture, comprising the steps of: generating a transaction identifier for each transaction in a plurality of transactions that uniquely identifies each transaction; for each operation in a transaction, recording change data for the operation, transaction identifier for the transaction, and an identifier to identify a relative ordering of each operation in the transaction in a first database object wherein at least one of the transactions include a plurality of operations; during a commit of the transaction, recording the transaction identifier and a system change number in a second database object, wherein the system change number indicates a timing of the commit that is later than a previously committed transaction; and associating the change data in the first database object with the system change number in the second database object based on the transaction identifier by performing a join operation on the first database object and the second database object, and wherein the join operation puts the change data in the first database into an order based on when the operation for each change data in the first database occurred.