Synchronization of recurring records in incompatible databases
First Claim
1. A computer implemented method of synchronizing at least a first and a second database, wherein the manner of storing a set of recurring date bearing instances differs between the first and second databases, and at least the first database uses a recurring record to store the set of recurring date bearing instances, the method comprising:
- processing a plurality of non-recurring records in the second database to identify a set of non-recurring records storing a set of recurring date bearing instances in the second database;
performing a comparison of the set of non-recurring records of the first second database to a recurring record of the first database; and
completing synchronization based on the outcome of the comparison.
1 Assignment
0 Petitions
Accused Products
Abstract
A technique for synchronizing databases in which different techniques are used for storing a recurring event. A database in which the recurring event is, for example, stored as a single recurring record can be synchronized with a database in which the same recurring event is stored as a series of individual records. The individual records are processed to form a synthetic recurring record representing the set of individual records, and synchronization decisions are based on a comparison of the synthetic record to the recurring record of the other database. Following synchronization, the synthetic record can be “fanned” back into the individual records to update the database containing individual records, and the updated recurring record can be written back to the other database. In this way, the invention avoids the problems encountered with prior methods, in which synchronization resulted in a recurring record being transformed into a series of individual records.
150 Citations
58 Claims
-
1. A computer implemented method of synchronizing at least a first and a second database, wherein the manner of storing a set of recurring date bearing instances differs between the first and second databases, and at least the first database uses a recurring record to store the set of recurring date bearing instances, the method comprising:
-
processing a plurality of non-recurring records in the second database to identify a set of non-recurring records storing a set of recurring date bearing instances in the second database; performing a comparison of the set of non-recurring records of the first second database to a recurring record of the first database; and completing synchronization based on the outcome of the comparison. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23)
-
-
24. A computer program, resident on a computer readable medium, for synchronizing at least a first and a second database, wherein the manner of storing a set of recurring date bearing instances differs between the first and second databases, and at least the first database uses a recurring record to store the set of recurring date bearing instances, comprising instructions for:
-
processing a plurality of non-recurring records in the second database to identify a set of non-recurring records storing the set of recurring date bearing instances in the second database; performing a comparison of the set of non-recurring records of the first second database to a recurring record of the first database; and completing synchronization based on the outcome of the comparison. - View Dependent Claims (25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46)
-
-
47. A computer implemented method of synchronizing at least a first and a second database, wherein records in the first and second databases include a key field, the method comprising:
-
performing a first comparison of the content of the key field of the records of the first database with the content of the key field of the records of the second database; selecting a plurality of groups of records of the first and second databases based on the outcome of the first comparison; performing a second comparison of the records in one of the plurality of groups of records to determine a correspondence between a record of the first database in the one of the plurality of groups and a record of the second database in the one of the plurality of groups; performing a third comparison of the records in the determined correspondence; and completing the synchronization based on the outcome of the third comparison. - View Dependent Claims (48, 49, 50, 51, 52)
-
-
53. A computer program, resident on a computer readable medium, for synchronizing at least a first and a second database, wherein records in the first and second databases include a key field, comprising instructions for:
-
performing a first comparison of the content of the key field of the records of the first database with the content of the key field of the records of the second database; selecting a plurality of groups of records of the first and second databases based on the outcome of the first comparison; performing a second comparison of the records in one of the plurality of groups of records to determine a correspondence between a record of the first database in the one of the plurality of groups and a record of the second database in the one of the plurality of groups; performing a third comparison of the records in the determined correspondence; and completing the synchronization based on the outcome of the third comparison. - View Dependent Claims (54, 55, 56, 57, 58)
-
Specification