Techniques for the logical replication of high-level procedures

Details Techniques for the logical replication of high-level procedures Techniques for the logical replication of high-level procedures

2007-12-12

2011-12-27

Cottingham, John R. (Department: 2167)

Data processing: database and file management or data structures

File or database maintenance

Synchronization

Reexamination Certificate

active

08086564

ABSTRACT:
A method and system that annotates a redo log to provide information concerning the execution of a procedure at a primary database. The annotations include entry and exit markers that indicate the beginning and the end of the execution along with any arguments passed to the procedure, and whether the execution of the procedure was successful. At the standby database, these markers are used to create a logical transaction associated with the procedure. The operations performed by the procedure are grouped into individual transactions, and these individual transactions are grouped as belonging to the logical transaction. If the execution of the procedure was successful at the primary database, then the individual transactions are discarded, and the logical transaction is applied by executing the procedure at the standby database. If the execution of the procedure failed at the primary database, then the individual transactions and the logical transaction are discarded.

REFERENCES:
patent: 6067542 (2000-05-01), Carino, Jr.
patent: 6678704 (2004-01-01), Bridge et al.
patent: 6980988 (2005-12-01), Demers et al.
patent: 7003694 (2006-02-01), Anderson et al.
patent: 7305421 (2007-12-01), Cha et al.
patent: 2004/0098425 (2004-05-01), Wiss et al.
patent: 2004/0148316 (2004-07-01), Bridge et al.
patent: 2004/0210577 (2004-10-01), Kundu et al.
patent: 2004/0210606 (2004-10-01), Brown et al.
patent: 2005/0262170 (2005-11-01), Girkar et al.
patent: 2005/0289174 (2005-12-01), Kolli et al.
patent: 2006/0004838 (2006-01-01), Shodhan et al.
patent: 2007/0100912 (2007-05-01), Pareek et al.
patent: 2007/0124348 (2007-05-01), Claborn et al.
patent: 2007/0168704 (2007-07-01), Connolly et al.
patent: 2007/0192384 (2007-08-01), Shodhan et al.
patent: 2007/0198700 (2007-08-01), Vivian et al.

Affiliated with

Also associated with

Rating

Techniques for the logical replication of high-level procedures does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Techniques for the logical replication of high-level procedures, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Techniques for the logical replication of high-level procedures will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4302409