Data-warehouse-based industrial control upper computer management system and data processing method

Abstract

The invention discloses a data-warehouse-based industrial control upper computer management system which comprises a PLC (programmable logic controller) module for data acquisition, an OPC (OLE for process control) module communicated with the PLC, a display module for displaying PLC real-time monitoring data, a database for storing PLC measurement data and an analyzing module. The analyzing module is used for building a data warehouse, for data inquiry and digging, by using collected data and according to user's requirements. The data warehouse is built by using the data collected by the PLC, the analyzing tool OLAP is used to analyze the collected data such as temperature and air pressure to obtain valuable data, and accordingly enterprise production capability and equipment operation condition analyzing capability are improved. The data-warehouse-based industrial control upper computer management system in good in interactivity and high in data analyzing capability.

Description

technical field [0001] The invention relates to process control automation and computer database technology, in particular to an industrial control upper computer management system and a PLC data processing method. Background technique [0002] PLC plays an important role in the field of industrial control systems. The general typical applications in industrial control systems are: PLC as a lower-level control machine to realize automatic control of the manufacturing process, and PC as a host computer to manage industrial process monitoring and mode control. The existing device has the advantages of high reliability, flexible system design, simple programming, easy installation, strong anti-interference ability, etc., but it does not have a good man-machine interface and data storage. [0003] In practical applications, it is often necessary to store, display and print out a set of PLC data, and to monitor the PLC in real time. The application of industrial monitoring config...

AI Technical Summary

Problems solved by technology

[0003] In practical applications, it is often necessary to store, display and print out a set of PLC data, and to monitor the PLC in real time. The application of industrial monitoring configuration software can solve such problems, but this type of system is not flexible enough and the cost is high

At present, the existing upper computer management system mainly stores the collected data directly in the database, then exports the data from the database to an excel sheet, uses excel to perform simple processing on the data, and prints it in the form of a report, which cannot fully meet the user's requirements for data analysis

Images