Method, system and computer program product for improved round robin for time series data
View Patent ↗A system for storing time series data in a database using round robin includes a user input interface and a round robin database file manager. The interface receives inputs specifying a time period and a sample rate for collection of delta samples. Each sample represents a difference between two subsequent values of the time series data. The manager accumulates the samples over the time period in accordance with the sample rate, calculates a field size for storing the samples for the time period based on a maximum one of the samples, and writes 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 system, having a processor, for storing time series data using round robin, comprising:
a user input interface for 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;
a database; and
a round robin database file manager for 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,
wherein the database is 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.