Patent ID: 8266101

Claim:
A method for replicating a table in a source database to a target database in real time in active-active topology, comprising: executing a Data Manipulation Language (DML) from a session to the source database to produce one or more row change data; receiving the row change data before a commit statement is issued from the session of the source database; determining if the row change data of the table is replicated data by examining the change data source origin information signal; clearing the signal if session level signal scope is not used and if the said determining step indicates that the row change data is replicated data; if the said determining step indicates that the row change data is not replicated data, if the target database is online, and if session level signaling scope is not used: sending a signal where the target database can read it; if the said determining step indicates that the row change data is not replicated data, and if the target database is online: applying the row change data to the table in the target database via a distributed transaction processing service that lets the client coordinate updates across two or more databases and treat those transactions as a single transaction; if the said determining step indicates that the row change data is not replicated data and if the target database is offline, passive or maintenance state: logging the row change data.