SYSTEM AND METHOD FOR SYNCHRONIZING DATA RECORDS BETWEEN MULTIPLE DATABASES
First Claim
1. A method of synchronizing data records stored in a first and second database, comprising the steps of:
- associating a pair of synchronization parameters with each data record stored in the first and second databases, the pair including a first synchronization parameter associated with the first database, and a second synchronization parameter associated with the second database;
updating a data record at the first database;
incrementing the first synchronization parameter associated with the updated data record at the first database;
transmitting a first update message from the first database to the second database, the first update message including the incremented first synchronization parameter, the second synchronization parameter, and the updated data record from the first database;
receiving the first update message at the second database; and
updating the data record at the second database using the information from the first update message.
2 Assignments
0 Petitions
Accused Products
Abstract
A system and method for synchronizing data records between multiple databases is provided. Each database includes data records that are modified to include at least one pair of synchronization parameters. In a two-database system including a first database and a second database, each data record is modified to include synchronization parameters for both the first and second databases. When an update is made to a data record at one of the databases, an update message is transmitted to the other database including both synchronization parameters from the database where the update is made, along with the updated data record. An efficient master-slave configuration between the databases then enables either database to resolve conflicts without further communications. The system and method scale to systems having more than two databases by modifying the data records in at least one of the databases to include a pair of synchronization parameters for each of the other databases to which it is being synchronized, and by providing a multi-level master-slave configuration. The system and method permits the ability to add and delete records and to securely communicate between all synchronized databases.
-
Citations
1 Claim
-
1. A method of synchronizing data records stored in a first and second database, comprising the steps of:
-
associating a pair of synchronization parameters with each data record stored in the first and second databases, the pair including a first synchronization parameter associated with the first database, and a second synchronization parameter associated with the second database; updating a data record at the first database; incrementing the first synchronization parameter associated with the updated data record at the first database; transmitting a first update message from the first database to the second database, the first update message including the incremented first synchronization parameter, the second synchronization parameter, and the updated data record from the first database; receiving the first update message at the second database; and updating the data record at the second database using the information from the first update message.
-
Specification