公开(公告)号：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.

公开(公告)号：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.

公开(公告)号：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.

公开(公告)号：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.

公开(公告)号：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.