18379684. FAILOVER OF DATABASE SESSIONS TO A LOGICAL REPLICA DATABASE simplified abstract (Oracle International Corporation)

FAILOVER OF DATABASE SESSIONS TO A LOGICAL REPLICA DATABASE

Organization Name

Oracle International Corporation

Inventor(s)

Carol Lyndall Colrain of Kansas City KS (US)

Xiaoli Qi of Palo Alto CA (US)

Kevin S. Neel of San Mateo CA (US)

Stephen J. Vivian of Londonderry NH (US)

Michael Cusson of Woburn MA (US)

Yunrui Li of Los Altos CA (US)

Jonathan Giloni of Foster City CA (US)

FAILOVER OF DATABASE SESSIONS TO A LOGICAL REPLICA DATABASE - A simplified explanation of the abstract

This abstract first appeared for US patent application 18379684 titled 'FAILOVER OF DATABASE SESSIONS TO A LOGICAL REPLICA DATABASE

Simplified Explanation

The patent application describes techniques for preserving inflight sessions during failover from a primary database to a replicated logical database.

• Techniques for preserving inflight sessions during failover:

   - Storing commit indications for transactions in the primary database before failover
   - Replicating commit indications to the logical replica database
   - Preserving client-side LOB references during failover
   - Preserving AS OF queries
   - Versioning checksums, signatures, and structures across logical replicas

Potential Applications

The technology described in the patent application could be applied in disaster recovery solutions for databases, ensuring seamless failover and minimal data loss.

Problems Solved

- Ensuring data consistency during failover - Preserving client-side references and queries - Maintaining versioning across logical replicas

Benefits

- Improved reliability and availability of database systems - Reduced downtime during failover events - Enhanced data integrity and consistency

Potential Commercial Applications

"Disaster Recovery Solutions for Databases: Preserving Inflight Sessions during Failover"

Possible Prior Art

There may be prior art related to database failover techniques, but specific examples are not provided in the patent application.

How does this technology impact database performance during failover events?

The patent application does not delve into the potential performance implications of the described techniques. It would be interesting to know if there are any trade-offs in terms of speed or resource utilization.

Are there any specific industries or use cases where this technology would be particularly beneficial?

While the patent application mentions general applications in disaster recovery, it would be valuable to explore if there are specific industries or scenarios where the described techniques could provide significant advantages.

Original Abstract Submitted

Techniques are described for preserving the inflight sessions failing over from a primary database to the replicated logical database of the primary database. In an implementation, prior to failover, when the primary database server receives a commit for a transaction, the process stores a commit indication that the transaction has been committed by performing a corresponding SQL command. The commit indication is replicated to the logical replica database by virtue of the replication of the SQL command and its execution on the logical replica database. Accordingly, the standby database server in the failover session may successfully request for the outcome of the transaction. Techniques are also described for the client-side LOB references to be preserved when failing over to the logical replica database, for AS OF queries preserved, and for versioning of checksums, signatures and structures across logical replicas.