System and method for synchronizing data between a plurality of databases

US 7,685,506 B2
Filed: 03/24/2003
Issued: 03/23/2010
Est. Priority Date: 02/13/1995
Status: Expired due to Fees

- Alert
- Pin

Associated Cases

Associated Defendants

First Claim

Patent Images

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 all claims

2 Assignments

Timeline View

Assignment View

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.

52 Citations

View as Search Results

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)
- - 2. The method as recited in claim 1 wherein receiving the confirmation message further comprises updating the date and time of the database synchronization.

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)
- - 4. The system as recited in claim 3 wherein the at least one modification identification field is automatically updated to reflect when any portion of the data is altered.
  - 5. The system as recited in claim 4 wherein the modification identification field further comprises a date/time of modification field identifying a date and time of receipt of altering data.
  - 6. The system as recited in claim 5 wherein the central processing unit, in identifying which portion of the data has been altered, is further operative to determine a date and time of a previous database synchronization and compare the date and time of the previous database synchronization with the date/time modification identification field associated with the data.
  - 7. The system as recited in claim 5 wherein the central processing unit, in modifying the data in the second database, is further operative to modify the second database in chronological order according to the date/time of modification identification field.
  - 8. The system as recited in claim 5 wherein the central processing unit, in identifying which portion of the data has been altered, is further operative to determine a date and time of a previous database synchronization.
  - 9. The system as recited in claim 5, wherein the central processing unit, in identifying which portion of the data has been altered is further operative to compare the date and time of the previous database synchronization with the date/time modification identification item associated with the data.
  - 10. The system as recited in claim 3 wherein the central processing unit is further operative to create and append a unique identification field to every new record of data that is added to the database.
  - 11. The system as recited in claim 10 wherein the central processing unit, in transferring only the altered portion of the data, is further operative to transfer only the altered portion of the data to the second database based on the unique identification field to eliminate the need to copy the entire database from the first database for synchronization.
  - 12. The system as recited in claim 3 wherein the central processing unit, in transferring only the altered portion of the data, is further operative to store the altered data in a redundant data database at the first database and transfer the redundant data database to the second database, and wherein, in modifying the second database, is operative to compare the altered data in the redundant data database with the replica data stored in the second database.
  - 13. The system as recited in claim 12, wherein the central processing unit is further operative to transfer identification information identifying the first database.
  - 14. The system as recited in claim 3 wherein the central processing unit, in modifying the second database, is further operative to determine if any of the data has been deleted from the first database, and if so, remove the deleted data from the second database.
  - 15. The system as recited in claim 3 wherein the central processing unit, upon receiving the confirmation message, is further operative to update the date and time of the database synchronization.

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)
- - 17. A method as set forth in claim 16 wherein the step of extracting is further defined as storing the altered portion of the first set of data in a redundant database at the first database and transferring the redundant database to the second database and comparing the altered portion of the first set of data in the redundant database with the second set of data stored in the second database.
  - 18. A method as set forth in claim 17 further comprising determining if any of the altered portion of the first set of data has been deleted from the first database, and if so, removing the deleted data from the second database.
  - 19. A method as set forth in claim 16 further comprising altering by addition, change, deletion or replacement of a portion of the second set of data in the second databases;
    - extracting the portion of the second set of data that has been altered in the second database;
      
      transferring only the altered portion from the second databases to the plurality of first databases at a predetermined time; and
      
      replacing the first set of data in the plurality of first databases in accordance with the altered portion of the second set of data.

Specification

Resources

Litigation Campaign Assessment

Litigation Data

Current Assignee
Hall Data Sync Technologies LLC
Original Assignee
S. E. HALL & CO.
Inventors
Hall, Stephan E., Fino, Timothy A.
Primary Examiner(s)
RUTLEDGE, AMELIA L

Application Number

US10/395,543
Publication Number

US 20030172006A1
Time in Patent Office

2,556 Days
Field of Search

715/500, 715/229, 715/200, 715/203, 707/203
US Class Current

715/200
CPC Class Codes

G06Q 30/02   Marketing; Price estimation...

G06Q 30/06   Buying, selling or leasing ...

G06Q 30/0601   Electronic shopping [e-shop...

G06Q 50/163   Real estate management

Y10S 707/99945   Object-oriented database st...

Y10S 707/99952   Coherency, e.g. same view t...

Y10S 707/99953   Recoverability

System and method for synchronizing data between a plurality of databases

First Claim

2 Assignments

Litigations

1 Petition

Accused Products

Abstract

52 Citations

19 Claims

Specification

Solutions

Use Cases

Quick Links

System and method for synchronizing data between a plurality of databases

First Claim

2 Assignments

Subscription Required

Subscription Required

Litigations

1 Petition

Subscription Required

Accused Products

Subscription Required

Abstract

52 Citations

19 Claims

Specification

Subscription Required

Solutions

Use Cases

Quick Links