Replication System with Methodology for Replicating Stored Procedure Calls
First Claim
1. In a database system without support for logging stored procedure invocations, a method for replicating invocation of a stored procedure from a primary database to a replicate database, the method comprising:
- inserting table data into the primary database for storing information sufficiently characterizing the procedure'"'"'s invocation to allow its replication, the table data being logged to a log file;
reading the log file, for determining changes to apply to the replicate database for replicating the procedure'"'"'s invocation; and
reconstructing the procedure'"'"'s invocation at the replicate database based on said determined changes.
1 Assignment
0 Petitions
Accused Products
Abstract
A replication system with methodology for replicating stored procedure calls is described. In one embodiment, for example, in a database system without support for logging stored procedure invocations, a method of the present invention is described for replicating invocation of a stored procedure from a primary database to a replicate database, the method comprises steps of: inserting table data into the primary database for storing information sufficiently characterizing the procedure'"'"'s invocation to allow its replication, the table data being logged to a log file; reading the log file, for determining changes to apply to the replicate database for replicating the procedure'"'"'s invocation; and reconstructing the procedure'"'"'s invocation at the replicate database based on the determined changes.
-
Citations
33 Claims
-
1. In a database system without support for logging stored procedure invocations, a method for replicating invocation of a stored procedure from a primary database to a replicate database, the method comprising:
-
inserting table data into the primary database for storing information sufficiently characterizing the procedure'"'"'s invocation to allow its replication, the table data being logged to a log file; reading the log file, for determining changes to apply to the replicate database for replicating the procedure'"'"'s invocation; and reconstructing the procedure'"'"'s invocation at the replicate database based on said determined changes. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17)
-
-
18. A system for replicating invocation of a stored procedure, the system comprising:
-
a primary database storing the procedure; a replicate database for receiving replication of the procedure'"'"'s invocation; at least one special purpose table created in the primary database for storing information sufficiently characterizing the procedure'"'"'s invocation to allow its replication; a log file storing log records that record changes to the primary database, including changes to said at least one special purpose table; and a log reader supporting replication of the procedure'"'"'s invocation to the replicate database based on changes recorded in the log file. - View Dependent Claims (19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33)
-
Specification