Synchronization of databases using filters

• US 6,212,529 B1
• Filed: 03/05/1998
• Issued: 04/03/2001
• Est. Priority Date: 11/13/1996
• Status: Expired due to Term

• Current Assignee: Intellisync Corporation (Nokia Corporation)
• Original Assignee: Puma Technology Inc.
• Inventors: Morgan, David W., Marien, John R., Boothby, David J.
• Primary Examiner(s): Black, Thomas G.
• Assistant Examiner(s): Coby, Frantz
• Application Number:
  US09/036,400
• Time in Patent Office: 1,125 Days
• Field of Search: 707/10, 707/201, 707/202, 707/204, 707/203
• US Class Current: 1/1
• CPC Class Codes: G06F 16/27 Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
• CPC Class Codes: G06F 16/275 Synchronous replication
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface
• CPC Class Codes: Y10S 707/99944 Object-oriented database structure
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing
• CPC Class Codes: Y10S 707/99952 Coherency, e.g. same view to multiple users

Abstract

A computer program is provided for synchronizing at least a first and a second database. A plurality of records of the first database fitting a selected criterion are identified. At least one of the identified records of the first database is then synchronized with a record of the second database. On a computer display, a record selection criteria displayed for a user to input the selected criterion.

Claims

1. A computer implemented method of synchronizing at least a first and a second personal information management database wherein the records of at least the first database include a text field, the method comprising:

using a filter to select a plurality of records of the first database, the filter comprising one or more user definable conditions or criteria that a record must match or fit to be selected, wherein the conditions or criteria include a user definable text criterion, and selecting the plurality records of the first database includes comparing the text field with the text criterion; and

synchronizing the selected records of the first database with records of the second database,

the synchronizing comprising adding, modifying, or deleting records,

whereby synchronization is performed for a subset of the records of the databases.

2. The method of claim 1 wherein records representative of the records of one of the first and second databases during a prior synchronization are stored in a history file, and wherein synchronizing the at least one of the selected records of the first database with a record of the second database further includes using the history file.

3. The method of claim 1 further comprising selecting records of the first database based on a selected criterion, wherein synchronizing the at least one of the selected records of the first database with a record of the second database further includes synchronizing the at least one of the selected records of the first database with at least one of the selected records the second database.

4. The method of claim 1 wherein records of the first database include a number field and the conditions criteria include a number criterion, and selecting the plurality records of the first database includes comparing the number field with the number criterion.

5. The method of claim 1 wherein records of the first database include a date field and the conditions or criteria include a date criterion, and selecting the plurality records of the first database includes comparing the date field with the date criterion.

6. The method of claim 1 wherein records of the first database include a boolean field and the conditions or criteria include a boolean criterion, and selecting the plurality records of the first database includes comparing the boolean field with the boolean criterion.

7. The method of claim 1 wherein records of the first database include a time field and the conditions or criteria include a time criterion, and selecting the plurality records of the first database includes comparing the time field with the time criterion.

8. The method of claim 1 wherein a selected plurality of the fields of the records of the first database are mapped onto a selected plurality of corresponding fields of the records of the second database and using a filter to select a plurality of records of the first database includes determining whether contents of a field of the records of the first database fit the one or more conditions or criteria wherein the field of the records of the first database is not mapped onto a corresponding field of the records of second database.

9. The method of claim 1 wherein the first database is located on a first computer and the second database located on a second computer, the method further comprising:

determining, at the first computer, whether a record of the first database has been changed or added since a previous synchronization, using a first history file located on the first computer comprising records representative of records of the first database at the completion of the previous synchronization;

if the record of the first database has not been changed or added since the previous synchronization, sending from the first computer to the second computer information which the second computer uses to select the record of the first database to be unchanged.

10. The method of claim 9 wherein selecting the plurality of records of the first database is performed at the first computer.

11. The method of claim 9 wherein selecting the plurality of records of the first database is performed at the second computer.

12. The method of claim 1 further comprising:

