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