公开(公告)号：US11120036B2

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

申请号：US15227899

申请日：2016-08-03

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Jean de Lavarene ,  Yuri Dolgov ,  Vidya Hegde ,  Saurabh Verma ,  Krishna Chandra ,  Aramvalarthanathan Namachivayam

IPC: G06F16/25 ,  G06F16/2455 ,  G06F9/50 ,  H04L29/06

Abstract: Described herein are systems and methods for providing access to a database in a multi-tenant environment, including the use of a connection pool, with support for efficient repurposing of connections. In accordance with an embodiment, a software application can request that a connection be provided, to enable access to the database. In response to receiving the request, the connection pool can first determine if a particular connection with the exact desired attributes already exists within the pool, but is borrowed at the time of the request. If such a connection exists, then the connection pool can wait a period of time for that particular connection to become available, referred to herein as a double-wait. Subsequently, if the particular connection is not made available within the double-wait time period, the connection pool resumes its usual operation, for example by repurposing other connections.

公开(公告)号：US20180039678A1

公开(公告)日：2018-02-08

申请号：US15227899

申请日：2016-08-03

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Jean de Lavarene ,  Yuri Dolgov ,  Vidya Hegde ,  Saurabh Verma ,  Krishna Chandra ,  Aramvalarthanathan Namachivayam

IPC: G06F17/30 ,  H04L29/06

CPC classification number: G06F16/25 ,  G06F9/5061 ,  G06F16/24552 ,  H04L67/42

Abstract: Described herein are systems and methods for providing access to a database in a multi-tenant environment, including the use of a connection pool, with support for efficient repurposing of connections. In accordance with an embodiment, a software application can request that a connection be provided, to enable access to the database. In response to receiving the request, the connection pool can first determine if a particular connection with the exact desired attributes already exists within the pool, but is borrowed at the time of the request. If such a connection exists, then the connection pool can wait a period of time for that particular connection to become available, referred to herein as a double-wait. Subsequently, if the particular connection is not made available within the double-wait time period, the connection pool resumes its usual operation, for example by repurposing other connections.

公开(公告)号：US10909211B2

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

申请号：US15644504

申请日：2017-07-07

Applicant: Oracle International Corporation

Inventor： Jean De Lavarene ,  Vidya Hegde ,  Saurabh Verma ,  Chandra Sekhar Krishna Mahidhara ,  Aramvalarthanathan Namachivayam

IPC: G06F16/00 ,  G06F16/958 ,  G06F16/25 ,  G06F16/28 ,  G06F16/21 ,  G06F16/2453

Abstract: Described herein are systems and methods for providing access to a database in a multi-tenant environment, including the use of a connection pool, and support for limiting the maximum number of connections per tenant or per database shard. For example, when a tenant is associated with a service, configuring a maximum connections per service limit on a shared connection pool indicates to the system that the shared pool should not repurpose existing connections, or create new connections for a service, if the maximum connections per service limit has been reached for that particular service. The system can also maintain a parameter that keeps track of the total number of connections created to each shard of a sharded database. The connection pool can scan the sharded database topology, to determine which shard or sharded instance can satisfy the request, without exceeding the maximum limit for that shard.

公开(公告)号：US10824750B2

公开(公告)日：2020-11-03

申请号：US15644505

申请日：2017-07-07

Applicant: Oracle International Corporation

Inventor： Jean De Lavarene ,  Aramvalarthanathan Namachivayam ,  Vidya Hegde ,  Saurabh Verma ,  Chandra Sekhar Krishna Mahidhara

IPC: G06F16/00 ,  G06F21/62 ,  H04L29/06 ,  G06F16/951 ,  H04L29/08

Abstract: Described herein are systems and methods for providing access to a database in a multi-tenant environment, including the use of a connection pool, and support for efficient connection validation. For example, the system can support a “seconds to trust idle connection” functionality, which enables lazy validation of connections in the connection pool. The seconds to trust idle connection is the time period, expressed, for example, as a number of seconds, within a particular connection usage, that the connection pool trusts that the connection is still viable, and if so will skip a connection validation test before delivering the connection to a requesting application.

公开(公告)号：US11290540B2

公开(公告)日：2022-03-29

申请号：US15644508

申请日：2017-07-07

Applicant: Oracle International Corporation

Inventor： Jean De Lavarene ,  Vidya Hegde ,  Saurabh Verma ,  Chandra Sekhar Krishna Mahidhara ,  Aramvalarthanathan Namachivayam

IPC: H04L29/08 ,  H04L67/141 ,  H04L67/01

Abstract: Described herein are systems and methods for providing access to a database in a multi-tenant environment, including the use of a connection pool, and support for server-side connection pool multiple tagging. For example, the system can provide a capability to associate multiple connection properties with a particular server-side connection in, e.g., an Oracle Database Resident Connection Pooling (DRCP) environment; look up a connection with one or multiple properties; and provide information about a returned connection so that a requesting application can review the properties associated with the returned connection, in order to determine how best to “fix-up” or otherwise use that connection.

公开(公告)号：US10742748B2

公开(公告)日：2020-08-11

申请号：US15644502

申请日：2017-07-07

Applicant: Oracle International Corporation

Inventor： Jean De Lavarene ,  Saurabh Verma ,  Vidya Hegde ,  Chandra Sekhar Krishna Mahidhara ,  Aramvalarthanathan Namachivayam

IPC: H04L29/08 ,  G06F9/54 ,  G06F16/27 ,  H04L12/24 ,  H04L29/06

Abstract: Described herein are systems and methods for providing access to a database in a multi-tenant environment, including the use of a connection pool, and support for live addition of a tenant. When a pluggable database (PDB), for use by a tenant, is added to a multi-tenant database, it can generate an event to notify the connection pool. The connection pool environment consumes this PDB-add event, and dynamically configures a new tenant to access the shared pool. Since the new tenant addition is based on receipt of an event from the database, the connection pool does not require manual configuration for that tenant. Once a tenant is added, it can borrow connections from the pool in the same manner as existing tenants, and can also share existing pool properties, such as, for example a maximum pool size, or maximum number of connections per tenant.

公开(公告)号：US20180039628A1

公开(公告)日：2018-02-08

申请号：US15227897

申请日：2016-08-03

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Jean de Lavarene ,  Saurabh Verma ,  Vidya Hegde ,  Krishna Chandra ,  Aramvalarthanathan Namachivayam

IPC: G06F17/30 ,  H04L29/08

CPC classification number: G06F16/214 ,  G06F9/5061 ,  H04L67/1002 ,  H04L67/148 ,  H04L67/16

Abstract: Described herein are systems and methods for providing access to a database in a multi-tenant environment, including the use of a connection pool, and support for dynamic relocation of tenants. In accordance with an embodiment, a software application can obtain a connection from the connection pool, on behalf of a tenant, which enables the software application or tenant to access the database. A relocation process enables a tenant which is associated with a multi-tenant or other client application, to be relocated within the database environment, for example across a plurality of container databases, with near-zero downtime to the client application, including managing the draining of existing connections, and the migrating of new connections, without requiring changes to the underlying application.