US 8,554,728 B2Granted

Method and system for managing a distributed transaction process

AssigneeACS State & Local Solutions, Inc.

InventorsKevin Zou, Josh A. Wiles, Pasquale Solitro, Zheng Zhu

Life of this patent

Estimating the term…

Loading patent…

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.

Claims26

Dependent claims

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.

6 more elements

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.

9 more elements

Dependencies are inferred from the claim text.

Facts

Application: 12/318,688Filed 6 Jan 2009 · continuation
Priority: 1 Oct 2002
Published: US 2009/0177709 A19 Jul 2009
Granted: 8 Oct 2013
Term ends: Not estimatedThe source records don’t support an estimate.

Classification4 codes

G06F 16/27
Of structured data, e.g. relational data: replication, distribution or synchronisation of data between databases or within a distributed database…
Y10S 707/99955
Coherency, e.g. same view to multiple users: archiving or backup
G06F
Computing and data processing
Y10S
Technical subjects covered by former uspc cross-reference art collections [xracs] and digests

Family

Application60/414,645Us provisional application · filed 1 Oct 2002
Application60/430,941Us provisional application · filed 5 Dec 2002
Application10/650,994Parent of this continuation · filed 29 Aug 2003
US 2009/0177709 A1Pre-grant publication · published 9 Jul 2009
US 7,587,434 B2Parent of this continuation
US 2004/0088298 A1Published application
US 7,493,348 B2Related patent
US 8,554,728 B2This patent

From the US filing history. Foreign family members aren’t listed.