Method and system for managing a distributed transaction process
First Claim
1. A method for synchronizing a first database with a second database, comprising:
- logging a first set of discrepancy transactions, wherein the first set of discrepancy transactions are a set of transactions reflected in the second database that are not reflected in the first database;
updating the first database to reflect the first set of discrepancy transactions while continuing to accept additional transactions to the second database, wherein, while the first database is being updated to reflect the first set of discrepancy transactions, the first database does not accept the additional transactions;
logging the additional transactions accepted to the second database as a second set of discrepancy transactions;
determining whether a discrepancy between the first database that has been updated to reflect the first set of discrepancy transactions and the second database that has accepted the additional transactions is met by a configurable threshold; and
when the discrepancy is met by the configurable threshold;
halting accepting transactions to the second database,completing the updating of the first database to reflect the second set of discrepancy transactions, andresuming accepting transactions to the second database and the first database.
7 Assignments
0 Petitions
Accused Products
Abstract
Systems and methods for managing a distributed transaction process include an active transaction manager that manages transactions with an active database, a latent transaction manager that manages transactions with a merge database, a transaction log that reflects the set of transactions in the active database that are not affiliated with the transactions in the merge database, and a merge manager that uses the transaction log to determine whether to transfer control of the merge database to the active transaction manager. Systems and methods may further instruct the active transaction manager to halt transactions with the active database while the merge database is updated to reflect a set of transactions affiliated with the set of transactions in the transaction log, and instruct the active transaction manager to subsequently manage transactions to the active database and the merge database.
-
Citations
26 Claims
-
1. A method for synchronizing a first database with a second database, comprising:
-
logging a first set of discrepancy transactions, wherein the first set of discrepancy transactions are a set of transactions reflected in the second database that are not reflected in the first database; updating the first database to reflect the first set of discrepancy transactions while continuing to accept additional transactions to the second database, wherein, while the first database is being updated to reflect the first set of discrepancy transactions, the first database does not accept the additional transactions; logging the additional transactions accepted to the second database as a second set of discrepancy transactions; determining whether a discrepancy between the first database that has been updated to reflect the first set of discrepancy transactions and the second database that has accepted the additional transactions is met by a configurable threshold; and when the discrepancy is met by the configurable threshold; halting accepting transactions to the second database, completing the updating of the first database to reflect the second set of discrepancy transactions, and resuming accepting transactions to the second database and the first database. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13)
-
-
14. A system for synchronizing a first database with a second database, comprising:
-
a first database; a second database; and a processor, wherein the processor is configured to access the first database and the second database, including the operations of; logging a first set of discrepancy transactions, wherein the first set of discrepancy transactions are a set of transactions reflected in the second database that are not reflected in the first database; updating the first database to reflect the first set of discrepancy transactions while continuing to accept additional transactions to the second database, wherein, while the first database is being updated to reflect the first set of discrepancy transactions, the first database does not accept the additional transactions; logging the additional transactions accepted to the second database as a second set of discrepancy transactions; determining whether a discrepancy between the first database that has been updated to reflect the first set of discrepancy transactions and the second database that has accepted the additional transactions is met by a configurable threshold; and when the discrepancy is met by the configurable threshold; halting accepting transactions to the second database, completing the updating of the first database to reflect the second set of discrepancy transactions, and resuming accepting transactions to the second database and the first database. - View Dependent Claims (15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26)
-
Specification