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

A data warehouse and management system technology, which is applied in the field of industrial control upper computer management system and PLC data processing, can solve the problems of high cost, inability to fully meet the requirements of data analysis, and insufficient flexibility of system use, so as to achieve strong data analysis ability and improve Enterprise production capacity and equipment operation analysis, good effect of data analysis ability

Inactive Publication Date: 2013-12-04
SUZHOU CHIEN SHIUNG INST OF TECH
View PDF4 Cites 6 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

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

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Data-warehouse-based industrial control upper computer management system and data processing method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0010] Such as figure 1 As shown, the present invention mainly includes industrial equipment, PLC, OPC module, upper computer and database. Among them, the upper computer includes the upper computer management system, which is developed by VC++ and SQLSERVER2005; the human-computer interaction interface developed by VC++ can monitor the parameters of the production process in real time, use OPC technology to realize the communication between PLC and the upper computer, and use SQLSERVER2005 for data storage, Query, analyze. The present invention uses PLC to collect various parameters of the production process in real time, establishes a data warehouse according to the key observation indicators of the production process and equipment of the enterprise, and uses the analysis tool OLAP to analyze the collected data such as temperature and air pressure according to the specific analysis requirements of the enterprise for data. Analyze and obtain valuable data to improve the prod...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

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...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
IPC IPC(8): G05B19/05
Inventor 刘坤杨正校
Owner SUZHOU CHIEN SHIUNG INST OF TECH
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap