US 12,118,014 B2 · Separation of logical and physical storage in a distributed database system

Abstract

Distributed database systems including compute nodes and page servers are described herein that enable separating logical and physical storage of database files in a distributed database system. A distributed database system includes a page server and a compute node, and is configured to store a logical database file that includes data and is associated with a file identifier. Each page server is configurable to store slices (i.e., subportions) of the logical database file. The compute node is coupled to the plurality of page servers and configured to store the logical database file responsive to a received command. In an aspect, such storage may comprise slicing the data comprising the logical database file into a set of slices with each being associated with a respective page server, maintaining an endpoint mapping for each slice of the first set of slices, and transmitting each slice to the associated for storage thereby.

Claims20

Dependent claims

A system for storing data in a distributed database, the system comprising:

a processor;
a computer-readable storage medium comprising computer-executable instructions that, when executed by the processor, cause the processor to:
divide a first file into a first set of cells, each cell associated with a respective server of a plurality of servers;
maintain endpoint mappings for a set of contiguous portions of the first file, each endpoint mapping maintained for a corresponding contiguous portion of the set of contiguous portions and comprising a range identifier that specifies a location within the first file of the corresponding contiguous portion and an endpoint address corresponding to the respective server associated with the range identifier, wherein each contiguous portion of the first file comprises one or more cells of the first set of cells;
and
transmit data corresponding to each cell to the respective server associated with the cell.

3 more elements

A computer-readable storage medium comprising computer-readable instructions that, when executed by a processor, cause the processor to:

divide a first file into a first set of cells, each cell associated with a respective server of a plurality of servers;
maintain endpoint mappings for a set of contiguous portions of the first file, each endpoint mapping maintained for a corresponding contiguous portion of the set of contiguous portions and comprising a range identifier that specifies a location within the first file of the corresponding contiguous portion and an endpoint address corresponding to the respective server associated with the range identifier, wherein each contiguous portion of the first file comprises one or more cells of the first set of cells;
and
transmit data corresponding to each cell to the respective server associated with the cell.

1 more element

Dependencies are inferred from the claim text.

Facts

Application

18/351,258Filed 12 Jul 2023 · continuation

Priority

12 Aug 2021

Published

US 2023/0046342 A12 Nov 2023

Granted

15 Oct 2024

Term ends

Not estimatedThe source records don’t support an estimate.

Classification10 codes

G06F 16/256
Integrating or interfacing systems involving database management systems: in federated or virtual databases
G06F 16/184
Distributed file systems: implemented as replicated file system
G06F 16/185
File system types: hierarchical storage management [HSM] systems, e.g. file migration or policies thereof
G06F 16/1858
File system types: parallel file systems, i.e. file systems supporting multiple processors

Family

Application63/232,619Us provisional application · filed 12 Aug 2021

Application17/465,298Parent of this continuation · filed 2 Sep 2021

US 2023/0350912 A1Pre-grant publication · published 2 Nov 2023

US 11,748,369 B2Parent of this continuation

US 2023/0046342 A1Published application

US 12,118,014 B2This patent

From the US filing history. Foreign family members aren’t listed.

Separation of logical and physical storage in a distributed database system

Life of this patent

Separation of logical and physical storage in a distributed database system

Life of this patent

Abstract

Claims20