Apparatus and method for log based replication of distributed transactions using globally acknowledged commits

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.

Description

FIELD OF THE INVENTION[0001]This invention relates generally to the replication of data in a networked environment. More particularly, this invention relates to log based replication of distributed transactions using globally acknowledged commits.BACKGROUND OF THE INVENTION[0002]In a distributed database system, operations associated with a transaction can be submitted at multiple nodes or sites. The transaction is an atomic unit of work that is either fully submitted or entirely rolled back in the database for recovery and consistency reasons. Most transactional managers within a distributed database system implement some variation of a two-phase commit protocol. A two-phase commit protocol is a distributed algorithm that specifies when all nodes in a distributed system agree to commit a transaction. The protocol results in either all nodes committing the transaction or aborting, even in the case of network failures or node failures. The two phases of the algorithm are the commit-r...

AI Technical Summary

Benefits of technology

The patent describes a system for creating a computer database of transaction data from a computer network. The system captures data from different sources and stores it in a target node queue. This data is then used to create a global table that includes information about the transaction, such as identifiers and participating node data. The technical effect of this invention is the improved ability to capture and utilize transaction data from different sources, making it easier to create a comprehensive and accurate dataset.

Problems solved by technology

The protocol results in either all nodes committing the transaction or aborting, even in the case of network failures or node failures.

In the absence of such methods, partial changes from one or additional (but not all) sites may be reflected in the target database system thereby breaking transactional consistency.

Images