公开(公告)号：US20190075170A1

公开(公告)日：2019-03-07

申请号：US15912861

申请日：2018-03-06

Applicant: Oracle International Corporation

Inventor： Carol Colrain ,  Kevin Neel ,  Pablo Silberkasten ,  Michael McMahon ,  Saurabh Verma ,  Douglas Surber ,  Jean De Lavarene

IPC: H04L29/08 ,  G06F17/30 ,  G06F1/30

Abstract: In accordance with an embodiment, described herein is a system and method for high availability and load balancing in a database environment. A transparency engine can be provided between client applications and a database, and can operate as a proxy engine for the database and as a session abstraction layer for the client applications, to enable the client applications to utilize database features provided by the connection pool without code changes to the client applications. The transparency can keep track of session states, request boundaries and cursors to efficiently reuse the database connections across the client applications. The transparency engine can use the request boundaries and indicators from the database to detect safe places to drain database connections in the event of database outages.

公开(公告)号：US12072851B2

公开(公告)日：2024-08-27

申请号：US17409203

申请日：2021-08-23

Applicant: Oracle International Corporation

Inventor： Pablo Silberkasten ,  Carol Colrain ,  Kevin Neel ,  Michael McMahon ,  Saurabh Verma ,  Jean De Lavarene

IPC: G06F15/16 ,  G06F1/30 ,  G06F16/21 ,  G06F16/2455 ,  G06F16/25 ,  G06F16/958 ,  H04L67/1004 ,  H04L67/14 ,  H04L67/141 ,  H04L67/142 ,  H04L67/145 ,  H04L67/5681

CPC classification number: G06F16/21 ,  G06F1/30 ,  G06F16/2455 ,  G06F16/252 ,  G06F16/972 ,  H04L67/1004 ,  H04L67/14 ,  H04L67/141 ,  H04L67/142 ,  H04L67/145 ,  H04L67/5681

Abstract: In accordance with an embodiment, described herein is a system and method for connection concentration in a database environment. A transparency engine provided between client applications and a database can include a connection pool (e.g., UCP connection pool). The transparency engine can operate as a proxy engine for the database and as a session abstraction layer for the client applications, to enable the client applications to utilize features provided by the connection pool without code changes. The transparency engine can receive application connections from the client applications, and concentrate the application connections on a smaller number of database connections maintained in the connection pool.

公开(公告)号：US09984096B2

公开(公告)日：2018-05-29

申请号：US15087895

申请日：2016-03-31

Applicant: Oracle International Corporation

Inventor： Paul Parkinson ,  Todd J. Little ,  Carol Colrain ,  Jean De Lavarene ,  Vivekanandhan Raja ,  Douglas Surber ,  Stefan Roesch ,  Nancy Ikeda ,  Kevin Neel

IPC: G06F17/30 ,  G06F9/46

CPC classification number: G06F17/30227 ,  G06F9/46 ,  G06F9/466

Abstract: A system and method for reducing communications overhead in a distributed transaction processing environment such as an XA environment. In accordance with an embodiment communication overhead is reduced in a transaction start method by deferring a transaction start communication. The deferred transaction start communication is determined from a subsequent transaction processing communication thereby reducing the number of networks calls required for each transaction and enhancing system performance.

公开(公告)号：US11100058B2

公开(公告)日：2021-08-24

申请号：US15912856

申请日：2018-03-06

Applicant: Oracle International Corporation

Inventor： Pablo Silberkasten ,  Carol Colrain ,  Kevin Neel ,  Michael McMahon ,  Saurabh Verma ,  Jean De Lavarene

IPC: G06F15/16 ,  G06F16/21 ,  H04L29/08 ,  G06F16/958 ,  G06F16/25 ,  G06F1/30 ,  G06F16/2455

Abstract: In accordance with an embodiment, described herein is a system and method for connection concentration in a database environment. A transparency engine provided between client applications and a database can include a connection pool (e.g., UCP connection pool). The transparency engine can operate as a proxy engine for the database and as a session abstraction layer for the client applications, to enable the client applications to utilize features provided by the connection pool without code changes. The transparency engine can receive application connections from the client applications, and concentrate the application connections on a smaller number of database connections maintained in the connection pool.

公开(公告)号：US10678761B2

公开(公告)日：2020-06-09

申请号：US15912861

申请日：2018-03-06

Applicant: Oracle International Corporation

Inventor： Carol Colrain ,  Kevin Neel ,  Pablo Silberkasten ,  Michael McMahon ,  Saurabh Verma ,  Douglas Surber ,  Jean De Lavarene

IPC: G06F16/21 ,  G06F16/2455 ,  G06F16/958 ,  G06F1/30 ,  H04L29/08 ,  G06F16/25

Abstract: In accordance with an embodiment, described herein is a system and method for high availability and load balancing in a database environment. A transparency engine can be provided between client applications and a database, and can operate as a proxy engine for the database and as a session abstraction layer for the client applications, to enable the client applications to utilize database features provided by the connection pool without code changes to the client applications. The transparency can keep track of session states, request boundaries and cursors to efficiently reuse the database connections across the client applications. The transparency engine can use the request boundaries and indicators from the database to detect safe places to drain database connections in the event of database outages.

公开(公告)号：US10318520B2

公开(公告)日：2019-06-11

申请号：US15087896

申请日：2016-03-31

Applicant: Oracle International Corporation

Inventor： Paul Parkinson ,  Todd J. Little ,  Carol Colrain ,  Jean De Lavarene ,  Vivekanandhan Raja ,  Douglas Surber ,  Stefan Roesch ,  Nancy Ikeda ,  Kevin Neel

IPC: G06F9/46 ,  G06F16/23

Abstract: A system and method for reducing communications overhead in a distributed transaction processing environment such as an XA environment. In accordance with an embodiment communication overhead is reduced in a transaction by deferring a transaction end communication. The deferred transaction end communication is determined from a subsequent XA transaction communication thereby reducing the number of networks calls required for each transaction and enhancing system performance.

公开(公告)号：US10909088B2

公开(公告)日：2021-02-02

申请号：US15912861

申请日：2018-03-06

Applicant: Oracle International Corporation

Inventor： Carol Colrain ,  Kevin Neel ,  Pablo Silberkasten ,  Michael McMahon ,  Saurabh Verma ,  Douglas Surber ,  Jean De Lavarene

IPC: G06F16/21 ,  G06F16/2455 ,  G06F16/958 ,  G06F1/30 ,  H04L29/08 ,  G06F16/25

Abstract: In accordance with an embodiment, described herein is a system and method for high availability and load balancing in a database environment. A transparency engine can be provided between client applications and a database, and can operate as a proxy engine for the database and as a session abstraction layer for the client applications, to enable the client applications to utilize database features provided by the connection pool without code changes to the client applications. The transparency can keep track of session states, request boundaries and cursors to efficiently reuse the database connections across the client applications. The transparency engine can use the request boundaries and indicators from the database to detect safe places to drain database connections in the event of database outages.

公开(公告)号：US10339127B2

公开(公告)日：2019-07-02

申请号：US15009660

申请日：2016-01-28

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Carol Colrain ,  Stefan Heinrich Roesch ,  Todd J. Little ,  Paul Parkinson

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.