Synchronization of databases with record sanitizing and intelligent comparison

• US 6,532,480 B1
• Filed: 04/11/2000
• Issued: 03/11/2003
• Est. Priority Date: 11/13/1996
• Status: Expired due to Term

• Current Assignee: Intellisync Corporation (Nokia Corporation)
• Original Assignee: Pumatech Inc.
• Inventors: Boothby, David J.
• Primary Examiner(s): Coby, Frantz
• Application Number:
  US09/547,412
• Time in Patent Office: 1,064 Days
• Field of Search: 707/201, 707/8, 707/104, 707/200, 707/203
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2308 Concurrency control transaction processing G06F9/466
• CPC Class Codes: G06F 16/273 Asynchronous replication or reconciliation
• CPC Class Codes: Y10S 707/99938 Concurrency, e.g. lock management in shared database
• CPC Class Codes: Y10S 707/99952 Coherency, e.g. same view to multiple users
• CPC Class Codes: Y10S 707/99953 Recoverability

Abstract

A method of synchronizing at least a first and a second database each containing dated records such as events, wherein the records of the first and second databases are synchronized across a narrow date range narrower than the date range of the records of at least one of the databases. A prior synchronization can be performed across a prior date range. The date range of the prior synchronization is stored, along with the history file containing information representative of the content of the databases following the prior synchronization. When a current synchronization is performed, it is performed across a date range that combines the prior date range with the current date range.

Claims

1. A computer implemented method of synchronizing records of first and second databases, the records of the first and second databases being 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, wherein at least one field of records of the first database is subject to a first rule of data value to which the corresponding field of records of the second database is not subject, the method comprising:

comparing the content of the one field to the content of the corresponding field of the second database and in performing the comparison applying the first rule of data value, thereby comparing the records of the incompatible databases;

taking synchronization actions based on the outcome of the comparison.

2. The method of claim 1 wherein at least one field of records of the second database is subject to a second rule of data value to which a corresponding field of records of the first database is not subject, wherein the computer program further comprises applying the second rule of data value in performing a comparison of the content of the corresponding field of records of the first database to the content of the at least one field of the second database.

3. The method of claim 1 wherein applying the first rule of data value comprises:

using the first rule of data value to modify a corresponding field of records representative of the records of the second database; and

thereafter comparing the content of the modified corresponding field of the representative records to the content of the one field.

4. The method of claim 1 wherein the content of the one field comprises at least a first portion and a second portion and the first rule of data value requires the presence of the second portion, and wherein applying the first rule of data value comprises comparing only the first portion to the content of the corresponding field.

5. The method of claim 1 wherein the content of the corresponding field comprises at least a first portion and a second portion and the first rule of data value prohibits the content of the one field from containing the second portion and wherein applying the first rule of data value comprises comparing only a first portion of the content of the corresponding field to the one field.

6. The method of claim 1 wherein the first rule of data value requires the content of the one field of the first database to have a specified value and wherein applying the first rule of data value comprises omitting comparison of the content of the one field with the content of the corresponding field.

7. The method of claim 1 wherein the first rule of data value limits the content of the one field to a first specified value and wherein applying the first rule of data value comprises setting the first specified value equivalent to a second specified value of the content of the corresponding field.

8. The method in claim 7 wherein the first specified value comprises a value selected from a range of values.

9. The method in claim 7 wherein the second specified value comprises a value selected from a range of values.

10. The method of claim 1 wherein applying the first rule of data value consists of one of:

a) comparing only a portion of the content of the one field to the content of the corresponding field;

b) comparing only a portion of the content of the corresponding field to the content of the one field;

c) omitting comparison of the content of the one field with the content of the corresponding field;

d) setting a first specified value of the one field equivalent to a second specified value of the corresponding field.

11. The method of claim 1 wherein the first rule of data value consists of one of:

a requirement that the content of the one field be in upper case;

a requirement that the content of the one field have a specified form of punctuation;

a requirement that the content of the one field have a specified form of spacing;

a requirement that the content of the one field have a value limited to a specified range of values;

a requirement that the content of the one field have a first specified value based on the content of another field;

a requirement that the content of the one field be limited to a specified length; and

a requirement that the content of the one field include a specified code.

12. A computer program, resident on a computer readable medium, for synchronizing records of first and second databases, the records of the first and second databases being 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, wherein at least one field of records of the first database is subject to a first rule of data value to which the corresponding field of records of the second database is not subject, the computer program comprising the steps for:

comparing the content of the one field to the content of the corresponding field of the second database and in performing the comparison applying the first rule of data value, thereby comparing the records of the incompatible databases;

taking synchronization actions based on the outcome of the comparison.

13. The computer program of claim 12 wherein at least one field of records of the second database is subject to a second rule of data value to which a corresponding field of records of the first database is not subject, wherein the computer program further comprises applying the second rule of data value in performing a comparison of the content of the corresponding field of records of the first database to the content of the at least one field of the second database.

14. The computer program of claim 12 wherein applying the first rule of data value comprises:

using the first rule of data value to modify a corresponding field of records representative of the records of the second database; and

thereafter comparing the content of the modified corresponding field of the representative records to the content of the one field.

15. The computer program of claim 12 wherein the content of the one field comprises at least a first portion and a second portion and the first rule of data value requires the presence of the second portion, and wherein applying the first rule of data value comprises comparing only the first portion to the content of the corresponding field.

16. The computer program of claim 12 wherein the content of the corresponding field comprises at least a first portion and a second portion and the first rule of data value prohibits the content of the one field from containing the second portion and wherein applying the first rule of data value comprises comparing only a first portion of the content of the corresponding field to the one field.

17. The computer program of claim 12 wherein the first rule of data value requires the content of the one field of the first database to have a specified value and wherein applying the first rule of data value comprises omitting comparison of the content of the one field with the content of the corresponding field.

18. The computer program of claim 12 wherein the first rule of data value limits the content of the one field to a first specified value and wherein applying the first rule of data value comprises setting the first specified value equivalent to a second specified value of the content of the corresponding field.

19. The computer program in claim 18 wherein the first specified value comprises a value selected from a range of values.

20. The computer program in claim 18 wherein the second specified value comprises a value selected from a range of values.

21. The computer program of claim 12 wherein applying the first rule of data value consists of one of:

a) comparing only a portion of the content of the one field to the content of the corresponding field;

b) comparing only a portion of the content of the corresponding field to the content of the one field;

c) omitting comparison of the content of the one field with the content of the corresponding field;

d) setting a first specified value of the one field equivalent to a second specified value of the corresponding field.

22. The method of claim 12 wherein the first rule of data value consists of one of:

a requirement that the content of the one field be in upper case;

a requirement that the content of the one field have a specified form of punctuation;

a requirement that the content of the one field have a specified form of spacing;

a requirement that the content of the one field have a value limited to a specified range of values;

a requirement that the content of the one field have a first specified value based on the content of another field;

a requirement that the content of the one field be limited to a specified length; and

a requirement that the content of the one field include a specified code.