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

公开(公告)号：US10915506B2

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

申请号：US15912866

申请日：2018-03-06

Applicant: Oracle International Corporation

Inventor： Pablo Silberkasten ,  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 row buffering 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 engine can maintain a plurality of local row buffers to store rows fetched from a database. The local buffers can be filled by rows pre-fetched from the database. When a client application requests rows from the database, the transparency engine can first check whether the rows exist in a local buffer. If the rows are present in the local buffer, the transparency engine sends the rows to the requesting client application, without going to the database.

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

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

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