Abstract: A database system is operable to determine a query operator execution flow that includes a plurality of operators for execution of a corresponding query against a database having a schema that includes a plurality of columns. The query operator execution flow is executed in conjunction with executing the corresponding query against the database based on generating a first plurality of data blocks of a multi-column data stream as first output of a first operator of the plurality of operators, where each data block of the multi-column data stream includes column values for each of the plurality of columns. Executing the query operator execution flow is further based on processing the multi-column data stream as input of a second operator of the plurality of operators serially after the first operator to generate a second plurality of data blocks as second output of the second operator.

Abstract: A method for execution by a node of a computing device includes: determining level assignment data indicating assignment to a subset of levels of a plurality of levels of a query execution plan, wherein the plurality of levels includes a lowest level, at least one inner level, and a highest level; determining a query for execution; determining a query discriminator number corresponding to the query; determining to process the query at one of the plurality of levels based on determining the one of the plurality of levels is included in the subset of levels; generating query resultant data by facilitating execution of at least one query operator of the query in accordance with the one of the plurality of levels; selecting one of a plurality of possible parent nodes in a sequentially higher one of the plurality of levels based on the query discriminator number; and sending the query resultant data to the one of the plurality of possible parent nodes for processing.

Abstract: A query processing system is operable to receive a query expression that includes a call to a computing window function indicating an expression that includes a column reference that includes a prior row index identifier. The computing window function is executed based on accessing at ordered set of rows of the database indicated in the call to the computing window function. An output column is generated based on generating output for each row of a set of rows in the ordered set of rows by evaluating the expression based on performing at least one operation upon a column value, determined based on applying the column reference, of a previous row in the ordered set of rows. A query resultant for the query expression is generated based on the output column generated for the rows in the ordered set of rows.

Abstract: A database system is operable to execute a request to generate a decision tree model. A training set of rows are determined based on accessing a plurality of rows of a relational database table of a relational database. First query data is generated for execution based on the training set of rows. First query output is generated based on executing the first query data. A first portion of the decision tree model data is built based on the first query output. Additional query data is generated for execution based on the first query output. Additional query output is generated based on executing the additional query data. An additional portion of the decision tree model data is built based on the additional query output. Model output for the decision tree model is generated via processing input data in conjunction with processing the decision tree model data.

Abstract: A database system is operable to receive a plurality of records of a dataset for storage. A plurality of segment row data is generated from the plurality of records and a plurality of parity data corresponding to the plurality of segment row data is generated. The plurality of segment row data is stored via a first storage mechanism. The plurality of parity data is stored via a second storage mechanism. Execution of a plurality of queries against the dataset is facilitated by accessing the plurality of segment row data via the first storage mechanism. A storage failure of one of the plurality of segment row data via the first storage mechanism is detected. The one of the plurality of segment row data is recovered for storage via the first storage mechanism based on accessing at least one parity data via the second storage mechanism.

Abstract: A processing system of a node is operable to determine a query for execution and determine a set of segments that each include a corresponding set of rows required to execute the query. A first segment of the set of segments is determined to be processed as a virtual segment. A locally rebuilt set of rows corresponding to the first segment is generated by utilizing a recovery scheme based on determining the first segment is to be processed as a virtual segment. Execution of the query is facilitated by utilizing the locally rebuilt set of rows.

Abstract: A database system is operable to determine a query for execution. The database system can execute a left join operation for the query based on receiving a plurality of left input rows, and forwarding all of the plurality of left input rows are forwarded. It is determined whether any right input rows match with each given left input row based on a hash map. When one right input row is identified as matching with the given left input row, a value of right input row is copied and emitted in conjunction with the given left input row. When no right input rows are identified as matching with the given left input row, a null value is emitted in conjunction with the given left input row.

Abstract: A database system is operable to communicate first system metadata to a plurality of nodes in a first temporal period, where each node of the plurality of nodes updates corresponding system configuration data as the first system metadata. At least one database function is performed in the first temporal period via the plurality of nodes operating in conjunction with the first system metadata. Updated system metadata is determined based on a first metadata change applied the first system metadata. The first metadata change is communicated to the plurality of nodes in a second temporal period, where each node further updates the corresponding system configuration data as the updated system metadata based on applying the first metadata change to the first system metadata. The at least one database function is performed in the second temporal period via the plurality of nodes operating in conjunction with the updated system metadata.

Abstract: A database system operates by: receiving a user-generated secondary indexing hint data for a dataset from a client device, wherein the client device generated the user-generated hint data based on user input in response to at least one prompt displayed by an interactive interface displayed via a display device of the client device; generating a plurality of segments that each include distinct subsets of a plurality of rows of a dataset; automatically selecting, for each of the plurality of segments, a secondary indexing scheme from a plurality of secondary indexing options based on the user-provided secondary indexing hint data; generating a plurality of secondary indexes for each of the plurality of segments in accordance with the corresponding secondary indexing scheme; and storing the plurality of segments and the plurality of secondary indexes in memory.

Abstract: A database system is operable to generate and a first plurality of column-formatted segments from a first plurality of rows. A query indicates parameters for generating a result set, and further indicating an instruction to store the result set. A query operator execution flow that includes a loading operator is generated. The query is executed based on accessing at least one of the first plurality of rows, processing the at least one of the first plurality of rows to generate a second plurality of rows as the result set, and executing the loading operator. At least one new column-formatted segment is from the second plurality of rows based on execution of the loading operator. The at least one new column-formatted segment is stored access in future query executions.

