×

Method for sequential coordination of external database application events with asynchronous internal database events

  • US 7,426,559 B2
  • Filed: 05/09/2002
  • Issued: 09/16/2008
  • 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 executing on a processor and in communication with a memory, the method comprising:

  • 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; and

    wherein the replication command comprises a first command comprising a signal stopping the replication of changes related to a database table wherein the first command is a signal stopping application of changes to data into a first database table, and a second command is a signal starting application of changes to contents of the first database table into a second database table.

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