System and method for synchronizing data records between multiple databases

• US 7,490,114 B2
• Filed: 11/16/2004
• Issued: 02/10/2009
• Est. Priority Date: 04/10/2000
• Status: Expired due to Term

• Current Assignee: Malikie Innovations Limited (Key Patent Innovations Limited)
• Original Assignee: Research In Motion Limited (Blackberry Limited)
• Inventors: Hind, Hugh, Dunk, Craig
• Primary Examiner(s): To; Baoquoc N.
• Application Number:
  US10/990,014
• Publication Number:
  US 20050071358A1
• Time in Patent Office: 1,547 Days
• Field of Search: 707/200, 707/203, 707/204, 455/426.1, 455/412.2, 455/414.1, 455/466, 709/206, 709/246
• US Class Current: 1/1
• CPC Class Codes: G06F 16/275 Synchronous replication
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation
• CPC Class Codes: Y10S 707/99952 Coherency, e.g. same view to multiple users
• CPC Class Codes: Y10S 707/99953 Recoverability
• CPC Class Codes: Y10S 707/99955 Archiving or backup

Abstract

First and second pairs of synchronization parameters are stored in first and second databases. The first and second pairs are compared upon a data record being updated in either database to determine whether a synchronization conflict has occurred and a corresponding synchronization operation is executed.

Claims

1. A method of synchronizing data records stored in a host system and a device system, comprising the steps of:

associating a first device synchronization parameter and a first host synchronization parameter with a data record stored at the host system;

associating a second device synchronization parameter and a second host synchronization parameter with a data record stored at the device system;

updating the first host synchronization parameter when the data record is updated at the host system and transmitting a first update message from the host system to the device system; and

updating the second device synchronization parameter when the data record is updated at the device system and transmitting a second update message from the device system to the host system;

wherein the first and second host synchronization parameters are indicative of versions of data records stored at the host system, and the first and second device synchronization parameters are indicative of versions of records store at the device system.

2. The method of claim 1, wherein the first update message includes the updated first host synchronization parameter and the first device synchronization parameter.

3. The method of claim 1, wherein the second update message includes the updated second device synchronization parameter and the second host synchronization parameter.

4. The method of claim 1, further comprising:

receiving the first update message at the device system;

detecting for conflicts between the updated data record at the device system and the data record at the host system; and

ignoring the updated data record if there is a conflict detected.

5. The method of claim 1, wherein the device system comprises a mobile communication device.

6. A system for synchronizing data records stored in a host system and a device system, comprising the steps of:

means for associating a first device synchronization parameter and a first host synchronization parameter with a data record stored at the host system;

means for associating a second device synchronization parameter and a second host synchronization parameter with a data record stored at the device system;

means for updating the first host synchronization parameter when the data record is updated at the host system and transmitting a first update message from the host system to the device system; and

means for updating the second device synchronization parameter when the data record is updated at the device system and transmitting a second update message from the device system to the host system;

wherein the first and second host synchronization parameters are indicative of versions of data records stored at the host system, and the first and second device synchronization parameters are indicative of versions of records store at the device system.