System and method for synchronizing data between a plurality of databases
DCFirst Claim
1. A method for synchronizing data in data fields between a plurality of first databases in communication with a second database after at least a portion of the data in any one of the plurality of first databases has been altered by addition, change, deletion or replacement of a portion thereof, the second database having a replica of data stored in the first database of the plurality of first databases, the method comprising:
- comparing a modification identification, wherein the modification identification includes a modification field associated with the data in one of the plurality of first databases to a modification identification associated with a prior synchronization;
identifying an altered portion of the data that has the modification identification subsequent to the prior synchronization modification identification as a result of being altered;
transferring only the altered portion of the data from the first database of the one of the plurality of first databases to the second database;
replacing the data in the second database corresponding to the altered portion of the data;
wherein transferring only the altered portion of the data further includes;
receiving a confirmation message at the one of the plurality of first databases that transferred the altered portion to the second database that the altered portion is received; and
replacing the data stored in each one of the other plurality of first databases to correspond with the portion of the data altered in the one of the plurality of first databases.
2 Assignments
Litigations
1 Petition
Accused Products
Abstract
A system for facilitating the information transfer and processing associated with home construction and home sales. Various discrete software modules are disclosed each handling a specific task associated with home construction and sales. Also, a system for communicating between separate data bases is disclosed wherein separate and distinct sales offices, each having their own data base, may communicate with a parent, market office having its own data base wherein the data bases of the sales offices and the market office are synchronized according to the method of the present invention so that any data updates in any of the sales offices would be automatically updated in the associated market offices. This aspect of the present invention allows a corporation responsible for home construction and sales amongst various regional, market, and sales offices to coordinate a plurality of discretely separate data bases in a way such that they are all synchronized with one another at a predetermined time.
-
Citations
19 Claims
-
1. A method for synchronizing data in data fields between a plurality of first databases in communication with a second database after at least a portion of the data in any one of the plurality of first databases has been altered by addition, change, deletion or replacement of a portion thereof, the second database having a replica of data stored in the first database of the plurality of first databases, the method comprising:
-
comparing a modification identification, wherein the modification identification includes a modification field associated with the data in one of the plurality of first databases to a modification identification associated with a prior synchronization; identifying an altered portion of the data that has the modification identification subsequent to the prior synchronization modification identification as a result of being altered; transferring only the altered portion of the data from the first database of the one of the plurality of first databases to the second database; replacing the data in the second database corresponding to the altered portion of the data; wherein transferring only the altered portion of the data further includes; receiving a confirmation message at the one of the plurality of first databases that transferred the altered portion to the second database that the altered portion is received; and replacing the data stored in each one of the other plurality of first databases to correspond with the portion of the data altered in the one of the plurality of first databases. - View Dependent Claims (2)
-
-
3. A system for synchronizing data in data fields between first and second databases after at least a portion of the data in the first database has been altered by addition, change, deletion or replacement of a portion thereof, each of the databases having a replica of data stored in the other database, the system comprising:
-
an input device associated with the first database for receiving data altering at least a portion of the data stored in the first database; and a central processing unit associated with the first database for comparing a modification identification associated with the data in the first database to a modification identification associated with a prior synchronization, wherein the modification identification includes a modification field associated with the data;
identifying an altered portion of the data that has the modification identification subsequent to the prior synchronization modification identification as a result of being altered, transferring only the altered portion of the data from the first database to the second database, receiving a confirmation message at the first database from the second database, and replacing the data in the second database associated with the altered portion of the data. - View Dependent Claims (4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15)
-
-
16. A method for synchronizing data in data fields between a plurality of first databases and a second database, the method comprising:
-
providing each of the plurality of first databases with a first set of data capable of being modified in each of the first databases; providing the second database with a second set of data that corresponds to the first set of data and that is capable of being modified in the second database; altering by addition, change, deletion or replacement of a portion of the first set of data in at least one of the first databases; comparing a modification identification associated with the portion of first set of data to a modification identification associated with a prior synchronization for the first set of data, wherein the modification identification includes a modification field associated with the data; extracting the portion of the first set of data that has been altered in the one of the first databases and that has the modification identification subsequent to the prior synchronization modification identification as a result of being altered; transferring only the altered portion from the one of first databases to the second database at a predetermined time; replacing the second set of data in the second database corresponding to the altered portion of the first set of data; transferring the altered data from the second database to the other first databases; and replacing the first set of data stored in the other first databases in accordance with the altered portion of the first set of data transferred from the second database. - View Dependent Claims (17, 18, 19)
-
Specification