CPC G06F 16/2456 (2019.01) [G06F 16/2282 (2019.01); G06F 16/284 (2019.01); G06F 21/6227 (2013.01)] | 19 Claims |
1. A method for execution by at least one processor of a database system, comprising:
receiving a plurality of records of a dataset for storage, wherein each of the plurality of records include a plurality of values corresponding to a plurality of fields of the dataset;
generating a plurality of segment row data from the plurality of records, wherein each segment row data includes a corresponding one of a plurality of mutually exclusive proper subsets of the plurality of records;
storing the plurality of segment row data via a first storage mechanism corresponding to a first durability level;
facilitating 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;
facilitating execution of a plurality of queries against the dataset by accessing the plurality of segment row data via the first storage mechanism;
detecting a failure of storage of one of the plurality of segment row data via the first storage mechanism, wherein detecting the failure of the storage the one of the plurality of segment row data via the first storage mechanism includes detecting a failed memory drive storing the one of the plurality of segment row data; and
recovering the one of the plurality of segment row data 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, wherein recovering the one of the plurality of segment row data for storage via the first storage mechanism includes:
accessing duplicate segment row data of the one of the plurality of segment row data stored via the second storage mechanism; and
storing the duplicate segment row data via a second memory drive of the first storage mechanism that is different from the failed memory drive.
|