Patent ID: 7222141

Claim:
A system for synchronizing data records between a secondary database and a distributed database system comprising: one or more processors; a distributed database system comprising at least two source databases including at least one main database having a plurality of records, and at least one replica database having a subset of one or more records of the plurality of records contained in the main database, and further identifying each record within the source databases using a source database record identifier; a secondary database including one or more records that are each record identified by a secondary database record identifier, wherein one or more of the secondary database records corresponds to a record within each source database; an identification mapping database associated with each source database, the identification mapping database including a mapping table for associating secondary database record identifiers to corresponding source database record identifiers; a replica identification database associated with the secondary database that contains an entry for each respective source database, each entry comprising information regarding a last synchronization between the secondary database and the respective source database including a time when the last synchronization occurred; a delta modification database identifying and storing information including the secondary database record identifier corresponding to the one or more records of the secondary database that have been modified since the last synchronization between the secondary database and each source database according to the replica identification database, wherein the stored information for each identified record that has been modified since the last synchronization further includes an action flag that describes an action taken on the identified record; and a synchronization module that synchronizes records that are identified by the delta modification database into corresponding records within each source database based at least in part on the mapping table and the action flag, wherein the replica identification database is updated to include the time of synchronization and the delta modification database is updated to store version numbers of said synchronized records for said synchronization.