Method and system for supporting data consistency on an active standby database after DML redirection to a primary database

A computer program product embodied on a non-transitory computer readable medium, the computer readable medium having stored thereon a sequence of instructions which, when executed by a processor causes the processor to execute a method for supporting data consistency on an active standby database after redirecting a Data Manipulation Language (DML) statement to a primary database, comprising:

• receiving the DML statement at a database session in an active standby server on which the active standby database resides;
• redirecting the DML statement from the active standby server to the primary database;
• executing the DML statement on the primary database;
• communicating information associated with execution of the DML statement on the primary database to the database session in the active standby server;
• receiving a query at the active standby database through an additional database session in the active standby server, the query directed to data to which the DML statement is directed;
• determining whether the additional database session is associated with additional information that matches a subset of the information associated with execution of the DML statement on the primary database;
• and
• sending a set of results to a client from which the query originated, wherein the set of results include one or more changes made by the DML statement responsive to determining the additional database session is associated with additional information that matches the subset of the information associated with execution of the DML statement and the set of results do not include the one or more changes made by the DML statement responsive to determining the additional database session is not associated with additional information that matches the subset of the information associated with execution of the DML statement.

A computer system to implement a method for supporting data consistency on an active standby database after redirecting a Data Manipulation Language (DML) statement to a primary database, comprising:

• a memory for storing data and instructions;
• and
• a processor that executes a sequence of instructions which, when executed by the processor causes the processor to execute a process, the process comprising:
• receiving the DML statement at a database session in an active standby server on which the active standby database resides;
• redirecting the DML statement from the active standby server to the primary database;
• executing the DML statement on the primary database;
• communicating information associated with execution of the DML statement on the primary database to the database session in the active standby server;
• receiving a query at the active standby database through an additional database session in the active standby server, the query directed to data to which the DML statement is directed;
• determining whether the additional database session is associated with additional information that matches a subset of the information associated with execution of the DML statement on the primary database;
• and
• sending a set of results to a client from which the query originated, wherein the set of results include one or more changes made by the DML statement responsive to determining the additional database session is associated with additional information that matches the subset of the information associated with execution of the DML statement and the set of results do not include the one or more changes made by the DML statement responsive to determining the additional database session is not associated with additional information that matches the subset of the information associated with execution of the DML statement.