CN102854870B - Distributed control system and data report generating method - Google Patents
Distributed control system and data report generating method Download PDFInfo
- Publication number
- CN102854870B CN102854870B CN201210382072.8A CN201210382072A CN102854870B CN 102854870 B CN102854870 B CN 102854870B CN 201210382072 A CN201210382072 A CN 201210382072A CN 102854870 B CN102854870 B CN 102854870B
- Authority
- CN
- China
- Prior art keywords
- data
- report
- field
- opc
- user
- 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.)
- Active
Links
Classifications
-
- 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
- Programmable Controllers (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a distributed control system and a data reporting generating method. The system comprises a field device, a data transmission network, a controller, a field bus, a system control server and a system database, wherein the system control server comprises a report generating tool which generates a user report of the distributed control system based on data in the system database. According to the technical scheme provided by the invention, real-time data in the production process can be processed in the distributed control system without a man-machine interaction interface, and the corresponding user data report can be generated automatically and periodically.
Description
The present invention requires applicant Shanghai industrial automation company limited of Siemens to be called the right of priority of the Chinese utility model patent application of " a kind of dcs " in the name of application on May 9th, 2012.
Technical field
The present invention relates to industrial automatic control field, particularly a kind of dcs and datagram table generating method.
Background technology
At a dcs (Distributed Control System without human-computer interaction interface, DCS) in, field apparatus is controlled by PLC or DCS program completely, or user is undertaken simple mutual by operator's console, real time data in process of production, or cumulative data etc. often can only complete by the mode of manual metering.This mode not only precision is not high, and real-time is bad, and has increased operating personnel's work load.
OPC refers to the open interface agreement in data communication.Although the SIMATIC NET OPC product component of Siemens Company can read the data in dcs by the mode of OPC, lack corresponding tool and utilize the data that OPC collects to complete report generation work.Visible, in prior art, need a kind of dcs badly, it can allow computing machine to the real time data in production run by certain mode, or cumulative data etc. files and calculate and generate corresponding form, and this process can periodically be completed automatically.
Summary of the invention
In view of this, the object of the invention is to propose a kind of dcs and datagram table generating method, make in the situation that not possessing interpersonal interactive interface, the real time data in production run to be processed, and periodically automatically generate corresponding user data form.
According to an aspect of the present invention, a kind of dcs is provided, described system comprises field apparatus, data transmission network, controller, fieldbus, system Control Server and system database, wherein, described system Control Server comprises report-building tool, and the data of described report-building tool based in described system database generate user's form of described dcs.
Preferably, described report-building tool comprises OPC service link block, user communication point designated module, data memory module and report generation module.
Preferably, described OPC service link block, for SIMATIC NET opc server being set by described fieldbus at described controller, and be connected with the Step7 control tool in described controller, make described controller read the field data in described field apparatus with OPC protocol mode, and collected field data is sent to described system Control Server;
Described user communication point designated module, for selecting the field equipment communication point for generating described user's form, this is by selecting corresponding field equipment communication address to realize, the set SIMATIC NET opc server of the mode of described report-building tool by address and described OPC service link block is realized and shaken hands, the data that the corresponding described field apparatus in selected address collects are using the data basis as follow-up generating report forms;
Described data memory module, for setting up an independent real-time data base at described system database, the field data of the described field apparatus that described SIMATIC NET opc server is gathered is stored in some cycles in the described real-time data base of described system database, as the data basis of follow-up generating report forms; And
Described report generation module, for the report form template and the data computation rule that arrange in advance according to user, based on the data of storing in described system database, periodically generates described user's form and exports described user's form, and with Excel formatted output.
Preferably, described report-building tool further comprises data backup module, and it derives the data in database preserve after generated data form.
Preferably, described controller is PLC.
Preferably, described fieldbus is Profibus bus or Profinet bus.
According to another aspect of the present invention, also provide a kind of in dcs the method for generated data form, described dcs comprises field apparatus, data transmission network, controller, fieldbus, system Control Server and system database, described system Control Server comprises a report-building tool, described report-building tool further comprises OPC service link block, user communication point designated module, data memory module and report generation module
Wherein, said method comprising the steps of:
Step 1: described OPC service link block arranges SIMATIC NETOPC server in described controller by described fieldbus, and is connected with the Step7 control tool in described controller;
Step 2: described user communication point designated module is selected the field equipment communication point for generating described data sheet, this is by selecting corresponding field equipment communication address to realize, the set SIMATIC NET opc server of the mode of described report-building tool by address and described OPC service link block is realized and shaken hands, the data that the corresponding described field apparatus in selected address collects are using the data basis as follow-up generating report forms;
Step 3: described controller, according to selected field equipment communication point, reads the field data in described field apparatus with OPC protocol mode, and collected field data is sent to described system Control Server;
Step 4: described data memory module is set up an independent real-time data base in described system database, the field data of the described field apparatus that described SIMATIC NET opc server is gathered is stored in some cycles in the described real-time data base of described system database, as the data basis of follow-up generating report forms; And
Step 5: report form template and data computation rule that described report generation module arranges in advance according to user, based on the data of storing in described system database, periodically generate described data sheet and export described data sheet, and with Excel formatted output.
Preferably, described report-building tool further comprises data backup module, and described method also comprises step 6 after step 5: described data backup module derives the data in described real-time data base preserve after generating described data sheet.
From such scheme, can find out, according to technical scheme of the present invention, can in the dcs that does not possess interpersonal interactive interface, process the real time data in production run, and periodically automatically generate corresponding user data form.
Brief description of the drawings
To, by describing the preferred embodiments of the present invention in detail with reference to accompanying drawing, the person of ordinary skill in the art is more clear that above-mentioned and other feature and advantage of the present invention below, in accompanying drawing:
Fig. 1 is the system construction drawing of dcs in the specific embodiment of the invention;
Fig. 2 is the structural drawing of report-building tool in the specific embodiment of the invention;
Fig. 3 is the operational flowchart of dcs generated data form in the concrete real-time mode of the present invention;
Fig. 4 uses the data sheet surface chart that in the specific embodiment of the invention, dcs generates.
Embodiment
For making the object, technical solutions and advantages of the present invention clearer, the present invention is described in more detail by the following examples.
Fig. 1 is the system construction drawing of dcs in the specific embodiment of the invention.
As shown in Figure 1, the dcs in the specific embodiment of the invention comprises multiple field apparatuss 1, data transmission network 2, controller 3, fieldbus 4, system Control Server 5 and system database 6.Multiple controllers 3 are distributed in industry spot, connect multiple field apparatuss 2 by data transmission network 2, and these field apparatuss 2 are controlled.Here, data transmission network 2 both can send to field apparatus 2 by the control command of controller 3, and the data transmission that also field apparatus 2 can be collected is to controller 3.Multiple controllers 3 are also connected with system Control Server 5 by fieldbus 4, the field data that this fieldbus 4 can collect controller 3 is sent to system Control Server 5, thereby carry out system-level data processing and control, also the order that user can be inputted in system Control Server 5 is sent to controller 3 simultaneously, thereby realizes the control to field apparatus 1.System Control Server 5 is connected with system database 6, and this system database is for storing gathered field data, as the basis of follow-up data processing.
In the dcs of embodiment, field apparatus 1 can comprise the various sensors of collection site data or carry out motor, the various actuating equipments etc. of control command.Data transmission network 2 comprises the network access devices such as the network switch, hub, netting twine.Controller 3 comprises the industrial control equipments such as PLC.Fieldbus 4 comprises Profibus bus or Profinet bus etc.System Control Server 5 can be realized by the PC as host computer or server, and system database 6 can build based on SQL Server database.
Described system Control Server 5 comprises a report-building tool 7, and this report-building tool 7 can generate based on the field data of storing in this system database 6 the various forms of dcs.Fig. 2 is the structural drawing of report-building tool in the specific embodiment of the invention.As shown in Figure 2, the report-building tool 7 in embodiment comprises OPC service link block 71, user communication point designated module 72, data memory module 73 and report generation module 74.
OPC service link block 71 arranges SIMATIC NET opc server in PLC controller 3 by fieldbus 4, and with controller 3 in control tool, as connections such as Step7, make PLC controller 3 to read the field data in field apparatus 1 with OPC protocol mode, and collected field data is sent to system Control Server 5.
The field equipment communication point that user communication point designated module 72 is selected for generated data form, this is by selecting corresponding field equipment communication address to realize, like this, the set opc server of the mode of report-building tool 7 by address and OPC service link block 71 is realized and being shaken hands, and the data that the corresponding field apparatus 1 in selected address collects are using the data basis as follow-up generating report forms.
Data memory module 73 is set up an independent real-time data base in system database 6, and the field data of the field apparatus of opc server collection 1 is stored in this real-time data base with some cycles, as the data basis of follow-up generating report forms.The foundation of this real-time data base can be stored separately the real time data of the form for generating, and makes report generation operation more fast.
Report form template and data computation rule that report generation module 74 arranges in advance according to user, based on the data of storing in real-time data base, periodically generated data form, and with formatted outputs such as Excel.Wherein, user can arrange report form template in advance according to demand, and comprising required data type and data display format, such as moment, curve map demonstration etc. occur for time period, maximal value, minimum value, mean value, data.Wherein, user can define computation rule according to desired data, for example, calculate maximal value, calculated minimum, calculating mean value etc.Certainly, user can also pre-define the cycle of report generation, such as per minute, per hour or every day etc.
Preferably, report-building tool 7 can also comprise a data backup module 75.This data backup module 75 derives the data in real-time data base preserve after generated data form, and its object is to improve the operational efficiency of real-time data base, can not lose again historical data simultaneously.
Fig. 3 is the operational flowchart of dcs generated data form in the concrete real-time mode of the present invention.Become the operating process of data sheet below with regard to the system architecture open-birth in conjunction with above-mentioned introduction.
S1: the OPC service link block 71 of report-building tool 7 arranges SIMATIC NET opc server in PLC controller 3 by network, and is connected with STEP7 instrument in controller 3.
S2: the field equipment communication point that the user communication point designated module 72 of report-building tool 7 is selected for generated data form, this is by selecting corresponding field equipment communication address to realize, and the data that the corresponding field apparatus 1 in selected address collects are using the data basis as follow-up generating report forms.
S3:PLC controller 3, according to selected field equipment communication point, reads the field data in field apparatus 1 with OPC protocol mode, and collected field data is sent to system Control Server 5.
S4: the data memory module 73 of report-building tool 7 by the field data of gathered field apparatus 1 with in some cycles storage real-time data base.
S5: data sheet template and data computation rule that the report generation module 74 of report-building tool 7 arranges in advance according to user, based on the data of storing in real-time data base, periodically generated data form, and with formatted outputs such as Excel.Fig. 4 shows one and uses the surface chart of the data sheet that the dcs of embodiment generates as example.
S6: the data backup module 75 of report-building tool 7 derives the data in real-time data base preserve after generated data form.
According to technical scheme of the present invention, can in the dcs that does not possess interpersonal interactive interface, process the real time data in production run, and periodically automatically generate corresponding user data form.
The foregoing is only preferred embodiment of the present invention, in order to limit the present invention, within the spirit and principles in the present invention not all, any amendment of doing, be equal to replacement, improvement etc., within all should being included in protection scope of the present invention.
Claims (6)
1. a dcs, comprise field apparatus (1), data transmission network (2), controller (3), fieldbus (4), system Control Server (5) and system database (6)
Wherein, described system Control Server (5) comprises report-building tool (7), the data of described report-building tool (7) based in described system database (6) generate user's form of described dcs, described report-building tool (7) comprises OPC service link block (71), user communication point designated module (72), data memory module (73) and report generation module (74), it is characterized in that
Described OPC service link block (71), for SIMATIC NET opc server being set by described fieldbus (4) at described controller (3), and be connected with the Step7 control tool in described controller (3), make described controller (3) read the field data in described field apparatus (1) with OPC protocol mode, and collected field data is sent to described system Control Server (5);
Described user communication point designated module (72), for selecting the field equipment communication point for generating described user's form, this is by selecting corresponding field equipment communication address to realize, the set SIMATIC NET opc server of the mode of described report-building tool (7) by address and described OPC service link block (71) is realized and shaken hands, the data that the corresponding described field apparatus in selected address (1) collects are using the data basis as follow-up generating report forms;
Described data memory module (73), for setting up an independent real-time data base at described system database (6), the field data of the described field apparatus (1) that described SIMATIC NET opc server is gathered is stored in some cycles in the described real-time data base of described system database (6), as the data basis of follow-up generating report forms; And
Described report generation module (74), for the report form template and the data computation rule that arrange in advance according to user, based on the data of storage in described system database (6), periodically generate described user's form and export described user's form, and with Excel formatted output.
2. dcs according to claim 1, it is characterized in that, described report-building tool (7) further comprises data backup module (75), and it derives the data in database preserve after generated data form.
3. dcs according to claim 1, is characterized in that, described controller (3) is PLC.
4. dcs according to claim 1, is characterized in that, described fieldbus (4) is Profibus bus or Profinet bus.
5. the method for a generated data form in dcs, it is characterized in that, described dcs comprises field apparatus (1), data transmission network (2), controller (3), fieldbus (4), system Control Server (5) and system database (6), described system Control Server (5) comprises a report-building tool (7), described report-building tool (7) further comprises OPC service link block (71), user communication point designated module (72), data memory module (73) and report generation module (74),
Wherein, said method comprising the steps of:
Step 1: described OPC service link block (71) arranges SIMATIC NET opc server in described controller (3) by described fieldbus (4), and is connected with the Step7 control tool in described controller (3);
Step 2: described user communication point designated module (72) is selected the field equipment communication point for generating described data sheet, this is by selecting corresponding field equipment communication address to realize, the set SIMATIC NET opc server of the mode of described report-building tool (7) by address and described OPC service link block (71) is realized and shaken hands, the data that the corresponding described field apparatus in selected address (1) collects are using the data basis as follow-up generating report forms;
Step 3: described controller (3) is according to selected field equipment communication point, read the field data in described field apparatus (1) with OPC protocol mode, and collected field data is sent to described system Control Server (5);
Step 4: described data memory module (73) is set up an independent real-time data base in described system database (6), the field data of the described field apparatus (1) that described SIMATIC NET opc server is gathered is stored in some cycles in the described real-time data base of described system database (6), as the data basis of follow-up generating report forms; And
Step 5: report form template and data computation rule that described report generation module (74) arranges in advance according to user, based on the data of storage in described system database (6), periodically generate described data sheet and export described data sheet, and with Excel formatted output.
6. method according to claim 5, it is characterized in that, described report-building tool (7) further comprises data backup module (75), and described method also comprises step 6 after step 5: described data backup module (75) derives the data in described real-time data base preserve after generating described data sheet.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210382072.8A CN102854870B (en) | 2012-05-09 | 2012-10-10 | Distributed control system and data report generating method |
Applications Claiming Priority (3)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201220205157.4 | 2012-05-09 | ||
| CN201220205157 | 2012-05-09 | ||
| CN201210382072.8A CN102854870B (en) | 2012-05-09 | 2012-10-10 | Distributed control system and data report generating method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN102854870A CN102854870A (en) | 2013-01-02 |
| CN102854870B true CN102854870B (en) | 2014-10-22 |
Family
ID=47401529
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201210382072.8A Active CN102854870B (en) | 2012-05-09 | 2012-10-10 | Distributed control system and data report generating method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102854870B (en) |
Families Citing this family (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103699557B (en) * | 2013-09-04 | 2017-10-10 | 中国四维测绘技术有限公司 | report processing method and system |
| CN103943452B (en) * | 2014-04-28 | 2016-04-27 | 南方科技大学 | A kind of process control method of plasma treatment and device |
| CN107506965A (en) * | 2017-08-26 | 2017-12-22 | 泰州星云动力有限公司 | A kind of BOM manages Core Generator |
| CN107566198B (en) * | 2017-10-27 | 2021-03-16 | 成都西加云杉科技有限公司 | Network equipment evaluation method and intelligent service management system |
| CN110412932A (en) * | 2018-04-27 | 2019-11-05 | 杭州诺云科技有限公司 | A kind of record system and method, Inversion System and the method for control process data |
| CN109240242A (en) * | 2018-10-24 | 2019-01-18 | 合肥中科离子医学技术装备有限公司 | Distributed superconducting magnet coil control system and its method for generating data sheet |
| CN110362567A (en) * | 2019-05-29 | 2019-10-22 | 武汉快快充通信技术有限公司 | A kind of the telephone expenses front-end platform and financial statement deriving method of distributed deployment |
| CN110555044A (en) * | 2019-09-06 | 2019-12-10 | 西门子工厂自动化工程有限公司 | Data processing method, programmable logic controller and data processing system |
| CN110850824A (en) * | 2019-11-12 | 2020-02-28 | 北京矿冶科技集团有限公司 | Implementation method for acquiring data of distributed control system to Hadoop platform |
| CN111459111A (en) * | 2020-04-13 | 2020-07-28 | 昱源宁海环保科技股份有限公司 | Application system of DCS in ceramsite production line |
| CN112667665A (en) * | 2020-12-31 | 2021-04-16 | 新奥数能科技有限公司 | Method and device for generating SCADA control system report and electronic equipment |
| CN113536753B (en) * | 2021-07-05 | 2024-05-14 | 无锡信捷电气股份有限公司 | Formula management system capable of being freely configured |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5390132A (en) * | 1991-12-09 | 1995-02-14 | Yokogawa Electric Corporation | Distributed control system having a control unit to detect and control interruption of transmission to and from remote input/output devices |
| CN101122793A (en) * | 2006-08-09 | 2008-02-13 | 临安微创网格信息工程有限公司 | Industrial production line embedded type main control system |
| CN102081358A (en) * | 2009-12-01 | 2011-06-01 | 爱默生过程管理电力和水解决方案公司 | Decentralized industrial process simulation system |
| CN102367742A (en) * | 2011-10-08 | 2012-03-07 | 北京华通伟业科技发展有限公司 | Monitoring system |
-
2012
- 2012-10-10 CN CN201210382072.8A patent/CN102854870B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5390132A (en) * | 1991-12-09 | 1995-02-14 | Yokogawa Electric Corporation | Distributed control system having a control unit to detect and control interruption of transmission to and from remote input/output devices |
| CN101122793A (en) * | 2006-08-09 | 2008-02-13 | 临安微创网格信息工程有限公司 | Industrial production line embedded type main control system |
| CN102081358A (en) * | 2009-12-01 | 2011-06-01 | 爱默生过程管理电力和水解决方案公司 | Decentralized industrial process simulation system |
| DE102010060924A1 (en) * | 2009-12-01 | 2011-06-09 | Emerson Process Management Power & Water Solutions, Inc. | Improved distributed industrial process simulation system |
| CN102367742A (en) * | 2011-10-08 | 2012-03-07 | 北京华通伟业科技发展有限公司 | Monitoring system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102854870A (en) | 2013-01-02 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102854870B (en) | Distributed control system and data report generating method | |
| JP7037204B2 (en) | Smart factory monitoring methods and systems | |
| Xu | Machine Tool 4.0 for the new era of manufacturing | |
| CN102880149B (en) | A kind of dcs and user data report form generation method | |
| CN109933035A (en) | A kind of production line control system, method and the production system twin based on number | |
| JP2020518079A (en) | Smart factory parallel control method and system | |
| CN107363812A (en) | The sixdegree-of-freedom simulation teaching system of controlled in wireless | |
| CN101984376B (en) | Fault simulation device of numerical control machine | |
| US20130096695A1 (en) | Method for configuring a control device | |
| CN203204395U (en) | DCS (distributed control system) experiment platform used for process control research by using semi-physical simulation technology | |
| CN103034171B (en) | The kinetic control system of open type flexible digital control system | |
| JP2017207830A (en) | Information processing device which processes processing information between a plurality of manufacturing cells | |
| CN104875204A (en) | Offline programming module and application method of plasma space cutting robot | |
| CN103905410A (en) | Multi-channel communication protocol converter capable of converting user-defined protocol to Modbus protocol | |
| CN103135536A (en) | Data collection system (DCS) and information processing method of computer production simulation model | |
| CN103533099A (en) | Variable-frequency drive and address mapping method thereof under MODBUS communication protocol | |
| CN104615105A (en) | Simulation teaching system for petrochemical industry | |
| CN106094775A (en) | A kind of cutting production line long distance control system | |
| CN101234287A (en) | Flue gas process control system using semi-dry process desulfurization defluorination | |
| CN112055047A (en) | Data communication method based on publishing and subscribing for intelligent coal-fired power plant | |
| CN108154297A (en) | A kind of factory management system and information processing method | |
| CN112784427B (en) | Intelligent manufacturing simulation system based on digital twin technology | |
| Sun et al. | Open cnc system design for multiple intelligent functions based on twincat and. net framework | |
| CN106125676A (en) | A kind of robot control system | |
| CN102520658A (en) | Industrial human-computer interface configuration system and variable monitoring method thereof |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| C41 | Transfer of patent application or patent right or utility model | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20151029 Address after: 100016 Beijing, Jiuxianqiao, East Chaoyang District Road, building No. 9, building A1, layer 8 Patentee after: Siemens Factory Automation Engineering Co., Ltd. Address before: 200030, 22-25 floor, Xuhui yuan building, 1089 south two road, Shanghai, Zhongshan Patentee before: Siemens Industrial Automation Ltd., Shanghai |