CN110851444A - Data acquisition and analysis method for industrial workshop - Google Patents
Data acquisition and analysis method for industrial workshop Download PDFInfo
- Publication number
- CN110851444A CN110851444A CN201911075666.2A CN201911075666A CN110851444A CN 110851444 A CN110851444 A CN 110851444A CN 201911075666 A CN201911075666 A CN 201911075666A CN 110851444 A CN110851444 A CN 110851444A
- Authority
- CN
- China
- Prior art keywords
- data
- analysis
- module
- database
- industrial plant
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000004458 analytical method Methods 0.000 title claims abstract description 79
- 238000004519 manufacturing process Methods 0.000 claims abstract description 31
- 238000006243 chemical reaction Methods 0.000 claims abstract description 12
- 238000010606 normalization Methods 0.000 claims abstract description 10
- 238000005265 energy consumption Methods 0.000 claims abstract description 9
- 230000036541 health Effects 0.000 claims abstract description 9
- 230000010354 integration Effects 0.000 claims abstract description 9
- 238000012545 processing Methods 0.000 claims description 21
- 238000007405 data analysis Methods 0.000 claims description 12
- 238000013480 data collection Methods 0.000 claims description 10
- 238000000034 method Methods 0.000 claims description 8
- 238000012544 monitoring process Methods 0.000 claims description 7
- 238000004140 cleaning Methods 0.000 claims description 6
- 238000012795 verification Methods 0.000 claims description 4
- 230000005540 biological transmission Effects 0.000 claims description 3
- 238000005516 engineering process Methods 0.000 description 4
- 238000004891 communication Methods 0.000 description 3
- 230000008569 process Effects 0.000 description 2
- 238000011160 research Methods 0.000 description 2
- 101000720958 Homo sapiens Protein artemis Proteins 0.000 description 1
- 102100025918 Protein artemis Human genes 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000002860 competitive effect Effects 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 230000003203 everyday effect Effects 0.000 description 1
- 238000007689 inspection Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000006855 networking Effects 0.000 description 1
- 238000005457 optimization Methods 0.000 description 1
- 238000003672 processing method Methods 0.000 description 1
- 238000007493 shaping process Methods 0.000 description 1
- 238000003860 storage Methods 0.000 description 1
- 230000000007 visual effect Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2291—User-Defined Types; Storage management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/215—Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/258—Data format conversion from or to a database
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- Quality & Reliability (AREA)
- Testing And Monitoring For Control Systems (AREA)
- General Factory Administration (AREA)
Abstract
The invention provides a data acquisition and analysis method for an industrial workshop, which comprises the following steps: collecting data of equipment in an industrial workshop; performing format conversion on the data to perform format normalization; analyzing the data, and storing an analysis result into a database; the data integration tool cleans data of different data sources and sends the processed data to the PG database; performing an analysis on the processed data in the PG database, wherein the analysis comprises at least one of: production efficiency analysis, product quality analysis, equipment health assessment and energy consumption analysis.
Description
Technical Field
The embodiment of the invention relates to the technical field of data processing and automatic control, in particular to a data acquisition and analysis method for an industrial workshop.
Background
With the rise of a new industrial revolution with information technology as the core, the concept of "industrial 4.0" is proposed, and the fourth industrial revolution is clearly marked by high digitalization of production, networking and machine self-organization. As the core of intelligent manufacturing, industrial 4.0 and industrial internet, data acquisition and analysis in production process and inter-vehicle industrial communication network technology have attracted attention of all parties. The United states competitive program lists the data acquisition and analysis of the production process and the inter-vehicle industrial communication network technology as important research projects. The European Union starts ARTEMIS and other important projects in the recent period, and takes the data acquisition and analysis in the production process and the workshop-level industrial communication network technology as an important research direction of an intelligent system.
The intelligent manufacturing equipment industry in China has formed a group of faucet enterprises with international competitiveness. But "the level of data utilization by the manufacturing industry is significantly behind that of other industries, particularly those oriented toward B2C". In fact, in the present phase, with the intelligentization of industrial equipment, manufacturing enterprises generate a considerable amount of data every day, how to utilize the data and mine the potential value of the data, so that the manufacturing enterprises improve the production quality and the production efficiency, which become the key concern of each enterprise. However, in the prior art, no good data acquisition and analysis scheme exists for mass data in the manufacturing industry.
Disclosure of Invention
Aiming at the problem that a proper solution is lacked in the field of manufacturing data processing in the prior art, the embodiment of the invention provides a data acquisition and analysis method for an industrial workshop, so as to acquire and process massive industrial workshop data.
In order to solve the above problem, an embodiment of the present invention provides a data collection and analysis method for an industrial plant, including:
collecting data of equipment in an industrial workshop;
performing format conversion on the data to perform format normalization; analyzing the data, and storing an analysis result into a database;
the data integration tool cleans data of different data sources and sends the processed data to the PG database;
performing an analysis on the processed data in the PG database, wherein the analysis comprises at least one of: production efficiency analysis, product quality analysis, equipment health assessment and energy consumption analysis.
In some embodiments, wherein said analyzing the data comprises:
according to the format of the received data, carrying out code conversion on the data so as to convert the data into a preset format;
the data is processed for limit checking and verification.
In some embodiments, the equipment within the industrial plant comprises at least one of: smart electric meter, temperature and humidity sensor, dew point meter.
In some embodiments, the method further comprises: and transmitting the analysis result to a preset terminal for displaying.
In order to solve the above problem, an embodiment of the present invention further provides a data acquisition and analysis method for an industrial plant, including:
receiving data of equipment in an industrial workshop through an intelligent terminal connected with the equipment;
carrying out format conversion on the data through a multi-protocol data acquisition module so as to carry out format normalization; analyzing the data, and storing an analysis result into a database;
cleaning the data of different data sources through the database, and sending the processed data to the PG database;
analyzing the processed data in the PG database by using a data analysis module, wherein the analysis comprises at least one of the following: production efficiency analysis, product quality analysis, equipment health assessment and energy consumption analysis.
In some embodiments, wherein the multi-protocol data acquisition module comprises: the system comprises a model management sub-module, a data acquisition sub-module, a data processing sub-module, a data and message monitoring sub-module and a collaborative issuing sub-module;
the model management submodule is used for generating and storing a model for data analysis;
the data acquisition submodule is used for receiving the data received by the intelligent terminal and carrying out normalization processing on the data format;
the data processing submodule is used for extracting the data of the data acquisition submodule and analyzing the data by utilizing a model in the model management submodule;
and the data and message monitoring submodule is used for processing the data so as to check and verify the limit value.
In some embodiments, the devices within the industrial plant include, but are not limited to, at least one of the following intelligent terminal devices: smart electric meter, temperature and humidity sensor, dew point meter.
In some embodiments, the method further comprises:
and transmitting the analysis result of the data analysis module to a preset terminal for displaying through a transmission module.
The technical scheme of the invention has the following beneficial effects: the embodiment of the invention provides a data acquisition and analysis method for an industrial workshop, which can be used for acquiring data from intelligent industrial equipment by using a multi-protocol data acquisition software tool, carrying out primary processing on the data and then transferring the data into a database. The data integration tool can extract data from the database, clean and integrate data of different sources and different types, and then store the data subjected to secondary processing into the PG database. The intelligent analysis tool obtains data from the PG database, and analyzes the production process data: production efficiency analysis, product quality analysis, equipment health assessment, energy consumption analysis and the like. And finally displaying in a visual chart form.
Drawings
Fig. 1 is a schematic diagram of the principle of the embodiment of the present invention.
Detailed Description
In order to make the technical problems, technical solutions and advantages of the present invention more apparent, the following detailed description is given with reference to the accompanying drawings and specific embodiments.
The technical scheme of the embodiment of the invention provides a data acquisition and analysis method for an industrial workshop, which can better acquire and process the data of the industrial workshop so as to better acquire and analyze the data of the industrial workshop.
The embodiment of the invention provides a data acquisition and analysis method for an industrial workshop, which comprises the following steps:
collecting data of equipment in an industrial workshop; the apparatus comprises at least one of: the intelligent electric meter, the temperature and humidity sensor and the dew point instrument;
performing format conversion on the data to perform format normalization; according to the format of the received data, carrying out code conversion on the data to convert the data into a preset format, and processing the data to carry out limit value check and verification; storing the analysis results in a database;
the data integration tool cleans data of different data sources and sends the processed data to the PG database;
performing an analysis on the processed data in the PG database, wherein the analysis comprises at least one of: production efficiency analysis, product quality analysis, equipment health assessment and energy consumption analysis;
and transmitting the analysis result to a preset terminal for displaying.
Meanwhile, the invention also provides a data acquisition and analysis method for the industrial workshop, which comprises the following steps:
receiving data of equipment in an industrial workshop through an intelligent terminal connected with the equipment;
carrying out format conversion on the data through a multi-protocol data acquisition module so as to carry out format normalization; analyzing the data, and storing an analysis result into a database;
cleaning the data of different data sources through the database, and sending the processed data to the PG database;
analyzing the processed data in the PG database by using a data analysis module, wherein the analysis comprises at least one of the following: production efficiency analysis, product quality analysis, equipment health assessment and energy consumption analysis.
In some embodiments, wherein the multi-protocol data acquisition module comprises: the system comprises a model management sub-module, a data acquisition sub-module, a data processing sub-module, a data and message monitoring sub-module and a collaborative issuing sub-module;
the model management submodule is used for generating and storing a model for data analysis;
the data acquisition submodule is used for receiving the data received by the intelligent terminal and carrying out normalization processing on the data format;
the data processing submodule is used for extracting the data of the data acquisition submodule and analyzing the data by utilizing a model in the model management submodule;
and the data and message monitoring submodule is used for processing the data so as to check and verify the limit value.
In some embodiments, the devices within the industrial plant include, but are not limited to, at least one of the following intelligent terminal devices: smart electric meter, temperature and humidity sensor, dew point meter.
In some embodiments, the method further comprises:
and transmitting the analysis result of the data analysis module to a preset terminal for displaying through a transmission module.
The technical scheme of the embodiment of the invention aims at the requirements of data acquisition and analysis in the production process of the traditional industry and manufacturing enterprises, and provides a data processing method as shown in figure 1, which can be a complete scheme from a data side to an intelligent terminal and throughout links of data acquisition, data cleaning and processing, data analysis, data intelligent display and the like. Relates to the application of an acquisition terminal, multi-protocol data acquisition software, a data integration tool, a PG database, intelligent master control and intelligent analysis tool software.
The data acquisition and analysis method for the industrial workshop, provided by the embodiment of the invention, comprises the following steps: the intelligent equipment is used for acquiring data, and comprises a multi-protocol data acquisition module for format conversion, a database for storing data, a data integration module for data integration, a PG database for data cleaning and an intelligent analysis module for analyzing data;
the intelligent device is used for receiving various devices of the industrial workshop so as to receive the working data of the various devices in real time. Wherein the various devices of the industrial plant may include: smart electric meter, temperature and humidity sensor, dew point instrument and other equipment.
The multi-protocol data acquisition module supports data acquisition and forwarding of multiple protocols, such as DLT645, Modbus, IEC61850, IEC101, IEC104, OPC and other industrial protocols; the method supports real-time collection of multi-modal data (analog quantity, state quantity, double precision quantity, shaping quantity, text quantity, binary quantity and the like); meanwhile, the multi-protocol data acquisition module can perform primary processing such as code conversion, limit value inspection, reasonable verification and the like on acquired data. Through the multi-protocol data acquisition module, valuable data can be acquired from the working data of equipment in factory workshops, such as intelligent electric meters, temperature and humidity sensors, dew point meters and the like, and are forwarded and stored to the database. The multi-protocol data acquisition module comprises a model management submodule, a data acquisition submodule, a data processing submodule, a data and message monitoring submodule and a collaborative issuing submodule.
The data integration module is used for cleaning data of different data sources and sending the processed data to the PG database. The PG database is an open source relational database, has excellent characteristics and is suitable for actual production. The distributed storage and optimization processing of real-time data, product data and third-party service data of the heterogeneous intelligent equipment on the production site can be realized.
The analysis tool module is connected with the PG database to extract production process data and analyze the production process data in the production process to perform production efficiency analysis, product quality analysis, equipment health assessment, energy consumption analysis and the like. And finally, the analysis result is displayed on a PC terminal or a mobile device or other terminals in a real-time correlation chart form to assist the upper layer of production in making a decision.
While the foregoing is directed to the preferred embodiment of the present invention, it will be understood by those skilled in the art that various changes and modifications may be made without departing from the spirit and scope of the invention as defined in the appended claims.
Claims (8)
1. A method for data collection and analysis for an industrial plant, comprising:
collecting data of equipment in an industrial workshop;
performing format conversion on the data to perform format normalization; analyzing the data, and storing an analysis result into a database;
the data integration tool cleans data of different data sources and sends the processed data to the PG database;
performing an analysis on the processed data in the PG database, wherein the analysis comprises at least one of: production efficiency analysis, product quality analysis, equipment health assessment and energy consumption analysis.
2. The data collection and analysis method for an industrial plant of claim 1, wherein the analyzing the data comprises:
according to the format of the received data, carrying out code conversion on the data so as to convert the data into a preset format;
the data is processed for limit checking and verification.
3. The data collection and analysis method for an industrial plant of claim 1, wherein the equipment within the industrial plant comprises at least one of: smart electric meter, temperature and humidity sensor, dew point meter.
4. The data collection and analysis method for an industrial plant of claim 1, further comprising: and transmitting the analysis result to a preset terminal for displaying.
5. A method for data collection and analysis for an industrial plant, comprising:
receiving data of equipment in an industrial workshop through an intelligent terminal connected with the equipment;
carrying out format conversion on the data through a multi-protocol data acquisition module so as to carry out format normalization; analyzing the data, and storing an analysis result into a database;
cleaning the data of different data sources through the database, and sending the processed data to the PG database;
analyzing the processed data in the PG database by using a data analysis module, wherein the analysis comprises at least one of the following: production efficiency analysis, product quality analysis, equipment health assessment and energy consumption analysis.
6. The data collection analysis method for an industrial plant of claim 5, wherein the multi-protocol data collection module comprises: the system comprises a model management sub-module, a data acquisition sub-module, a data processing sub-module, a data and message monitoring sub-module and a collaborative issuing sub-module;
the model management submodule is used for generating and storing a model for data analysis;
the data acquisition submodule is used for receiving the data received by the intelligent terminal and carrying out normalization processing on the data format;
the data processing submodule is used for extracting the data of the data acquisition submodule and analyzing the data by utilizing a model in the model management submodule;
and the data and message monitoring submodule is used for processing the data so as to check and verify the limit value.
7. The data collection and analysis method for the industrial plant according to claim 1, wherein the devices in the industrial plant include but are not limited to at least one of the following intelligent terminal devices: smart electric meter, temperature and humidity sensor, dew point meter.
8. The data collection and analysis method for an industrial plant of claim 1, further comprising:
and transmitting the analysis result of the data analysis module to a preset terminal for displaying through a transmission module.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911075666.2A CN110851444A (en) | 2019-11-06 | 2019-11-06 | Data acquisition and analysis method for industrial workshop |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911075666.2A CN110851444A (en) | 2019-11-06 | 2019-11-06 | Data acquisition and analysis method for industrial workshop |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110851444A true CN110851444A (en) | 2020-02-28 |
Family
ID=69598336
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911075666.2A Pending CN110851444A (en) | 2019-11-06 | 2019-11-06 | Data acquisition and analysis method for industrial workshop |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110851444A (en) |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103577939A (en) * | 2013-11-22 | 2014-02-12 | 广东电网公司电力调度控制中心 | Grid data management method and system |
| CN108268621A (en) * | 2018-01-09 | 2018-07-10 | 上海大学 | Data analysis, excavation, rendering and method for visualizing based on big data |
| CN109558397A (en) * | 2018-10-30 | 2019-04-02 | 平安医疗健康管理股份有限公司 | A kind of data processing method, device, server and computer storage medium |
| CN109710678A (en) * | 2018-12-27 | 2019-05-03 | 成都电科智联科技有限公司 | A kind of real time data system and operation method of industry big data monitoring management |
| CN109739148A (en) * | 2019-01-23 | 2019-05-10 | 上海智共荟智能科技有限公司 | For industrial processing equipment large data sets at optimization processing transmission system and method |
| CN110188102A (en) * | 2019-05-24 | 2019-08-30 | 重庆邮电大学 | A kind of factory's multi-source energy consumption data parallel processing system (PPS) and method |
| CN110297847A (en) * | 2019-07-03 | 2019-10-01 | 牡丹江师范学院 | A kind of intelligent information retrieval method based on big data principle |
-
2019
- 2019-11-06 CN CN201911075666.2A patent/CN110851444A/en active Pending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103577939A (en) * | 2013-11-22 | 2014-02-12 | 广东电网公司电力调度控制中心 | Grid data management method and system |
| CN108268621A (en) * | 2018-01-09 | 2018-07-10 | 上海大学 | Data analysis, excavation, rendering and method for visualizing based on big data |
| CN109558397A (en) * | 2018-10-30 | 2019-04-02 | 平安医疗健康管理股份有限公司 | A kind of data processing method, device, server and computer storage medium |
| CN109710678A (en) * | 2018-12-27 | 2019-05-03 | 成都电科智联科技有限公司 | A kind of real time data system and operation method of industry big data monitoring management |
| CN109739148A (en) * | 2019-01-23 | 2019-05-10 | 上海智共荟智能科技有限公司 | For industrial processing equipment large data sets at optimization processing transmission system and method |
| CN110188102A (en) * | 2019-05-24 | 2019-08-30 | 重庆邮电大学 | A kind of factory's multi-source energy consumption data parallel processing system (PPS) and method |
| CN110297847A (en) * | 2019-07-03 | 2019-10-01 | 牡丹江师范学院 | A kind of intelligent information retrieval method based on big data principle |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN112765768B (en) | Discrete workshop digital traceability method based on Internet of things | |
| CN108538757B (en) | Solar cell manufacturing process tracing method | |
| CN102053608A (en) | Method for energy consumption interactive processing in production process | |
| US11231980B1 (en) | Method, device and system for fault detection | |
| CN114446037A (en) | Carbon emission monitoring system and method based on Internet of things technology | |
| CN213754105U (en) | Photovoltaic power plant intelligent management system based on big data | |
| CN107942873A (en) | A kind of intelligent accounting of the operation cost of Furniture manufacture production line and monitoring method | |
| CN109325641A (en) | A kind of industrial efficiency management system and method | |
| CN115796436B (en) | Production test data management system based on big data | |
| CN110851444A (en) | Data acquisition and analysis method for industrial workshop | |
| CN112580957A (en) | Smart energy management and control system based on cloud platform | |
| CN112132519A (en) | Bottled gas cross network system based on thing networking big data | |
| CN110222100B (en) | Processing method, system and storage medium based on big data display process timing diagram | |
| CN116050781A (en) | Enterprise intelligent management system based on industrial Internet | |
| CN212082447U (en) | Data acquisition system of on-line monitoring system for steam extraction and heat supply of nuclear power plant | |
| CN113110361A (en) | Intelligent factory integrated control system based on production networking | |
| CN110727667B (en) | Consistency management system for power equipment | |
| CN111178763A (en) | Enterprise energy efficiency data management method and device | |
| CN117493498B (en) | Electric power data mining and analysis system based on industrial Internet | |
| CN212750066U (en) | Signal sorting device of energy information mixing channel | |
| CN110969329A (en) | Energy performance assessment management system | |
| CN207946674U (en) | A kind of yield acquisition system based on industrial Internet of Things | |
| CN113344236A (en) | Data-driven production energy consumption prediction method and system | |
| CN115656908A (en) | Detection system and method for intelligent power grid data acquisition terminal | |
| CN207008845U (en) | A kind of power industry data acquisition and Transmission system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20200228 |