Patent ID: 6668260
Filing Date: 2003-12-23
Classification: G06F,Y10S

Abstract:
A method of replicating a database table comprising the steps of:(a) generating a master table having a key column and an identifier column; (b) copying the master table to a satellite table, (c) inserting at least one row into the master table; and (d) assigning a first identifier value to the identifier column of the inserted row; (e) comparing the master table key and identifier columns of the master table with the satellite table key and identifier columns of the satellite table; (i) producing a set of rows based on said comparison, said set of rows, including rows present in the master table but not present in the satellite table; (ii) deleting from the satellite table rows that are present in the satellite table but not in the master table, as determined by said comparison; and (iii) inserting the set of rows into the satellite table.