Duplicated storage of database system row data via a data lakehouse platform

A method for execution by at least one processor, 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 at least one file stored in a second storage mechanism corresponding to a second durability level that is more durable than the first durability level, wherein table metadata corresponding to the at least one file is further stored via the second storage mechanism;
• 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 is based on:
• accessing duplicate segment row data of the one of the plurality of segment row data stored via the second storage mechanism via accessing of the at least one file based on accessing the table metadata corresponding to the at least one file based on communications between at least one storage system interface and a metadata processing system of 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.

A non-transitory computer readable storage medium comprises:

• at least one memory section that stores operational instructions that, when executed by a processing module that includes a processor and a memory, causes the processing module to:
• receive 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;
• generate 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;
• store the plurality of segment row data via a first storage mechanism corresponding to a first durability level;
• facilitate storage of the plurality of segment row data via at least one file stored in a second storage mechanism corresponding to a second durability level that is more durable than the first durability level, wherein table metadata corresponding to the at least one file is further stored via the second storage mechanism;
• facilitate execution of a plurality of queries against the dataset by accessing the plurality of segment row data via the first storage mechanism;
• detect 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
• recover 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 is based on:
• accessing duplicate segment row data of the one of the plurality of segment row data stored via the second storage mechanism via accessing of the at least one file based on accessing the table metadata corresponding to the at least one file based on communications between at least one storage system interface and a metadata processing system of 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.