Synchronization of databases using filters

• US 7,209,911 B2
• Filed: 02/02/2001
• Issued: 04/24/2007
• Est. Priority Date: 11/13/1996
• Status: Expired due to Fees

• Current Assignee: Intellisync Corporation (Nokia Corporation)
• Original Assignee: Intellisync Corporation (Nokia Corporation)
• Inventors: Boothby, David J., Morgan, David W.
• Primary Examiner(s): Coby; Frantz
• Application Number:
  US09/776,452
• Publication Number:
  US 20010005849A1
• Time in Patent Office: 2,272 Days
• Field of Search: 707/8, 707/104.1, 707/10, 707/200, 707/201, 707/203, 707/2, 707/4, 707/100, 707/102, 707/103.R
• 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 input region may be 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 of the type having a plurality of records, wherein the records of the first and second personal information management databases include fields, 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 fields of records of the first database must match or fit to be selected, and

selecting the plurality of records of the first database includes evaluating fields of the first database with the user-definable conditions or criteria, 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.

3. The method of claim 1 or 2 further comprising:

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

4. The method of claim 3 further comprising:

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

9. The method of claim 1 or 2 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.

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

13. The method of claim 11, 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.

2. A computer implemented method of synchronizing at least a first and a second personal information management database of the type having a plurality of records, wherein the records of the first and second personal information management databases include fields, the method comprising:

using a filter to select a plurality of records of the first database, the filter comprising one or more user selectable conditions or criteria that fields of records of the first database must match or fit to be selected, and

selecting the plurality of records of the first database includes evaluating fields of the first database with the user selectable conditions or criteria, 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.

5. A computer program, resident on a computer readable medium, for synchronizing at least a first and a second personal information management database of the type having a plurality of records, wherein the records of the first and second personal information management databases include fields, 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 fields of records of the first database must match or fit to be selected, and

selecting the plurality of records of the first database includes evaluating fields of the first database with the user-definable conditions or criteria, 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.

7. The computer program of claim 5 or 6 further comprising instructions for:

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

8. The computer program of claim 7 further comprising instructions for:

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

10. The computer program of claim 5 or 6 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.

12. The computer program of claim 5 or 6 wherein the first and second databases are located on different computers and at least one of the computers is a handheld computer.

14. The computer program of claim 12, 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.

6. A computer program, resident on a computer readable medium, for synchronizing at least a first and a second personal information management database of the type having a plurality of records, wherein the records of the first and second personal information management databases include fields, comprising instructions for:

using a filter to select a plurality of records of the first database, the filter comprising one or more user selectable conditions or criteria that fields of records of the first database must match or fit to be selected, and

selecting the plurality of records of the first database includes evaluating fields of the first database with the user selectable conditions or criteria, 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.