TRANSITIVE DATABASE REPLICATION

A database is replicated to other systems using multisite table(s) and associated replication trigger logic. Each system includes a main table, multisite table(s) and replication trigger logic. A multisite table corresponds to a main table of another system. When a main table of a system is changed, in response to an input, the system generates and sends replication transactions to the other systems for changing main tables in the other systems. In accordance with the change specified in the replication transaction, the multisite tables are modified. In each system, the replication trigger logic determines whether or not to replicate the change specified in the replication transaction to the main table of the each system, upon application of the replication trigger logic to the replication transaction. The change specified in the replication transaction may relate to inserting, deleting, or updating a record in the main table.