公开(公告)号：US20170103098A1

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

申请号：US15268438

申请日：2016-09-16

Applicant: Oracle International Corporation

Inventor： Wei-Ming Hu ,  Mark Dilman ,  Ghazi Nourdine Benadjaoud ,  Ilya Taranov

IPC: G06F17/30

CPC classification number: G06F16/213 ,  G06F16/217 ,  G06F16/221 ,  G06F16/2272 ,  G06F16/2282 ,  G06F16/2455 ,  G06F16/2471 ,  G06F16/248 ,  G06F16/252 ,  G06F16/27 ,  G06F16/278

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 for organizing a sharded database using composite sharding.

公开(公告)号：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，组件）可以配置为允许客户端应用程序在连接检验期间或稍后提供分片密钥 时间; 识别客户端应用程序指定的分片密钥; 并启用客户端应用程序连接到特定的分片或块。 该方法可以有效地重新使用连接资源，并能更快地访问适当的分片。

公开(公告)号：US08838535B2

公开(公告)日：2014-09-16

申请号：US13645819

申请日：2012-10-05

Applicant: Oracle International Corporation

Inventor： Wei-Ming Hu ,  Lakshminaray Chidambaran ,  Mark Dilman ,  Feroz A. Khan ,  Bhaskar Mathur ,  Kevin S. Neel ,  Leonid Novak ,  Kant C. Patel ,  Saravanakumar Ramasubramanian ,  Michael J. Stewart ,  Hubert Sun

IPC: G06F17/30

CPC classification number: G06F17/30595 ,  H04L41/02 ,  H04L67/1002

Abstract: Techniques are provided to allow users to define a global service that is offered across multiple replicated databases. Database clients connect to and use a global service just as they do with regular services on a single database today. Upon receiving a connection request, a collection of components, referred to collectively as the Global Data Service framework (GDS framework), automatically chooses the best database server instances to which to connect a client. Once those connections have been established, the clients determine which database server instance, of those database server instances to which they are connected, to send requests to based, at least in part, on advisory messages sent to the clients by the GDS framework.

Abstract translation: 提供技术以允许用户定义跨多个复制数据库提供的全局服务。 数据库客户端连接到并使用全局服务，就像现在一个数据库上的常规服务一样。 一旦接收到连接请求，将统称为全局数据服务框架（GDS框架）的组件集合自动选择连接客户端的最佳数据库服务器实例。 一旦建立了这些连接，客户端将确定哪些数据库服务器实例（与其连接的数据库服务器实例）发送请求至少部分地基于由GDS框架发送给客户端的咨询消息。