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

公开(公告)号：US11586614B2

公开(公告)日：2023-02-21

申请号：US16932633

申请日：2020-07-17

Applicant: Oracle International Corporation

Inventor： James W. Stamos ,  Mahesh Baburao Girkar ,  Wei Ming Hu ,  Juan R. Loaiza ,  Sachin Vijaykumar Sonawane ,  Hongjie Yang

IPC: G06F16/23 ,  G06F16/21 ,  H04L9/06 ,  H04L9/00

Abstract: Distributed ledgered data is stored within a distributed persistent storage system comprising multiple persistent storage systems as distributed ledgered participants. In various embodiments, the distributed ledgered data is maintained using the native capabilities of a persistent storage system. The distributed ledgered data is replicated as persistent data objects in a “ledgered repository of objects” that are replicated at each of the persistent storage systems. Changes at one persistent storage system are recorded within a block in a distributed blockchain that is distributed across each of the other distributed ledgered participants. The other distributed ledgered participants read the changes from the blockchain and apply the changes to the respective replicas at each of the other distributed ledgered participants. Hence, this approach is referred to as blockchain apply. Blockchain apply may be used to replicate the repository objects of various forms of PSSs. In a DBMS, a repository of objects is a table, where each record or row is an object in the repository. In a file system, a repository of objects is a directory, where each directory and file therein is an object in the repository. In a document storage system (DOCS), a repository of objects is a collection of documents, where each document is an object in the repository.

公开(公告)号：US20210406252A1

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

申请号：US17473525

申请日：2021-09-13

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.

公开(公告)号：US10545935B2

公开(公告)日：2020-01-28

申请号：US15133979

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

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.

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

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

公开(公告)号：US11609901B2

公开(公告)日：2023-03-21

申请号：US17473525

申请日：2021-09-13

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.

公开(公告)号：US20210073208A1

公开(公告)日：2021-03-11

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

公开(公告)号：US20210034606A1

公开(公告)日：2021-02-04

申请号：US16932633

申请日：2020-07-17

Applicant: Oracle International Corporation

Inventor： James W. Stamos ,  Mahesh Baburao Girkar ,  Wei Ming Hu ,  Juan R. Loaiza ,  Sachin Vijaykumar Sonawane ,  Hongjie Yang

IPC: G06F16/23 ,  G06F16/21 ,  H04L9/06

Abstract: Distributed ledgered data is stored within a distributed persistent storage system comprising multiple persistent storage systems as distributed ledgered participants. In various embodiments, the distributed ledgered data is maintained using the native capabilities of a persistent storage system. The distributed ledgered data is replicated as persistent data objects in a “ledgered repository of objects” that are replicated at each of the persistent storage systems. Changes at one persistent storage system are recorded within a block in a distributed blockchain that is distributed across each of the other distributed ledgered participants. The other distributed ledgered participants read the changes from the blockchain and apply the changes to the respective replicas at each of the other distributed ledgered participants. Hence, this approach is referred to as blockchain apply. Blockchain apply may be used to replicate the repository objects of various forms of PSSs. In a DBMS, a repository of objects is a table, where each record or row is an object in the repository. In a file system, a repository of objects is a directory, where each directory and file therein is an object in the repository. In a document storage system (DOCS), a repository of objects is a collection of documents, where each document is an object in the repository.