US5943676A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Synchronization of recurring records in incompatible databases
Assignee: Intellisync LLC
•
Filing: 1996-11-13
•
Granted: 1999-08-24
•
Expires: 2016-11-13
Abstract
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.
Inventors
- 👤 David J. Boothby
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-02 18:10
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/27; G06F16/273; Y; Y10; Y10S; Y10S707/00; Y10S707/99951; Y10S707/99952
Claims Analysis
Total Claims: 62
Claim 1
Independent Claim
115 words
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 database to a recurring record of the first database; and completing synchronization based on the outcome of the comparison.
Claim 2
Dependent Claim
115 words
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 database to a recurring record of the first database; and completing synchronization based on the outcome of the comparison.
Claim 3
Dependent Claim
25 words
The method of claim 1 wherein the step of completing synchronization includes adding, modifying, or deleting one of the synthetic recurring record and recurring record.
Claim 4
Dependent Claim
28 words
The method of claim 1 further comprising, after completing synchronization, storing the set of recurring date bearing instances in the second database as a plurality of non-recurring records.
Claim 5
Dependent Claim
39 words
The method of claim 1 further comprising, after completing synchronization, storing the set of recurring date bearing instances in the second database as a recurring record having a different record structure than the recurring record of the first database.
Claim 6
Dependent Claim
31 words
The method of claim 1 further comprising storing a history file containing a record representative of one of the recurring record and the set of non-recurring instances in a past synchronization.
Claim 7
Dependent Claim
47 words
The method of claim 5 further comprises performing a second comparison of one of the synthetic recurring record and the recurring record to the record representative of the recurring record or the set of non-recurring instances and completing synchronization based on the outcome of the second comparison.
Claim 8
Dependent Claim
68 words
The method of claim 1 wherein each recurring record and each non-recurring record includes a key field, and wherein the step of processing a plurality of non-recurring records in the second database further comprises: performing a second comparison of the key fields of the recurring and non-recurring records; and selecting a group of records from among the recurring and non-recurring records based on the outcome of the comparison.
Claim 9
Dependent Claim
34 words
The method of claim 7 wherein the step of selecting a group of records comprises selecting the group based on identity of the content of the key fields of the recurring and non-recurring records.
Claim 10
Dependent Claim
83 words
The method of claim 7 wherein each recurring record and each non-recurring record includes at least one other field, and wherein the step of processing a plurality of non-recurring records in the second database further comprises: performing a third comparison of the at least one other field of the non-recurring records in the group; selecting a set of non-recurring records based on the outcome of the third comparison; and correlating the set of non-recurring records to the recurring record of the first database.
Claim 11
Dependent Claim
40 words
The method of claim 9 wherein selecting the set of non-recurring records based on the outcome of the third comparison is based on identity of content of the at least one other field of the non-recurring records in the group.
Claim 12
Dependent Claim
74 words
The method of claim 1 wherein processing the plurality of non-recurring records further includes processing the plurality of non-recurring records to generate a synthetic recurring record representing the set of recurring date bearing instances in the second database, and wherein performing a comparison of the set of non-recurring records to a recurring record includes performing a comparison of the synthetic recurring record of the second database to the recurring record of the first database.
Claim 13
Dependent Claim
31 words
The method of claim 11 wherein, following the step of completing synchronization, one of the synthetic recurring record and recurring record is fanned back into a plurality of fanned non-recurring records.
Claim 14
Dependent Claim
61 words
The method of claim 11 wherein the synthetic recurring record has a list of excluded instances and the step of processing a plurality of non-recurring records in the second database to generate a synthetic recurring record further comprises generating a list of excluded instances representative of instances previously represented by the recurring record and currently represented by another record or deleted.
Claim 15
Dependent Claim
68 words
The method of claim 11 wherein the recurring record and the synthetic recurring record each contain a list of excluded date bearing instances, wherein the step of performing a comparison of the synthetic recurring record to the recurring record includes performing a comparison of the list of excluded date bearing instances of the recurring record with the list of excluded date bearing instances of the synthetic recurring record.
Claim 16
Dependent Claim
34 words
The method of claim 14 wherein the step of completing synchronization includes adding, modifying, or deleting the list of excluded date bearing instances of one of the recurring record and the synthetic recurring record.
Claim 17
Dependent Claim
25 words
The method of claim 14 wherein the step of completing synchronization includes adding, modifying, or deleting one of the synthetic recurring record and recurring record.
Claim 18
Dependent Claim
53 words
The method of claim 14 wherein, following the step of completing synchronization, one of the synthetic recurring record and recurring record is fanned into a plurality of fanned non-recurring records excluding the instances in the list of excluded date bearing instances of a corresponding one of the synthetic recurring record and recurring record.
Claim 19
Dependent Claim
29 words
The method of claim 11 further comprising storing a history file containing a record representative of one of the recurring record and synthetic recurring record in a past synchronization.
Claim 20
Dependent Claim
101 words
The method of claim 18 wherein the second database assigns a unique ID to each record, and wherein the method further comprises: fanning one of the synthetic recurring record and the recurring record into a plurality of fanned non-recurring records; storing records in the history file representative of the plurality of fanned non-recurring records; storing in the history file the unique IDs assigned by the second database to the plurality of fanned non-recurring records; and recording linkages among the records representative of the plurality of non-recurring records and the record representative of one of the recurring record and synthetic recurring record.
Claim 21
Dependent Claim
123 words
The method of claim 18 wherein the second database assigns unique IDs to each record, the history file further contains records representative of non-recurring records of the second database from a past synchronization and unique IDs assigned to the non-recurring records of the second database, and the step of processing a plurality of non-recurring records in the second database to generate a synthetic recurring record further comprises: performing a comparison of the unique IDs stored in the history file with unique IDs of the plurality of non-recurring records in the second database; and selecting a set of non-recurring records in the second database based on the comparison of the unique IDs and generating the synthetic recurring record using the set of non-recurring records.
Claim 22
Dependent Claim
42 words
The method of claim 20 wherein the step of selecting a set of non-recurring records further comprises selecting a set of non-recurring records in the second database having unique IDs matching a set of the unique IDs stored in the history file.
Claim 23
Dependent Claim
88 words
The method of claim 20 wherein one of the synthetic recurring record and the recurring record has an exclusion list and the step of selecting the set of non-recurring records comprises: selecting a set of records in the history file having unique IDs failing to match any of the unique IDs of non-recurring records in the second database; and adding, modifying, or deleting the exclusion list of at least one of the synthetic recurring record and the recurring record, using the set of records in the history file.
Claim 24
Dependent Claim
52 words
The method of claim 18 further comprises performing a second comparison of one of the synthetic recurring record and the recurring record to the history file record representative of the recurring record or the synthetic recurring record in the past synchronization, and completing synchronization based on the outcome of the second comparison.
Claim 25
Dependent Claim
120 words
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 database to a recurring record of the first database; and completing synchronization based on the outcome of the comparison.
Claim 26
Dependent Claim
120 words
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 database to a recurring record of the first database; and completing synchronization based on the outcome of the comparison.
Claim 27
Dependent Claim
26 words
The computer program of claim 24 wherein the instruction for completing synchronization includes adding, modifying, or deleting one of the synthetic recurring record and recurring record.
Claim 28
Dependent Claim
31 words
The computer program of claim 24 further comprising instructions for, after completing synchronization, storing the set of recurring date bearing instances in the second database as a plurality of non-recurring records.
Claim 29
Dependent Claim
42 words
The computer program of claim 24 further comprising instructions for, after completing synchronization, storing the set of recurring date bearing instances in the second database as a recurring record having a different record structure than the recurring record of the first database.
Claim 30
Dependent Claim
34 words
The computer program of claim 24 further comprising instructions for storing a history file containing a record representative of one of the recurring record and the set of non-recurring instances in a past synchronization.
Claim 31
Dependent Claim
50 words
The computer program of claim 28 further comprises instructions for performing a second comparison of one of the synthetic recurring record and the recurring record to the record representative of the recurring record or the set of non-recurring instances and completing synchronization based on the outcome of the second comparison.
Claim 32
Dependent Claim
71 words
The computer program of claim 24 wherein each recurring record and each non-recurring record includes a key field, and wherein the instruction for processing a plurality of non-recurring records in the second database further comprises instructions for: performing a second comparison of the key fields of the recurring and non-recurring records; and selecting a group of records from among the recurring and non-recurring records based on the outcome of the comparison.
Claim 33
Dependent Claim
37 words
The computer program of claim 30 wherein the instruction for selecting a group of records comprises instructions for selecting the group based on identity of the content of the key fields of the recurring and non-recurring records.
Claim 34
Dependent Claim
86 words
The computer program of claim 30 wherein each recurring record and each non-recurring record includes at least one other field, and wherein the instruction for processing a plurality of non-recurring records in the second database further comprises instruction for: performing a third comparison of the at least one other field of the non-recurring records in the group; selecting a set of non-recurring records based on the outcome of the third comparison; and correlating the set of non-recurring records to the recurring record of the first database.
Claim 35
Dependent Claim
41 words
The computer program of claim 32 wherein selecting the set of non-recurring records based on the outcome of the third comparison is based on identity of content of the at least one other field of the non-recurring records in the group.
Claim 36
Dependent Claim
75 words
The computer program of claim 24 wherein processing the plurality of non-recurring records further includes processing the plurality of non-recurring records to generate a synthetic recurring record representing the set of recurring date bearing instances in the second database, and wherein performing a comparison of the set of non-recurring records to a recurring record includes performing a comparison of the synthetic recurring record of the second database to the recurring record of the first database.
Claim 37
Dependent Claim
32 words
The computer program of claim 34 wherein, following the instruction for completing synchronization, one of the synthetic recurring record and recurring record is fanned back into a plurality of fanned non-recurring records.
Claim 38
Dependent Claim
64 words
The computer program of claim 34 wherein the synthetic recurring record has a list of excluded instances and the instruction for processing a plurality of non-recurring records in the second database to generate a synthetic recurring record further comprises instructions for generating a list of excluded instances representative of instances previously represented by the recurring record and currently represented by another record or deleted.
Claim 39
Dependent Claim
71 words
The computer program of claim 34 wherein the recurring record and the synthetic recurring record each contain a list of excluded date bearing instances, wherein the instruction for performing a comparison of the synthetic recurring record to the recurring record includes instructions for performing a comparison of the list of excluded date bearing instances of the recurring record with the list of excluded date bearing instances of the synthetic recurring record.
Claim 40
Dependent Claim
37 words
The computer program of claim 37 wherein the instruction for completing synchronization includes instructions for adding, modifying, or deleting the list of excluded date bearing instances of one of the recurring record and the synthetic recurring record.
Claim 41
Dependent Claim
28 words
The computer program of claim 37 wherein the instruction for completing synchronization includes instructions for adding, modifying, or deleting one of the synthetic recurring record and recurring record.
Claim 42
Dependent Claim
54 words
The computer program of claim 37 wherein, following the instruction for completing synchronization, one of the synthetic recurring record and recurring record is fanned into a plurality of fanned non-recurring records excluding the instances in the list of excluded date bearing instances of a corresponding one of the synthetic recurring record and recurring record.
Claim 43
Dependent Claim
32 words
The computer program of claim 34 further comprising instructions for storing a history file containing a record representative of one of the recurring record and synthetic recurring record in a past synchronization.
Claim 44
Dependent Claim
102 words
The computer program of claim 41 wherein the second database assigns a unique ID to each record, and wherein the computer program comprises: fanning one of the synthetic recurring record and the recurring record into a plurality of fanned non-recurring records; storing records in the history file representative of the plurality of fanned non-recurring records; storing in the history file the unique IDs assigned by the second database to the plurality of fanned non-recurring records; and recording linkages among the records representative of the plurality of non-recurring records and the record representative of one of the recurring record and synthetic recurring record.
Claim 45
Dependent Claim
126 words
The computer program of claim 41 wherein the second database assigns unique IDs to each record, the history file further contains records representative of non-recurring records of the second database from a past synchronization and unique IDs assigned to the non-recurring records of the second database, and the instruction for processing a plurality of non-recurring records in the second database to generate a synthetic recurring record further comprises instructions for: performing a comparison of the unique IDs stored in the history file with unique IDs of the plurality of non-recurring records in the second database; and selecting a set of non-recurring records in the second database based on the comparison of the unique IDs and generating the synthetic recurring record using the set of non-recurring records.
Claim 46
Dependent Claim
45 words
The computer program of claim 43 wherein the instruction for selecting a set of non-recurring records further comprises instructions for selecting a set of non-recurring records in the second database having unique IDs matching a set of the unique IDs stored in the history file.
Claim 47
Dependent Claim
91 words
The computer program of claim 43 wherein one of the synthetic recurring record and the recurring record has an exclusion list and the instruction for selecting the set of non-recurring records comprises instructions for: selecting a set of records in the history file having unique IDs failing to match any of the unique IDs of non-recurring records in the second database; and adding, modifying, or deleting the exclusion list of at least one of the synthetic recurring record and the recurring record, using the set of records in the history file.
Claim 48
Dependent Claim
53 words
The computer program of claim 41 further comprises performing a second comparison of one of the synthetic recurring record and the recurring record to the history file record representative of the recurring record or the synthetic recurring record in the past synchronization, and completing synchronization based on the outcome of the second comparison.
Claim 49
Dependent Claim
155 words
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.
Claim 50
Dependent Claim
155 words
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.
Claim 51
Dependent Claim
35 words
The method of claim 47, the method further comprises selecting the plurality of groups of records based on identity of the contents of the key fields of the records of the first and second database.
Claim 52
Dependent Claim
70 words
The method of claim 47 further comprising storing a history file containing history records representative of records of the first and second databases in a past synchronization, wherein performing a second comparison includes performing a comparison of the records in the one of the plurality of groups to the history records and wherein performing the third comparison includes comparing a corresponding history record with the records in the determined correspondence.
Claim 53
Dependent Claim
33 words
The method of claim 49 wherein the step of completing synchronization further comprises: performing a third comparison of the records of the corresponding item group; and completing synchronization based on the third comparison.
Claim 54
Dependent Claim
13 words
The method of claim 47 wherein the key field is a date field.
Claim 55
Dependent Claim
13 words
The method of claim 47 wherein the key field is a text field.
Claim 56
Dependent Claim
160 words
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.
Claim 57
Dependent Claim
160 words
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.
Claim 58
Dependent Claim
39 words
The computer program of claim 53, the computer program further comprises instructions for selecting the plurality of groups of records based on identity of the contents of the key fields of the records of the first and second database.
Claim 59
Dependent Claim
73 words
The computer program of claim 53 further comprising instructions for storing a history file containing history records representative of records of the first and second databases in a past synchronization, wherein performing a second comparison includes performing a comparison of the records in the one of the plurality of groups to the history records and wherein performing the third comparison includes comparing a corresponding history record with the records in the determined correspondence.
Claim 60
Dependent Claim
36 words
The computer program of claim 55 wherein the instruction for completing synchronization further comprises instructions for: performing a third comparison of the records of the corresponding item group; and completing synchronization based on the third comparison.
Claim 61
Dependent Claim
14 words
The computer program of claim 53 wherein the key field is a date field.
Claim 62
Dependent Claim
14 words
The computer program of claim 53 wherein the key field is a text field.
References Cited (Backward Citations)
US4432057A
Cited
US4807182A
Cited
US4819156A
Cited
US4956809A
Cited
US4827423A
Cited
US4866611A
Cited
US5237678A
Cited
US5261045A
Cited
US4875159A
Cited
US4980844A
Cited
US5251151A
Cited
US5228116A
Cited
US5136707A
Cited
US5065360A
Cited
US5339392A
Cited
US5187787A
Cited
US5187787B1
Cited
US5170480A
Cited
US5251291A
Cited
US5210868A
Cited
US5444851A
Cited
US5511188A
Cited
US5463735A
Cited
US5142619A
Cited
US5278978A
Cited
US5333252A
Cited
US5272628A
Cited
US5293627A
Cited
US5301313A
Cited
US5333265A
Cited
US5315709A
Cited
US5283887A
Cited
US5355476A
Cited
US5327555A
Cited
US5261094A
Cited
US5396612A
Cited
US5333316A
Cited
US5475833A
Cited
US5375234A
Cited
US5519606A
Cited
US5701423A
Cited
US5392390A
Cited
US5666553A
Cited
US5666530A
Cited
US5339434A
Cited
US5600834A
Cited
US5710922A
Cited
US5568402A
Cited
US5583793A
Cited
US5434994A
Cited
US5778388A
Cited
US5684984A
Cited
US5684990A
Cited
US5729735A
Cited
US5682524A
Cited
US5758150A
Cited
US5727202A
Cited
US5758355A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2002-08-23 | 2003-02-22 | 2003-08-24 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2006-08-23 | 2007-02-22 | 2007-08-24 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2010-08-23 | 2011-02-22 | 2011-08-24 | $7700.00 | Window Closed / Lapsed |