Indexing flexible multi-representation storages for time series data

A computer program product comprising a non-transitory machine-readable medium storing instructions that, when executed by at least one programmable processor, cause the at least one programmable processor to perform operations comprising:

• representing raw time series data in a time series data column with a plurality of representations of the raw time series data, wherein each of the plurality of representations refers to a storage approach of the raw time series data, wherein the plurality of representations comprise at least two storage approaches, wherein the at least two storage approaches comprise at least two different compression formats in which the raw time series data is stored;
• indexing the plurality of representations using a representation index, the representation index comprising, for each segment of the plurality of representations, a start row identifier, a representation identifier corresponding to a representation of the plurality of representations, an end row identifier, and an offset value, wherein the offset value indicates a relevant position within the representation of the plurality of representations where the segment begins, wherein each segment comprises one or more rows in the time series data column associated with the representation of the plurality of representations;
• and
• accessing the representation index instead of the time series data column to perform a data operation on the raw time series data.

A system comprising:

• computer hardware configured to perform operations comprising:
• representing raw time series data in a time series data column with a plurality of representations of the raw time series data, wherein each of the plurality of representations refers to a storage approach of the raw time series data, wherein the plurality of representations comprise at least two storage approaches, wherein the at least two storage approaches comprise at least two different compression formats in which the raw time series data is stored;
• indexing the plurality of representations using a representation index, the representation index comprising, for each segment of the plurality of representations, a start row identifier, a representation identifier corresponding to a representation of the plurality of representations, an end row identifier, and an offset value, wherein the offset value indicates a relevant position within the representation of the plurality of representations where the segment begins, wherein each segment comprises one or more rows in the time series data column associated with the representation of the plurality of representations;
• and
• accessing the representation index instead of the time series data column to perform a data operation on the raw time series data.