System and method of synchronizing replicated data
OwnerWilliam Zoltaninventor
Life of this patent
Estimating the term…
Loading patent…
OwnerWilliam Zoltaninventor
Estimating the term…
A replication method is provided for synchronizing master and satellite data tables, including several acts. An identifier column is generated for each table of a tree of master tables. The tree of master tables is copied to a tree of satellite tables, so that the tree of satellite tables is a replica of the tree of master tables. An insert trigger is associated with each of the master tables. Inserts are allowed to be made to at least one of the master tables, and synchronizing the tree of satellite tables to the tree of master tables. Key and checksum columns of each of the master tables are compared with key and checksum columns of each of the satellite tables. Row sets of rows are produced, wherein each row set includes those rows present in the master table but not in the satellite table. The rows that are present in the satellite tables but not in the corresponding master tables are determined by comparing the key and checksum columns of the master tables to those of the satellite tables, and, are deleted. The row sets of rows are then inserted into the satellite tables.
A method for synchronizing a satellite table to a master table, the method comprising the steps of:
Dependencies are inferred from the claim text.