determining whether the records of the first database have been changed or added since the previous synchronization, based on data reflecting whether the records of the first database have been added or changed since a previous synchronization;

if one of the records of the first database has not been changed or added since the previous synchronization, performing a synchronization with records of the second database using a record representative of the one record at the time of a previous synchronization, the representative record being stored in a history file containing records reflecting the contents of records of the first database at the time of a previous synchronization.

13. The method of claim 12 wherein the history file contains at least one record representative of at least one record of the first database failing to fit the one or more conditions or criteria at the time of the previous synchronization and failing to be synchronized with the records of the second database at the time of the previous synchronization.

14. The method of claim 1 further comprising:

deleting a second plurality of the records of the first database failing to fit the conditions or criteria.

15. The method of claim 14 fixer comprising:

updating a plurality of records of the second database failing to fit the current value of the conditions or criteria.

16. The method of claim 1 wherein the conditions or criteria has a current value during a current synchronization being different from a previous value during a previous synchronization, further comprising:

updating a plurality of records of the second database, based on results of the synchronization, wherein the plurality of records of the second database fit the previous value of the conditions or criteria but fail to fit the current value of the conditions or criteria.

17. The method of claim 1 further comprising synchronizing a third database with one of the first and second databases.

18. The method of claim 17 wherein synchronizing the third database with one of the first and second databases includes:

selecting a plurality of records of a third database fitting second conditions or criteria; and

synchronizing at least one of the identified records of the third database with a second record of the one of the first and second databases.

19. The method of claim 18 wherein the first-mentioned conditions or criteria and the second conditions or criteria are the same.

20. The method of claim 18 wherein the second record of the one of the first and second databases includes a code identifying the second record as having originated from the third database.

21. The method of claim 1 further comprising displaying a record selection criteria input region on a computer display for a user to input a record selection criteria that specifies the conditions or criteria.

22. The method of claim 21 further comprising:

transmitting the record selection criteria to a database manager, wherein the database manager manages the first database, and using the record selection criteria to select records of the first database fitting the conditions or criteria.

23. The method of claim 1, wherein the first and second databases are different copies of the personal information management database of the same individual.

24. The method of claim 23, wherein the personal information management database includes a schedule database.

25. The method of claim 1, wherein the first and second databases are located on different computers and at least one of the computers is a handheld computer.

26. The method of claim 25, wherein the handheld computer has less storage capacity than the other computer, wherein fewer records are stored in the database on the handheld computer than in the database on the other computer, and wherein the filter is used to limit the number of records added to the database on the handheld computer during a synchronization.

27. A computer program, resident on a computer readable medium, for synchronizing at least a first and a second personal information management database wherein the records of at least the first database include a text field, comprising instructions for:

using a filter to select a plurality of records of the first database,

the filter comprising one or more user definable conditions or criteria that a record must match or fit to be selected, wherein the conditions or criteria include a user definable text criterion, and selecting the plurality records of the first database includes comparing the text field with the text criterion; and

synchronizing the selected records of the first database with records of the second database,

the synchronizing comprising adding, modifying, or deleting records,

whereby synchronization is performed for a subset of the records of the databases.

28. The computer program of claim 27 wherein records representative of the records of the first and second databases during a prior synchronization are stored in a history file, and wherein synchronizing the at least one of the selected records of the first database with a record of the second database further includes using the history file.

29. The computer program of claim 27 further comprising instructions for selecting records of the first database based on a selected criterion, wherein synchronizing the at least one of the selected records of the first database with a record of the second database further includes synchronizing the at least one of the selected records of the first database with at least one of the selected records the second database.

30. The computer program of claim 27 wherein records of the first database include a number field and the conditions or criteria include a number criterion, and selecting the plurality records of the first database includes comparing the number field with the number criterion.

31. The computer program of claim 27 wherein records of the first database include a date field and the conditions or criteria include a date criterion, and selecting the plurality records of the first database includes comparing the date field with the date criterion.

32. The computer program of claim 27 wherein records of the first database include a boolean field and the conditions or criteria a include a boolean criterion, and selecting the plurality records of the first database includes comparing the boolean field with the boolean criterion.

