Abstract: A method for accessing information in a replicated database includes receiving a request for information in a database. The request is associated with a table in the database. The table includes a plurality of identifiers each identifying a portion of the information in the table. The method also includes executing a logical structure associated with the table to produce a logical view of the table. The logical view contains at least a portion of the information from the table without containing the identifiers. The method further includes identifying the requested information in the logical view, and communicating the identified requested information in the logical view.

Abstract: 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.

Abstract: 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.

Abstract: A replication method including 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 occuring responsively to inserting a row into one of the master tables.

Abstract: A replication method including 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 occuring responsively to inserting a row into one of the master tables.

Abstract: 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 I 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.