CN106681294A - Software industrial control system based on database - Google Patents
Software industrial control system based on database Download PDFInfo
- Publication number
- CN106681294A CN106681294A CN201710127251.XA CN201710127251A CN106681294A CN 106681294 A CN106681294 A CN 106681294A CN 201710127251 A CN201710127251 A CN 201710127251A CN 106681294 A CN106681294 A CN 106681294A
- Authority
- CN
- China
- Prior art keywords
- data
- control module
- plc
- production
- data base
- 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/418—Total factory control, i.e. centrally controlling a plurality of machines, e.g. direct or distributed numerical control [DNC], flexible manufacturing systems [FMS], integrated manufacturing systems [IMS], computer integrated manufacturing [CIM]
- G05B19/4183—Total factory control, i.e. centrally controlling a plurality of machines, e.g. direct or distributed numerical control [DNC], flexible manufacturing systems [FMS], integrated manufacturing systems [IMS], computer integrated manufacturing [CIM] characterised by data acquisition, e.g. workpiece identification
-
- 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/30—Nc systems
- G05B2219/31—From computer integrated manufacturing till monitoring
- G05B2219/31326—Database to manage communication networks
-
- 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
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/02—Total factory control, e.g. smart factories, flexible manufacturing systems [FMS] or integrated manufacturing systems [IMS]
Abstract
The invention relates to a software industrial control system based on a database. The software industrial control system comprises a PLC data acquisition control module utilizing for production data acquisition and production device via the PLC; a network communication data acquisition control module utilizing for a current production management system interacting and new production control data updating or adding to the local; a serial port data control module utilizing for the production device acquisition under the agreement of serial communication; an external database data communication module utilizing for obtaining required information data from the database; a running logic control module utilizing for communicating with PLC and controlling running logic; a dynamic loading data module on a product type, which is used for executing corresponding programs by transferring the task preset in PLC.
Description
Technical field
The present invention relates to production process control technology field, more particularly to software industry control technical field, specifically refer to one kind
Software industrial control system based on data base.
Background technology
The nonstandard software that existing industrial control software is defined for client's current production, software inhouse logic coupling is serious,
Client changes service logic on the basis of existing hardware or increases new product type, then or client to increase hardware (phase
Software function should be increased) when, intricate operation and easily affect the running of original normal function
The content of the invention
The purpose of the present invention is the shortcoming for overcoming above-mentioned prior art, there is provided one kind can be realized accurately neatly adding
The processor of different product is carried, loading velocity is heightened, later stage maintainability is lifted, the logic more easily base of upgrading products is made
In the software industrial control system of data base.
To achieve these goals, the present invention has following composition：
The software industrial control system of data base should be based on, including：
Plc data acquisition control module, for gathering production process in data, and production equipment is controlled by PLC；
Network communication data acquisition control module, interacts for being attached with current production management system, and storage is local
The creation data of collection, and new production control data is updated or increased newly to local；
External data base data communication module, for obtaining the information data for needing from data base by programmable interface；
Operation logic control module, for by described network communication data acquisition control module, described serial ports number
According to the product data that acquisition control module and described external data base data communication module are obtained, communicated with PLC and controlled
The movement logic of the described system of system；
Product type dynamic load data module, for obtaining process data in real time, and by calling PLC in default
Business performs corresponding production routine.
It is preferred that described plc data acquisition control module is processed interacting for workpiece model data with PLC.
It is preferred that network system of the described network communication data acquisition control module according to current production environment, selects
Network communication protocol, described network communication protocol is included ICP/IP protocol, udp protocol or is assisted based on ICP/IP protocol and UDP
The communication protocol that view is formulated.
It is preferred that described network communication data acquisition control module also includes serial port data acquisition control module, it is described
Serial port data acquisition control module be used for by serial communication protocol collection production equipment data.
More preferably, described serial port data acquisition control module also includes supplied materials product identification unit, and described supplied materials is produced
Product recognition unit is used to be interacted with described production equipment by one-dimension code or Quick Response Code, the workpiece of the current processing of record, and obtains
Take the corresponding processor of current workpiece.
It is preferred that described data base includes SQLServer, mysql, postgreSQL and oracle.
The software industrial control system based on data base in the invention is employed, different product accurately can be neatly loaded
Processor, heightens loading velocity, lifts later stage maintainability, and the logic for making upgrading products is more convenient, and has a wide range of applications
Scope.
Description of the drawings
Fig. 1 is the schematic diagram of the software industrial control system based on data base of the present invention.
Specific embodiment
In order to more clearly describe the technology contents of the present invention, carry out with reference to specific embodiment further
Description.
Based on the software industrial control system of data base, including：
Plc data acquisition control module, for gathering production process in data, and production equipment is controlled by PLC；
Network communication data acquisition control module, interacts for being attached with current production management system, and storage is local
The creation data of collection, and new production control data is updated or increased newly to local；
External data base data communication module, for obtaining the information data for needing from data base by programmable interface；
Operation logic control module, for by described network communication data acquisition control module, described serial ports number
According to the product data that acquisition control module and described external data base data communication module are obtained, communicated with PLC and controlled
The movement logic of the described system of system；
Product type dynamic load data module, for obtaining process data in real time, and by calling PLC in default
Business performs corresponding production routine.
In a kind of preferably embodiment, described plc data acquisition control module is processed workpiece model with PLC
The interaction of data.
In a kind of preferably embodiment, described network communication data acquisition control module is according to current production environment
Network system, select network communication protocol, described network communication protocol to include ICP/IP protocol, udp protocol or be based on
The communication protocol that ICP/IP protocol and udp protocol are formulated.
In a kind of preferably embodiment, described network communication data acquisition control module is also adopted including serial data
Collection control module, described serial port data acquisition control module is used to gather the data of production equipment by serial communication protocol.
In a kind of more preferably embodiment, described serial port data acquisition control module also includes supplied materials product identification list
Unit, described supplied materials product identification unit is used to be interacted with described production equipment by one-dimension code or Quick Response Code, and record is current
The workpiece of processing, and obtain the corresponding processor of current workpiece.
In a kind of preferably embodiment, described data base include SQLServer, mysql, postgreSQL and
oracle。
In a kind of more specifically embodiment, the system includes that plc data acquisition control module, network communication data are adopted
Collection control module, serial port data acquisition control module, external data base data communication module, operation logic control module and product
Type dynamic load data module, the present invention carries out the identification of different product to supplied materials product and loads product pair using data base
The manufacturing procedure answered, as shown in figure 1, wherein：
First, plc data acquisition control module
The plc data acquisition control module includes PLC (programmable logic controller (PLC)) and corresponding industrial computer software
Logic control part, realizes interacting processing workpiece model by (using the network port/serial port etc.) with PLC interaction datas
Data.
Control：The action of corresponding machinery or industrial robot is controlled by PLC；
Collection：Data in collection production process.
2nd, network communication data acquisition control module
The network communication data acquisition control module uses network communication protocol (TCP/IP or UDP)
1st, according to the network system of current production environment, select using TCP/IP or UDP or be based on by Ethernet cable
The communication protocol that the above two agreements are formulated, makes the system be attached with current production management system and interacts, and collection and control are
For the operation of Current software system, this software is data source and controlled terminal to current production management system.
Collection：This software is stored in the creation data of local collection；
Control：New production control data is updated or increased newly local.
2nd, reading one-dimension code or the device and this software of Quick Response Code carries out data acquisition；
Collection：The workpiece of the current processing of record, and obtain the corresponding processor of current workpiece.
3rd, serial port data acquisition control module
Serial ports：Serial communication protocol；
Read the device of one-dimension code or Quick Response Code carries out data acquisition with this software；
Collection：The workpiece of the current processing of record, and obtain the corresponding processor of current workpiece.
4th, external data base data communication module：
External data base includes：SQLServer, mysql, postgreSQL, oracle, the module uses corresponding
Programmable interface obtains the information data required for this software from data above storehouse.
5th, operation logic control module
The operation logic control module is by the in external data base data communication and network data acquisition control system
The product data obtained in two or serial port data acquisition control section, then carry out communication control system movement logic with PLC.
6th, product type dynamic load data module
By real-time and timing by external data base communications portion, it is capable of achieving client and adds in oneself system accordingly
Product data after, this software can in real time get process data, the identification and loading to supplied materials product, and by calling
Default task is performing corresponding production routine in PLC.Operation logic control module and product type dynamic load data mould
Block is complementary.
The software industrial control system based on data base in the invention is employed, different product accurately can be neatly loaded
Processor, heightens loading velocity, lifts later stage maintainability, and the logic for making upgrading products is more convenient, and has a wide range of applications
Scope.
In this description, the present invention is described with reference to its specific embodiment.But it is clear that still can make
Various modifications and alterations are without departing from the spirit and scope of the present invention.Therefore, specification and drawings are considered as illustrative
And it is nonrestrictive.
Claims (6)
1. a kind of software industrial control system based on data base, it is characterised in that described system includes：
Plc data acquisition control module, for gathering production process in data, and production equipment is controlled by PLC；
Network communication data acquisition control module, interacts for being attached with current production management system, the local collection of storage
Creation data, and new production control data is updated or is increased newly to local；
External data base data communication module, for obtaining the information data for needing from data base by programmable interface；
Operation logic control module, for being adopted by described network communication data acquisition control module, described serial data
The product data that collection control module and described external data base data communication module are obtained, are communicated and are controlled institute with PLC
The movement logic of the system stated；
Product type dynamic load data module, for obtaining process data in real time, and by calling PLC in default task hold
The corresponding production routine of row.
2. the software industrial control system based on data base according to claim 1, it is characterised in that described plc data is adopted
Collection control module is processed interacting for workpiece model data with PLC.
3. the software industrial control system based on data base according to claim 1, it is characterised in that described network service number
According to acquisition control module according to the network system of current production environment, network communication protocol, described network communication protocol are selected
The communication protocol formulated including ICP/IP protocol, udp protocol or based on ICP/IP protocol and udp protocol.
4. the software industrial control system based on data base according to claim 1, it is characterised in that described network service number
Also include serial port data acquisition control module according to acquisition control module, described serial port data acquisition control module is used for by string
Row communication protocol gathers the data of production equipment.
5. the software industrial control system based on data base according to claim 4, it is characterised in that described serial data is adopted
Collection control module also includes supplied materials product identification unit, and described supplied materials product identification unit is used for by one-dimension code or Quick Response Code
Interact with described production equipment, the workpiece of the current processing of record, and obtain the corresponding processor of current workpiece.
6. the software industrial control system based on data base according to claim 1, it is characterised in that described data base includes
SQLServer, mysql, postgreSQL and oracle.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710127251.XA CN106681294A (en) | 2017-03-06 | 2017-03-06 | Software industrial control system based on database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710127251.XA CN106681294A (en) | 2017-03-06 | 2017-03-06 | Software industrial control system based on database |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN106681294A true CN106681294A (en) | 2017-05-17 |
Family
ID=58826634
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710127251.XA Pending CN106681294A (en) | 2017-03-06 | 2017-03-06 | Software industrial control system based on database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106681294A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107957708A (en) * | 2017-11-24 | 2018-04-24 | 武汉华中数控股份有限公司 | Numerically controlled machine remote collecting method and system based on Quick Response Code |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| KR20030078298A (en) * | 2002-03-29 | 2003-10-08 | 위아 주식회사 | Device for numerical control and monitoring of a machine and method thereof |
| CN201359698Y (en) * | 2008-12-30 | 2009-12-09 | 大连三高重工设备有限公司 | Automatic control system of large steel pipe production workshop |
| CN101794140A (en) * | 2009-12-30 | 2010-08-04 | 北京数码大方科技有限公司 | Code conversion method and device used for numerical control system |
| CN103217935A (en) * | 2011-11-11 | 2013-07-24 | 洛克威尔自动控制技术股份有限公司 | Integrated and scalable architecture for accessing and delivering data |
| CN104808592A (en) * | 2015-03-13 | 2015-07-29 | 华中科技大学 | Numerical control system based on virtual upper computer |
-
2017
- 2017-03-06 CN CN201710127251.XA patent/CN106681294A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| KR20030078298A (en) * | 2002-03-29 | 2003-10-08 | 위아 주식회사 | Device for numerical control and monitoring of a machine and method thereof |
| CN201359698Y (en) * | 2008-12-30 | 2009-12-09 | 大连三高重工设备有限公司 | Automatic control system of large steel pipe production workshop |
| CN101794140A (en) * | 2009-12-30 | 2010-08-04 | 北京数码大方科技有限公司 | Code conversion method and device used for numerical control system |
| CN103217935A (en) * | 2011-11-11 | 2013-07-24 | 洛克威尔自动控制技术股份有限公司 | Integrated and scalable architecture for accessing and delivering data |
| CN104808592A (en) * | 2015-03-13 | 2015-07-29 | 华中科技大学 | Numerical control system based on virtual upper computer |
Non-Patent Citations (1)
| Title |
|---|
| 周本华 等: "现场数据采集技术及在智能制造系统中的应用", 《制造技术与机床》 * |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107957708A (en) * | 2017-11-24 | 2018-04-24 | 武汉华中数控股份有限公司 | Numerically controlled machine remote collecting method and system based on Quick Response Code |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Shafiq et al. | Virtual engineering object/virtual engineering process: a specialized form of cyber physical system for Industrie 4.0 | |
| JP6615331B2 (en) | Industrial robot process cloud system | |
| Wang et al. | Cloud-based cyber-physical systems in manufacturing | |
| CN108769165A (en) | Data processing method, Internet of Things access system in a kind of Internet of Things | |
| EP1746799B1 (en) | Execution of industrial automation applications on communication infrastructure devices | |
| Ye et al. | Toward the plug-and-produce capability for industry 4.0: An asset administration shell approach | |
| EP3318941B1 (en) | Industrial automation system machine analytics for a connected enterprise | |
| Ahmadi et al. | Evolution of 3C cyber-physical systems architecture for industry 4.0 | |
| Kuhn et al. | Service-based architectures in production systems: Challenges, solutions & experiences | |
| CN106681294A (en) | Software industrial control system based on database | |
| CN108549353A (en) | Wisdom factory monitoring method and system, readable storage medium storing program for executing, terminal | |
| Wu et al. | Cyber physical production systems: a review of design and implementation approaches | |
| Øvern | Industry 4.0-Digital twins and OPC UA | |
| CN109884971A (en) | Long-range control method, apparatus and system | |
| CN104539651B (en) | A kind of embedded hardware equipment that quickly accesses is to the method for back-stage management platform agent server | |
| CN111368720A (en) | Automatic carrying and goods taking system and method | |
| CN106209968A (en) | A kind of Internet of Things data intelligence integration middleware | |
| US20160349966A1 (en) | Device-to-device communication in an industrial automation environment | |
| CN106790569B (en) | method for realizing plug and play of terminal equipment based on Internet of things platform | |
| Elkazini et al. | Impacts of adopting Industry 4.0 technologies on supply chain management: A literature review | |
| CN111038792A (en) | Weighing control method and device for incoming materials of enameled wire | |
| Kashevnik et al. | Industrial cyber-physical system for lenses assembly: Configuration workstation scenario | |
| Guerra-Zubiaga et al. | Computer vision and machine learning to create an advanced pick-and-place robotic operation using industry 4.0 Trends | |
| Rogers et al. | Automated adapting component transfer system using real-time robot control within a KUKA RobotSensorInterface environment | |
| CN104202216A (en) | Method for automatically processing network acquisition abnormity warning |
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 |
Application publication date: 20170517 |
|
| RJ01 | Rejection of invention patent application after publication |