Invention Grant
- Patent Title: Techniques for the log-based replication of high-level procedures
- Patent Title (中): 高级程序的日志复制技术
-
Application No.: US13292918Application Date: 2011-11-09
-
Publication No.: US08676752B2Publication Date: 2014-03-18
- Inventor: Joydip Kundu , Anthony Adams , Goutam Kulkarni , Roger MacNicol , Douglas Voss , Qinqin Wang
- Applicant: Joydip Kundu , Anthony Adams , Goutam Kulkarni , Roger MacNicol , Douglas Voss , Qinqin Wang
- Applicant Address: US CA Redwood Shores
- Assignee: Oracle International Corporation
- Current Assignee: Oracle International Corporation
- Current Assignee Address: US CA Redwood Shores
- Agency: Vista IP Law Group, LLP
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/00

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.
Public/Granted literature
- US20120059792A1 Techniques for the Logical Replication of High-Level Procedures Public/Granted day:2012-03-08
Information query