公开(公告)号：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），并附加数据库会话。 稍后，当连接关闭时，数据库会话将被注销，并且无会话连接返回到缓存以供后续使用。

公开(公告)号：US09251178B2

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

申请号：US13912086

申请日：2013-06-06

Applicant: Oracle International Corporation

Inventor： Jean de Lavarene ,  Tong Zhou ,  Douglas Surber ,  Stephen Felts ,  David Merrill

IPC: G06F17/30 ,  G06F9/50

CPC classification number: G06F17/30289 ,  G06F9/5011 ,  G06F17/30943 ,  G06F2209/5011

Abstract: A system and method for connection labeling for use with connection pools. In accordance with an embodiment, the system comprises a connection pool, including a plurality of connection objects which provide connections that software applications can use to make requests to access the database, wherein each of the connections can be labeled according to the configuration of particular applications; and a connection pool logic that identifies connections labeled as high-cost connections, and avoids using those high-cost connections to serve requests when the total number of connections is below a particular threshold value.

Abstract translation: 用于连接池的连接标签的系统和方法。 根据实施例，系统包括连接池，连接池包括多个连接对象，其提供软件应用可以用来进行访问数据库的请求的连接，其中可以根据特定应用的配置标记每个连接 ; 以及标识为高成本连接的连接标识的连接池逻辑，并且当连接总数低于特定阈值时，避免使用这些高成本连接来提供请求。

公开(公告)号：US20210406252A1

公开(公告)日：2021-12-30

申请号：US17473525

申请日：2021-09-13

Applicant: Oracle International Corporation

Inventor： Lik Wong ,  Leonid Novak ,  Douglas N. Surber ,  Ilesh Garish ,  Saurabh Verma ,  Wei Ming Hu ,  Mark Dilman ,  Jean de Lavarene

IPC: G06F16/23 ,  G06F16/2455

Abstract: Techniques are provided for processing a database command in a sharded database. The processing of the database command may include generating or otherwise accessing a shard key expression, and evaluating the shard key expression to identify one or more target shards that contain data used to execute the database command.

公开(公告)号：US10545935B2

公开(公告)日：2020-01-28

申请号：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: G06F16/00 ,  G06F16/22 ,  G06F16/25 ,  G06F16/2455

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.

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

公开(公告)号：US20160306854A1

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

申请号：US15133972

申请日：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, described herein are systems and methods for providing direct access to a sharded database. A shard director provides access by software client applications to database shards. A connection pool (e.g., a Universal Connection Pool, UCP) and database driver (e.g., a Java Database Connectivity, JDBC, component) can be configured to allow a client application to provide a shard key, either during connection checkout or at a later time; recognize shard keys specified by the client application; and enable connection by the client application to a particular shard or chunk. The approach enables efficient re-use of connection resources, and faster access to appropriate shards.

Abstract translation: 根据一个实施例，这里描述了用于提供对分片数据库的直接访问的系统和方法。 分片主任提供软件客户端应用程序访问数据库分片。 连接池（例如通用连接池，UCP）和数据库驱动程序（例如，Java数据库连接，JDBC，组件）可以配置为允许客户端应用程序在连接检验期间或稍后提供分片密钥 时间; 识别客户端应用程序指定的分片密钥; 并启用客户端应用程序连接到特定的分片或块。 该方法可以有效地重新使用连接资源，并能更快地访问适当的分片。

公开(公告)号：US09268798B2

公开(公告)日：2016-02-23

申请号：US13912098

申请日：2013-06-06

Applicant: Oracle International Corporation

Inventor： Jean de Lavarene ,  Tong Zhou ,  Douglas Surber ,  Stephen Felts ,  David Merrill

IPC: G06F17/30 ,  G06F9/50

CPC classification number: G06F17/30289 ,  G06F9/5011 ,  G06F17/30943 ,  G06F2209/5011

Abstract: A system and method for connection labeling for use with connection pools, including support for cloud-based multi-tenant environments using connection labeling. In accordance with an embodiment, the system comprises a connection pool, including a plurality of connection objects which provide connections that software applications can use to make requests to access the database, wherein each of the connections can be labeled according to the configuration of particular applications; and a connection pool logic that identifies connections labeled as high-cost connections, and controls the creation or repurposing of high-cost connections to serve requests from the multiple tenants or tenant applications.

Abstract translation: 用于连接池的连接标签的系统和方法，包括使用连接标签支持基于云的多租户环境。 根据实施例，系统包括连接池，连接池包括多个连接对象，其提供软件应用可以用来进行访问数据库的请求的连接，其中可以根据特定应用的配置标记每个连接 ; 以及连接池逻辑，用于标识标记为高成本连接的连接，并控制高成本连接的创建或重新使用，以提供来自多个租户或租户应用程序的请求。

公开(公告)号：US11636075B2

公开(公告)日：2023-04-25

申请号：US15133972

申请日：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: G06F16/00 ,  G06F16/22 ,  G06F16/25 ,  G06F16/2455 ,  G06F16/27

Abstract: In accordance with an embodiment, described herein are systems and methods for providing direct access to a sharded database. A shard director provides access by software client applications to database shards. A connection pool (e.g., a Universal Connection Pool, UCP) and database driver (e.g., a Java Database Connectivity, JDBC, component) can be configured to allow a client application to provide a shard key, either during connection checkout or at a later time; recognize shard keys specified by the client application; and enable connection by the client application to a particular shard or chunk. The approach enables efficient re-use of connection resources, and faster access to appropriate shards.

公开(公告)号：US11409721B2

公开(公告)日：2022-08-09

申请号：US16724909

申请日：2019-12-23

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: G06F16/20 ,  G06F16/22 ,  G06F16/25 ,  G06F16/2455 ,  G06F16/27

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.