System and method for synchronizing multiple database files

• US 7,206,796 B2
• Filed: 08/12/2005
• Issued: 04/17/2007
• 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): WOO, ISAAC M
• Application Number:
  US11/202,736
• Publication Number:
  US 20050278392A1
• Time in Patent Office: 613 Days
• Field of Search: 707100-1041, 707200-206
• US Class Current: 707/620
• 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 a 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.

Claims

1. A method for initializing a database system having one client computer and a server computer, comprising:

determining if the server computer contains a database;

copying a client computer database to the server computer, if the server computer does not contain a database;

synchronizing the client computer database with the server computer database if the server computer contains a database, wherein synchronizing the client computer database with the server computer database includes;

receiving, at the client computer, synchronization data from the server computer;

updating the entire client computer database with the server computer database if the synchronization data includes the server computer database; and

updating selective client computer database data objects, if the synchronization data only includes corresponding selective server data objects;

in response to receiving a user-generated command, configuring the database for;

storage only on the client computer;

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 a database only be stored on the client computer;

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.

2. The method as recited in claim 1, further comprising transmitting, from the client computer to the server computer, a last access time stored on the client computer database.

3. The method as recited in claim 1, further comprising receiving an updated last server access time from the server computer, wherein the updated last server access time corresponds to a clock time maintained by the server computer.

4. A computer-readable medium bearing computer-executable instructions which, when executed, initializes a database system having one client computer and a server computer, comprising:

determining if the server computer contains a database;

copying a client computer database to the server computer, if the server computer does not contain a database;

synchronizing the client computer database with the server computer database if the server computer contains a database, wherein synchronizing the client computer database with the server computer database includes;

receiving, at the client computer, synchronization data from the server computer;

updating the entire client computer database with the server computer database if the synchronization data includes the server computer database; and

updating selective client computer database data objects, if the synchronization data only includes corresponding selective server data objects;

in response to receiving a user-generated command, configuring the database for;

storage only on the client computer;

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 a database only be stored on the client computer;

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.

5. The computer-readable medium as recited in claim 4, further comprising transmitting, from the client computer to the server computer, a last access time stored on the client computer database.

6. The computer-readable medium as recited in claim 4, further comprising receiving an updated last server access time from the server computer, wherein the updated last server access time corresponds to a clock time maintained by the server computer.

7. A method for initializing a database system having one client computer and a server computer, comprising:

determining if the server computer contains a database;

copying a client computer database to the server computer, if the server computer does not contain a database;

synchronizing the client computer database with the server computer database if the server computer contains a database;

wherein synchronizing the client computer database with the server computer database includes 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 for;

storage only on the client computer;

storage on both the client computer and the server computer; and

deleting the server computer database if the server computer contains a database and if the user-generated command dictates that a database only be stored on the client computer.

8. The method as recited in claim 7, 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.

9. The method as recited in claim 7, wherein selectively downloading data objects stored in the server computer database to the client computer database includes 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.

10. The method as recited in claim 9, further comprising 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, downloading the one data object stored in the server computer database to the client computer database.

11. A computer-readable medium bearing computer-executable instructions which, when executed, initializes a database system having one client computer and a server computer, comprising:

determining if the server computer contains a database;

copying a client computer database to the server computer, if the server computer does not contain a database;

synchronizing the client computer database with the server computer database if the server computer contains a database;

wherein synchronizing the client computer database with the server computer database includes 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 for;

storage only on the client computer;

storage on both the client computer and the server computer; and

deleting the server computer database if the server computer contains a database and if the user-generated command dictates that a database only be stored on the client computer.

12. The computer-readable medium as recited in 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-readable medium as recited in claim 11, wherein selectively downloading data objects stored in the server computer database to the client computer database includes 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.

14. The computer-readable medium as recited in claim 13, further comprising 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, downloading the one data object stored in the server computer database to the client computer database.