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

公开(公告)号：US20170103094A1

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

申请号：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

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 to route database requests and process queries in a sharded database.