×

Method, system, and program product for sequential coordination of external database application events with asynchronous internal database events

  • US 7,979,546 B2
  • Filed: 04/15/2008
  • Issued: 07/12/2011
  • Est. Priority Date: 05/09/2002
  • Status: Expired due to Fees
First Claim
Patent Images

1. A method of managing a database management system that includes a replication system and that has at least one database table that is subject to replication, a recovery log, and a replication signal table, said method comprising computer executable program code stored on a memory and executed on a processor to perform:

  • creating entries in the recovery log in response to changes to a state of any one or more of the at least one database table and the replication signal table, wherein said replication signal table is a specific table that is configured for all users of the database management system, and wherein the entries in the recovery log are ordered according to a total order;

    inserting into the replication signal table, at least one row that describes a replication command to the replication system relating to the at least one database table;

    detecting a recovery log entry in the recovery log that pertains to the at least one row in the replication signal table;

    taking replication actions responsive to the recovery log entries that are positioned subsequent to the recovery log entry that pertains to the at least one row in the replication signal table, according to the total order of the recovery log.

View all claims
  • 6 Assignments
Timeline View
Assignment View
    ×
    ×