Method for layering, storing and inquiring data of curve chart of project control system

Abstract

The invention relates to a method for layering, storing and inquiring data of a curve chart of a project control system. The method comprises a storing step and an inquiring step, wherein the storing step comprises: establishing a layered fast table for the project control system to be inquired, processing the source data of the project control system, and storing a processing result into the layered fast table; the inquiring step comprises: selecting the corresponding layered fast table as a data source and inquiring in the data source according to the inquiring content input by a user, sampling from the inquired result sets, and drawing the curve chart according to sampling results. Through the adoption of the method, the needed inquiring data can be quickly obtained from massive amounts of the data of the project control system, the data is ensured to be consistent during the contraction and the enlargement of the curve chart, and at the same time, the obtained data number is maintained at a lower level; the chart reacting circumstances of a fact can be quickly and accurately drawn, and at the same time, the system pressure is reduced to the minimum level; the curve chart reacting real operation situations can be drawn in the fastest time, the bottleneck and the technical problems of the production system are visually and accurately known, the quality of service is improved, and the production cost is reduced.

Description

[0001] technical field [0002] The invention relates to the technical field of data processing, in particular to a data layered storage and query method for graphs of industrial control systems. [0003] Background technique [0004] With the informatization construction of enterprises, production enterprises generate a large amount of real-time monitoring data, and the industrial control system needs to draw the real-time data as curves and present them to users through the interface. At present, the industrial control system collects and stores real-time data of various devices and monitoring instruments through the network. When drawing real-time data curves, most industrial control systems use the method of drawing data in full, that is, for each query operation, the industrial control system needs to send data to the background In the real-time data table of the database, request all monitoring detailed data that meet the user's requirements, and then draw a curve. I...

AI Technical Summary

Problems solved by technology

[0005] It can be seen that the current data storage and query methods involve a large number of data statistics calculations, which consume system memory and time. If multiple graphs are queried at the same time, the transmission pressure on the network is very high.

Although the currently drawn graphs truly reflect the operation of the system, due to the large amount of data displayed on limited display devices, many concerns cannot be easily observed

The usual solution is to use high-configuration server and client, increase network bandwidth, use load balancing, etc., which not only increases the operating cost of the enterprise, but also increases the complexity of the system

Images