Schema updating for synchronizing databases connected by wireless interface

• US 7,730,028 B2
• Filed: 09/22/2006
• Issued: 06/01/2010
• Est. Priority Date: 09/22/2006
• Status: Active Grant

• Current Assignee: Malikie Innovations Limited (Key Patent Innovations Limited)
• Original Assignee: Research In Motion Limited (Blackberry Limited)
• Inventors: May, Darrell R., Tysowski, Piotr K.
• Primary Examiner(s): Wu; Yicun
• Application Number:
  US11/534,239
• Publication Number:
  US 20080077632A1
• Time in Patent Office: 1,348 Days
• Field of Search: 707100-102, 455/412
• US Class Current: 707/610
• CPC Class Codes: G06F 16/211 Schema design and management
• CPC Class Codes: G06F 16/2358 Change logging, detection, and notification replication G06F16/27
• CPC Class Codes: H04L 67/1095 Replication or mirroring of data, e.g. scheduling or transport for data synchronisation between network nodes

Abstract

A method of updating a database, including data records, to accord with an updated schema. The method includes obtaining, at a portable electronic device, the updated schema associated with the database. If a field is deleted in the updated schema, the data records are updated by deleting the field from each of the data records. An update command is transmitted from the portable electronic device for updating the database schema for a corresponding backup database at a server.

Claims

1. A method of updating and backing up a database at a portable electronic device, including data records, to accord with an updated schema, the method comprising:

obtaining at said a portable electronic device the updated schema associated with the database;

comparing at said portable electronic device the updated schema with a previous schema associated with the database, to determine database schema changes, wherein said data records are stored in said database according to said previous schema;

changing the data records at said portable electronic device by deleting a field from each of the data records if the field is deleted in the updated schema;

generating an update command at said portable electronic device based on said comparing, when the updated schema differs from said previous schema, said update command comprising said database schema changes which enables a backup database stored at a server to be updated to accord with the updated schema; and

transmitting said update command from said portable electronic device to said server.

2. The method of updating and backing up a database according to claim 1, further comprising changing the data records, if a field is modified in the updated schema, by one of deleting data from a modified field for each of the data records and modifying field data for each of the data records.

3. The method of updating and backing up a database according to claim 1, wherein said previous schema is stored in memory at the portable electronic device.

4. The method of updating and backing up a database according to claim 1, wherein said transmitting an update command comprises transmitting an update command if a field is deleted in the updated schema.

5. The method of updating and backing up a database according to claim 4, wherein transmitting an update command comprises transmitting an update command if a field is modified in the updated schema.

6. The method of updating and backing up a database according to claim 1, wherein said obtaining at a portable electronic device the updated schema includes obtaining a mapping between field tags of the updated schema and field tags in a messaging application programming interface (MAPI).

7. The method of updating and backing up a database according to claim 1, comprising storing said updated schema at the portable electronic device.

8. The method of updating and backing up a database according to claim 1, further comprising:

receiving at the server the update command comprising database schema changes from the portable electronic device for updating the database schema for the backup database; and

changing the backup data records by deleting a field from each of the backup data records if the field is deleted in the updated schema.

9. The method of updating and backing up a database according to claim 8 comprising changing the backup data records, if a field is modified in the updated schema, by one of:

deleting data from the modified field for each of the backup data records and modifying the field data for each of the backup data records.

10. The method of updating and backing up a database according to claim 8, comprising storing said updated schema in association with said backup database.

17. The method according to claim 4, wherein said obtaining the updated schema comprises obtaining a mapping between field tags of the updated schema and field tags in a messaging application programming interface (MAPI).

18. The method according to claim 17, wherein said update command further comprises said mapping between field tags of the updated schema and field tags in said messaging application programming interface (MAPI).

11. A computer program product, comprising a computer usable medium having a computer-readable program code adapted to be executed to implement a method for updating and backing up a database at a portable electronic device, including data records, to accord with an updated schema, the method comprising:

obtaining at a portable electronic device the updated schema associated with a database;

comparing at said portable electronic device the updated schema with a previous schema associated with the database, to determine database schema changes, wherein said data records are stored in said database according to said previous schema;

changing the data records at said portable electronic device by deleting a field from each of the data records if the field is deleted in the updated schema;

generating an update command at said portable electronic device based on said comparing, when the updated schema differs from said previous schema, said update command comprising said database schema changes which enables a backup database stored at a server to be updated to accord with the updated schema; and

transmitting said update command from said portable electronic device to said server.

12. A portable electronic device comprising:

an input enabled to receive an updated schema associated with a database;

a memory enabled to store data records in said database;

a processor, connected to the input and the memory, said processor enabled to;

compare the updated schema with a previous schema associated with the database, to determine database schema changes, wherein said data records are stored in said database according to said previous schema;

change the data records deleting a field from each of the data records if the field is deleted in the updated schema;

