Method and apparatus for synchronizing databases connected by wireless interface

• US 20070112882A1
• Filed: 11/17/2005
• Published: 05/17/2007
• Est. Priority Date: 11/17/2005
• Status: Active Grant

• Current Assignee: Malikie Innovations Limited (Key Patent Innovations Limited)
• Original Assignee: Blackberry Limited
• Inventors: Hardy, Michael, Linkert, Barry, Tysowski, Piotr
• Granted Patent: US 7,613,739 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/275 Synchronous replication
• CPC Class Codes: Y10S 707/99952 Coherency, e.g. same view to multiple users

Abstract

A method of synchronizing at least one database including at least one updated data record with at least one other database including a corresponding data record. The method includes comparing at least one field of data of the updated data record with a corresponding field of the data record prior to updating, generating change information including at least the location of a change and an indication representative of the change for the field of the updated data record, and transmitting the change information for assembly in the corresponding data record.

Claims

1. A method of synchronizing at least one database including at least one updated data record with at least one other database including a corresponding data record, the method comprising:

comparing at least one field of data of the updated data record with a corresponding field of said data record prior to updating;

generating change information including at least the location of a change and an indication representative of change for said field of the updated data record wherein when said change information includes information relating to a plurality of changes and two of said plurality of changes are separated in position by fewer than a threshold number of bytes, said change information for the two changes includes a single location of change and an indication representative of both said two changes;

comparing a size of said change information to a size of said full field; and

if said change information is smaller than said full field, transmitting said change information for assembly in said corresponding data record, otherwise transmitting said full field for assembly in said corresponding data record.

2. The method according to claim 1, wherein said comparing comprises comparing byte information of said at least one field of data of the updated data record with byte information of said corresponding field of said data record prior to updating and said change information comprises byte change information.

3. The method according to claim 2, wherein said generating change information includes generating a byte index position for said location of change and generating a length value for said indication representative of said change.

4. The method according to claim 3, wherein said generating change information further includes generating new data as part of said indication representative of change.

5. An apparatus for synchronizing at least one database including at least one updated data record with at least one other database including a corresponding data record, the apparatus comprising:

a memory device for storing said at least one database including said at least one updated data record; and

a processor operably coupled to said memory device and to a transmitting and receiving device, for comparing at least one field of data of the updated data record with a corresponding field of said data record prior to updating, generating change information including at least the location of a change and an indication representative of change for said field of the updated data record wherein when said change information includes information relating to a plurality of changes and two of said plurality of changes are separated in position by fewer than a threshold number of bytes, said change information for the two changes includes a single location of change and an indication representative of both said two changes, comparing a size of said change information to a size of said full field, and if said change information is smaller than said full field, transmitting said change information for assembly in said corresponding data record, otherwise transmitting said full field for assembly in said corresponding data record.

6. The apparatus according to claim 5, wherein said change information comprises byte change information comprising a byte index position for said location of change and a length value for said indication representative of said change.

7. The apparatus according to claim 6, wherein said change information further comprises new data as part of said indication representative of change.

8. A computer-readable medium having computer readable code embodied therein for:

comparing at least one field of data of the updated data record with a corresponding field of said data record prior to updating;

generating change information including at least the location of a change and an indication representative of change for said field of the updated data record wherein when said change information includes information relating to a plurality of changes and two of said plurality of changes are separated in position by fewer than a threshold number of bytes, said change information for the two changes includes a single location of change and an indication representative of both said two changes;

comparing a size of said change information to a size of said full field; and

if said change information is smaller than said full field, transmitting said change information for assembly in said corresponding data record, otherwise transmitting said full field for assembly in said corresponding data record.