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 optimization storage and query method based on the field of industrial control. Background technique [0002] In industrial control, the realization of intelligent control has always been the goal pursued by people. For intelligent control, real-time data acquisition is the most basic and important link, which is related to the performance of the entire system. Only by collecting the data in real time and ensuring its authenticity can the subsequent processing be carried out through the powerful processing and analysis capabilities of the computer, and then the control can be implemented. [0003] In the field of industrial control, the device is basically running all the time, and at the same time it is constantly generating circuit data related to the operation of the device. As time goes by, a very large amount of data will be generated during operation and s...

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