33. The computer program of claim 27 wherein records of the first database include a time field and the conditions or criteria include a time criterion, and selecting the plurality records of the first database includes comparing the time field with the time criterion.

34. The computer program of claim 27 wherein a selected plurality of the fields of the records of the first database are mapped onto a selected plurality of corresponding fields of the records of the second database and using a filter to select a plurality of records of the first database includes determining whether contents of a field of the records of the first database fit one or more conditions or criteria, wherein the field of the records of the first database is not mapped onto a corresponding field of the records of second database.

35. The computer program of claim 27 wherein the first database is located on a first computer and the second database located on a second computer, the computer program further comprising instructions for:

determining, at the first computer, whether a record of the first database has been changed or added since a previous synchronization, using a first history file located on the first computer comprising records representative of records of the first database at the completion of the previous synchronization;

if the record of the first database has not been changed or added since the previous synchronization, sending from the first computer to the second computer information which the second computer uses to select the record of the first database to be unchanged.

36. The computer program of claim 35 wherein selecting the plurality of records of the first database is performed at the first computer.

37. The computer program of claim 35 wherein selecting the plurality of records of the first database is performed at the second computer.

38. The computer program of claim 27 further comprising instructions for:

determining whether the records of the first database have been changed or added since the previous synchronization, based on data reflecting whether the records of the first database have been added or changed since a previous synchronization;

if one of the records of the first database has not been changed or added since the previous synchronization, performing a synchronization with records of the second database using a record representative of the one record at the time of a previous synchronization, the representative record being stored in a history file containing records reflecting the contents of records of the databases at the time of a previous synchronization.

39. The computer program of claim 38 wherein the history file contains at least one record representative of at least one record of the first database failing to fit the one or more conditions or criteria at the time of the previous synchronization and failing to be synchronized with the records of the second database at the time of the previous synchronization.

40. The computer program of claim 27 further comprising instructions for:

deleting a second plurality of the records of the first database failing to fit the conditions or criteria.

41. The computer program of claim 40 further comprising instructions for:

updating a plurality of records of the second database failing to fit the current value of the conditions or criteria.

42. The computer program of claim 27 wherein the conditions or criteria has a current value during a current synchronization being different from a previous value during a previous synchronization, further comprising instructions for:

updating a plurality of records of the second database, based on results of the synchronization, wherein the plurality of records of the second database fit the previous value of the conditions or criteria but fail to fit the current value of the conditions or criteria.

43. The computer program of claim 27 further comprising instructions for synchronizing a third database with one of the first and second databases.

44. The computer program of claim 43 wherein synchronizing the third database with one of the first and second databases includes instructions for:

selecting a plurality of records of a third database fitting second conditions or criteria; and

synchronizing at least one of the identified records of the third database with a second record of the one of the first and second databases.

45. The computer program of claim 44 wherein the first-mentioned conditions or criteria and the second conditions or criteria are the same.

46. The computer program of claim 44 wherein the second record of the second database includes a code identifying the second record of the second database as having originated from the third database.

47. The computer program of claim 27 further comprising instructions for displaying a record selection criteria input region on a computer display for a user to input a record selection criteria that specifies the conditions or criteria.

48. The computer program of claim 47 further comprising instructions for:

transmitting the record selection criteria to a database manager, wherein the database manager manages the first database, and using the record selection criteria to select records of the first database fitting the conditions or criteria.

49. The computer program of claim 27, wherein the first and second databases are different copies of the personal information management database of the same individual.

50. The computer program of claim 49, wherein the personal information management database includes a schedule database.

51. The computer program of claim 27, wherein the first and second databases are located on different computers and at least one of the computers is a handheld computer.—

52. The method of claim 51, wherein the handheld computer has less storage capacity than the other computer, wherein fewer records are stored in the database on the handheld computer than in the database on the other computer, and wherein the filter is used to limit the number of records added to the database on the handleld computer during a synchronization.