Replication-only triggers

摘要

A method provides a replication-only trigger in a database management system. The database management system has a source server and a target server. At least one replication-only trigger which is associated with a replication operation is registered. The replication-only trigger is associated with a stored procedure. The stored procedure is invoked in response to an occurrence of the replication operation in replicating data from the source server to the target server.

主权项

1. A method of managing replicated data at a target database, comprising:
registering a replication-only trigger specifying a replication condition and a stored procedure, the replication-only trigger configured to invoke the stored procedure only upon detecting a replication event at the target database that satisfies the replication condition, wherein the replication-only trigger comprises one of: (i) a pre-commit trigger, and (ii) a post-commit trigger, wherein the pre-commit trigger executes within a transaction that applies the replication event to data in the target database, wherein the post-commit trigger creates an indication specifying whether the replication event is successfully applied to the data in the target database, wherein the replication-only trigger comprises a replication trigger header associated with a replication trigger column; monitoring, at the target database, replication events received from a source database to detect when the replication condition is satisfied; responsive to detecting a first replication event that satisfies the replication condition specified in the replication-only trigger, invoking the stored procedure specified by the replication-only trigger at the target database; and updating a progress table that indicates a commit point of a transaction which was last processed, wherein invoking the specified stored procedure is based on the commit point of the progress table.