SYSTEM AND PROGRAM PRODUCT FOR SEQUENTIAL COORDINATION OF EXTERNAL DATABASE APPLICATION EVENTS WITH ASYNCHRONOUS INTERNAL DATABASE EVENTS
First Claim
Patent Images
1. A database management system that includes a replication system, a processor, and a memory, the database management system comprising:
- at least one database table that is subject to replication;
a recovery log; and
a replication signal table;
said replication system creates 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;
said replication system 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;
said replication system detecting a recovery log entry in the recovery log that pertains to the at least one row of the replication signal table;
said replication system 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 of the replication signal table, according to the total order of the recovery log and executing said replication command entered in the replication signal table only after taking actions in response to all preceding entries of the recovery log; and
wherein the replication command comprises a first command comprising a signal stopping the copying of data into a database table.
6 Assignments
0 Petitions
Accused Products
Abstract
Database management systems and program products that exploit time dependent sequential database management system processes to ensure presentation of the same data or view to one or a plurality of users through sequencing asynchronous database management operations such as recovery and replication. Sequencing is accomplished through the use of entries in sequential logs, including transaction logs, recovery logs, and other data recovery tools and applications. Uses include managing data migration and data replication.
-
Citations
19 Claims
-
1. A database management system that includes a replication system, a processor, and a memory, the database management system comprising:
-
at least one database table that is subject to replication; a recovery log; and a replication signal table; said replication system creates 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; said replication system 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; said replication system detecting a recovery log entry in the recovery log that pertains to the at least one row of the replication signal table; said replication system 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 of the replication signal table, according to the total order of the recovery log and executing said replication command entered in the replication signal table only after taking actions in response to all preceding entries of the recovery log; and wherein the replication command comprises a first command comprising a signal stopping the copying of data into a database table. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8)
-
-
9. A program product comprising executable program codes stored on a processor usable storage medium and executed by a processor, the program product for managing a database management system, comprising:
-
said database management system including a replication system, at least one database table that is subject to replication, a recovery log, and a replication signal table; a program code for 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; a program code for detecting a recovery log entry in the recovery log that pertains to the replication signal table; a program code for taking replication actions responsive to the recovery log entries that are positioned subsequent to the recovery log entry that pertains to the replication signal table, according to the total order of the recovery log; a program code for inserting a replication command into the replication signal table; and wherein the replication command comprises a first command comprising a signal stopping the copying of data into a database table and wherein said replication command entered in said replication signal table also controls the processing of database events in a same transaction as said replication command. - View Dependent Claims (10, 11, 12, 13, 14, 15, 16, 17, 18, 19)
-
Specification