US 12,093,254 B1
Query execution during storage formatting updates
George Kondiles, Chicago, IL (US); Andrew Michael Bass, Carmel, IN (US); Finley Jordan Lau, Chicago, IL (US); Natalia Marie Jenuwine, Chicago, IL (US); Greg R. Dhuse, Chicago, IL (US); Hassan Farahani, Evanston, IL (US); and Gregory A. Papadopoulos, Chicago, IL (US)
Assigned to Ocient Holdings LLC, Chicago, IL (US)
Filed by Ocient Holdings LLC, Chicago, IL (US)
Filed on Apr. 28, 2023, as Appl. No. 18/308,954.
Int. Cl. G06F 16/30 (2019.01); G06F 16/22 (2019.01); G06F 16/23 (2019.01); G06F 16/2453 (2019.01)
CPC G06F 16/24537 (2019.01) [G06F 16/221 (2019.01); G06F 16/2379 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A method comprising:
storing an initial set of segments in a segment storage system, wherein the initial set of segments include a plurality of column values of a plurality of records of a dataset;
during a first temporal period after the initial set of segments are stored, facilitating execution of at least one first query against the dataset to generate at least one first corresponding query resultant based on access to column values in the initial set of segments;
determining to re-store column values of records of a first initial segment of the initial set of segments via applying at least one storage optimization technique;
during a second temporal period after the first temporal period, generating at least one first updated segment based on determining to re-store the column values of the records, wherein the at least one first updated segment is structured differently from the first initial segment based on applying the at least one storage optimization technique;
during the second temporal period, facilitating execution of at least one second query against the dataset to generate at least one second corresponding query resultant via access to the column values in the first initial segment based on the at least one first updated segment not yet being available for query execution;
after the second temporal period, replacing storage of the first initial segment with storage of the at least one first updated segment in the segment storage system; and
during a third temporal period after the second temporal period, facilitating execution of at least one third query against the dataset to generate at least one third corresponding query resultant via access to column values in the at least one first updated segment based on the at least one first updated segment being available for query execution.