11,681,686 - Systems and methods to fully process an initially incomplete replicated and committed transaction
Abstract:Methods and apparatus are provided to fully process an initially incomplete replicated and committed transaction. A transaction pattern table is provided that includes a plurality of records, each record being defined by a transaction pattern identifier. Each record includes a transaction pattern and a metric of occurrence of the transaction pattern. An incomplete transaction is automatically compared to the transaction patterns in the table and a subset of transaction patterns in the table are identified that are potential candidates for matching the incomplete transaction. The incomplete transaction is categorized using the metric of occurrence of the transaction pattern for each transaction pattern in the subset. The categorization predicts when all steps or operations of the transaction which have completed in the source database have been replicated, and the incomplete transaction is committed based on this prediction. Any additional steps or operations which have completed in the source database for the committed incomplete transaction are processed as a new transaction applied to the target database, thereby fully processing the incomplete transaction.