CN111212093A - Data processing system and control device - Google Patents
Data processing system and control device Download PDFInfo
- Publication number
- CN111212093A CN111212093A CN202010145762.6A CN202010145762A CN111212093A CN 111212093 A CN111212093 A CN 111212093A CN 202010145762 A CN202010145762 A CN 202010145762A CN 111212093 A CN111212093 A CN 111212093A
- Authority
- CN
- China
- Prior art keywords
- data
- server
- real
- control unit
- processing system
- 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
Images
Classifications
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L63/00—Network architectures or network communication protocols for network security
- H04L63/08—Network architectures or network communication protocols for network security for authentication of entities
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L63/00—Network architectures or network communication protocols for network security
- H04L63/02—Network architectures or network communication protocols for network security for separating internal from external traffic, e.g. firewalls
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L67/00—Network arrangements or protocols for supporting network services or applications
- H04L67/01—Protocols
- H04L67/02—Protocols based on web technology, e.g. hypertext transfer protocol [HTTP]
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L67/00—Network arrangements or protocols for supporting network services or applications
- H04L67/01—Protocols
- H04L67/12—Protocols specially adapted for proprietary or special-purpose networking environments, e.g. medical networks, sensor networks, networks in vehicles or remote metering networks
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L67/00—Network arrangements or protocols for supporting network services or applications
- H04L67/14—Session management
- H04L67/141—Setup of application sessions
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L67/00—Network arrangements or protocols for supporting network services or applications
- H04L67/50—Network services
- H04L67/52—Network services specially adapted for the location of the user terminal
Landscapes
- Engineering & Computer Science (AREA)
- Computer Networks & Wireless Communication (AREA)
- Signal Processing (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Computing Systems (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Computer Security & Cryptography (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Computer Hardware Design (AREA)
- Health & Medical Sciences (AREA)
- General Health & Medical Sciences (AREA)
- Medical Informatics (AREA)
- Computer And Data Communications (AREA)
Abstract
本公开提供了一种数据处理系统及控制设备，涉及工业控制技术领域，所述数据处理系统包括：分散控制单元以及综合保护单元；第一服务器，用于通过通信协议对客户端以及所述分散控制单元建立通信连接，并接收来自所述分散控制单元的数据；数据采集器，用于从所述第一服务器采集所述分散控制单元的数据并将所述数据存储至实时数据库中；所述实时数据库，用于存储所述数据采集器获取的数据；第二服务器；查询服务器，其上安装有链接服务器，用于接收访问请求，通过所述链接服务器访问所述实时数据库，并对所述实时数据库中的数据进行预处理，以将预处理后的数据存储至目标数据库。本公开能够提高数据处理的准确性和及时性。
The present disclosure provides a data processing system and control device, which relate to the technical field of industrial control. The data processing system includes: a distributed control unit and a comprehensive protection unit; The control unit establishes a communication connection and receives data from the distributed control unit; a data collector is used to collect the data of the distributed control unit from the first server and store the data in a real-time database; the a real-time database for storing the data acquired by the data collector; a second server; a query server, on which a link server is installed, for receiving access requests, accessing the real-time database through the link server, and providing access to the real-time database through the link server The data in the real-time database is preprocessed to store the preprocessed data in the target database. The present disclosure can improve the accuracy and timeliness of data processing.
Description
Technical Field
The disclosure relates to the technical field of industrial control, in particular to a data processing system and control equipment.
Background
In order to ensure the safety of the data, the data in the production process is generally processed manually.
In the related art, a dedicated interface may be provided. In this way, since a dedicated interface requires one device to configure one interface, the deployment process is complicated and the cost is high, and the actual requirements cannot be met. Besides, in the related art, the query can be performed in the operation room or the master control room, but the operation room generally does not allow to connect with an external computer network, and does not allow to transmit through a data copying device, so that the efficiency is low, the data is not consistent, the real-time performance is poor, the data processing efficiency is low, and the data cannot be processed in time when a fault occurs. In addition, the collected data is relatively cluttered and not easy to analyze, and therefore, the efficiency is low.
It is to be noted that the information disclosed in the above background section is only for enhancement of understanding of the background of the present disclosure, and thus may include information that does not constitute prior art known to those of ordinary skill in the art.
Disclosure of Invention
An object of the present disclosure is to provide a data processing system and a control device, which overcome, at least to some extent, the problems of untimely data acquisition and low efficiency due to the limitations and disadvantages of the related art.
Additional features and advantages of the disclosure will be set forth in the detailed description which follows, or in part will be obvious from the description, or may be learned by practice of the disclosure.
According to an aspect of the present disclosure, there is provided a data processing system comprising:
a distributed control unit and a comprehensive protection unit;
the system comprises a first server, a distributed control unit and a second server, wherein the first server is used for establishing communication connection between a client and the distributed control unit through a communication protocol and receiving data from the distributed control unit;
the data acquisition unit is arranged on the client and used for acquiring the data of the distributed control unit from the first server and storing the data into a real-time database;
the real-time database is in communication connection with the data acquisition unit and is used for storing the data acquired by the data acquisition unit;
the second server is in communication connection with the comprehensive protection unit and is used for transmitting the data of the comprehensive protection unit to the real-time database;
and the query server is provided with a link server and used for receiving an access request, accessing the real-time database through the link server and preprocessing data in the real-time database so as to store the preprocessed data in a target database.
In an exemplary embodiment of the present disclosure, the data collector includes:
and the timing acquisition unit is used for acquiring data of the plurality of distributed control units at a first time in a timing mode through the access path.
In an exemplary embodiment of the present disclosure, the access path is determined according to an access identifier and location information of the data collector.
In an exemplary embodiment of the present disclosure, the data collector is a thermometer.
In an exemplary embodiment of the present disclosure, the first server includes:
and the protocol configuration unit is used for configuring the communication protocol for the first server and inquiring data of all the distributed control units from the data acquisition unit through the communication protocol.
In an exemplary embodiment of the present disclosure, the query server includes:
and the access control unit is used for accessing the data of the real-time database through the link server configured in the query server.
In an exemplary embodiment of the present disclosure, the access control unit includes:
and the path determining module is used for determining the address identifier of the real-time database and connecting the address identifier through the link server so as to access the real-time database.
In an exemplary embodiment of the present disclosure, the access control unit includes:
and the data storage unit is used for storing the data in the data acquisition unit to a target database through a timing task.
In an exemplary embodiment of the present disclosure, the data processing system further includes:
an application unit;
and the management and control unit is used for acquiring the data from the target database and carrying out preset operation on the data.
According to an aspect of the present disclosure, there is provided a control apparatus including:
a processor;
a memory; and
a data processing system as claimed in any preceding claim.
In the data processing system and the control device provided in the exemplary embodiment, on one hand, the first server is configured to realize remote access between the query server and the distributed control unit, and the link server accesses the real-time database for storing the data of the distributed control unit, so that a process of manually acquiring data or acquiring data only through a fixed area can be avoided, and the efficiency and convenience of data acquisition are improved. On the other hand, the data of the distributed control unit and the comprehensive protection unit collected by the data collector can be read in the real-time database through remote access, so that the problem that an external network or a copying device cannot be used in the related technology is solved, the data safety is improved, meanwhile, the data can be timely and conveniently collected, the application range is enlarged, the timeliness and the reliability of data processing are improved on the basis, the occurrence of faults can be avoided, and abnormal conditions can be timely solved. On the other hand, the data stored in the real-time database can be preprocessed through the query server, so that the problem that the data are messy and difficult to analyze is avoided, and the data processing efficiency is improved.
It is to be understood that both the foregoing general description and the following detailed description are exemplary and explanatory only and are not restrictive of the disclosure.
Drawings
The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the present disclosure and together with the description, serve to explain the principles of the disclosure. It is to be understood that the drawings in the following description are merely exemplary of the disclosure, and that other drawings may be derived from those drawings by one of ordinary skill in the art without the exercise of inventive faculty.
FIG. 1 schematically shows a block diagram of a data processing system in an exemplary embodiment of the disclosure.
Fig. 2 schematically shows a specific structural diagram of a data processing system in an exemplary embodiment of the present disclosure.
Fig. 3 schematically shows a block diagram of a control device in an exemplary embodiment of the present disclosure.
Detailed Description
Example embodiments will now be described more fully with reference to the accompanying drawings. Example embodiments may, however, be embodied in many different forms and should not be construed as limited to the examples set forth herein; rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the concept of example embodiments to those skilled in the art. The described features, structures, or characteristics may be combined in any suitable manner in one or more embodiments. In the following description, numerous specific details are provided to give a thorough understanding of embodiments of the disclosure. One skilled in the relevant art will recognize, however, that the subject matter of the present disclosure can be practiced without one or more of the specific details, or with other methods, components, devices, steps, and the like. In other instances, well-known technical solutions have not been shown or described in detail to avoid obscuring aspects of the present disclosure.
Furthermore, the drawings are merely schematic illustrations of the present disclosure and are not necessarily drawn to scale. The same reference numerals in the drawings denote the same or similar parts, and thus their repetitive description will be omitted. Some of the block diagrams shown in the figures are functional entities and do not necessarily correspond to physically or logically separate entities. These functional entities may be implemented in the form of software, or in one or more hardware modules or integrated circuits, or in different networks and/or processor devices and/or microcontroller devices.
The terms "the" and "said" are used to indicate the presence of one or more elements/components/etc.; the term "comprising" is used in an open-ended inclusive sense and means that there may be additional elements/components/etc. other than the listed elements/components/etc. The terms "first," "second," and "third" are used merely as labels, and are not limiting as to the number of their objects.
The embodiment of the present disclosure first provides a data processing system, which can process any application scenario, such as a production shop, where data cannot be collected in time. Next, referring to fig. 1, a data processing system 100 in the present exemplary embodiment mainly includes the following parts:
a distributed control unit 110 and an integrated protection unit 120;
a first server 130, configured to establish a communication connection between a client and the distributed control unit through a communication protocol, and receive data from the distributed control unit;
the data acquisition unit 140 is arranged on the client and used for acquiring the data of the distributed control unit from the first server and storing the data into a real-time database;
the real-time database 150 is in communication connection with the data acquisition unit and is used for storing the data acquired by the data acquisition unit;
the second server 160 is in communication connection with the comprehensive protection unit and is used for transmitting the data of the comprehensive protection unit to the real-time database;
and the query server 170 is provided with a link server and is used for receiving an access request, accessing the real-time database through the link server, and preprocessing data in the real-time database to store the preprocessed data in a target database.
In the technical scheme provided by the embodiment of the disclosure, on one hand, remote access between the client and the distributed control unit is realized by configuring the first server, and the real-time database for storing data is accessed by linking the server, so that the process of manually acquiring data can be avoided, the efficiency and convenience of data acquisition are improved, the complexity of deployment is reduced, and the cost is reduced. On the other hand, the data of the distributed control unit and the comprehensive protection unit collected by the data collector can be read in the real-time database through remote access, so that the problem that an external network or a copying device cannot be used in the related technology is solved, the data safety is improved, meanwhile, the data can be timely and conveniently collected, the application range is enlarged, the timeliness and the reliability of data processing are improved on the basis, the occurrence of faults can be avoided, and abnormal conditions can be timely solved. On the other hand, the data stored in the real-time database can be preprocessed through the query server, so that the problem that the data are messy and difficult to analyze is avoided, and the data processing efficiency is improved.
Next, a data processing system in an embodiment of the present disclosure will be described in detail with reference to the drawings.
First, the data processing system 100 includes a distributed control unit 110 and an integrated protection unit 120.
In an embodiment of the present disclosure, the operation of a data processing system for processing data in a factory floor involves two parts: one part is a distributed control unit, the other part is a comprehensive protection unit, the two units can be respectively used as subsystems to form a data processing system, and the two units belong to different types of systems with different functions. The distributed control unit may represent a DCS (distributed control system) control station, and the distributed control unit may be used to collect production data. The distributed control unit is an instrument control system which is based on a microprocessor and adopts a design principle of distributed control functions, centralized display operation, and consideration of branch and autonomous and comprehensive coordination. In the embodiment of the present disclosure, the distributed control unit may include a distributed engineer station and a plurality of distributed operation stations. The decentralized operation station is used for displaying and recording process data from each control unit, and is an operation interface for users to interact with production process information. The decentralized operating station comprises a host system, a display device, a keyboard input device, an information storage device, a printing output device and the like, and mainly realizes powerful display functions (such as simulation parameter display, system state display, various picture display and the like), an alarm function, an operation function, a report printing function, a configuration function, a programming function and the like. The decentralized operating station mainly realizes general production operation and monitoring tasks and has the functions of data acquisition and processing, monitoring picture display, fault diagnosis, alarm and the like. The distributed engineer station has functions such as configuration of the system and modification of the control target in addition to the general functions of the distributed operation station.
The integrated protection unit 120 may be another system, which represents a total power reduction part, and is mainly used for acquiring power related data, i.e. the data collected thereon is different from the data of the distributed control units.
A first server 130, configured to establish a communication connection with a client and the distributed control unit through a communication protocol, and receive data from the distributed control unit.
In this embodiment of the present disclosure, the first server may be a reconfigured server, and specifically may correspond to the client. The first server in the embodiments of the present disclosure may be a server for establishing a remote connection and a remote communication, and may be an OPC server, for example. The data may be confidential data generated in real time during production.
The OPC server provides a channel standard for realizing real-time data transmission between different applications (even between applications on different workstations connected through a network); the format of the transmission and exchange in the channel is also defined for the needs of process control. The architecture of the OPC standard is a client/server model, i.e., software is divided into OPC servers and OPC clients. The OPC server provides an OPC data access standard interface; the OPC client accesses OPC data through the standard interface.
The OPC server effectively separates the hardware and application software, requiring only a set of software components to be provided, which can be used by all OPC clients, without the need for repeated development of drivers. Once the hardware is upgraded, only the I/O interface part of the OPC server end needs to be modified, and the client program does not need to be modified. Secondly, only one set of OPC interface is developed, and then the access operation can be carried out on the equipment of different hardware manufacturers in a unified mode.
After installing the first server, a communication protocol may be configured for the first server, where the communication protocol may be a DCOM (Distributed Component Object Model) communication protocol. The communication protocol is a program interface by which a client program object can request a server program object from another computer in the network. Under the control of the communication protocol, the parameters of the data collector read by the distributed control unit can be inquired in real time on the first server through configuration software corresponding to the OPC server.
The process of configuring the communication protocol may be as follows: setting the authentication level of the client, the security access authority, the activation mode, the configuration authority and the like. Specifically, dcomcfg is input to enter a DCOM configuration program in the WINDOWS operation, the DCOM configuration at the server needs to set the computer default identity authentication level to be 'none', and the setting bits of the remote and local access permissions of ANONYMOUS LOGON, Everyone, Guests, INTERACTIVE, NETWORKK and SYSTEM are allowed in the 'COM security access permission' setting; in the setting of COM safe starting and activating authority, local starting, remote starting, local activating and remote activating of ANONYMOUS LOGON, Everyone, Guests, INTERACTIVE, NETWORKK and SYSTEM are set to be allowed. Under the component service-my computer-DCOM configuration directory, OpcEnum is selected and its authentication level is set to none. The settings of "start and activation limits" and "access limits" are set in the security page as default values. The 'configuration permission' is self-defined: and newly adding users ANONYMOUS LOGON, Everyone, Guests, INTERACTIVE, NETWORKK and SYSTEM, setting parameters of 'full control' and 'reading' as allowed, and setting the OPC Server in the same way. And setting the local security policy as 'classic' and configuring the firewall attribute, namely completing the server-side configuration of the DCOM.
After the first server is configured, the first server can acquire the production data acquired by the distributed control unit through the communication connection between the first server and the distributed control unit.
And the data collector 140 is arranged on the client and is used for collecting the data of the distributed control unit from the first server and storing the data into a real-time database.
In the embodiment of the present disclosure, the client may be an OPC client, and specifically may correspond to the first server. The data collector can be deployed on the client to collect the production data collected by the engineering stations and each decentralized operation station in the decentralized control unit from the first server through the data collector. The data collector may be a collector using various types of data, the data types may include, for example, temperature, humidity, size, and the like, and the data types are different, and the types of the corresponding data collectors are also different. In an embodiment of the disclosure, the data collector may be a thermometer for collecting the temperature of the distributed control unit from the first server. Specifically, a thermometer can be arranged, the thermometer is connected into a DCS cabinet through 4-20mA hard wiring, and data scanning is carried out by taking 2 seconds as a period. After the data is collected, the collected data can be stored in a real-time database, and the real-time database can correspond to the data collector.
When the data acquisition unit is set, the access path can be determined according to the data acquisition unit. The access path here can be determined according to the access identifier and the position information of the data collector. The access identifier may be a computer number of the first server. The location information of the data collector may include a station number of the data collector and a bit number of the data collector. The station number refers to the number of the distributed control stations deployed by the data acquisition unit so as to determine which data of the distributed control stations are acquired; the bit number is used to indicate the number of the data collector, so that one data collector is uniquely indicated by the bit number, thereby facilitating distinction. Through setting up first server for the data that the customer end can directly acquire the decentralized control unit have avoided can only through the artifical problem of gathering in the workshop, through dispose first server in data processing system, can realize the remote data access ability of high performance, thereby make the data exchange between the industrial control software convenient and fast more. The first server based on the COM/DCOM protocol provides possibility for software and hardware equipment communication and interactive access of different industrial automatic controls.
And the real-time database 150 is in communication connection with the data collector and is used for storing the data acquired by the data collector.
In the disclosed embodiment, the real-time database may be used for data sharing, with which each executing code exchanges data for storing information about collected production data, control outputs, intermediate results of certain calculations, control algorithm structures, and the like. The real-time database is the most basic information resource of the DCS, and the real-time data is stored and managed by the real-time database. In DCS, a database file may be generated by using general database tool software, and the system directly manages the data format or converts the generated data file into a format required by DCS by using some method. In the embodiment of the disclosure, the real-time database is used for storing the real-time data collected by the data collector from each operation station in the distributed control unit. The real-time database may also store data from the integrated protection unit. The data of the integrated protection unit may be transmitted by the second server, the integrated protection unit being independent from the distributed control unit.
And the second server 160 is in communication connection with the comprehensive protection unit and is used for transmitting the data of the comprehensive protection unit to the real-time database.
In the embodiment of the present disclosure, the second server may also be any one of OPC servers, and specifically may be the same as or different from the first server in type, but has similar functions. The second server can be configured with a serial communication protocol, and is simple and easy to control, deploy and maintain. For the second server, the second server may be configured to establish a communication connection between the integrated protection unit and the upper computer, and directly transmit the power-related data to the real-time database for storage.
And the query server 170 is provided with a link server and is used for receiving an access request, accessing the real-time database through the link server, and preprocessing data in the real-time database to store the preprocessed data in a target database.
In the embodiment of the present disclosure, the query server refers to a server for performing an access function, and may be equivalent to an externally deployed server. In order to realize the functions of accessing and querying the confidential data by the query server, a link server can be deployed on the query server for real-time access through the link server.
The process of configuring the link server in the query server may include: in query server management software, a link server named 'A' is newly established, and the type of the link server is 'other data sources'; the access interface is set to 'AAAOLE DB Provider'; the product name is AAA; the IP address is the IP address of the real-time database server. After the link server is configured successfully, all data of each table in the real-time database can be seen. By configuring the link server in the query server, the real-time database can be accessed by a method of establishing a link connection server so as to acquire data.
After configuring the link server for the query server, the data may be read from the real-time database timing. Specifically, a timing task is set in the query server, and the whole point data of the data acquisition unit, which is six points earlier each day, is stored in the target database. The target database can be displayed in a data table form, and the table corresponding to the target database can store data by taking the storage time and the data collector bit number ID as main keys. The timing task part of the database can be realized by the following codes:
as can be seen from the above, the bit number address, the recording time, and the currently measured real-time value of the data collector may be selected from the operation result of the OpenQuery () function and inserted into the temporary recording table dcs _ temp that temporarily stores all bit number data information, and the query server may directly access the values of other types of databases through the OpenQuery () function.
The timing task reading data can also be realized by the following codes:
in this segment of code, the function CONVERT () obtains the current date in the form of the string '20 XX-XX', and adds a segment of the time-representative string '06:00:00' to the end to obtain a string representing the time six hours earlier in the day. At this time, the data of the thermometer at six points earlier each day is automatically stored in a preset data table in a target database (relational database), the name of the preset data table may be mw _ production _ date, and fields in the preset data table include: time, ID, and measurement.
In addition, the data may be pre-processed by querying the server. The pretreatment process may be: through SQL sentences, preprocessing and analysis are carried out every day or every hour and then the data are stored in a target database, so that reports, important parameter historical trends and the like can be made by using the data, the labor hour is greatly saved, and the data acquisition interval is more flexible. The preprocessing may include, for example, data cleaning, data filtering, data sorting, and the like, and is not limited herein. The data may be acquired from the real-time database and then preprocessed, or the data of the real-time database may be preprocessed and then acquired, where the processing sequence is not limited.
In addition, on the basis of fig. 1, the data processing system may further include: the device comprises an application unit and a management and control unit. The application unit can be a Web application; the management and control unit may be a production management and control platform, and may be configured to acquire data from a target database, so as to perform a preset operation on the acquired data. The preset operation may be an operation of generating a graph, or generating a trend graph, or performing reprocessing such as calculation. The preset operation may be implemented by a production management and control platform, and a result of executing the preset operation may be displayed on the production management and control platform.
Further, an access link for querying the database may be established, and a server data set for reading data in the preset data table mw _ production _ date may be newly created to read the data of the target database, at which time the temperature measurement values at six points per day recorded by the table may be derived, so as to facilitate calculation of various requirements or generate a chart.
In the embodiment of the disclosure, if an access request is received, an access connection between the query server and the real-time database can be established in response to the access request, the query server periodically reads data from the distributed control unit periodically acquired from the first server by the data acquisition unit from the real-time database through the deployed link server, obtains data of the comprehensive protection unit read by the second server from the real-time database, and stores the data into the preset data table of the target database, so that the accuracy and efficiency of data acquisition are improved. Remote access of DCS industrial control data is realized by configuring a first server based on a DCOM protocol, and then required measuring point real-time data is stored in a real-time database by a data acquisition unit. The real-time database is accessed through a link server of the query server, and data in the real-time database is preprocessed by a timing task and then stored in the relational database through a query code compiling and analyzing method. And reading the production parameters and other information in the relational database by report making software to make a production report for production scheduling and decision making. Since remote access and remote connection between the decentralized control unit and the query server are realized by the first server and the linking server. All data in the production process of the decentralized control unit can be read in real time while data safety is guaranteed, timeliness is improved, and data reading efficiency and convenience are improved.
A detailed block diagram of a data processing system 200 is schematically shown in fig. 2, and with reference to the diagram in fig. 2, mainly includes the following parts:
the distributed control station 201, i.e., a distributed control unit, in which a first server 2011 may be provided, may include a distributed engineer station 2012 and a plurality of distributed operation stations 2013. The first server 2011 may be used to obtain data from distributed control stations, i.e., to obtain production data.
And the integrated protection unit 202 is configured to transmit data to the real-time database 206 through the second server 205 under the control of the communication protocol.
A client 203, on which a data collector 204 may be disposed, may be configured to collect production data from the first server via the access path and transmit the data to the real-time database 206 under control of the communication protocol.
And the query server 207 is provided with a link server 208, and accesses the address identifier set for the real-time database through the link server so as to obtain data from the real-time database through the address identifier for preprocessing and store the preprocessed data into the target database.
The manufacturing execution system 209, i.e., the MES system, has a production management and control platform 210 disposed thereon for obtaining data from the target database and performing preset operations thereon.
And a control 211, configured to obtain data collected by the second server from the real-time database. The webspace with the remote monitoring function can be monitored and embedded into a control by using a web browser, the control actually provides the same function as a complete terminal service client, and the function can be realized even if the client is not installed.
And an application 212 for interfacing with the manufacturing execution system and the control through the intranet switch and the firewall. The application may be a Web application, which may be run with the help of a browser. Web applications are typically B/S mode.
With the data processing system shown in fig. 2, manual copying of instrument data is not required, so that labor cost is greatly saved and working efficiency is improved. The obtained data is more complete and coherent. The production safety and the data safety coefficient are improved. The automatically generated data reports can better assist in decision making. The distributed control unit and the server are connected into a network to realize mutual communication and access of data by setting a communication protocol, the real-time database is driven to carry out real-time acquisition and screening on a plurality of DCS, the data in the database is automatically updated, and the DCS control data is remotely acquired to the real-time database in real time through the computer network, so that the monitoring of field operation is achieved, and a foundation is provided for reasonably arranging production and timely finding out operation faults.
A block diagram of a control device 300 is schematically shown in fig. 3, and with reference to what is shown in fig. 3, mainly comprises: a processor 310, a memory 320, and a data processing system 100. The control device may be various industrial devices in various fields, such as industrial devices, mechanical devices, electronic devices, and the like, and may be, for example, an electric welding device. In the embodiment of the disclosure, after the production data collected by the decentralized control station is transmitted to the OPC server, the production data is read and stored in the real-time database by the data collector installed in the real-time database, and is stored in the target database after being preprocessed and analyzed every day or every hour by the SQL statements, so that the data stored in the target database can be used to make reports, important parameter historical trends, and the like, thereby saving labor, making the data collection interval more flexible, and making the working performance of the control device more stable.
Furthermore, the above-described figures are merely schematic illustrations of processes involved in methods according to exemplary embodiments of the invention, and are not intended to be limiting. It will be readily understood that the processes shown in the above figures are not intended to indicate or limit the chronological order of the processes. In addition, it is also readily understood that these processes may be performed synchronously or asynchronously, e.g., in multiple modules.
Other embodiments of the disclosure will be apparent to those skilled in the art from consideration of the specification and practice of the disclosure disclosed herein. This application is intended to cover any variations, uses, or adaptations of the disclosure following, in general, the principles of the disclosure and including such departures from the present disclosure as come within known or customary practice within the art to which the disclosure pertains. It is intended that the specification and examples be considered as exemplary only, with a true scope and spirit of the disclosure being indicated by the following claims.
Claims (10)
1. A data processing system, comprising:
a distributed control unit and a comprehensive protection unit;
the system comprises a first server, a distributed control unit and a second server, wherein the first server is used for establishing communication connection between a client and the distributed control unit through a communication protocol and receiving data from the distributed control unit;
the data acquisition unit is arranged on the client and used for acquiring the data of the distributed control unit from the first server and storing the data into a real-time database;
the real-time database is in communication connection with the data acquisition unit and is used for storing the data acquired by the data acquisition unit;
the second server is in communication connection with the comprehensive protection unit and is used for transmitting the data of the comprehensive protection unit to the real-time database;
and the query server is provided with a link server and used for receiving an access request, accessing the real-time database through the link server and preprocessing data in the real-time database so as to store the preprocessed data in a target database.
2. The data processing system of claim 1, wherein the data collector comprises:
and the timing acquisition unit is used for acquiring data of the plurality of distributed control units at a first time in a timing mode through the access path.
3. The data processing system of claim 2, wherein the access path is determined according to an access identifier and location information of the data collector.
4. A data processing system according to claim 1 or 2, wherein the data collector is a thermometer.
5. The data processing system of claim 1, wherein the first server comprises:
and the protocol configuration unit is used for configuring the communication protocol for the first server and inquiring data of all the distributed control units from the data acquisition unit through the communication protocol.
6. The data processing system of claim 1, wherein the query server comprises:
and the access control unit is used for accessing the data of the real-time database through the link server configured in the query server.
7. The data processing system of claim 6, wherein the access control unit comprises:
and the path determining module is used for determining the address identifier of the real-time database and connecting the address identifier through the link server so as to access the real-time database.
8. The data processing system of claim 6, wherein the access control unit comprises:
and the data storage unit is used for storing the data in the data acquisition unit to a target database through a timing task.
9. The data processing system of claim 1, further comprising:
an application unit;
and the management and control unit is used for acquiring the data from the target database and carrying out preset operation on the data.
10. A control apparatus, characterized by comprising:
a processor;
a memory; and
a data processing system as claimed in any one of claims 1 to 9.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010145762.6A CN111212093A (en) | 2020-03-05 | 2020-03-05 | Data processing system and control device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010145762.6A CN111212093A (en) | 2020-03-05 | 2020-03-05 | Data processing system and control device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111212093A true CN111212093A (en) | 2020-05-29 |
Family
ID=70789860
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010145762.6A Pending CN111212093A (en) | 2020-03-05 | 2020-03-05 | Data processing system and control device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111212093A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111747134A (en) * | 2020-07-14 | 2020-10-09 | 界首市鑫华装璜彩印有限公司 | A decentralized control system for wrapping paper loads |
| CN116708030A (en) * | 2023-08-04 | 2023-09-05 | 浙江大学 | Industrial edge computing gateway and its protocol traffic monitoring method and device |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| KR20130026548A (en) * | 2011-07-22 | 2013-03-14 | 한국산업기술대학교산학협력단 | Integration control system having a common use interface |
| CN103135529A (en) * | 2013-01-29 | 2013-06-05 | 浙江大学 | Energy management system and energy management method |
| CN107291058A (en) * | 2017-08-01 | 2017-10-24 | 西安交通大学 | A kind of continuous casting production process data acquisition monitoring system |
| CN210724868U (en) * | 2020-03-05 | 2020-06-09 | 中国恩菲工程技术有限公司 | Data processing system and control device |
-
2020
- 2020-03-05 CN CN202010145762.6A patent/CN111212093A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| KR20130026548A (en) * | 2011-07-22 | 2013-03-14 | 한국산업기술대학교산학협력단 | Integration control system having a common use interface |
| CN103135529A (en) * | 2013-01-29 | 2013-06-05 | 浙江大学 | Energy management system and energy management method |
| CN107291058A (en) * | 2017-08-01 | 2017-10-24 | 西安交通大学 | A kind of continuous casting production process data acquisition monitoring system |
| CN210724868U (en) * | 2020-03-05 | 2020-06-09 | 中国恩菲工程技术有限公司 | Data processing system and control device |
Non-Patent Citations (1)
| Title |
|---|
| 张为民;马杰;: "生产设备实时数据远程监测研究与实现", 计算机应用与软件, no. 09, 12 September 2018 (2018-09-12) * |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111747134A (en) * | 2020-07-14 | 2020-10-09 | 界首市鑫华装璜彩印有限公司 | A decentralized control system for wrapping paper loads |
| CN111747134B (en) * | 2020-07-14 | 2021-09-21 | 界首市鑫华装璜彩印有限公司 | A decentralized control system for wrapping paper loads |
| CN116708030A (en) * | 2023-08-04 | 2023-09-05 | 浙江大学 | Industrial edge computing gateway and its protocol traffic monitoring method and device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107390636B (en) | Operation monitoring method, maintenance method and system for numerical control equipment | |
| US9400867B2 (en) | Method and system for monitoring and reporting equipment operating conditions and diagnostic information | |
| CN107682404B (en) | Remote control system and control method for multi-protocol environmental test equipment | |
| JP2021022150A (en) | Data format preparing device, edge server, and data format preparing method | |
| CN210724868U (en) | Data processing system and control device | |
| CN112995327A (en) | Cloud platform system, factory end, industrial cloud platform and service docking system | |
| CN114077633A (en) | Multi-source heterogeneous numerical control system monitoring server based on OPC UA | |
| CN111212093A (en) | Data processing system and control device | |
| CN111968356A (en) | Intelligent building energy consumption monitoring system and method | |
| CN109392192B (en) | Method and system for device connection of SCADA system for fast communication | |
| CN116774645A (en) | Method, device, medium and equipment for associating equipment object model with entity equipment | |
| JP2018072958A (en) | Data providing device and data providing method | |
| WO2015064427A1 (en) | Information collection system | |
| CN119419954A (en) | A distribution network symbiosis simulation system and method based on digital twin | |
| CN108200062B (en) | Data management method and system for intelligent instrument equipment | |
| CN113348778B (en) | Generalized satellite comprehensive test system based on DDS system | |
| CN110855757A (en) | Soft start equipment management system and method based on cloud service | |
| CN117632182A (en) | Software updating method and device for star service computer, electronic equipment and storage medium | |
| CN117633967A (en) | Digital virtual factory construction system | |
| CN113315769B (en) | Industrial control asset information collection method and device | |
| CN116720320A (en) | Digital twinning-based substation equipment data display method and device | |
| CN116108740A (en) | Modeling method and device for power equipment | |
| CN115529328A (en) | Intelligent management system and method for Internet of things | |
| CN116484591B (en) | Model construction method and system for whole-flow digital chemical engineering design of coal preparation plant | |
| KR101936694B1 (en) | Apparatus for processing inspection data |
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 |