CN109145000A - A kind of RTDB in Industry Control OPC UA data-interface implementation method - Google Patents
A kind of RTDB in Industry Control OPC UA data-interface implementation method Download PDFInfo
- Publication number
- CN109145000A CN109145000A CN201810917401.1A CN201810917401A CN109145000A CN 109145000 A CN109145000 A CN 109145000A CN 201810917401 A CN201810917401 A CN 201810917401A CN 109145000 A CN109145000 A CN 109145000A
- Authority
- CN
- China
- Prior art keywords
- opc
- data
- equipment
- measurement point
- real
- 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.)
- Granted
Links
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a kind of RTDB in Industry Control OPC UA data-interface implementation methods, including two parts of OPC UA device configuration and real-time data memory.It has the advantage that: the present invention gets through the data-interface of the OPC UA of RTDB in Industry Control, it can be achieved that supporting the reading of the real time data of OPC UA equipment and platform software, storage；The present invention provides the record addition and/or modification of the database during device configuration, and all OPC UA equipment of effective guarantee are applicable in；The present invention integrates the API that OPC Foundation official provides in real-time data base, is not necessarily to other applications, realizes in real-time data base to the connection of OPC UA equipment and reading data and storage；Configuration information is stored in relevant database in the present invention, and real time data is saved in real-time data base, realizes the storage of the high frequency real time data of OPC UA, strong operability.
Description
Technical field
The present invention relates to wireless network monitoring technical fields more particularly to a kind of RTDB in Industry Control OPC UA data to connect
Mouth implementation method.
Background technique
With the increasingly complexity of industrial process systems, in order to ensure its safe and stable operation, Industry RealTime Database System
It is had been more and more widely used in industrial process monitoring, and is increasingly becoming Dynamic matrix control and process detection and level of factory information
Manage indispensable technical data platform.
OPC is that automation industry and other industry are pacified for data as one of transport protocol common in industry spot
Interoperability standard when total exchange is all widely used in multiple fields.It ensures independently of platform from multiple manufacturers
Equipment between information seamless transit.With the introducing of the framework in manufacture system service-oriented, brought to OPC
New challenge ensuring the safety of data for how to redefine framework, OPC foundation being promoted to found new frame
Structure ----OPC UA, to meet these demands.At the same time, OPC UA also provides a function for the exploitation in future and expansion
It can open technology platform abundant.OPC UA is one independently of platform, Enterprise SOA specification, is integrated with all
Function from existing OPC Classic specification, provides migration path for safer and expansible solution, the rule
The compatible OPC Classic specification of model.And support of the RTDB in Industry Control as industrial circle mass data storage, it integrates
OPC UA data-interface has higher practicability.
There is also the implementation methods to RTDB in Industry Control interface in the prior art, such as patent publication No. is CN
" the industrial real-time data base interface method " of 104965917 A discloses a kind of industrial real-time data base interface method, belongs to
In wireless network monitoring technical field, the OPC technology for containing real-time data base and DCS interface, the method for realizing interface, in real time
OPC configuration of database etc..But the patent carrying out configuration is obtained using OPC Client software, needs external interface
Machine is acquired data into database by the software on interface message processor (IMP), and level of integrated system is lower；It and is based on OPC
Classic specification, can not support OPC UA to standardize；Configuration information and real time data are maintained in relevant database；Connection
Slowly, information storage is slow.
Therefore, those skilled in the art is dedicated to developing a kind of RTDB in Industry Control OPC UA data-interface realization side
Method, to solve the problems, such as that data can not be transmitted between existing real-time data base and OPC UA equipment.
Summary of the invention
In view of the above drawbacks of the prior art, the technical problem to be solved by the present invention is to existing real-time data base with
Data can not be transmitted between OPC UA equipment and level of integrated system is low, information stores slow problem；Realize real-time data base OPC
UA data-interface can realize real-time data base and industry spot OPC UA equipment dock and all OPC UA standards of supporting
Real-time data memory is realized in the docking of platform software.
To solve the above-mentioned problems, the present invention provides a kind of RTDB in Industry Control OPC UA data-interface realization sides
Method includes the following steps:
S1: log-on data storage, the OPC UA implementor name for storing information as needed search OPC in device databases
The corresponding linking URL of UA equipment, measurement point and the corresponding NodeID of measurement point；Wherein, measurement point refers in OPC UA equipment
Need to carry out the variable of real-time storage.
S2: the connection of OPC UA equipment is carried out according to URL, and implements the reading and storage of measurement point information.
Further, in above-mentioned steps S1, if the OPC UA equipment searched is already existing OPC in device databases
UA equipment then matches linking URL, measurement point and the corresponding NodeID information of measurement point in device databases.
Further, in above-mentioned steps S1, if the OPC UA equipment searched is new OPC UA equipment, device data is carried out
The variable information of not existing OPC UA equipment connection and acquisition OPC equipment in library, each variable correspond to unique NodeID,
The corresponding NodeID of variable point is read, and matches the measurement point for needing to implement storage, completes to add new OPC UA equipment.
Further, it when the new OPC UA equipment of above-mentioned carry out connects, calls OPC official to provide API and realizes OPC UA equipment
Connection, shows equipment variables information and variable information after successful connection.
Further, device databases described in above-mentioned steps S1 are a kind of relevant database, all for storing
Implementor name, linking URL, measurement point, the measurement point of OPC UA device configuration correspond to NodeID.
Further, two kinds of tables of data are set in the device databases, are respectively as follows:
(1) equipment list, for storing the corresponding linking URL of equipment, device type, associated real time data library name；
(2) measurement point table, for storing the corresponding NodeID of all measurement points, measurement point and associated equipment.
Further, it in above-mentioned steps S2, needs to add timestamp to data after reading data success, number in real time is written
According to.
Further, it in above-mentioned steps S2, if there is connection failure in OPC UA equipment connection procedure, will reattempt to
Connection, reconnecting number is 1-10 time, if will cease attempt to connect after reconnect is unsuccessful, real-time data memory knot
Beam.
Preferably, reconnecting number is 5 times.
Further, in above-mentioned steps S2, reading data carries out in the circulating cycle, and cycling condition is data storage starting
When, reading data can reattempt to reading after being abnormal, and it is unsuccessful after continuous reading 1-15 times, it will jump out circulation, disconnect
Connection, reattempts to connection.
Preferably, continuous reading times are 10 times.
Further, during above-mentioned OPC UA device configuration, OPC UA equipment is carried out after configuring forming apparatus linking URL
The measurement point for carrying out real-time storage, the linking URL information and correspondence of all OPC UA equipment may be selected in connection after successful connection
Measurement point information preservation in device databases, can modify or add data-base recording.
The RTDB in Industry Control OPC UA data-interface implementation method provided by implementing aforementioned present invention, has as follows
Technical effect:
(1) present invention get through RTDB in Industry Control OPC UA data-interface, it can be achieved that support OPC UA equipment with
And reading, the storage of the real time data of platform software；
(2) present invention provides the record addition of the database during device configuration and/or modification, effective guarantee own
OPC UA equipment is applicable in；
(3) present invention integrates the API that OPC Foundation official provides in real-time data base, is not necessarily to other application journey
Sequence is realized in real-time data base to the connection of OPC UA equipment and reading data and storage；；
(4) configuration information is stored in relevant database in the present invention, and real time data is saved in real-time data base, is realized
The storage of the high frequency real time data of OPC UA, strong operability.
Detailed description of the invention
It is described further below with reference to technical effect of the attached drawing to design of the invention, specific structure and generation, with
It is fully understood from the purpose of the present invention, feature and effect.
Fig. 1 is reading data flow diagram in the embodiment of the present invention；
Fig. 2 is device configuration flow diagram in the embodiment of the present invention.
Specific embodiment
Below in conjunction with the embodiment of the present invention, technical scheme in the embodiment of the invention is clearly and completely described,
Obviously, described embodiments are only a part of the embodiments of the present invention, instead of all the embodiments.Based in the present invention
Embodiment, every other embodiment obtained by those of ordinary skill in the art without making creative efforts, all
Belong to the scope of protection of the invention.
Using following specific embodiments, the technical schemes of the invention are described in detail below.
The present invention provides a kind of RTDB in Industry Control OPC UA data-interface implementation methods, include the following steps:
As shown in Figure 1, using being initialized, carrying out the OPC UA of information storage as needed after data storage starting
Implementor name searches device databases and the device configuration information；
After the completion of initialization according to user configuration information carry out equipment connection, after successful connection, according in configuration information with
The associated measurement point of the equipment and measurement point correspond to nodeID, carry out reading data；
It reads and timestamp successfully is added to data, be written in real-time data base, read and exist with write-in real-time data base process
It is carried out in circulation, when cycling condition is data storage starting.
Further, the OPC UA device configuration information certainty searched in above-mentioned steps includes the corresponding connection of equipment
URL, real time data library name, equipment correlation measurement point and its NodeID.
Further, if connection failure in data storage procedure, will re-start trial connection, number of attempt be 5 times, 5
It is secondary it is unsuccessful after will stop data storage；
If reading data is abnormal, reattempt to reading will jump out circulation, breaks after continuous 10 readings are unsuccessful
Connection is opened, connection is reattempted to.
Based on above-mentioned implementation method, OPC UA equipment can be started as shown in Figure 2 before OPC UA equipment starts real-time storage
Configuration.
As shown in Fig. 2, inquiry needs to store whether the OPC UA equipment of information is number of devices after user configuration interface is opened
According to equipment is had existed in library, different disposal is carried out according to user's different operation:
If the OPC UA equipment searched is already existing OPC UA equipment in device databases, according to OPC UA equipment
Name matches linking URL, measurement point and the corresponding NodeID information of measurement point in device databases, and OPC official is called to provide
API realizes the connection of OPC equipment, and link information, variable information and the equipment correlation measurement point of equipment are shown after successful connection,
User can be modified；User clicks save after, the record more in new relation library accordingly；
If inspection result is not existing equipment in device databases, according to the URL that user inputs, calling OPC official
API is provided and realizes the connection of OPC UA equipment, shows equipment variables information and variable information after successful connection, user choose need into
The corresponding unique NodeID of the measurement point and measurement point of row real-time storage, after user clicks preservation, in device databases
The record of middle addition new equipment.
Further, configuration information is inevitable in above-mentioned steps corresponds to comprising implementor name, linking URL, measurement point, measurement point
nodeID。
Further, following relevant tables of data is set in the device databases:
(1) equipment list, for storing the corresponding linking URL of equipment, device type, associated real time data library name；
(2) measurement point table, for storing the corresponding NodeID of all measurement points, measurement point and associated equipment.
The preferred embodiment of the present invention has been described in detail above.It should be appreciated that those skilled in the art without
It needs creative work according to the present invention can conceive and makes many modifications and variations.Therefore, all technologies in the art
Personnel are available by logical analysis, reasoning, or a limited experiment on the basis of existing technology under this invention's idea
Technical solution, all should be within the scope of protection determined by the claims.
Claims (9)
1. a kind of RTDB in Industry Control OPC UA data-interface implementation method, which comprises the steps of:
S1: log-on data storage, the OPC UA implementor name for storing information as needed are searched OPC UA in device databases and are set
Standby corresponding linking URL, measurement point and the corresponding NodeID of measurement point；Wherein, measurement point refers to needs in OPC UA equipment
Carry out the variable of real-time storage；
S2: the connection of OPC UA equipment is carried out according to URL, and implements the reading and storage of measurement point information.
2. data-interface implementation method as described in claim 1, which is characterized in that in the step S1, if the OPC searched
UA equipment be device databases in already existing OPC UA equipment, then in device databases match linking URL, measurement point with
And the corresponding NodeID information of measurement point.
3. data-interface implementation method as described in claim 1, which is characterized in that in the step S1, if the OPC searched
UA equipment is not existing OPC UA equipment in device databases, then carries out new OPC UA equipment connection and obtain OPC equipment
Variable information, each variable corresponds to unique NodeID, reads the corresponding NodeID of variable point, and matches needs and implement to deposit
The measurement point of storage is completed to add new OPC UA equipment.
4. data-interface implementation method as described in claim 1, which is characterized in that device data described in the step S1
Library is a kind of relevant database, for storing implementor name, linking URL, measurement point, the measurement point of all OPC UA device configurations
Corresponding NodeID.
5. data-interface implementation method as claimed in claim 4, which is characterized in that two kinds of numbers are arranged in the device databases
According to table, it is respectively as follows:
(1) equipment list, for storing the corresponding linking URL of equipment, device type, associated real time data library name；
(2) measurement point table, for storing the corresponding NodeID of all measurement points, measurement point and associated equipment.
6. data-interface implementation method as described in claim 1, which is characterized in that in the step S2, reading data success
Timestamp is added to data afterwards, real time data is written.
7. data-interface implementation method as described in claim 1, which is characterized in that in the step S2, OPC UA equipment connects
If there is connection failure in termination process, connection will be reattempted to, reconnecting number is 1-10 time, if reconnect not at
It will cease attempt to connect after function, real-time data memory terminates.
8. data-interface implementation method as described in claim 1, which is characterized in that in the step S2, reading data exists
It is carried out in circulation, when cycling condition is data storage starting, reading data can reattempt to reading after being abnormal, continuous to read
It is unsuccessful after 1-15 times, it will jump out circulation, disconnect, reattempt to connection.
9. data-interface implementation method as described in claim 1, which is characterized in that during the OPC UA device configuration,
The connection of OPC UA equipment is carried out after configuring forming apparatus linking URL, the measurement point for carrying out real-time storage may be selected after successful connection,
The linking URL information of all OPC UA equipment and corresponding measurement point information preservation can modify in device databases
Or addition data-base recording.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810917401.1A CN109145000B (en) | 2018-08-13 | 2018-08-13 | Industrial real-time database OPC UA data interface implementation method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810917401.1A CN109145000B (en) | 2018-08-13 | 2018-08-13 | Industrial real-time database OPC UA data interface implementation method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109145000A true CN109145000A (en) | 2019-01-04 |
| CN109145000B CN109145000B (en) | 2022-03-18 |
Family
ID=64792784
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810917401.1A Active CN109145000B (en) | 2018-08-13 | 2018-08-13 | Industrial real-time database OPC UA data interface implementation method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109145000B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112035040A (en) * | 2020-08-31 | 2020-12-04 | 北京润科通用技术有限公司 | Interface variable information processing method and device |
Citations (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101042796A (en) * | 2006-03-23 | 2007-09-26 | 上海宝信软件股份有限公司 | Method for collecting process data of industry on-the-spot apparatus |
| CN102768666A (en) * | 2011-05-05 | 2012-11-07 | 上海可鲁系统软件有限公司 | Method and system for storing and reading industrial data |
| CN103529825A (en) * | 2013-10-23 | 2014-01-22 | 上海白丁电子科技有限公司 | Automatic equipment failure analysis and diagnosis method and device thereof |
| CN103738369A (en) * | 2013-12-26 | 2014-04-23 | 北京交控科技有限公司 | ATS device and system based on OPC UA technology |
| CN105045922A (en) * | 2015-08-26 | 2015-11-11 | 山东鲁能软件技术有限公司 | Electrical equipment monitoring method and device |
| WO2015169355A1 (en) * | 2014-05-07 | 2015-11-12 | Siemens Aktiengesellschaft | Method and device for consistent set operations of data-changing opc-ua calls |
| CN105911965A (en) * | 2016-03-14 | 2016-08-31 | 上海电气集团股份有限公司 | Method for realizing data analysis in data monitoring system |
| CN106444678A (en) * | 2016-10-31 | 2017-02-22 | 马鞍山钢铁股份有限公司 | Energy management system and method for metallurgical enterprise |
| CN106550052A (en) * | 2016-12-08 | 2017-03-29 | 南京富岛信息工程有限公司 | A kind of data acquisition unit and method based on OPC UA |
| US20170142229A1 (en) * | 2015-11-12 | 2017-05-18 | China Petroleum & Chemical Corporation | Systems and methods for drilling automation with opc ua |
| CN106773978A (en) * | 2016-12-28 | 2017-05-31 | 武汉科技大学 | A kind of device data acquisition system based on OPC UA agreements |
-
2018
- 2018-08-13 CN CN201810917401.1A patent/CN109145000B/en active Active
Patent Citations (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101042796A (en) * | 2006-03-23 | 2007-09-26 | 上海宝信软件股份有限公司 | Method for collecting process data of industry on-the-spot apparatus |
| CN102768666A (en) * | 2011-05-05 | 2012-11-07 | 上海可鲁系统软件有限公司 | Method and system for storing and reading industrial data |
| CN103529825A (en) * | 2013-10-23 | 2014-01-22 | 上海白丁电子科技有限公司 | Automatic equipment failure analysis and diagnosis method and device thereof |
| CN103738369A (en) * | 2013-12-26 | 2014-04-23 | 北京交控科技有限公司 | ATS device and system based on OPC UA technology |
| WO2015169355A1 (en) * | 2014-05-07 | 2015-11-12 | Siemens Aktiengesellschaft | Method and device for consistent set operations of data-changing opc-ua calls |
| CN105045922A (en) * | 2015-08-26 | 2015-11-11 | 山东鲁能软件技术有限公司 | Electrical equipment monitoring method and device |
| US20170142229A1 (en) * | 2015-11-12 | 2017-05-18 | China Petroleum & Chemical Corporation | Systems and methods for drilling automation with opc ua |
| CN105911965A (en) * | 2016-03-14 | 2016-08-31 | 上海电气集团股份有限公司 | Method for realizing data analysis in data monitoring system |
| CN106444678A (en) * | 2016-10-31 | 2017-02-22 | 马鞍山钢铁股份有限公司 | Energy management system and method for metallurgical enterprise |
| CN106550052A (en) * | 2016-12-08 | 2017-03-29 | 南京富岛信息工程有限公司 | A kind of data acquisition unit and method based on OPC UA |
| CN106773978A (en) * | 2016-12-28 | 2017-05-31 | 武汉科技大学 | A kind of device data acquisition system based on OPC UA agreements |
Non-Patent Citations (2)
| Title |
|---|
| 邱云 等: "基于OPC UA技术的 Labview 与 PLC通信", 《计算机系统应用》 * |
| 陈骞 等: "基于OPC UA的历史数据存取", 《微型电脑应用》 * |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112035040A (en) * | 2020-08-31 | 2020-12-04 | 北京润科通用技术有限公司 | Interface variable information processing method and device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109145000B (en) | 2022-03-18 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US7543175B2 (en) | Method and system for intelligent and adaptive exception handling | |
| CN104581785B (en) | wireless network test method, test device and mobile terminal | |
| CN103544095B (en) | The method for supervising of server program and system thereof | |
| CN104239476A (en) | Method, device and system for synchronizing databases | |
| CN103916482A (en) | Data synchronous transmission method based on sqlite | |
| CN104767653B (en) | A kind of method and apparatus of network interface monitoring | |
| CN110807064A (en) | Data recovery device in RAC distributed database cluster system | |
| CN107729228A (en) | Interface test method, device, storage medium and processor | |
| CN109857391A (en) | Processing method and processing device, storage medium and the electronic device of data | |
| CN116204438A (en) | Test case generation method, automatic test method and related device | |
| CN102236707A (en) | Method, device and system for obtaining update data of database | |
| CN105827424A (en) | Data acquisition method and data acquisition device | |
| CN109145000A (en) | A kind of RTDB in Industry Control OPC UA data-interface implementation method | |
| CN101193154A (en) | Testing data integration system and method for mobile phone product | |
| CN110377588A (en) | A kind of database object access monitoring method, server and terminal | |
| CN114285695A (en) | Communication method, device, equipment, system and storage medium | |
| JPH10301799A (en) | System for applying test program | |
| US20050246395A1 (en) | Databases synchronization | |
| CN106547485A (en) | Data migration method and device | |
| CN104735097A (en) | Information collecting method and system | |
| CN114328180A (en) | Interface automation test method, system, electronic equipment and storage medium | |
| CN113778895A (en) | Automatic interface testing method and device | |
| CN108427608A (en) | Event alarm method and event alarm device | |
| CN113238950A (en) | System and method for testing distributed system, storage medium and electronic equipment | |
| CN111327581B (en) | Equipment access method and device, electronic equipment and storage medium |
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 | ||
| EE01 | Entry into force of recordation of patent licensing contract |
Application publication date: 20190104 Assignee: Shanghai Electric Huicheng Intelligent System Co., Ltd Assignor: Shanghai Electrical Group Co., Ltd. Contract record no.: X2019310000022 Denomination of invention: A method for implementing OPC UA data interface of industrial real-time database License type: Common License Record date: 20191126 |
|
| EE01 | Entry into force of recordation of patent licensing contract | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |