Replication system with methodology for replicating stored...

Details Replication system with methodology for replicating stored... Replication system with methodology for replicating stored...

2011-05-31

2011-05-31

Lu, Charles E (Department: 2161)

Data processing: database and file management or data structures

File or database maintenance

Synchronization

C707S667000

Reexamination Certificate

active

07953698

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.

REFERENCES:
patent: 4819156 (1989-04-01), DeLorme et al.
patent: 4945474 (1990-07-01), Elliott et al.
patent: 5043866 (1991-08-01), Myre et al.
patent: 5155678 (1992-10-01), Fukumoto et al.
patent: 5170480 (1992-12-01), Mohan et al.
patent: 5280611 (1994-01-01), Mohan et al.
patent: 5287501 (1994-02-01), Lomet
patent: 5369757 (1994-11-01), Spiro et al.
patent: 5455946 (1995-10-01), Mohan et al.
patent: 5640561 (1997-06-01), Satoh et al.
patent: 5721918 (1998-02-01), Nilsson et al.
patent: 5758150 (1998-05-01), Bell et al.
patent: 5778388 (1998-07-01), Kawamura et al.
patent: 5806075 (1998-09-01), Jain et al.
patent: 6014674 (2000-01-01), McCargar
patent: 6192398 (2001-02-01), Hunt
patent: 6275832 (2001-08-01), Watts et al.
patent: 6321234 (2001-11-01), Debrunner
patent: 6496944 (2002-12-01), Hsiao et al.
patent: 6567928 (2003-05-01), Lyle et al.
patent: 6721765 (2004-04-01), Ghosh et al.
patent: 6845392 (2005-01-01), Koontz et al.
patent: 6941139 (2005-09-01), Shupe et al.
patent: 2006/0190498 (2006-08-01), Pruet, III
Information Technology—Database languages—SQL, American National Standard ANSI/ISO/IEC 9075: 1992.

Affiliated with

Also associated with

Rating

Replication system with methodology for replicating stored... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Replication system with methodology for replicating stored..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Replication system with methodology for replicating stored... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2656844