公开(公告)号：US11151124B2

公开(公告)日：2021-10-19

申请号：US16565273

申请日：2019-09-09

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.

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

公开(公告)号：US10268710B2

公开(公告)日：2019-04-23

申请号：US15267395

申请日：2016-09-16

Applicant: Oracle International Corporation

Inventor： Wei-Ming Hu ,  Mark Dilman ,  Stephen Ball ,  Ghazi Nourdine Benadjaoud ,  Leonid Novak ,  Ilya Taranov ,  Zheng Zeng

IPC: G06F17/00 ,  G06F17/30

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.

公开(公告)号：US20140101100A1

公开(公告)日：2014-04-10

申请号：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: G06F7/00 ,  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框架发送给客户端的咨询消息。

公开(公告)号：US20250094445A1

公开(公告)日：2025-03-20

申请号：US18805383

申请日：2024-08-14

Applicant: Oracle International Corporation

Inventor： Lik Wong ,  Sampanna Salunke ,  Leonid Novak ,  Mark Dilman ,  Wei-Ming Hu

IPC: G06F16/27

Abstract: Replication is improved in a globally distributed database, such as a replicated sharded database, which uses raft-based asynchronous database replication. Improvements include Raft log persistence, coordination of followers' processing speed, transaction outcome determination, and column name compression, and improved failover time through heartbeat consolidation and keeping apply processes of followers running across failovers.

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

公开(公告)号：US11204900B2

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

申请号：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/27 ,  G06F16/22 ,  G06F16/248 ,  G06F16/25 ,  G06F16/2455 ,  G06F16/2458

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.

公开(公告)号：US20190220450A1

公开(公告)日：2019-07-18

申请号：US16360263

申请日：2019-03-21

Applicant: Oracle International Corporation

Inventor： Wei-Ming Hu ,  Mark Dilman ,  Stephen Ball ,  Ghazi Nourdine Benadjaoud ,  Leonid Novak ,  Ilya Taranov ,  Zheng Zeng

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

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

公开(公告)号：US10331634B2

公开(公告)日：2019-06-25

申请号：US15268108

申请日：2016-09-16

Applicant: Oracle International Corporation

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

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

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.