Abstract: A storage system is operable to transition from operation in accordance with a first storage scheme to operation in accordance with a second storage scheme by, for each storage device of the plurality of storage devices, expanding a storage size of a single storage structure of the corresponding plurality of data storage structures identified to implement the second storage scheme from an initial size to a final size consuming full storage resources of the each storage device based on writing all new data of a plurality of write requests to the single storage structure in accordance with the second storage scheme, performing at least one expansion of the single storage structure within the each storage device in response to an expansion condition being met, and completing transition based on the single storage structure reaching the final size consuming the full storage resources of the each storage device.

Abstract: A database system is operable to determine to generate a segment rebuild plan for rebuilding a first segment based on accessing first segment metadata for the first segment. A plurality of replicated part location data is determined for a plurality of parts of the first segment based on processing the first segment metadata and based on applying a deterministic segment part replica dispersal algorithm previously utilized to store the segment group. Nodes of the database system storing a corresponding plurality of sibling parts required to rebuild the plurality of parts of the first segment are determined based on the plurality of replicated part location data and based on storage location-to-node mapping data. The first segment is rebuilt based on applying the segment rebuild plan.

Abstract: A database system operates by: determining a set of assigned segments based on data ownership information; generating a plurality of segment handles and a corresponding plurality of segment metadata for the set of assigned segments based on performing a segment activation step for the set of assigned segments; determining a first query for execution requiring access to a first segment of the set of assigned segments; and executing an IO operator of the first query based on loading the first segment by utilizing a corresponding one of the plurality of segment handles.

Abstract: A database system is operable to execute a query transaction to generate addendum part data updating a segment A target storage node receives a plurality of sets of buffered rows and a plurality of flush requests. The target storage nodes each of a plurality of addendum parts in response to receiving a corresponding one of a plurality of flush requests. The target node assigns a plurality of version numbers to the plurality of addendum parts. A coordinator operator execution module commits only a final addendum part having a most recent version number as the addendum part data for the segment.

Abstract: A database system is operable to, during a first temporal period, facilitate execution of a first query to generate a first query resultant based on access to an initial set of segments. During a second temporal period after the first temporal period, an updated segment is generated based on determining to re-store corresponding column values of an initial segment via applying at least one storage optimization technique. During the second temporal period, execution of a second query is facilitated to generate a second query resultant via access to the initial segment. After the second temporal period, storage of the initial segment is replaced with storage of the updated segment. During a third temporal period after the second temporal period, execution of a third query is facilitated to generate a third corresponding query resultant via access to the updated segment.

Abstract: A storage system is operable to transition from operation in accordance with a first storage scheme to operation in accordance with a second storage scheme by, for each storage device of the plurality of storage devices, expanding a storage size of a single storage structure of the corresponding plurality of data storage structures identified to implement the second storage scheme from an initial size to a final size consuming full storage resources of the each storage device based on writing all new data of a plurality of write requests to the single storage structure in accordance with the second storage scheme, performing at least one expansion of the single storage structure within the each storage device in response to an expansion condition being met, and completing transition based on the single storage structure reaching the final size consuming the full storage resources of the each storage device.