System and method for synchronizing multiple database files
First Claim
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 Assignments
0 Petitions
Accused Products
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.
-
Citations
20 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. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10)
-
-
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. - View Dependent Claims (12, 13, 14, 15, 16, 17, 18, 19, 20)
-
Specification