CN107766391A - Database and OPC systems of connections and its control method - Google Patents
Database and OPC systems of connections and its control method Download PDFInfo
- Publication number
- CN107766391A CN107766391A CN201610705684.4A CN201610705684A CN107766391A CN 107766391 A CN107766391 A CN 107766391A CN 201610705684 A CN201610705684 A CN 201610705684A CN 107766391 A CN107766391 A CN 107766391A
- Authority
- CN
- China
- Prior art keywords
- opc
- module
- database
- query statement
- opc client
- 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
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/80—Information retrieval; Database structures therefor; File system structures therefor of semi-structured data, e.g. markup language structured data such as SGML, XML or HTML
- G06F16/83—Querying
- G06F16/835—Query processing
- G06F16/8373—Query execution
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/80—Information retrieval; Database structures therefor; File system structures therefor of semi-structured data, e.g. markup language structured data such as SGML, XML or HTML
- G06F16/84—Mapping; Conversion
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a kind of database and OPC systems of connections, including information flag text module, for importing configuration information；Database and OPC system of connections programs, for parsing configuration information and being sent to OPC client module and query statement module；OPC client module, for performing device directive；Query statement module, for performing database instruction；Opc server module, for obtaining or setting the parameter of equipment；Man-machine interface, display and export for control and the daily record of system.Highly compatible can be achieved, simplification, because OPC is factory's universal data interface, all equipment with OPC data interface can be connected, extending mark language is simple simultaneously, it is easy to learn and use, the competency profiling of user can farthest be reduced by importing configuration information using extending mark language, improve operating efficiency.
Description
Technical field
The present invention relates to the technical field of data processing based on OPC industrial standards and database SQL query language, is particularly
Refer to a kind of database and OPC systems of connections and its control method.
Background technology
In recent years, with factory automation and information-based development, the automation of shop equipment and the informationization of management level
All it has been widely used.The demand such as the collection of management level and the information of shop equipment layer, interaction is increasingly heavy, and this just needs one
Compatibility, effective, simplification can meet demand interface linking.
In current factory automation, the information exchange between factory management layer and shop equipment is much manually to transmit
Realize, it is low that the depth of personnel participates in causing efficiency, many bad results such as error rate height.And waste substantial amounts of people
Power resource.
Realizing the information exchange another way between factory management layer and shop equipment is customized using various special-purpose softwares
Write program realization.Professional software species is more, and programming difficulty is big, and factory needs to cultivate full-time engineers design's exploitation.For
Various interfaces are different in factory, and the link of the different controller of agreement expends substantial amounts of work, is unfavorable for upgrading and the mark of factory
Standardization.This has also resulted in factory and has been difficult to quickly upgrading integration production equipment, to adapt to the demand of Flexible Production.
The content of the invention
, can be with the technical problem to be solved in the present invention is to provide a kind of database and OPC systems of connections and its control method
It is simple to realize connection shop equipment and management level database.
In order to solve the above technical problems, embodiments of the invention provide a kind of database and OPC systems of connections, including：
Information flag text module, for importing configuration information；
Database and OPC system of connections programs, for parsing configuration information and being sent to OPC client module and inquiry refers to
Make module；
OPC client module, for performing device directive；
Query statement module, for performing database instruction；
Opc server module, for obtaining or setting the parameter of equipment；
Man-machine interface, display and export for control and the daily record of system.
Preferably, the configuration information that described information retrtieval module imports is OPC client connector, variable, OPC
It is one or more in client executing instruction, database connector and query statement.
Preferably, the device directive be OPC client connector, variable, it is a kind of in OPC client execute instruction or
It is a variety of.
Preferably, the database instruction is one or more in database connector and query statement.
Preferably, the OPC client module, is additionally operable to be performed according to the OPC client connector, the variable that receive
OPC client execute instruction, being sent to query statement module received from the real time data to opc server module variable, and
Implementing result is sent to opc server module.
Preferably, the query statement module, is additionally operable to perform query statement according to the database connector received,
Variable received from OPC client module is stored, and then implementing result is sent to OPC client module.
Preferably, the opc server module, it is additionally operable to device parameter to be sent to the variable of OPC client module
In, and export the result received from OPC client.
Present invention also offers the control method that a kind of database couples with OPC, step includes：
S1. open system, configuration information is imported, being provided with information includes OPC client connector, variable, OPC client
Hold execute instruction, database connector, query statement；
S2. configuration information is parsed, and OPC client connector, variable, OPC client execute instruction are sent to an OPC
Client modules, database connector, query statement are sent to a query statement module；
S3.OPC client modules perform OPC client execute instruction according to the OPC client connector, the variable that receive,
The real time data for receiving the variable from an opc server module is sent to query statement module, then implementing result sent out
Deliver to opc server module；
S4. query statement module performs query statement according to the database connector received, received from OPC client mould
The variable of block is stored in a database, and then implementing result is sent to OPC client module；
Device parameter, is then sent to OPC client module by S5.OPC server module real-time collecting device parameters
In variable, and the result received from OPC client module is sent to equipment；
S6. show and export daily record；
S7. system is closed.
The above-mentioned technical proposal of the present invention has the beneficial effect that：
Database proposed by the present invention and OPC systems of connections and its control method, achievable highly compatible, simplification, by
It is factory's universal data interface in OPC, all equipment with OPC data interface, while extending mark language letter can be connected
It is single, it is easy to learn and use, the competency profiling of user can farthest be reduced by importing configuration information using extending mark language, be improved
Operating efficiency.
Brief description of the drawings
The theory diagram of Fig. 1 embodiment of the present invention；
Fig. 2 is the control method flow chart of the embodiment of the present invention.
Embodiment
To make the technical problem to be solved in the present invention, technical scheme and advantage clearer, below in conjunction with accompanying drawing and tool
Body embodiment is described in detail.
The invention provides a kind of database and OPC systems of connections, to realize highly compatible, simplification；Such as Fig. 1 institutes
Show, it includes：Information flag text module, database and OPC systems of connections program, OPC client module, query statement mould
Block, opc server module, man-machine interface.Each module is introduced in detail below.
Information flag text module, for importing configuration information.
Database and OPC system of connections programs, for import information retrtieval module, and parse information to OPC client
End module and query statement module.
OPC client module, for performing device directive.
Query statement module, for performing database instruction.
Opc server module, for obtaining or setting the parameter of equipment.
Man-machine interface, display and export for control and the daily record of system.
It is described above the database and OPC systems of connections of the present invention.
Present invention also offers the control method that a kind of database couples with OPC, as shown in Fig. 2 method includes following step
Suddenly：
Information flag text is database and OPC configuration information of the user using extending mark language editor.
Database and OPC systems of connections program by information flag text resolution and be respectively sent to OPC client module and
Query statement module, and parsing information is published to display interface.
OPC client module performs database and instructed with the OPC client that OPC systems of connections program imports.
The real time data of variable received from opc server module is sent to query statement module, then performing knot
Fruit is sent to opc server module.
Query statement module performs the query statement that database imports with OPC systems of connections program.Received from OPC client
The variable deposit database of end module, then sends implementing result to OPC client module.
Opc server module is used for real-time collecting device parameter, then device parameter is sent to the variable of OPC client
In, and the result received from OPC client is sent to equipment.
Wherein, man-machine interface is used for the startup of system, stops display and export with daily record.
The database that summary technical scheme proposes and OPC systems of connections and its control method, can be achieved highly compatible,
Simplification, because OPC is factory's universal data interface, all equipment with OPC data interface can be connected, while extend mark
Remember that language is simple, be easy to learn and use, the quality of user can farthest be reduced by importing configuration information using extending mark language
It is required that improve operating efficiency.
Described above is the preferred embodiment of the present invention, it is noted that for those skilled in the art
For, on the premise of principle of the present invention is not departed from, some improvements and modifications can also be made, these improvements and modifications
It should be regarded as protection scope of the present invention.
Claims (8)
1. a kind of database and OPC systems of connections, it is characterised in that including：
Information flag text module, for importing configuration information；
Database and OPC system of connections programs, for parsing configuration information and being sent to OPC client module and query statement mould
Block；
OPC client module, for performing device directive；
Query statement module, for performing database instruction；
Opc server module, for obtaining or setting the parameter of equipment；
Man-machine interface, display and export for control and the daily record of system.
2. database according to claim 1 and OPC systems of connections, it is characterised in that described information retrtieval module
The configuration information of importing is OPC client connector, variable, OPC client execute instruction, database connector and query statement
Middle one or more.
3. database according to claim 2 and OPC systems of connections, it is characterised in that the device directive is OPC client
Hold one or more in connector, variable, OPC client execute instruction.
4. database according to claim 3 and OPC systems of connections, it is characterised in that the database instruction is data
It is one or more in storehouse connector and query statement.
5. database according to claim 4 and OPC systems of connections, it is characterised in that the OPC client module, also
For performing OPC client execute instruction according to the OPC client connector, the variable that receive, received to opc server
The real time data of module variable is sent to query statement module, and implementing result is sent to opc server module.
6. database according to claim 5 and OPC systems of connections, it is characterised in that the query statement module, also use
In performing query statement according to the database connector received, the variable received from OPC client module is stored, then
Implementing result is sent to OPC client module.
7. database according to claim 6 and OPC systems of connections, it is characterised in that the opc server module, also
For device parameter to be sent in the variable of OPC client module, and export the result received from OPC client.
8. the control method that a kind of database couples with OPC, it is characterised in that step includes：
S1. open system, configuration information is imported, is provided with information and is held including OPC client connector, variable, OPC client
Row instruction, database connector, query statement；
S2. configuration information is parsed, and OPC client connector, variable, OPC client execute instruction are sent to an OPC client
End module, database connector, query statement are sent to a query statement module；
S3.OPC client modules perform OPC client execute instruction according to the OPC client connector, the variable that receive, connecing
Receive the variable from an opc server module real time data be sent to query statement module, then implementing result send to
Opc server module；
S4. query statement module performs query statement according to the database connector received, received from OPC client module
Variable is stored in a database, and then implementing result is sent to OPC client module；
S5.OPC server module real-time collecting device parameters, then device parameter is sent to the variable of OPC client module
In, and the result received from OPC client module is sent to equipment；
S6. show and export daily record；
S7. system is closed.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610705684.4A CN107766391A (en) | 2016-08-22 | 2016-08-22 | Database and OPC systems of connections and its control method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610705684.4A CN107766391A (en) | 2016-08-22 | 2016-08-22 | Database and OPC systems of connections and its control method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107766391A true CN107766391A (en) | 2018-03-06 |
Family
ID=61264260
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610705684.4A Pending CN107766391A (en) | 2016-08-22 | 2016-08-22 | Database and OPC systems of connections and its control method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107766391A (en) |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101026633A (en) * | 2007-03-01 | 2007-08-29 | 江西省电力科学研究院 | IEC 61850 and OPC based heterogeneous power quality monitoring device integrating method and gateway |
| CN101488280A (en) * | 2008-01-18 | 2009-07-22 | 绍兴电力局 | Embedded PI data collecting apparatus based on OPC |
| CN101713994A (en) * | 2009-12-03 | 2010-05-26 | 陕西北人印刷机械有限责任公司 | Information management system for on-line production of printing machine and method thereof |
| CN102325177A (en) * | 2011-09-05 | 2012-01-18 | 太原理工大学 | Coal mine production three-dimensional visualization information system based on Internet of things |
| CN202886956U (en) * | 2012-10-16 | 2013-04-17 | 浙江天工自信科技工程有限公司 | Power-generator performance monitoring system based on similarity principle |
| CN104660682A (en) * | 2015-01-27 | 2015-05-27 | 华南理工大学 | OPC data acquisition and monitoring intelligent terminal based on TD-LTE |
| CN105807725A (en) * | 2014-12-30 | 2016-07-27 | 上海远动科技有限公司 | SCADA intelligent monitoring scheduling system based on GDI and application method |
-
2016
- 2016-08-22 CN CN201610705684.4A patent/CN107766391A/en active Pending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101026633A (en) * | 2007-03-01 | 2007-08-29 | 江西省电力科学研究院 | IEC 61850 and OPC based heterogeneous power quality monitoring device integrating method and gateway |
| CN101488280A (en) * | 2008-01-18 | 2009-07-22 | 绍兴电力局 | Embedded PI data collecting apparatus based on OPC |
| CN101713994A (en) * | 2009-12-03 | 2010-05-26 | 陕西北人印刷机械有限责任公司 | Information management system for on-line production of printing machine and method thereof |
| CN102325177A (en) * | 2011-09-05 | 2012-01-18 | 太原理工大学 | Coal mine production three-dimensional visualization information system based on Internet of things |
| CN202886956U (en) * | 2012-10-16 | 2013-04-17 | 浙江天工自信科技工程有限公司 | Power-generator performance monitoring system based on similarity principle |
| CN105807725A (en) * | 2014-12-30 | 2016-07-27 | 上海远动科技有限公司 | SCADA intelligent monitoring scheduling system based on GDI and application method |
| CN104660682A (en) * | 2015-01-27 | 2015-05-27 | 华南理工大学 | OPC data acquisition and monitoring intelligent terminal based on TD-LTE |
Non-Patent Citations (1)
| Title |
|---|
| 丁佳佳等: ""煤炭仓储企业的生产数据存储与发布系统的设计"", 《煤炭技术》 * |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105488032A (en) | Speech recognition input control method and system | |
| CN105681285B (en) | A kind of isomery industry signal source information acquisition methods | |
| CN101262486A (en) | Modbus bus analysis system based on built-in platform | |
| CN110191138A (en) | A kind of edge calculations intelligent adapter and implementation method towards industry manufacture | |
| CN105786912A (en) | Data acquisition and transformation method and device | |
| CN104852960A (en) | Intelligent Internet of things cloud terminal system | |
| CN101944128A (en) | Data export and import method and device | |
| CN107294778A (en) | A kind of method that industrial equipment collection is realized based on cloud Internet of Things platform | |
| CN103780624A (en) | General application layer network communication protocol application method for complicated system | |
| CN103914501A (en) | Power industry real-time reporting method based on massive real-time database | |
| CN106919697A (en) | A kind of method that data are imported multiple Hadoop components simultaneously | |
| CN113783860B (en) | Message processing method, device, equipment and storage medium based on visual configuration | |
| CN104537496A (en) | Intelligent terminal device use state statistics and analysis method and device | |
| CN109818950A (en) | A kind of access control rule optimization method and device, computer readable storage medium | |
| CN102521318A (en) | General data exchange device based on extensible markup language (XML) | |
| CN107766391A (en) | Database and OPC systems of connections and its control method | |
| CN103986588B (en) | Computer system and far-end remote control method of computer device | |
| CN110572242A (en) | Method for collecting data unified codes of injection molding machine | |
| CN108108375A (en) | A kind of big data extracting method and system | |
| CN115062051A (en) | Universal assembly cross-database language query method and system | |
| WO2019062042A1 (en) | Task management method | |
| CN205028119U (en) | Servo universal control system of gas -liquid based on PCI bus | |
| CN102722592B (en) | Universal digital information recording device and method | |
| CN110493343B (en) | OPC-based method for communicating with multiple PLCs | |
| CN106346476A (en) | Control method and control device for steering engine |
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 | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20180306 |
|
| WD01 | Invention patent application deemed withdrawn after publication |