Abstract: A record processing and storage system is operable to receive a plurality of formatted record data. Each of the plurality of formatted record data includes a fixed-length batch section that includes a plurality of fixed-length row sections. Each of the plurality of fixed-length row sections includes at least one fixed-length data value at least one fixed-length offset value. Each of the plurality of formatted record data further includes a variable-length batch section that includes a plurality of variable-length row sections. Each of the plurality of variable-length row sections includes at least one variable-length data value, where the fixed-length offset value for the corresponding one of the plurality of records indicates an offset of the at least one variable-length data value in the each formatted record data. A plurality of pages that include the plurality of formatted record data are generated and stored in a page storage system.

Abstract: A data stream processing system is operable to generate key assignment data indicating assignment of each of a plurality of subsets of a plurality of possible keys to a plurality of feed receiver modules by assigning one owner feed receiver module of the plurality of feed receiver modules to each key of the plurality of possible keys for a plurality of incoming messages, and by further assigning a set of follower feed receiver modules of the plurality of feed receiver modules to the each key of the plurality of possible keys. The plurality of incoming messages are processed via the plurality of feed receiver modules based on the key assignment data.

Abstract: A record processing and storage system is operable to receive a plurality of row data that each indicate a batch number. Each of the plurality of row data is added to a pending row data pool. A plurality of pages is generated from the plurality of row data via a plurality of processing core resources. Each processing core resource in the plurality of processing core resources processing a corresponding subset of the plurality of row data by retrieving, in each time slice of a plurality of time slices, one row data from the pending row data pool with a most favorably ordered batch number of row data in the pending row data pool. Each processing core resource further processes the one row data in the in each time slice to participate in generation of at least one of the plurality of pages.

Abstract: A method for execution by at least one processor of a database system includes storing a plurality of column values for a first column of a plurality of rows. Each of a set of missing data-based conditions for the first column are indexed via an indexing scheme. A subset of the set of missing data-based conditions that satisfy a query predicate of a query are identified. An IO pipeline for access of the first column based on the query predicate and further based on the subset of the set of missing data-based conditions is generated. The IO pipeline is applied in conjunction with execution of the query by applying at least one index element to identify a proper subset of the plurality of rows based on index data of the indexing scheme, and by generating a query resultant based on the proper subset.

Abstract: A node is operable to determine to send at least on data block to a destination node. A second relay node of an initial route that includes exactly a predefined number of relay nodes for relaying at least one data block from the node to a destination node is identified. A set of intermediate node options is identified by identifying nodes of the database system capable of receiving the at least one data block from the node and further capable of sending the at least one data block to the second relay node. Intermediate node selection data is generated by selecting one intermediate node from the set of intermediate node options. The at least one data block is transmitted from the node to the one intermediate node via the first direct connection to facilitate sending of the at least one data block from the node to the destination node.

Abstract: A method for execution by a query processing system includes receiving a query expression that includes a call to a computing window function. The computing window function is executed in accordance with execution of the query expression against a database. Execution of the query expression includes accessing an ordered set of rows of the database indicated in the call to the computing window function, and applying a recursive definition indicated in the call to the computing window function to each row in the ordered set of rows to generate output for each row in the ordered set of rows. A query resultant for the query expression is generated based on the output for each row in the ordered set of rows.

Abstract: A database system is operable to generate a plurality of segment row data from a plurality of records received for storage. The plurality of segment row data is stored via a first storage mechanism corresponding to a first durability level. Storage of the plurality of segment row data via a second storage mechanism corresponding to a second durability level that is more durable than the first durability level is facilitated. Execution of a plurality of queries against the dataset is facilitated by accessing the plurality of segment row data via the first storage mechanism. A failure of storage of one of the plurality of segment row data via the first storage mechanism is detected. The one of the plurality of segment row data is recovered for storage via the first storage mechanism based on accessing at least one of the plurality of segment row data via the second storage mechanism.

Abstract: A computing device is operable to receive a plurality of partition allocation requests based on execution of a corresponding plurality of query operations in conjunction with execution of a corresponding query. Processing a first partition allocation request of the plurality of partition allocation requests corresponding to execution of a first operation of the corresponding plurality of query operations is based on allocating a set of partitions of a plurality of partitions. Content is loaded into the set of partitions for access in executing the first operation. Access to the content via the set of partitions is facilitated in conjunction with execution of the first operation. The set of partitions are released based on determining the first operation has completed access of the content in conjunction with the execution of the first operation.

Abstract: A method for execution by a record processing and storage system includes receiving a plurality of records and generating a plurality of pages that include the plurality of records in accordance with a row-based format. The plurality of pages is stored via a page storage system. Segment generation determination data is generated based on storage utilization data of the page storage system. A plurality of segments is generated from the plurality of pages that include the plurality of records in a column-based format based on the segment generation determination data indicating segments be generated. The plurality of segments is stored via a segment storage system.

Abstract: A method includes receiving a proper subset of messages of a plurality of incoming messages with keys included in a corresponding subset of a plurality of possible keys assigned to the feed receiver module in key assignment data. Messages of the proper subset of messages are maintained. Owned ones of the proper subset of messages having keys included in an owned subset of keys in the corresponding subset, corresponding to keys in the corresponding subset to which the feed receiver module is assigned as an owner in the key assignment data, are identified. Only the owned ones of the proper subset of messages are emitted.