Method, system and computer program product for improved round robin for time series data

摘要

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.