×

Optimized database technique to enable faster data synchronization

  • US 7,113,963 B1
  • Filed: 11/10/2000
  • Issued: 09/26/2006
  • Est. Priority Date: 11/10/2000
  • Status: Expired due to Fees
First Claim
Patent Images

1. A method for synchronizing data records between plural databases comprising the steps of:

  • a) designating a first database as a source database and a second database as a target database;

    b) determining a state of a first modification flag and a second modification flag, said first modification flag contained in a first data record in said source database, said second modification flag contained in a first data record in said target database, wherein said first modification flag indicates that said first data record in said source database has been modified and wherein a value of said first modification flag, indicative of a particular event, is set upon an occurrence of said particular event, wherein said second modification flag indicates that said first data record in said target database has been modified and wherein a value of said second modification flag, indicative of a second particular event, is set upon an occurrence of said second particular event;

    c) provided that said first modification flag is set and said second modification flag is not set, propagating said first data record in said source database to said first data record in said target database;

    d) provided that said first modification flag is not set, comparing a first modification count contained in said first data record in said source database with a second modification count contained in said first data record in said target database, said first and second modification counts each being a value indicating how many times said first data record in said source database and said first data record in said target database has been modified respectively;

    e) provided that said first modification count has a higher value than said second modification count, propagating said first data record in said source database to said first data record in said target database, wherein said steps a) through e) can be completed without comparing raw data of said first data record and said corresponding data record;

    f) incrementing said second modification count to said high value of said first modification count;

    g) repeating said steps a) through f) until all of said data records in said source database have been processed; and

    h) re-designating said second database as said source database and said first database as said target database; and

    i) performing said steps a) through g) until all of said data records in said source database have been processed,wherein said step c) comprises the step of marking said first data record as deleted in said target database, provided that said first modification flag is set to indicate that said first data record has been deleted from said source database and that said first data record exists and is not already marked as deleted in said target database.

View all claims
  • 4 Assignments
Timeline View
Assignment View
    ×
    ×