Back to results
US 10,949,411 B2Granted
Time stamp bounded addition of data to an append-only distributed database table
AssigneeMicrosoft Technology Licensing, LLC
InventorsOzgun Ali Erdogan, Sumedh Suhas Pathak
Life of this patent
Estimating the term…
Abstract
A method implemented by a computer includes receiving a segment of data that has a time dimension, where the time dimension of the segment of data is bounded by a start time stamp and an end time stamp. The segment of data is added to an append-only database table of a distributed database. The addition operation imposes an inherent data order based upon the start time stamp and end time stamp without the manual definition off database table partition in the distributed database.
Claims17
A method implemented by a computer, comprising:
- receiving database records, including a deterministic database command that will not generate different values on two different nodes in a distributed database and can be replicated across different nodes prior to execution because it will produce the same result on each of the different nodes, wherein each database record is immutable such that, after having been added to a database table, the each database record will not be changed, and wherein each received database record has an associated time stamp;
- automatically extracting a time range from the received database records, the extracted time range being determined from the associated time stamps of the received database records;
- grouping the database records into a segment of data that has a time dimension based upon the time range extracted from the received database records, wherein the time dimension of the segment of data is bounded by a start time stamp and an end time stamp and wherein each database record of the grouped database records has an associated time stamp that falls within the time dimension bounded by the start time stamp and the end time stamp;
- directing the segment of data to at least two different nodes of the distributed database;
- and
- adding, at each of the at least two different nodes of the distributed database, the segment of data to an append-only database table of the distributed database, wherein adding comprises automatically creating a database table partition based upon the start time stamp and end time stamp without the manual definition of a database table partition in the distributed database;
- and
- using start time stamps and end time stamps of database table partitions to prune a set of database table partitions not relevant to a database query.
5 more elements
A method implemented by a computer, comprising:
- receiving database records, including a deterministic database command that will not generate different database records on two different nodes in a distributed database, wherein each database record is immutable such that, after having been added to a database table, the each database record will not be changed, and wherein each received database record has an associated time stamp;
- automatically extracting a time range from the received database records, the extracted time range being determined from the associated time stamps of the received database records;
- grouping the database records into a segment of data that has a time dimension based upon the time range extracted from the received database records, wherein the time dimension of the segment of data is bounded by a start time stamp and an end time stamp and wherein each database record of the grouped database records has an associated time stamp that falls within the time dimension bounded by the start time stamp and the end time stamp;
- directing the segment of data to at least two different nodes of the distributed database;
- adding, at each of the at least two different nodes of the distributed database, the segment of data to an append-only database table of the distributed database, wherein adding comprises automatically creating a database table partition based upon the start time stamp and end time stamp without the manual definition of a database table partition in the distributed database, wherein adding the segment of data automatically creates a plurality of new database table partitions;
- storing the start time stamp and end time stamp for each new database table partition;
- receiving a database query for the database table, wherein the database query has a time dimension;
- and
- using start time stamps and end time stamps of database table partitions to prune a set of database table partitions not relevant to the database query.
6 more elements
Dependencies are inferred from the claim text.