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;
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 with log sequence numbers;
said replication system inserting into the replication signal table a replication command to the replication system relating to the at least one database table and comprising a first log sequence number correlating to a current first recovery log entry;
said replication system detecting a second recovery log entry in the recovery log for said replication command;
said replication system processing recovery log entries that are positioned subsequent to the second recovery log entry according to the log sequence numbers of the recovery log and executing said replication command entered in the replication signal table only after processing all recovery log entries up to the first recovery log entry pointed to by the first log sequence number.
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
18 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; 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 with log sequence numbers; said replication system inserting into the replication signal table a replication command to the replication system relating to the at least one database table and comprising a first log sequence number correlating to a current first recovery log entry; said replication system detecting a second recovery log entry in the recovery log for said replication command; said replication system processing recovery log entries that are positioned subsequent to the second recovery log entry according to the log sequence numbers of the recovery log and executing said replication command entered in the replication signal table only after processing all recovery log entries up to the first recovery log entry pointed to by the first log sequence number. - 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 comprising 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 with log sequence numbers; a program code for inserting a replication command to the replication system into the replication signal table, said replication command relating to the at least one database table and comprising a first log sequence number correlating to a current first recovery log entry; and a program code for detecting a second recovery log entry in the recovery log for the said replication command; a program code for processing recovery log entries that are positioned subsequent to the second recovery log entry according to the log sequence numbers of the recovery log and executing said replication command entered in the replication signal table only after processing all recovery log entries up to the first recovery log entry pointed to the first log sequence number. - View Dependent Claims (10, 11, 12, 13, 14, 15, 16, 17, 18)
-
Specification