Compressing time stamp columns

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:

• receiving a plurality of time stamps of a time series of data for operations executed on a database of a data platform;
• determining that the plurality of time stamps includes a gap separating a first subseries of successive time stamps separated by an equal time interval and a second subseries of successive time stamps separated by the equal time interval, the first subseries including a first start time of the first subseries, the second subseries including a second start time of the second subseries, and the gap separating the first subseries and the second subseries being different than the equal time interval;
• storing, in a dictionary of a column store of the database, the first start time of the first subseries, the second start time of the second subseries, and the equal time interval, a starting values vector storing a respective starting time stamp for each of the first subseries and the second subseries;
• generating an index vector comprising a first start value and a second start value, the first start value corresponding to the first start time of the first subseries and the second start value corresponding to the second start time of the second subseries;
• and
• executing, based at least in part on the dictionary including the equal time interval and the index vector, the operations on the time series of data.

A system comprising:

• at least one programmable processor;
• and
• at least one memory storing instructions that, when executed by the at least one programmable processor, cause the at least one programmable processor to perform operations comprising:
• receiving a plurality of time stamps of a time series of data for operations executed on a database of a data platform;
• determining that the plurality of time stamps includes a gap separating a first subseries of successive time stamps separated by an equal time interval and a second subseries of successive time stamps separated by the equal time interval, the first subseries including a first start time of the first subseries, the second subseries including a second start time of the second subseries, and the gap separating the first subseries and the second subseries being different than the equal time interval;
• storing, in a dictionary of a column store of the database, the first start time of the first subseries, the second start time of the second subseries, and the equal time interval, a starting values vector storing a respective starting time stamp for each of the first subseries and the second subseries;
• generating an index vector comprising a first start value and a second start value, the first start value corresponding to the first start time of the first subseries and the second start value corresponding to the second start time of the second subseries;
• and
• executing, based at least in part on the dictionary including the equal time interval and the index vector, the operations on the time series of data.