Method, system, and computer program product for improved round robin for time series data
View Patent ↗A method, system, and computer program product are provided for improved round robin for time series data. The method includes receiving user inputs specifying a time period and a sample rate for collection of delta samples. Each delta sample represents a difference between two subsequent values of the time series data. The method further includes accumulating the delta samples over the time period in accordance with the sample rate, calculating a field size based on a maximum one of the delta samples, and writing the delta values to the database using the calculated field size. The database is relatable to a plurality of records. Each record corresponds to a respective time period for delta sample collection and has an adjustable field size for delta sample storage based on a maximum delta sample value for the respective time period.
1. A method for storing time series data in a database using round robin, comprising:
receiving user inputs specifying a time period and a sample rate for collection of delta samples, each of the delta samples representing a difference between two subsequent values of the time series data;
accumulating the delta samples over the time period in accordance with the sample rate;
calculating a field size for storing the delta samples for the time period based on a maximum one of the delta samples; and
writing the delta values to the database using the calculated field size, the database being relatable to a plurality of records, each of the plurality of records corresponding to a respective one of a plurality of time periods for delta sample collection and having an adjustable field size for delta sample storage based on a maximum delta sample value for the respective one of the plurality of time periods.