APPARATUS AND METHOD FOR LOG BASED REPLICATION OF DISTRIBUTED TRANSACTIONS USING GLOBALLY ACKNOWLEDGED COMMITS

• US 20090217274A1
• Filed: 02/26/2008
• Published: 08/27/2009
• Est. Priority Date: 02/26/2008
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: GoldenGate Software, Inc. (Oracle Corporation)
• Inventors: SHEPHERD, Joel, CORBIN, Scott Roger, PAREEK, Alok, McALLISTER, Chris
• Granted Patent: US 8,650,155 B2
• Time in Patent Office: Days
• US Class Current: 718/101
• CPC Class Codes: G06F 16/2358 Change logging, detection, and notification replication G06F16/27
• CPC Class Codes: G06F 16/2379 Updates performed during online database operations; commit processing
• CPC Class Codes: G06F 16/2471 Distributed queries
• CPC Class Codes: G06F 9/466 Transaction processing

Abstract

A computer readable storage medium includes executable instructions to read source node transaction logs to capture transaction data, including local transaction data, global transaction identifiers and participating node data. The global transaction identifiers and participating node data are stored in target node queues. The target node queues are accessed to form global transaction data. Target tables are constructed based upon the local transaction data and the global transaction data.

Claims

1. A computer readable storage medium, comprising executable instructions to:

read source node transaction logs to capture transaction data, including local transaction data, global transaction identifiers and participating node data;

store the global transaction identifiers and participating node data in target node queues;

access target node queues to form global transaction data; and

construct target tables based upon the local transaction data and the global transaction data.

2. The computer readable storage medium of claim 1 wherein the source node transaction logs are processed with data capture modules.

3. The computer readable storage medium of claim 1 further comprising executable instructions to apply the global transaction identifiers and participating node data to transaction logs via a marker table.

4. The computer readable storage medium of claim 1 further comprising executable instructions to form a persistent queue comprising commit-ordered local transactions and associated global transaction identifiers and participating node data.

5. The computer readable storage medium of claim 1 wherein the executable instructions to access include executable instructions to access target node queues via a network.

6. The computer readable storage medium of claim 1 further comprising executable instructions to process the global transaction identifiers to globally acknowledge receipt of all local transactions.

7. The computer readable storage medium of claim 1 further comprising executable instructions to preserve transaction information and read positions within the target node queues to facilitate data recovery.

8. The computer readable storage medium of claim 1 further comprising executable instructions to identify that an entire global transaction is represented across the target node queues.

9. The computer readable storage medium of claim 1 further comprising executable instructions to implement a two-phase commit protocol to ensure that no local transactions are committed until locks are acquired for each local transaction on each node.

10. The computer readable storage medium of claim 1 further comprising executable instructions to facilitate log based replication of homogenous distributed source nodes.

11. The computer readable storage medium of claim 1 further comprising executable instructions to facilitate log based replication of heterogeneous distributed source nodes.

12. The computer readable storage medium of claim 1 further comprising executable instructions to halt data replication at target nodes for target side transactional consistency at a specified point in time.

13. The computer readable storage medium of claim 1 further comprising executable instructions to construct target tables in a homogenous distributed target system.

14. The computer readable storage medium of claim 1 further comprising executable instructions to construct target tables in a heterogeneous distributed target system.

15. The computer readable storage medium of claim 1 further comprising executable instructions to construct target tables in a non-distributed target system.

16. The computer readable storage medium of claim 1 further comprising executable instructions to construct target tables in a target system that does not support two-phase commit semantics.