generating an update command based on said comparing, when the updated schema differs from said previous schema, said update command comprising said database schema changes which enables a backup database stored at a server to be updated to accord with the updated schema; and

a transmitter, connected to the processor, said transmitter enabled to transmit said update command to said server.

13. The portable electronic device according to claim 12 wherein said input comprises at least one of a user input device, a receiver, and a connector.

14. A method of updating and backing up a database at a portable electronic device, said database comprising data records, to accord with an updated schema, the method comprising:

obtaining at said portable electronic device the updated schema associated with the database;

comparing at said portable electronic device the updated schema with a previous schema associated with the database, to determine database schema changes, wherein said data records are stored in said database according to said previous schema;

changing the data records by;

deleting a field from each of the data records, if said database schema changes comprise a deletion of said first field of the data records;

modifying field data stored in a second field in each of the data records, if said database schema changes comprise a modification of said second field of the data records; and

adding a new field in each of the data records, if said database schema changes comprise an addition of said new field of the data records;

generating an update command at said portable electronic device based on said comparing, when the updated schema differs from said previous schema, said update command comprising said database schema changes which enables a backup database stored at a server to be updated to accord with the updated schema; and

transmitting said update command from said portable electronic device to the server.

15. The method according to claim 14, wherein said modifying field data stored in said field of the data records comprises adding, deleting or modifying the data populating the field.

16. The method according to claim 14, wherein said previous schema is stored in memory at the portable electronic device.

19. The method according to claim 14, further comprising storing the updated schema at said portable electronic device.

20. The method according to claim 14, further comprising:

receiving at the server, the update command from the portable electronic device for updating the database schema for said backup database; and

changing backup data records according to said update command.

21. The method according to claim 20, wherein if said update command comprises a mapping between field tags of the updated schema and field tags in a messaging application programming interface (MAPI), said receiving said update command from the portable electronic device at said server comprises receiving said mapping between the field tags of said updated schema and the field tags in the MAPI.

22. The method according to claim 20, further comprising storing the updated schema in association with said backup database.

23. A computer program product, comprising a computer usable medium having a computer-readable program code adapted to be executed to implement a method for updating and backing up a database, at a portable electronic device, said database comprising data records, to accord with an updated schema, said method comprising:

obtaining at said portable electronic device the updated schema associated with the database;

comparing at said portable electronic device the updated schema with a previous schema associated with the database, to determine database schema changes, wherein said data records are stored in said database according to said previous schema;

changing the data records by;

deleting a field from each of the data records, if said database schema changes comprise a deletion of said first field of the data records;

modifying field data stored in a second field in each of the data records, if said database schema changes comprise a modification of said second field of the data records; and

adding a new field in each of the data records, if said database schema changes comprise an addition of said new field of the data records; and

generating an update command at said portable electronic device based on said comparing, when the updated schema differs from said previous schema, said update command comprising said database schema changes which enables a backup database stored at a server to be updated, to accord with the updated schema; and

transmitting said update command from said portable electronic device to the server.

24. A portable electronic device comprising:

an input enabled to receive an updated database schema associated with a database;

a memory enabled to store data records in said database;

a processor for executing computer-readable program code embodied in a computer usable medium of the portable electronic device, said computer-readable program code for causing the portable electronic device to;

obtain the updated schema associated with the database;

compare the updated schema with a previous schema associated with the database, to determine database schema changes, wherein said data records are stored in said database according to said previous schema;

change the data records by;

deleting a field from each of the data records, if said database schema changes comprise a deletion of said first field of the data records;

modifying field data stored in a second field in each of the data records, if said database schema changes comprise a modification of said second field of the data records; and

adding a new field in each of the data records, if said database schema changes comprise an addition of said new field of the data records; and

generating an update command based on said comparing, when the updated schema differs from said previous schema, said update command comprising said database schema changes which enables a backup database stored at a server to be updated to accord with the updated schema; and

transmitting said update command from said portable electronic device to the server.

25. The portable electronic device according to claim 24 wherein said input comprises at least one of a user input device, a receiver, and a connector.

26. A method carried out at a server for updating a backup database comprising backup data records stored on the server, to accord with an updated schema operated by a portable electronic device, the method comprising:

receiving an update command from the portable electronic device, said update command enables updating a database schema for the backup database, said update command determined at the portable electronic device by comparing an updated schema with a previous schema associated with a database at the portable electronic device, data records at the portable electronic device updated based on the comparison, wherein said data records are stored in said database according to said previous schema; and

changing the backup data records according to the update command by;

deleting a first field from each of the backup data records if the update command indicates that an associated first field is deleted in the updated schema operated by the portable electronic device,

modifying a second field in each of the backup data records, if the update command indicates that an associated second field of a data record stored in the database at the portable electronic device was previously modified when the updated database schema was applied to said database; and

adding a new field in each of the backup data records, if the update command indicates that an associated field of a data record stored in the database at the portable electronic device was previously added when the updated database schema was applied to said database.