System and method for synchronizing multiple database files

• US 7,013,316 B1
• Filed: 07/13/2000
• Issued: 03/14/2006
• Est. Priority Date: 07/13/2000
• Status: Expired due to Fees

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Curley, Vincent H., Black, Neil W., Mead, Jennifer R., Hansen, J. Peter
• Primary Examiner(s): Corrielus, Jean M.
• Assistant Examiner(s): Woo, Isaac M.
• Application Number:
  US09/615,182
• Time in Patent Office: 2,070 Days
• Field of Search: 707 1- 10, 707100-1041, 707200-205
• US Class Current: 1/1
• CPC Class Codes: G06F 16/275 Synchronous replication
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface
• CPC Class Codes: Y10S 707/99953 Recoverability
• CPC Class Codes: Y10S 707/99955 Archiving or backup

Abstract

A system and method for efficiently synchronizing multiple databases stored on multiple computing devices. The method and system provides a duplicated database configuration where a database can either be stored only on a plurality of client computers, or on at least client computer and a server computer. This duplicated database configuration allows users to access a database from a plurality of client computers that are communicatively connected to a server computer. In one embodiment, the method and system synchronizes the databases of a client computer to the database of a server computer by downloading selected database objects from the server computer database, thereby minimizing the amount of data transferred between the client and server computers. The synchronization routine selectively downloads database objects based on a comparison of server access time indicators stored in the databases. If the server access time stored in the server computer database is earlier than the access time stored in the client computer database, the server computer downloads the entire server computer database to the client computer. If the server access time stored in the client computer database is earlier than the server access time stored in the server computer database, the server computer only downloads new database objects from the server computer to the client computer. The synchronization routine also provides for reducing the likelihood of synchronization errors by detecting expired client computer databases. If a particular client computer database is expired, the server computer replaces the client computer database with the server computer database.

Claims

1. A computer-implemented method for dynamically synchronizing a duplicated database suitable for storage on both a server computer and a client computer, wherein a client computer database comprises a last server access time and a plurality of data objects and a server computer database comprises a creation time and a plurality of data objects, said computer-implemented method comprising:

downloading the server computer database data objects to the client computer database, if the client computer database last server access time indicates a time that is earlier than a time indicated by the creation time of the server computer database;

selectively downloading data objects stored in the server computer database to the client computer database, if the client computer database last server access time indicates a time that is not earlier than a time indicated by the creation time of the server computer database;

in response to receiving a user-generated command, configuring the database either for storage on the client computer or for storage on both the client computer and the server computer;

deleting the server computer database if the server computer contains a database and if the user-generated command dictates that the server computer database be deleted; and

copying the client computer database to the server computer, if the user-generated command dictates that the client computer database be copied to the server computer.

2. The computer-implemented method of claim 1, further comprising, updating the last server access time stored in the client computer database, wherein the updated last server access time corresponds to a clock time maintained by the server computer.

3. The computer-implemented method of claim 1, further comprising, transmitting, from the client computer to the server computer, the last server access time stored on the client computer database.

4. The computer-implemented method of claim 1, wherein each data object comprises a last server access time that indicates when the data object was modified, the selective downloading of the data objects comprises:

determining if the last server access time of one data object stored in the server computer database indicates a time later than a time indicated by the client computer database last server access time; and

selectively downloading the one data object stored in the server computer database to the client computer database, if the last server access time of the one data object stored in the server computer database indicates a time later than a time indicated by the client computer database last server access time.

5. The computer-implemented method of claim 1, further comprising:

determining if the client computer database last server access time is within a predetermined period of time from a clock time maintained by the server computer; and

downloading the server computer database to the client computer, if the client computer database last server access time is not within a predetermined period of time from a clock time maintained by the server computer.

6. A computer-readable medium containing computer-readable instructions which, when executed by a computer, perform the method of any one of claims 1–

5.

7. A computer-controlled apparatus for performing the method of any one of claims 1–

5.

8. The computer-implemented method of claim 1, further comprising deleting the client computer database if data objects have not been transmitted to the client computer system within a predetermined time period and if the server computer contains the database.

9. The computer-implemented method of claim 1, wherein the server computer communicates with the client computer using a Web server application.

10. The computer-implemented method of claim 1, wherein the data objects are configured to store any data that is capable of being stored in the database.

11. A computer-implemented method for dynamically synchronizing a duplicated database suitable for storage on both a server computer and a client computer, wherein a client computer database comprises a last server access time and a plurality of data objects and a server computer database comprises a creation time and a plurality of data objects, said computer-implemented method comprising:

determining if the client computer database last server access time indicates a time that is earlier than a time indicated by the creation time of the server computer database;

downloading the server computer database data objects to the client computer database, if the client computer database last server access time indicates a time that is earlier than a time indicated by the creation time of the server computer database;

in response to receiving a user-generated command, configuring the database for storage on either the client computer or both the client computer and the server computer; and

selectively downloading data objects stored in the server computer database to the client computer database, if the client computer database last server access time indicates a time that is not earlier than a time indicated by the creation time of the server computer database.

12. The computer-implemented method of claim 11, further comprising, updating the last server access time stored in the client computer database, wherein the updated last server access time corresponds to a clock time maintained by the server computer.

13. The computer-implemented method of claim 11, further comprising, transmitting, from the client computer to the server computer, the last server access time stored on the client computer database.

14. The computer-implemented method of claim 11, wherein each data object comprises a last server access time that indicates when the data object was modified, the selective downloading of the data objects comprises:

determining if the last server access time of one data object stored in the server computer database indicates a time later than a time indicated by the client computer database last server access time; and

selectively downloading the one data object stored in the server computer database to the client computer database, if the last server access time of the one data object stored in the server computer database indicates a time later than a time indicated by the client computer database last server access time.

15. The computer-implemented method of claim 11, further comprising:

determining if the client computer database last server access time is within a predetermined period of time from a clock time maintained by the server computer; and

downloading the server computer database to the client computer, if the client computer database last server access time is not within a predetermined period of time from a clock time maintained by the server computer.

16. The computer-implemented method of claim 15, wherein the predetermined period of time is ninety days.

17. A computer-readable medium containing computer-readable instructions which, when executed by a computer, perform the method of any one of claims 11–

16.

18. A computer-controlled apparatus for performing the method of any one of claims 11–

16.

19. The computer-implemented method of claim 11 wherein, if the client computer database does not contain a last server access time, determining that the client computer database was not initialized.

20. The computer implemented method of claim 11 wherein synchronizing the duplicated database suitable for storage on both the server computer and the client computer occurs automatically based on user defined settings.