Method and apparatus for synchronizing databases connected by wireless interface

• US 20070073787A1
• Filed: 06/15/2006
• Published: 03/29/2007
• Est. Priority Date: 09/29/2005
• Status: Abandoned Application

• Current Assignee: Malikie Innovations Limited (Key Patent Innovations Limited)
• Original Assignee: Blackberry Limited
• Inventors: Hardy, Michael, Linkert, Barry, Tysowski, Piotr
• Application Number:
  US11/452,907
• Publication Number:
  US 20070073787A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/273 Asynchronous replication or reconciliation
• CPC Class Codes: G06F 16/275 Synchronous replication

Abstract

A method of synchronizing a first database including first data records with a second database including second data records includes receiving information representative of the second data records and modifying the first data records of the first database in a unidirectional synchronization with the second data records of the second database including deleting ones of the first data records present in the first database for which there is no corresponding second data record present in the second database.

Claims

1. A method of synchronizing a first database including first data records with a second database including second data records, the method comprising:

receiving information representative of said second data records;

comparing information representative of the first data records with the information representative of the second data records of the second database; and

modifying said first data records of the first database, said modifying including deleting ones of said first data records present in said first database for which there is no corresponding second data record present in said second database.

2. The method according to claim 1, comprising receiving a synchronization trigger along with said information representative of said second data records.

3. The method according to claim 1, wherein modifying the first data records of the first database further includes writing to the first database further data records corresponding to second data records present in the second database for which there is no corresponding first data record present in said first database.

4. The method according to claim 3, wherein modifying the first data records of the first database further includes for those first data records that differ from corresponding ones of the second data records, overwriting those first data records of the first database to reflect the corresponding ones of the second data records.

5. The method according to claim 1, wherein comparing information representative of the first data records with the information representative of the second data records includes determining if a corresponding second data record is present in said second database for each first data record in the first database, prior to modifying said first data records.

6. The method according to claim 5, wherein said comparing includes for each second data record, determining whether or not a corresponding first data record exists in the first database and, if not requesting transmission of the second data record for which no corresponding first data record exists.

7. The method according to claim 1, wherein said comparing further includes determining if other first data records differ from corresponding other ones of the second data records and, if so, requesting transmission of the other ones of the second data records.

8. The method according to claim 5, further comprising receiving said second data record and writing to the first database.

9. The method according to claim 7, further comprising receiving the other ones of the second data records and overwriting over respective ones of the other first data records.

10. The method according to claim 1, wherein said receiving information representative of the second data records comprises receiving hash information representative of said second data records.

11. The method according to claim 10, wherein said comparing comprises comparing said hash information representative of the second data records with corresponding hash information representative of the first data records.

12. The method according to claim 2, wherein said synchronization trigger is generated at an electronic device on which said second database resides, in response deleting ones of the second data records.

13. The method according to claim 2, wherein said synchronization trigger is generated at an electronic device on which said second database resides, in response to receiving a delete data records command for deleting ones of the second data records, comparing the number of the ones of the second data records with a threshold number, and determining that the number of the ones of the second data records exceeds said threshold number.

14. An apparatus for synchronizing a first database including first data records with a second database including second data records, the apparatus comprising:

a memory device for storing said first data records in said first database;

a processor operably coupled to said memory device and to a transmitting and receiving device, for receiving information representative of said second data records, comparing information representative of the first data records with the information representative of the second data records of the second database, and modifying said first data records of the first database, said modifying including deleting ones of said first data records present in said first database for which there is no corresponding second data record present in said second database.

15. A computer-readable medium having computer-readable code embodied therein for execution by a processor for:

receiving information representative of second data records of a second database;

comparing information representative of first data records of a first database with the information representative of the second data records of the second database; and

modifying said first data records of the first database, said modifying including deleting ones of said first data records present in said first database for which there is no corresponding second data record present in said second database.