×

System and method for synchronizing data in multiple databases

  • US 6,516,327 B1
  • Filed: 09/24/1999
  • Issued: 02/04/2003
  • Est. Priority Date: 12/24/1998
  • Status: Expired due to Term
First Claim
Patent Images

1. A system for synchronizing data between one or more secondary systems and a distributed system comprising:

  • a distributed database system comprising one or more main databases and one or more replica databases, the one or more main databases comprising a plurality of main database records, and the one or more replica databases comprising plurality of replica database records;

    one or more secondary databases provided on a secondary database systems connectable to the distributed database system, wherein the one or more secondary databases comprise a plurality of secondary database records, each secondary database record corresponding to the corresponding at least one main database record and at least one replica database record;

    at least one modification database stored on the one or more secondary systems, the modification database comprising an entry corresponding to the main database record, the replica database record, and the corresponding secondary database record, the entry further comprising an update indicator for indicating whether the record has been updated since a prior synchronization between the one or more main, replica and secondary databases;

    at least one identification database comprising an identification number and a version number for each main, replica and secondary database record, wherein the identification database maps at least two records of the main, replica and secondary database records using the identification numbers and the version numbers; and

    one or more synchronization modules that synchronize records in the one or more main, replica and secondary databases with the distributed database system using the mapped records in the identification tables.

View all claims
  • 3 Assignments
Timeline View
Assignment View
    ×
    ×