Synchronization of databases using filters
DCFirst Claim
Patent Images
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.
4 Assignments
Litigations
0 Petitions
Reexamination
Accused Products
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.
-
Citations
52 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. - 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, 25, 26)
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. - View Dependent Claims (28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52)
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.
Specification