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
- 238000004891 communication Methods 0.000 claims abstract description 42
- 238000004519 manufacturing process Methods 0.000 claims abstract description 37
- 238000012545 processing Methods 0.000 claims description 6
- 230000004044 response Effects 0.000 claims description 5
- 238000000034 method Methods 0.000 claims description 4
- 230000008569 process Effects 0.000 claims description 4
- 238000011958 production data acquisition Methods 0.000 abstract 1
- 238000005516 engineering process Methods 0.000 description 3
- 230000003993 interaction Effects 0.000 description 2
- 241001269238 Data Species 0.000 description 1
- 230000009471 action Effects 0.000 description 1
- 230000004075 alteration Effects 0.000 description 1
- 230000000295 complement effect Effects 0.000 description 1
- 230000008878 coupling Effects 0.000 description 1
- 238000010168 coupling process Methods 0.000 description 1
- 238000005859 coupling reaction Methods 0.000 description 1
- 238000013480 data collection Methods 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
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] or 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] or 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]
Landscapes
- Engineering & Computer Science (AREA)
- General Engineering & Computer Science (AREA)
- Manufacturing & Machinery (AREA)
- Quality & Reliability (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Automation & Control Theory (AREA)
- Stored Programmes (AREA)
- General Factory Administration (AREA)
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 |
---|---|---|
Lins et al. | Cyber-physical production systems retrofitting in context of industry 4.0 | |
Wang et al. | An integrated industrial ethernet solution for the implementation of smart factory | |
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 | |
Ye et al. | Toward the plug-and-produce capability for industry 4.0: An asset administration shell approach | |
Ralph et al. | Digitalization and digital transformation in metal forming: key technologies, challenges and current developments of industry 4.0 applications | |
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 | |
CN110417760A (en) | The mutual operation method and middleware of marginal layer in industry internet | |
Wu et al. | Cyber physical production systems: a review of design and implementation approaches | |
Stocker et al. | Key success factors for the implementation of digital technologies in the context of Industry 4.0 | |
Øvern | Industry 4.0-Digital twins and OPC UA | |
George et al. | The Cobot Chronicles: Evaluating the Emergence, Evolution, and Impact of Collaborative Robots in Next-Generation Manufacturing | |
CN104539651B (en) | A kind of embedded hardware equipment that quickly accesses is to the method for back-stage management platform agent server | |
CN106412062A (en) | Method and system for remotely loading engineering to device and monitoring operation state of engineering | |
CN106790569B (en) | method for realizing plug and play of terminal equipment based on Internet of things platform | |
CN107678924A (en) | A kind of integrated data center operational system framework based on multiple agent | |
Guerra-Zubiaga et al. | Computer vision and machine learning to create an advanced pick-and-place robotic operation using industry 4.0 Trends | |
CN108038186A (en) | A kind of Internet of Things operating system framework based on multiple agent | |
CN111844021B (en) | Mechanical arm cooperative control method, device, equipment and storage medium | |
CN108733014A (en) | It is proposed and/or establish method, equipment, automated system and the device of Ai Zhen bodies | |
Hoppe | Forerunner to Industry 4.0 and the Internet of Things | |
CN107659557A (en) | A kind of simple big data is distributed to call computational methods | |
CN113930608A (en) | Centralized management and control system, method and device for annealing tinning machine and storage medium | |
US10930034B2 (en) | Automated event correlation in a managed historian 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 |
Application publication date: 20170517 |
|
RJ01 | Rejection of invention patent application after publication |