公开(公告)号：US20160306832A1

公开(公告)日：2016-10-20

申请号：US15133979

申请日：2016-04-20

Applicant: Oracle International Corporation

Inventor： Vidya Hegde ,  Jean de Lavarene ,  Douglas Surber ,  Mark Dilman ,  Leonid Novak ,  Wei Ming Hu ,  Ashok Shivarudraiah ,  Tong Zhou ,  Ilya Taranov

IPC: G06F17/30

Abstract: In accordance with an embodiment, the system enables access to a sharded database using a cache and a shard topology. A shard-aware client application connecting to a sharded database can use a connection pool (e.g., a Universal Connection Pool, UCP), to store or access connections to different shards or chunks of the sharded database within a shared pool. As new connections are created, a shard topology layer can be built at the database driver layer, which learns and caches shard key ranges to locations of shards. The shard topology layer enables subsequent connection requests from a client application to use a fast key path access to the appropriate shard or chunk.

Abstract translation: 根据实施例，该系统使得能够使用高速缓存和分片拓扑来访问分片数据库。 连接到分片数据库的分片识别客户端应用程序可以使用连接池（例如，通用连接池，UCP）来存储或访问到共享池内的分片数据库的不同碎片或块的连接。 当创建新连接时，可以在数据库驱动程序层构建分片拓扑图层，数据库驱动程序层可以将分片键范围学习并缓存到分片的位置。 分片拓扑层使来自客户端应用程序的后续连接请求能够使用快速键路径访问适当的分片或块。

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

公开(公告)号：US20190258613A1

公开(公告)日：2019-08-22

申请号：US16402864

申请日：2019-05-03

Applicant: Oracle International Corporation

Inventor： Wei-Ming Hu ,  Mark Dilman ,  Leonid Novak ,  Ilya Taranov ,  Zheng Zeng ,  Jean de Lavarene ,  Vidya Hegde

IPC: G06F16/21 ,  G06F16/2458 ,  G06F16/2455 ,  G06F16/22 ,  G06F16/27 ,  G06F16/25 ,  G06F16/248

Abstract: Techniques are provided for creating, organizing, and maintaining a sharded database. A sharded database can be created using user-defined sharding, system-managed sharding, or composite sharding. The sharded database is implemented with relational database techniques. The techniques described can be used to route database requests and process queries in a sharded database.

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

公开(公告)号：US09569472B2

公开(公告)日：2017-02-14

申请号：US14253580

申请日：2014-04-15

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Vidya Hegde ,  Jean de Lavarene ,  Pankaj Chand ,  Douglas Surber ,  Tong Zhou

IPC: G06F12/08 ,  G06F17/30

CPC classification number: G06F17/303 ,  G06F12/0813 ,  G06F12/0815 ,  G06F12/0868 ,  G06F17/30345 ,  G06F17/30902 ,  G06F2212/465

Abstract: Described herein is a system and method for providing a level 2 connection cache for use with a database environment. In accordance with an embodiment, a second level, or level 2 (L2), connection cache is used to cache no-session connections for use with a database. When a connection is requested, a no-session connection (NSC) can be retrieved from the cache and a database session is attached. Later, when the connection is closed, the database session is logged off and the no-session connection returned to the cache for subsequent use.

Abstract translation: 这里描述了一种用于提供与数据库环境一起使用的2级连接高速缓存的系统和方法。 根据实施例，使用第二级别或级别2（L2）连接高速缓存来缓存与数据库一起使用的非会话连接。 当请求连接时，可以从高速缓存检索无会话连接（NSC），并附加数据库会话。 稍后，当连接关闭时，数据库会话将被注销，并且无会话连接返回到缓存以供后续使用。

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

公开(公告)号：US20150026405A1

公开(公告)日：2015-01-22

申请号：US14253580

申请日：2014-04-15

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Vidya Hegde ,  Jean de Lavarene ,  Pankaj Chand ,  Douglas Surber ,  Tong Zhou

IPC: G06F12/08

CPC classification number: G06F17/303 ,  G06F12/0813 ,  G06F12/0815 ,  G06F12/0868 ,  G06F17/30345 ,  G06F17/30902 ,  G06F2212/465

Abstract: Described herein is a system and method for providing a level 2 connection cache for use with a database environment. In accordance with an embodiment, a second level, or level 2 (L2), connection cache is used to cache no-session connections for use with a database. When a connection is requested, a no-session connection (NSC) can be retrieved from the cache and a database session is attached. Later, when the connection is closed, the database session is logged off and the no-session connection returned to the cache for subsequent use.

Abstract translation: 这里描述了一种用于提供与数据库环境一起使用的2级连接高速缓存的系统和方法。 根据实施例，使用第二级别或级别2（L2）连接高速缓存来缓存与数据库一起使用的非会话连接。 当请求连接时，可以从高速缓存检索无会话连接（NSC），并附加数据库会话。 稍后，当连接关闭时，数据库会话将被注销，并且无会话连接返回到缓存以供后续使用。

公开(公告)号：US20150026213A1

公开(公告)日：2015-01-22

申请号：US14253573

申请日：2014-04-15

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Vidya Hegde ,  Jean de Lavarene ,  Pankaj Chand ,  Douglas Surber ,  Tong Zhou

IPC: G06F17/30

CPC classification number: G06F17/3048

Abstract: Described herein is a system and method for providing a shareable global cache for use with a database environment. In accordance with an embodiment, a shareable global cache is used for caching connections to database instances. When a request is received for a particular service, the system looks for an idle connection to that service, and, if none is available, locates an existing connection to a database instance serving that service and switches a service on the existing connection to that service.

Abstract translation: 这里描述了一种用于提供与数据库环境一起使用的可共享全局缓存的系统和方法。 根据实施例，可共享的全局缓存用于缓存到数据库实例的连接。 当接收到特定服务的请求时，系统会查找到该服务的空闲连接，如果没有可用的连接，则将现有连接定位到服务于该服务的数据库实例，并将现有连接上的服务切换到该服务 。

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