US6330568B1
Expired / Lapsed
US
⏱️ 0.0 years remaining
Synchronization of databases
Assignee: Intellisync LLC
•
Filing: 1997-11-05
•
Granted: 2001-12-11
•
Expires: 2017-11-05
Abstract
Abstract A computer implemented method and a computer program for synchronizing a first and a second database, where data is provided for keeping track of whether the records of the first database have been added or changed since a previous synchronization. Based data reflecting whether the records of the first database have been added or changed since a previous synchronization, it is determined whether the records of the first database have been changed or added since the previous synchronization. If one of the records of the first database has not been changed or added since the previous synchronization, a synchronization with records of the second database is performed using a record representative of the one record at the time of a previous synchronization. The representative record is stored in a history file which contains records reflecting the contents of records of the databases at the time of a previous synchronization.
Inventors
- 👤 David J. Boothby
- 👤 Robert C. Daley
- 👤 John R. Marien
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-08 13:33
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/27; G06F16/275; Y; Y10; Y10S; Y10S707/00; Y10S707/99951; Y10S707/99952; Y10S707/99953
Claims Analysis
Total Claims: 12
Claim 1
Independent Claim
345 words
A computer implemented method of synchronizing a first and a second database, wherein the first database is resident on a first computer and is capable of providing change data reflecting whether the records of the database have been changed, added, or deleted since the previous synchronization, wherein the second database is resident on a second computer different from the first computer, and wherein a history file reflecting the contents of records of the databases at the time of a prior synchronization is used to perform the synchronization, the method comprising: determining whether the records of the first database have been changed, added, or deleted since a previous synchronization, based on change data reflecting whether the records of the first database have been changed, added, or deleted since the previous synchronization, the change data comprising database generated data for keeping track of whether the records of the first database have been changed, added, or deleted since a previous synchronization; transferring from the first computer to the second computer generally only the change data and the records of the first database that have been changed or added; using the change data to determine which of the records of the first database have not been changed, added, or deleted since the previous synchronization; using the result of that determination and the transferred records to reconstruct the content of the first database at the time of the previous synchronization; performing a current synchronization using the reconstructed content of the first database, the history file containing records reflecting the contents of records of the databases at the time of the previous synchronization, and the second database changing, adding, or deleting the records of the first database based on the result of the current synchronization; changing, adding, or deleting the records of the second database based on the result of the current synchronization; and changing, adding or deleting records in the history file using results of the current synchronization such that the history file contains records reflecting the contents of records of the first and second databases after the current synchronization.
Claim 2
Dependent Claim
345 words
A computer implemented method of synchronizing a first and a second database, wherein the first database is resident on a first computer and is capable of providing change data reflecting whether the records of the database have been changed, added, or deleted since the previous synchronization, wherein the second database is resident on a second computer different from the first computer, and wherein a history file reflecting the contents of records of the databases at the time of a prior synchronization is used to perform the synchronization, the method comprising: determining whether the records of the first database have been changed, added, or deleted since a previous synchronization, based on change data reflecting whether the records of the first database have been changed, added, or deleted since the previous synchronization, the change data comprising database generated data for keeping track of whether the records of the first database have been changed, added, or deleted since a previous synchronization; transferring from the first computer to the second computer generally only the change data and the records of the first database that have been changed or added; using the change data to determine which of the records of the first database have not been changed, added, or deleted since the previous synchronization; using the result of that determination and the transferred records to reconstruct the content of the first database at the time of the previous synchronization; performing a current synchronization using the reconstructed content of the first database, the history file containing records reflecting the contents of records of the databases at the time of the previous synchronization, and the second database changing, adding, or deleting the records of the first database based on the result of the current synchronization; changing, adding, or deleting the records of the second database based on the result of the current synchronization; and changing, adding or deleting records in the history file using results of the current synchronization such that the history file contains records reflecting the contents of records of the first and second databases after the current synchronization.
Claim 3
Dependent Claim
43 words
The method of claim 1 wherein the records of the first and second databases are characterized respectively by first and second record structures, wherein the first record structure is different from the second record structure thereby making the first and second databases incompatible.
Claim 4
Dependent Claim
26 words
The computer implemented method of claim 2 wherein the change data indicates the most recent date and time of when the records were created or changed.
Claim 5
Dependent Claim
22 words
The computer implemented method of claim 2 wherein the change data comprises a flag set when the records are created or changed.
Claim 6
Dependent Claim
65 words
The computer implemented method of claim 2 wherein the first database provides further database generated data indicating which of the records were deleted since the previous synchronization, further comprising: identifying records of the history file corresponding to the deleted records by performing a comparison of the further database generated data with the history file; and completing the current synchronization using a result of the identification.
Claim 7
Dependent Claim
350 words
A computer program, resident on a computer readable medium, for synchronizing a first and a second database, wherein the first database is resident on a first computer and is capable of providing change data reflecting whether the records of the database have been changed, added, or deleted since the previous synchronization, wherein the second database is resident on a second computer different from the first computer, and wherein a history file reflecting the contents of records of the databases at the time of a prior synchronization is used to perform the synchronization, comprising instructions for: determining whether the records of the first database have been changed, added, or deleted since a previous synchronization, based on change data reflecting whether the records of the first database have been changed, added, or deleted since the previous synchronization, the change data comprising database generated data for keeping track of whether the records of the first database have been changed, added, or deleted since a previous synchronization; transferring from the first computer to the second computer generally only the change data and the records of the first database that have been changed or added; using the change data to determine which of the records of the first database have not been changed, added, or deleted since the previous synchronization; using the result of that determination and the transferred records to reconstruct the content of the first database at the time of the previous synchronization; performing a current synchronization using the reconstructed content of the first database, the history file containing records reflecting the contents of records of the databases at the time of the previous synchronization, and the second database changing, adding, or deleting the records of the first database based on the result of the current synchronization; changing, adding, or deleting the records of the second database based on the result of the current synchronization; and changing, adding or deleting records in the history file using results of the current synchronization such that the history file contains records reflecting the contents of records of the first and second databases after the current synchronization.
Claim 8
Dependent Claim
350 words
A computer program, resident on a computer readable medium, for synchronizing a first and a second database, wherein the first database is resident on a first computer and is capable of providing change data reflecting whether the records of the database have been changed, added, or deleted since the previous synchronization, wherein the second database is resident on a second computer different from the first computer, and wherein a history file reflecting the contents of records of the databases at the time of a prior synchronization is used to perform the synchronization, comprising instructions for: determining whether the records of the first database have been changed, added, or deleted since a previous synchronization, based on change data reflecting whether the records of the first database have been changed, added, or deleted since the previous synchronization, the change data comprising database generated data for keeping track of whether the records of the first database have been changed, added, or deleted since a previous synchronization; transferring from the first computer to the second computer generally only the change data and the records of the first database that have been changed or added; using the change data to determine which of the records of the first database have not been changed, added, or deleted since the previous synchronization; using the result of that determination and the transferred records to reconstruct the content of the first database at the time of the previous synchronization; performing a current synchronization using the reconstructed content of the first database, the history file containing records reflecting the contents of records of the databases at the time of the previous synchronization, and the second database changing, adding, or deleting the records of the first database based on the result of the current synchronization; changing, adding, or deleting the records of the second database based on the result of the current synchronization; and changing, adding or deleting records in the history file using results of the current synchronization such that the history file contains records reflecting the contents of records of the first and second databases after the current synchronization.
Claim 9
Dependent Claim
35 words
The computer program of claim 6 wherein the records of the first and second databases are charcterized respectively by first and second record structures, wherein the structure thereby making the first and second databases incompatible.
Claim 10
Dependent Claim
25 words
The computer program of claim 6 wherein the change data indicates the most recent date and time of when the records were created or changed.
Claim 11
Dependent Claim
21 words
The computer program of claim 6 wherein the chance data comprises a flag set when the recorda are created or changed.
Claim 12
Dependent Claim
66 words
The computer program of claim 6 wherein the first database provides further database generated data indicating which of the records were deleted since the previous synchronization, further comprising instructions for: identifying records of the history file corresponding to the deleted records by performing a comparison of the further database generated data with the history file; and completing the current synchronization using a result of the identification.
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
US5187787A
Cited
US5187787B1
Cited
US5339392A
Cited
US5170480A
Cited
US5251291A
Cited
US5210868A
Cited
US5463735A
Cited
US5511188A
Cited
US5444851A
Cited
US5142619A
Cited
US5155850A
Cited
US5278978A
Cited
US5333252A
Cited
US5272628A
Cited
US5293627A
Cited
US5301313A
Cited
US5333265A
Cited
US5745712A
Cited
US5315709A
Cited
US5283887A
Cited
US5355476A
Cited
US5327555A
Cited
US5261094A
Cited
US5396612A
Cited
US5333316A
Cited
US5475833A
Cited
US5278982A
Cited
US5375234A
Cited
US5519606A
Cited
US5392390A
Cited
US5666553A
Cited
US5701423A
Cited
US5708840A
Cited
US5615364A
Cited
US5928329A
Cited
US5666530A
Cited
US5339434A
Cited
US5600834A
Cited
US5710922A
Cited
US5838923A
Cited
US5613113A
Cited
US5619689A
Cited
US5560005A
Cited
US5583793A
Cited
US5568402A
Cited
US5434994A
Cited
US5845293A
Cited
US5897640A
Cited
US5778388A
Cited
US5684984A
Cited
US5926824A
Cited
US5684990A
Cited
US5729735A
Cited
US5682524A
Cited
US5596574A
Cited
US5630081A
Cited
US5978813A
Cited
US5758150A
Cited
US5884323A
Cited
US5832489A
Cited
US5727202A
Cited
US5758083A
Cited
US5708812A
Cited
US5884324A
Cited
US5790789A
Cited
US5758355A
Cited
US5884325A
Cited
US5870765A
Cited
US5870759A
Cited
US5999947A
Cited
US6125369A
Cited
US6081806A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2004-12-10 | 2005-06-11 | 2005-12-11 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2008-12-10 | 2009-06-11 | 2009-12-11 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2012-12-10 | 2013-06-11 | 2013-12-11 | $7700.00 | Window Closed / Lapsed |