CN110333690A - A kind of method that production equipment operation big data is acquired and inquired - Google Patents
A kind of method that production equipment operation big data is acquired and inquired Download PDFInfo
- Publication number
- CN110333690A CN110333690A CN201910541256.6A CN201910541256A CN110333690A CN 110333690 A CN110333690 A CN 110333690A CN 201910541256 A CN201910541256 A CN 201910541256A CN 110333690 A CN110333690 A CN 110333690A
- Authority
- CN
- China
- Prior art keywords
- data
- inquiry
- interface
- equipment
- technology
- 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
Classifications
-
- G—PHYSICS
- G05—CONTROLLING; REGULATING
- G05B—CONTROL OR REGULATING SYSTEMS IN GENERAL; FUNCTIONAL ELEMENTS OF SUCH SYSTEMS; MONITORING OR TESTING ARRANGEMENTS FOR SUCH SYSTEMS OR ELEMENTS
- G05B19/00—Programme-control systems
- G05B19/02—Programme-control systems electric
- G05B19/04—Programme control other than numerical control, i.e. in sequence controllers or logic controllers
- G05B19/05—Programmable logic controllers, e.g. simulating logic interconnections of signals according to ladder diagrams or function charts
- G05B19/054—Input/output
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/95—Retrieval from the web
- G06F16/953—Querying, e.g. by the use of web search engines
- G06F16/9532—Query formulation
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/95—Retrieval from the web
- G06F16/953—Querying, e.g. by the use of web search engines
- G06F16/9538—Presentation of query results
-
- G—PHYSICS
- G05—CONTROLLING; REGULATING
- G05B—CONTROL OR REGULATING SYSTEMS IN GENERAL; FUNCTIONAL ELEMENTS OF SUCH SYSTEMS; MONITORING OR TESTING ARRANGEMENTS FOR SUCH SYSTEMS OR ELEMENTS
- G05B2219/00—Program-control systems
- G05B2219/10—Plc systems
- G05B2219/11—Plc I-O input output
- G05B2219/1103—Special, intelligent I-O processor, also plc can only access via processor
Abstract
The invention discloses a kind of methods that equipment and production run big data are acquired and inquired, its main feature is that, including data acquisition, data query two parts；Based on OPC software development, data sharing between equipment is not only realized, while also guarantee company can carry out big data collection analysis to field device and creation data, improves utilization rate of equipment and installations, reduce equipment failure rate, improve production efficiency, reduce labor intensity.
Description
Technical field:
The present invention relates to equipment operating data acquisition and real-time query technical field, specifically a kind of production equipment operation is big
The method of data acquisition and inquiry.
Background technique:
Currently, each manufacturing corporate device is essentially respective independent control, mutual data interaction very little, and does not almost have
There are data to acquire preservation system, therefore does not have big data analysis ability.As equipment automatization technology high-speed develops, industry
The release of 4.0 standards, industry 4.0 require must moment concern technology development, guarantee the advance of technology, and by advanced technology
It is applied to production, reduces labor intensity, improving production efficiency becomes inexorable trend.
Therefore reinforce equipment between contact, equipment and process data are collected into database, with facilitate technique, equipment or
Person, which leads, carries out data query, is then managed decision according to inquired data, and then instruct and improve produced on-site efficiency,
Labor intensity is reduced, developing a kind of device data acquisition thus with inquiry system just becomes very urgent.
Summary of the invention:
The purpose of the present invention is overcoming the shortcomings of above-mentioned prior art, and a kind of operation big data acquisition of production equipment is provided and is looked into
The method of inquiry.
Present invention provide the technical scheme that a kind of method of production equipment operation big data acquisition and inquiry, special
Place is, includes the following steps:
The acquisition of a data: turning net technology by MPI/DP first, by network unification to the same local area network, then passes through OPC
Technology, data acquisition accumulates and deposit database saves in real time, specific as follows:
1. NET technology is turned by MPI/DP not in a network segment in view of each device IP, field device IP is unified to a son
In net, each subnet is finally linked to a multi port switch；
2. field adjustable Kepware is communicated, it is ensured that Kepware and all devices PLC ethernet communication are normal；
3. Kepware group interior nodes are written in the information for needing to acquire according to scene and regulatory requirement；
4. 2010 software platform of Microsoft Visual Studio is based on, using C# Winform organized data circle collection interface；
5. simultaneously database preservation is written in the production of data acquisition interface automatic collection and device data；
B data query: ASP.NET technology is utilized, data query network is established, shares collected data, facilitate equipment and work
Skill Expert Finding data:
1., using C# high-level language, establishing inquiry creation data webpage by ASP.NET technology, establishing an inquiry on demand
Web page interrogation data；
2. establishing query facility data web page using C# high-level language by ASP.NET technology, an inquiry is established on demand
Web page interrogation data (event-driven mechanism is taken in view of winform, therefore cannot achieve data-driven interface data, therefore
Realize that interface data updates by scan round mode in the backstage winform)；
3. using website browsing inquiry mode, realize that client accesses server-side mode, prevents the browsing place limitation of the interface C#, appoint
Meaning client can inquire production run data at any time.
The beneficial effects of the present invention are:
1, by incorporating JAXA technology, it is ensured that do not refresh webpage device data energy Local hydrodynamic unit in the case of ASP.NET webpage；
2, by webpage fast browsing device data, the boundary between equipment and production has thoroughly been broken, to preferably be existing
Field production service；
3, by web page interrogation equipment running status, PLC program demand must be monitored by thoroughly getting rid of, and field device is greatly lowered
Maintenance difficulties；
4, by web page browsing field data, field device remote monitoring and administration is realized.
Detailed description of the invention:
Fig. 1 is data acquisition schematic diagram of the invention；
Fig. 2 is data query schematic diagram of the invention；
Fig. 3 is equipment operating data schematic diagram of the invention.
Specific embodiment:
For a better understanding and implementation, providing specific embodiment with reference to the accompanying drawing, the present invention will be described in detail；Illustrated embodiment
For explaining only the invention, it is not intended to limit the scope of the present invention.
As shown in Figure 1, 2, 3；A kind of method that production equipment operation big data is acquired and inquired, is based on OPC software development,
Realize that pipe processing subsidiary factory's device data automatic collection saves and web browsing function, realize the full company of subsidiary factory's device data share and
Monitor function.Specific steps are such as:
The first step, data acquisition:
It is essentially DP/MPI communication in view of field device, therefore first passes through MPI/DP and turns net technology, device network is unified to same
In one local area network, then by OPC technology, data acquisition is accumulated and deposit database saves in real time:
1, not in a network segment, pass through in view of three producing line equipment (Guan Jiagong 1# line, Guan Jiagong 2# line, heat-treatment lines) IP
MPI/DP turns NET technology, and field device IP is unified into a subnet, and each subnet is finally linked to multiport exchange
Machine；
2, field adjustable Kepware is communicated, it is ensured that Kepware and all devices PLC ethernet communication are normal；
3, according to scene and regulatory requirement, Kepware group interior nodes are written into the information for needing to acquire；
4, it is based on 2010 software platform of Microsoft Visual Studio, using C# Winform organized data acquisition interface (Fig. 1)；
5, data acquisition interface automatically saves equipment creation data write-in database；
Second step, data query:
Using ASP.NET technology, data query network is established, shares collected data, facilitates equipment and technology Expert Finding
Data；
1, inquiry creation data webpage (Fig. 2) is established, establishes one on demand using C# high-level language by ASP.NET technology
Query webpage inquires data；
2, query facility data web page (Fig. 3) is established, establishes one on demand using C# high-level language by ASP.NET technology
Query webpage inquiry data (event-driven mechanism is taken in view of winform, therefore cannot achieve data-driven interface data, because
This realizes that interface data updates by scan round mode on the backstage winform).
3, it using website browsing inquiry mode, realizes that client accesses server-side mode, prevents the interface C# browsing place limit
System, any client can inquire production run data at any time, and which has following inherent advantage:
1, by incorporating JAXA technology, it is ensured that do not refresh webpage device data energy Local hydrodynamic unit in the case of ASP.NET webpage；
2, by webpage fast browsing device data, the boundary between equipment and production has thoroughly been broken, to preferably be existing
Field production service；
3, by web page interrogation equipment running status, PLC program demand must be monitored by thoroughly getting rid of, and field device is greatly lowered
Maintenance difficulties；
4, by web page browsing field data, field device remote monitoring and administration is realized.
Claims (1)
1. a kind of method of production equipment operation big data acquisition and inquiry, which comprises the steps of:
The acquisition of a data: turning net technology by MPI/DP first, by network unification to the same local area network, then passes through OPC
Technology, data acquisition accumulates and deposit database saves in real time, specific as follows:
1. NET technology is turned by MPI/DP not in a network segment in view of each device IP, field device IP is unified to a son
In net, each subnet is finally linked to a multi port switch；
2. field adjustable Kepware is communicated, it is ensured that Kepware and all devices PLC ethernet communication are normal；
3. Kepware group interior nodes are written in the information for needing to acquire according to scene and regulatory requirement；
4. 2010 software platform of Microsoft Visual Studio is based on, using C# Winform organized data circle collection interface；
5. simultaneously database preservation is written in the production of data acquisition interface automatic collection and device data；
B data query: ASP.NET technology is utilized, data query network is established, shares collected data, facilitate equipment and work
Skill Expert Finding data:
1., using C# high-level language, establishing inquiry creation data webpage by ASP.NET technology, establishing an inquiry on demand
Web page interrogation data；
2. establishing query facility data web page using C# high-level language by ASP.NET technology, an inquiry is established on demand
Web page interrogation data take event-driven mechanism in view of winform, therefore cannot achieve data-driven interface data, therefore
Realize that interface data updates by scan round mode in the backstage winform；
3. using website browsing inquiry mode, realize that client accesses server-side mode, prevents the browsing place limitation of the interface C#, appoint
Meaning client can inquire production run data at any time.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910541256.6A CN110333690A (en) | 2019-06-21 | 2019-06-21 | A kind of method that production equipment operation big data is acquired and inquired |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910541256.6A CN110333690A (en) | 2019-06-21 | 2019-06-21 | A kind of method that production equipment operation big data is acquired and inquired |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110333690A true CN110333690A (en) | 2019-10-15 |
Family
ID=68142841
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910541256.6A Pending CN110333690A (en) | 2019-06-21 | 2019-06-21 | A kind of method that production equipment operation big data is acquired and inquired |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110333690A (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102291278A (en) * | 2011-08-09 | 2011-12-21 | 上海辉格科技发展有限公司 | Remote test/calibration/service system and method of sensor or/and device |
| US20120245893A1 (en) * | 2009-11-02 | 2012-09-27 | D Angelo Giuseppe | Module for monitoring industrial processes |
| CN103425085A (en) * | 2013-07-24 | 2013-12-04 | 健雄职业技术学院 | Data-warehouse-based industrial control upper computer management system and data processing method |
| CN105929784A (en) * | 2016-05-11 | 2016-09-07 | 上海应用技术学院 | System for remote monitoring running state of continuous casting apparatus based on PLC |
| CN107908166A (en) * | 2017-11-20 | 2018-04-13 | 上海亚太计算机信息系统有限公司 | A kind of automobile making MES data acquisition system based on industry internet |
-
2019
- 2019-06-21 CN CN201910541256.6A patent/CN110333690A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20120245893A1 (en) * | 2009-11-02 | 2012-09-27 | D Angelo Giuseppe | Module for monitoring industrial processes |
| CN102291278A (en) * | 2011-08-09 | 2011-12-21 | 上海辉格科技发展有限公司 | Remote test/calibration/service system and method of sensor or/and device |
| CN103425085A (en) * | 2013-07-24 | 2013-12-04 | 健雄职业技术学院 | Data-warehouse-based industrial control upper computer management system and data processing method |
| CN105929784A (en) * | 2016-05-11 | 2016-09-07 | 上海应用技术学院 | System for remote monitoring running state of continuous casting apparatus based on PLC |
| CN107908166A (en) * | 2017-11-20 | 2018-04-13 | 上海亚太计算机信息系统有限公司 | A kind of automobile making MES data acquisition system based on industry internet |
Non-Patent Citations (1)
| Title |
|---|
| 控制网: "《自动化新品汇编 2010》", 31 October 2010 * |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102681497B (en) | Remote monitoring system of sewage disposal process and implementation method thereof | |
| DE202019104954U1 (en) | System for the intelligent industrial Internet of Things, using an artificial neural network architecture with bi-directional channels | |
| DE112018001085T5 (en) | DEVICE AND SYSTEM WITH SEVERAL DEVICES FOR MONITORING AND CONTROLLING MACHINES IN INDUSTRIAL PLANT | |
| WO2018095237A1 (en) | Mes-based intelligent heat treatment system and control method therefor | |
| CN107566528A (en) | Sewage treatment plant's monitoring system based on high in the clouds data sharing | |
| EP3547618B1 (en) | Method for establishing a redundant communication connection and fail-safe control unit | |
| DE112018004345T5 (en) | BUILDING MANAGEMENT SYSTEM WITH DATA RECORDING INTO INTELLIGENT ENTITIES AND INTERFACE OF INTELLIGENT ENTITIES WITH ENTERPRISE APPLICATIONS | |
| DE102011053883B4 (en) | Emergency lighting system with data communication capabilities | |
| CN105401771A (en) | Stereo garage integrated management system | |
| CN105446196B (en) | A kind of Intelligent spraying system and its control method with real-time monitoring and control | |
| EP2940926A1 (en) | Method for configuring a communication device within an industrial automation system and distribution unit for a configuration server of an industrial communication network | |
| CN109450698A (en) | A kind of PC automatic assembly line novel maintenance and monitoring method and system | |
| CN109361585A (en) | A kind of method that child node baud rate and address is arranged in host node automatically | |
| CN205139659U (en) | Sewage treatment system based on thing networking | |
| DE112014004208T5 (en) | Integration method and system | |
| CN106094775A (en) | A kind of cutting production line long distance control system | |
| CN110333690A (en) | A kind of method that production equipment operation big data is acquired and inquired | |
| CN111031083B (en) | Production data acquisition method in dual subscription mode | |
| DE102020109294A1 (en) | Method of operating a system | |
| CN106254138A (en) | Machine room intelligent operational system failure analysis methods | |
| CN113848834B (en) | Workshop equipment access system and method based on edge cloud cooperation | |
| CN206557559U (en) | A kind of remote port web monitoring systems based on Mine Integrated automated system | |
| CN114862112A (en) | Intelligent group control method and system for industrial manufacturing unit and electronic equipment | |
| DE19813883A1 (en) | Management system for the targeted provision of Internet information for closed user groups | |
| CN101452637A (en) | Centralized monitoring system and method for high-tension cable net |
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 | ||
| CB03 | Change of inventor or designer information | ||
| CB03 | Change of inventor or designer information |
Inventor after: Pan Chuangye Inventor after: Huang Ming Inventor before: Huang Ming Inventor before: Pan Chuangye |
|
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20191015 |