# US 2023/0054341 A1 · Distributed data storage and analytics system

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

- Number: US 2023/0054341 A1
- Document ID: US20230054341A1
- Status: Published application
- Kind: A1
- Application number: 17/979,936
- Filed: 2022-11-03
- Published: 2023-02-23
- Earliest claimed: 2018-11-20
- Assignees: Elastic Flash Inc.
- Applicants: Elastic Flash Inc.
- Inventors: Darshan Bharatkumar Rawal; Naoki Iwakami; Kalyan Seshu; Prasanta SAHOO
- Web page: https://patentgrep.com/patent/US20230054341A1

## CPC

- G06F 16/2343: {Locking methods, e.g. distributed locking or locking implementation details}
- G06F 16/256: {in federated or virtual databases}
- G06F 16/27: Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

In some implementations, a computer-implemented method includes receiving a state update command. The method further includes, in response to the state update command, sending a command to perform a state update in a first server of a plurality of servers and queueing incoming requests for access to the plurality of servers. The method further includes receiving confirmation from the first server that the state update was successful. The method further includes, after receiving the confirmation, sending a respective command to the plurality of servers to perform the state update and a scheduled update time associated with the state update. The method further includes receiving a respective state update message from a subset of the plurality of servers that the state update was successful and after receiving the state update message, transmitting the queued incoming requests to the subset of the plurality of servers.

## Claims

### Claim 1

A computer-implemented method comprising:
receiving a record from a data source at a server, wherein the record includes a plurality of fields processing the record at the server, wherein the processing includes performing data validation of the record;
after the processing, storing the record in a primary table of a database on a first server, wherein the record is associated with a primary key in the primary table that is unique to the record; and
creating a view based on the primary table.

### Claim 2 (depends on 1)

The computer-implemented method of claim 1, wherein the view has a different primary key than the primary key of the primary table and includes a subset of the plurality of fields such that at least one of the plurality of fields is excluded from the view.

### Claim 3 (depends on 1)

The computer-implemented method of claim 1, wherein processing the record further includes at least one of: appending other data to the record, performing format conversion of one or more fields in the record, or detecting an anomaly in the record.

### Claim 4 (depends on 1)

The computer-implemented method of claim 1, further comprising receiving a declaration that specifies a subset of the plurality of fields for the view.

### Claim 5 (depends on 4)

The computer-implemented method of claim 4, wherein the declaration further specifies a refresh cycle for the view, and further comprising:
updating the view per the refresh cycle.

### Claim 6 (depends on 5)

The computer-implemented method of claim 5, wherein the updating comprises synchronizing the view with the primary table.

### Claim 7 (depends on 1)

The computer-implemented method of claim 1, further comprising analyzing a query access pattern for the primary table, wherein creating the view is based on the query access pattern indicating that a subset of fields is queried repeatedly in a particular period of time.

### Claim 8 (depends on 1)

The computer-implemented method of claim 1, wherein the primary table is stored on a storage device selected based on storage tiering parameters.

### Claim 9 (depends on 1)

The computer-implemented method of claim 1, further comprising:
storing the view on a second server different from the first server, the first server and the second server are time synchronized.

### Claim 10 (depends on 1)

The computer-implemented method of claim 1, further comprising:
creating one or more additional views that include respective subsets of the plurality of fields; and
storing the one or more additional views on respective servers that are different from the first server and the second server.

### Claim 11

A computing device comprising:
a hardware processor; and
a memory coupled to the hardware processor, with instructions stored thereon that, when executed by the hardware processor, cause the hardware processor to perform operations comprising:
receiving a record from a data source at a server, wherein the record includes a plurality of fields
processing the record at the server, wherein the processing includes performing data validation of the record;
after the processing, storing the record in a primary table of a database on a first server, wherein the record is associated with a primary key in the primary table that is unique to the record; and
creating a view based on the primary table.

### Claim 12 (depends on 11)

The computing device of claim 11, wherein processing the record further includes at least one of: appending other data to the record, performing format conversion of one or more fields in the record, or detecting an anomaly in the record.

### Claim 13 (depends on 11)

The computing device of claim 11, wherein the operations further comprise:
receiving a declaration that specifies a subset of the plurality of fields for the view.

### Claim 14 (depends on 11)

The computing device of claim 11, wherein the operations further comprise analyzing a query access pattern for the primary table, wherein creating the view is based on the query access pattern indicating that a subset of fields are queried repeatedly in a particular period of time.

### Claim 15 (depends on 11)

The computing device of claim 11, wherein the operations further comprise:
creating one or more additional views that include respective subsets of the plurality of fields; and
storing the one or more additional views on respective servers that are different from the first server and the second server.

### Claim 16

A non-transitory computer-readable medium, with instructions stored thereon that, when executed by a processor, cause the processor to perform operations comprising:
receiving a record from a data source at a server, wherein the record includes a plurality of fields
processing the record at the server, wherein the processing includes performing data validation of the record;
after the processing, storing the record in a primary table of a database on a first server, wherein the record is associated with a primary key in the primary table that is unique to the record; and
creating a view based on the primary table.

### Claim 17 (depends on 16)

The non-transitory computer-readable medium of claim 16, wherein processing the record further includes at least one of: appending other data to the record, performing format conversion of one or more fields in the record, or detecting an anomaly in the record.

### Claim 18 (depends on 16)

The non-transitory computer-readable medium of claim 16, wherein the operations further comprise receiving a declaration that specifies a subset of the plurality of fields for the view.

### Claim 19 (depends on 16)

The non-transitory computer-readable medium of claim 16, wherein the operations further comprise analyzing a query access pattern for the primary table, wherein creating the view is based on the query access pattern indicating that a subset of fields are queried repeatedly in a particular period of time.

### Claim 20 (depends on 16)

The non-transitory computer-readable medium of claim 16, wherein the operations further comprise:
creating one or more additional views that include respective subsets of the plurality of fields; and
storing the one or more additional views on respective servers that are different from the first server and the second server.
