公开(公告)号：US20240273077A1

公开(公告)日：2024-08-15

申请号：US18400412

申请日：2023-12-29

Applicant: Oracle International Corporation

Inventor： Zheng Zeng ,  Lin Lu ,  Mark Dilman ,  Wei-Ming Hu ,  Ghazi Nourdine Benadjaoud ,  Leonid Novak ,  Darshan Maniyani

IPC: G06F16/22 ,  G06F16/27

CPC classification number: G06F16/2282 ,  G06F16/27

Abstract: Under dynamic shard mapping, applications may dynamically define, evolve, and redefine how a sharded table is sharded across shards according to sharding keys. Dynamic shard mapping is referred to as being dynamic because changes to a sharding directory that defines a sharding distribution scheme are effected without having to change synchronized f metadata. A sharding directory maps sharding key values to shard servers. The changes are effected directly by invoking an API or indirectly by submitting a DML command that includes, for example, a sharding key value that is unmapped by the sharding directory. The sharding directory is distributed among the shards and client computers of a sharded DBMS to facilitate and optimize the routing of database commands across the shards of a DBMS.

公开(公告)号：US11194773B2

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

申请号：US16569051

申请日：2019-09-12

Applicant: Oracle International Corporation

Inventor： Wei-Ming Hu ,  Ghazi Nourdine Benadjaoud ,  Mark Dilman ,  Darshan Maniyani ,  Sachin Rathod ,  Wumengjian Zhu

IPC: G06F16/21 ,  G06F16/22 ,  G06F16/25 ,  G06F16/2455

Abstract: Techniques described herein create a sharding environment from existing independent databases, use the sharding environment to issue cross shard queries, create “on all shards” new objects, and create and “on all shards” new users that will have permission to access the data across all database shards.

公开(公告)号：US20210081378A1

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

申请号：US16569051

申请日：2019-09-12

Applicant: Oracle International Corporation

Inventor： Wei-Ming Hu ,  Ghazi Nourdine Benadjaoud ,  Mark Dilman ,  Darshan Maniyani ,  Sachin Rathod ,  Wumengjian Zhu

IPC: G06F16/21 ,  G06F16/22 ,  G06F16/2455 ,  G06F16/25

Abstract: Techniques described herein create a sharding environment from existing independent databases, use the sharding environment to issue cross shard queries, create “on all shards” new objects, and create and “on all shards” new users that will have permission to access the data across all database shards.