公开(公告)号：WO2018027028A1

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

申请号：PCT/US2017/045288

申请日：2017-08-03

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： DE LAVARENE, Jean ,  DOLGOV, Yuri ,  HEGDE, Vidya ,  VERMA, Saurabh ,  MAHIDHARA, Chandra Sekhar Krishna ,  NAMACHIVAYAM, Aramvalarthanathan

IPC: G06F9/50

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.

Abstract translation: 这里描述的是用于提供对多租户环境中的数据库的访问的系统和方法，包括连接池的使用，支持连接的有效再利用。 根据一个实施例，软件应用程序可以请求提供连接，以允许访问数据库。 响应于接收到请求，连接池可以首先确定具有确切期望属性的特定连接是否已经存在于该池中，但是在该请求时借用。 如果存在这样的连接，则连接池可以等待该特定连接变为可用的一段时间，在此称为双等待。 随后，如果特定连接在双等待时间段内不可用，则连接池恢复其正常操作，例如通过重新调整其他连接。

公开(公告)号：WO2018027026A1

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

申请号：PCT/US2017/045283

申请日：2017-08-03

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： DE LAVARENE, Jean ,  VERMA, Saurabh ,  HEGDE, Vidya ,  MAHIDHARA, Chandra Sekhar Krishna ,  NAMACHIVAYAM, Aramvalarthanathan

IPC: G06F9/50 ,  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 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.

Abstract translation: 本文描述了用于提供对多租户环境中的数据库的访问的系统和方法，包括使用连接池以及支持租户的动态重定位。 根据一个实施例，软件应用程序可以代表租户从连接池获得连接，该连接使软件应用程序或租户能够访问数据库。 重定位过程使与多租户或其他客户端应用程序相关联的租户能够例如在多个容器数据库内重新定位到数据库环境内，其中客户端应用程序的停机时间接近零，包括管理排空 现有连接和新连接的迁移，而无需更改基础应用程序。

公开(公告)号：WO2017062288A1

公开(公告)日：2017-04-13

申请号：PCT/US2016/054930

申请日：2016-09-30

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： HU, Wei-Ming ,  DILMAN, Mark ,  BALL, Stephen ,  BENADJAOUD, Ghazi Nourdine ,  NOVAK, Leonid ,  TARANOV, Ilya ,  ZENG, Zheng ,  DE LAVARENE, Jean ,  HEGDE, Vidya

IPC: G06F17/30

CPC classification number: G06F17/30575

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 provide improvements to load distribution, organization, query processing, and schema propagation in a sharded database.

Abstract translation: 提供了用于创建，组织和维护分片数据库的技术。 可以使用用户定义的分片，系统管理的分片或复合分片创建分片数据库。 分片数据库采用关系数据库技术实现。 所描述的技术提供了在分片数据库中的负载分布，组织，查询处理和模式传播的改进。

公开(公告)号：WO2016172195A1

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

申请号：PCT/US2016/028420

申请日：2016-04-20

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： HEGDE, Vidya ,  DE LAVARENE, Jean ,  SURBER, Douglas ,  DILMAN, Mark ,  NOVAK, Leonid ,  HU, Wei ,  SHIVARUDRAIAH, Ashok ,  ZHOU, Tong ,  TARANOV, Ilya

IPC: G06F17/30

CPC classification number: G06F17/30492 ,  G06F17/30312 ,  G06F17/30339 ,  G06F17/3048 ,  G06F17/3056 ,  G06F17/30575

Abstract: In accordance with an embodiment, the system enables access to a sharded database. 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, and enables subsequent connection requests from a client application to use a fast key path access to the appropriate shard or chunk. A connection pool and database driver 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.

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