Database optimized storage and query method based on industrial control field

Abstract

The invention discloses a database optimized storage method based on the industrial control field. The method comprises the following steps of: S1, reading return path data, storing the return path data related to the automatic control rate into a real-time return path automatic control rate acquisition table, and storing the return path data related to the stability rate into a real-time return path stability rate acquisition table; taking the return path data with same space attribute as the tree node data, obtaining and storing the real-time automatic control rate and the stability rate of the tree node according to the return path data in the acquisition tables; S2, while reading the next round of return path data, executing the step S1, and simultaneously executing a step S3; and S3, storing a time stamp in a historical return path acquisition table before storing the current return path data; determining a statistic cycle, accumulating the length of the time stamp, storing the return path data in the historical return path acquisition table into each table corresponding to the statistic cycle, and then, obtaining the historical automatic control rate and the stability rate of the tree node. The invention further discloses a corresponding database optimized query method. With the method provided by the invention, the data query efficiency in a local database with a huge data volume can be improved.

Description

Technical field [0001] The invention relates to database storage and query technology, in particular to a database optimized storage and query method based on the industrial control field. Background technique [0002] In industrial control, the realization of intelligent control has always been the goal that people pursue. For intelligent control, real-time data acquisition is the most basic and most important link, which is related to the efficiency of the entire system. Only by collecting the data in real time and ensuring its authenticity can the subsequent processing and control be carried out through the powerful processing and analysis capabilities of the computer. [0003] In the field of industrial control, the device basically operates at all times, and at the same time, it constantly generates loop data related to the operation of the device. As time goes by, a very large amount of data will be generated during operation and stored in In a real-time database, in order t...

AI Technical Summary

Problems solved by technology

This leads to relatively low efficiency when users query the local database with such a large amount of data, and also causes huge pressure on the local database, data is easily lost, and data security cannot be reliably guaranteed

[0007] To sum up, the current data collection service does not perform any data processing when transferring data from the real-time database to the local database, and does not provide a query and statistical strategy for the huge data in the local database, resulting in The query efficiency of the local database with too large amount of data is low. At the same time, it also causes great pressure on the local database, the data is easily lost, and the security of the data cannot be reliably guaranteed.

Images