Patent ID: 6529917
Filing Date: 2003-03-04
Classification: G06F,Y10S

Abstract:
A replication method comprising:(a) generating an identifier column for a master table, the master table including a key column and an identifier column; (b) copying the master table to a satellite table, so that the satellite table is a replica of the master table; (c) associating an insert trigger with the master table; (d) assigning a first identifier value to the identifier column of an inserted row, the assigning caused by the insert trigger and occuring responsively to inserting a row into the master table; (e) allowing inserts to be made to the master table; and (f) synchronizing the satellite table to the master table, the synchronizing comprising: (i) comparing the master table key and identifier columns with the satellite table key and identifier columns; (ii) producing a row set of rows based on the comparing of 1.(f)(i), the rows being those rows present in the master table but not in the satellite table; (iii) comparing the master table key and identifier columns with the satellite table key and identifier columns; (iv) deleting the rows that are present in the satellite table but not in the master table, as determined based on the comparing of 1.(f)(iii); and (v) inserting the row set of rows into the satellite table.