×

Replication system with methodology for replicating stored procedure calls

  • US 7,953,698 B2
  • Filed: 08/03/2006
  • Issued: 05/31/2011
  • Est. Priority Date: 08/03/2006
  • Status: Active Grant
First Claim
Patent Images

1. In a database system employing a log file to record database changes but without support for logging stored procedure invocations, a method for providing support for replicating invocation of a user-created stored procedure from a primary database to a replicate database, the method implemented on at least one computer having a processor and a memory, the method comprising:

  • receiving from a user Structured Query Language (SQL) statements that define a stored procedure to be invoked at the primary database;

    receiving from the user subsequent SQL statements that invoke said stored procedure at the primary database;

    inserting into the stored procedure new code that tracks the stored procedure'"'"'s invocation, wherein when the stored procedure is invoked the new code inserted into the stored procedure also executes, and wherein said new code includes code that inserts table data when the procedure begins executing, code that removes table data when the procedure stops executing, and code that inserts table data indicating with which procedure parameter values the stored procedure is invoked;

    responsive to execution of said new code inserted into the stored procedure, recording descriptor information characterizing the stored procedure'"'"'s invocation, including information about when the stored procedure begins and exits execution, and information about any parameter values passed to the stored procedure, said descriptor information characterizing the stored procedure'"'"'s invocation without recording information about data values in the primary database that are affected as a result of the stored procedure'"'"'s invocation;

    propagating the stored procedure'"'"'s invocation through a log file of the primary database, wherein when the stored procedure'"'"'s invocation is propagated said descriptor information is stored as table data inserted into the primary database;

    reading the log file at the replicate database, for interpreting the descriptor information propagated through the log file; and

    replicating the stored procedure'"'"'s invocation at the replicate database based on said descriptor information.

View all claims
  • 1 Assignment
Timeline View
Assignment View
    ×
    ×