Invention Grant
- Patent Title: Guaranteed commit outcome in a distributed transaction processing system
-
Application No.: US15009660Application Date: 2016-01-28
-
Publication No.: US10339127B2Publication Date: 2019-07-02
- Inventor: Carol Colrain , Stefan Heinrich Roesch , Todd J. Little , Paul Parkinson
- Applicant: ORACLE INTERNATIONAL CORPORATION
- Applicant Address: US CA Redwood Shores
- Assignee: Oracle International Corporation
- Current Assignee: Oracle International Corporation
- Current Assignee Address: US CA Redwood Shores
- Agency: Hickman Palermo Becker Bingham LLP
- Main IPC: G06F17/30
- IPC: G06F17/30 ; G06F16/23 ; G06F11/07

Abstract:
Techniques are described for providing a guaranteed commit outcome for global transactions that are optimized by deferring the commit processing to a resource manager, such as a DBMS, using optimizations. The “Distributed Transaction Processing: The XA Specification” standard specification is ambiguous regarding commit outcomes for transactions managed by DBMS, resulting in wrong results for vendors implementing the standard. The techniques described provide a guaranteed commit outcome when using the optimizations, creating the opportunity for safe replay of global transactions when a communication error or timeout occurs between the transaction manager and the resource manager, and eliminating ambiguous transaction outcomes reaching applications and end users.Techniques described herein distinguished between global transactions in a session managed by a transaction manager, and those in the same session that are managed by the resource manager using the optimizations. The techniques provide a guaranteed commit outcome when the commit is managed by the resource manager, or when a transaction manager is managing the transaction. Switching between the different techniques to provide a guaranteed outcome occurs in a safe, performing, and silent manner, based on who controls the current transaction in a session. The solution includes one-phase processing, read only optimizations, and promotable transactions.
Public/Granted literature
- US20170220621A1 GUARANTEED COMMIT OUTCOME IN A DISTRIBUTED TRANSACTION PROCESSING SYSTEM Public/Granted day:2017-08-03
Information query