Importance

Loading Importance Indicators...

Abstract

A system and method are directed towards providing a database replication technique using interception in memory of the transaction change data records. The invention employs Input/Output instrumentation to capture and split out the in memory transaction change journal records. Captured memory blocks are sent to a parser, which concatenates the records into a single record, and creates a redo/undo vector that can be converted to original DML/DDL statements. Source level transformations can be applied to the vectors, which are then sent to a post agent on the same or a different computing device. The post agents may perform destination level transformations, and generate DML/DDL statements to be executed by the corresponding destination RDBMS instance. Post agents may also perform conflict detection and resolution during DML/DDL statement executions. Transaction consistency is supported by performing commits/rollback on the destination after receiving the redo/undo vector representing a commit/rollback on the source.

Loading the Abstract Image...

First Claim