公开(公告)号：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）来存储或访问到共享池内分散数据库的不同碎片或块的连接。 当创建新连接时，可以在数据库驱动程序层构建分片拓扑图层，数据库驱动程序层将分片密钥范围学习并缓存到分片的位置，并使来自客户端应用程序的后续连接请求能够使用快速键路径访问适当的 碎片或块。 可以将连接池和数据库驱动程序配置为允许客户端应用程序在连接检验期间或稍后提供分片密钥; 识别客户端应用程序指定的分片密钥; 并启用客户端应用程序连接到特定的分片或块。