摘要 |
A replication method includes several acts. An identifier column is generated for each table of a tree of master tables, each of the master tables including a key column and an identifier column, wherein one of the master tables is a root master table, wherein all of the other master tables are foreign key master tables that are foreign key dependent upon at least one other of the master tables, wherein all of the master tables can be reached by traversal of the 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. A checksum is assigned to the checksum column of an inserted row, the assigning caused by one of the insert triggers and occurring responsively to inserting a row into one of the master tables.
|