# US 2024/0004890 A1 · Data sharding system, data sharding method, and program stored in recording medium

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2024/0004890 A1
- Document ID: US20240004890A1
- Status: Published application
- Kind: A1
- Application number: 18/039,936
- Filed: 2021-12-02
- Published: 2024-01-04
- Earliest claimed: 2020-12-04
- Inventors: Geun Seok KIM
- Web page: https://patentgrep.com/patent/US20240004890A1

## CPC

- G06F 16/2471: {Distributed queries}
- G06F 16/278: {Data partitioning, e.g. horizontal or vertical partitioning}
- G06F 16/24575: {using context}
- G06F 16/27: Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
- G06F 16/29: Geographical information databases
- G06F 16/9537: Spatial or temporal dependent retrieval, e.g. spatiotemporal queries
- H04L 67/1097: for distributed storage of data in networks, e.g. transport arrangements for network file system [NFS], storage area networks [SAN] or network attached storage [NAS]
- H04L 67/52: specially adapted for the location of the user terminal
- H04L 67/63: Routing a service request depending on the request content or context
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)
- H04L: TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION (arrangements common to telegraphic and telephonic communication H04M)

## Abstract

A data sharding system comprises: a server that receives and processes a request from a client terminal, and detects country information and region information related to the request; a database unit that is connected to the server via a network, receives a query for the request from the server, and transmits a response to the query to the server, wherein the query may include a shard key being determined on the basis of the country information and region information related to the request, and the database unit may include a plurality of data nodes in which the query is distributed and processed on the basis of the shard key.

## Claims

### Claim 1

A data sharding system comprising:
a server that receives and processes a request from a client terminal and detects country information and region information related to the request; and
a database unit that is connected to the server via a network, receives a query for the request from the server, and transmits a response to the query to the server,
wherein the query includes a shard key determined based on the country information and region information related to the request, and
the database unit includes a plurality of data nodes in which the query is distributed and processed based on the shard key.

### Claim 2 (depends on 1)

The data sharding system of claim 1, wherein the database unit further includes a meta node that analyzes the query received from the server and distributes and processes the query to the plurality of data nodes based on the shard key, and
the meta node transmits the query to a data node corresponding to the shard key to acquire a response to the query.

### Claim 3 (depends on 1)

The data sharding system of claim 1, wherein the shard key includes an equipment code determined based on the country information and the region information, and
the server includes the country information, the region information, and a lookup table for a corresponding equipment code.

### Claim 4 (depends on 1)

The data sharding system of claim 1, wherein the server detects the country information and the region information based on IP address information of the client terminal or location information input by the client terminal.

### Claim 5 (depends on 3)

The data sharding system of claim 3, wherein the server includes:
a region information detection unit that detects the country information and the region information related to the request received from the client terminal;
an equipment code determination unit that determines the equipment code corresponding to the detected country information and the region information based on the lookup table; and
a data transmission unit that transmits the query including the equipment code as the shard key to the database unit and transmits a response from the database unit to the client terminal.

### Claim 6 (depends on 3)

The data sharding system of claim 3, wherein different equipment codes are assigned to each country.

### Claim 7 (depends on 3)

The data sharding system of claim 3, wherein the same equipment code is assigned to a plurality of regions within the same country.

### Claim 8 (depends on 3)

The data sharding system of claim 3, wherein different equipment codes are assigned to different regions within the same country.

### Claim 9

A data sharding method performed by a data sharding system including a server and a database unit, the data sharding method comprising:
a region information detection operation in which the server receives a request from a client terminal and detects country information and region information related to the request;
a query transmission operation in which the server transmits a query for the request to the database unit; and
a distributed processing operation in which the database unit receives the query, analyzes the query, and distributes and processes data to a plurality of data nodes based on a shard key,
wherein the query includes a shard key determined based on the country information and the region information related to the request, and
the database unit distributes and processes the query to the plurality of data nodes based on the shard key.

### Claim 10 (depends on 9)

A program stored in a recording medium to cause a computer to perform the data sharding method of claim 9.
