System and method for synchronizing data in multiple databases
First Claim
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.
3 Assignments
0 Petitions
Accused Products
Abstract
A system, method, and processor readable medium containing code for causing a processor to synchronize a secondary database system, such as one stored on a palmtop electronic device, with a distributed database system, comprising a main database and at least one replica database. The system further comprises a modification module that contains entries for modifications that have been made to the secondary database since a previous synchronization between the secondary database and the distributed database system and a synchronization module that synchronizes the secondary database with one of the databases of the distributed database system using the modification module. Each database in the distributed database system stores an identification mapping database having an assigned version number. The system further comprises a replica identification database associated with the secondary database that contains an entry for each source database of the distributed database system, each entry comprising information regarding the last synchronization between the secondary database and the source database including the version of the identification mapping database associated with the source database when the synchronization occurred. A pruning module is provided for pruning entries from the modification module using the replication identification database.
-
Citations
22 Claims
-
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 Dependent Claims (2, 3, 4, 5, 6, 7)
-
-
8. A system for synchronizing data between one or more secondary systems and a distributed system comprising:
-
a distributed database means 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 means 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 Dependent Claims (9, 10, 11, 12, 13, 14)
-
-
15. A method for synchronizing data between one or more secondary systems and a distributed system, the method comprising:
-
providing 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;
providing one or more secondary databases 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;
providing 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;
providing at least one identification database, the 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
utilizing 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 Dependent Claims (16, 17, 18)
-
-
19. A processor readable medium having code embodied therein for synchronizing data between one or more secondary systems and a distributed system, the medium comprising:
-
code for causing a processor to access 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;
code for causing a processor to access one or more secondary databases 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;
code for causing a processor to access 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;
code for causing a processor to access at least one identification database, the 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
code for causing a processor to utilize 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 Dependent Claims (20, 21, 22)
-
Specification