A historical average management system and management method

Abstract

The invention relates to a history average value management system and a management method. In order to solve the problems in the prior art that the inquiring speed of an average value inquiring system is slow, partial data needs to be cleared at intervals, and the data storage is limited, the system comprises a client side and a server side. The client side comprises a data inquiring request unit. The server side comprises a data inquiring unit, a data source, a data collecting unit, a ring data buffer unit, an average value processing unit, and an average value file unit. The management method comprises the average value storing step and the data inquiring step. The data is stored in a plurality of average value files according to the timing separation, each file has the storage structure convenient for searching, so a user can execute the query rapidly, and the spend time in the average value query is reduced. The data is stored by the storage structure set by the average value file, the data average value of the longer time can be stored, and the query complexity is constant, the query cannot be slowed because the time is long.

Description

technical field [0001] The invention relates to a data average value processing technology, in particular to a historical average value management system and management method. Background technique [0002] In the traditional industrial control system average calculation and query system, the data is stored in the relational database. Since the average value of one bit number per minute needs to store 1440 pieces of data a day, when the total number of bit numbers exceeds 10,000, more than 10 million pieces will be added every day. data. The more data, the greater the impact on the query speed, so in this case, some data is often cleared every once in a while, so that the saved data is limited, and directly leads to a certain limit on the query time period. Contents of the invention [0003] The present invention mainly solves the problem that the query speed of the average value query system in the prior art is slow, and some data needs to be cleared every once in a whil...

AI Technical Summary

Problems solved by technology

[0003] The present invention mainly solves the problem that the query speed of the average value query system in the prior art is slow, and some data needs to be cleared every once in a while, and the data storage is limited, and an optimized storage structure is provided, the query speed is constant, and the data storage capacity is large Historical average management system and management method

The present invention stores data into several average value files according to time, and each file has a storage structure that is convenient for retrieval, which enables users to quickly query and reduces the time spent on average value query. With the support of a large enough hard disk, it can Query longer interval data, which solves the problem that in the traditional query system, due to the increase of stored data, the query speed is affected, some data needs to be deleted every once in a while, and the stored data is limited

Images