Method for collecting real-time production data of cold rolling processing line based on algorithm script

Abstract

The invention discloses a method for acquiring real-time production data of a cold rolling processing line based on an algorithm script. The method comprises the following steps: configuring relevant parameters for acquiring the real-time production data of the cold rolling processing line; the collected real-time production data of the cold rolling processing line are sent to the time sequence database; judging whether the DB address of the data corresponds to the measured values of the plurality of measuring instruments, and if the DB address of the data does not correspond to the measured values of the plurality of measuring instruments, directly adopting the data in a time sequence database to carry out data analysis; and if the DB address of the data has the measurement values corresponding to a plurality of measurement instruments, performing data analysis on the data according to a first preset rule. The problem that in the prior art, when data needed by a data analyst does not exist in all the DB addresses corresponding to the PLC, the data cannot be directly input into the DB addresses for broker forwarding and then fall into a time sequence library is solved.

Description

Technical Field

[0001] The present invention relates to the technical field of real-time production data of cold rolling processing lines, and specifically relates to a method for collecting real-time production data of cold rolling processing lines based on algorithm scripts. Background Art

[0002] For data collection in the industrial field, it is necessary to use the industrial PLC data collection software Kepware, configure and test the network connection with devices and PLCs, obtain the DB addresses of corresponding points through the HMI screen of the first-level system, publish them to the corresponding Kepserver and perform broker data forwarding to achieve data collection. The collected data is stored in a time series database and provided to data analysts for data analysis. If the DB addresses of the required data directly correspond to the values we need, these data are directly forwarded by the broker and then stored in the time series database. However, when the data required by the data analyst does not exist in all the DB addresses corresponding to the PLC, at this time, the DB addresses cannot be directly entered for broker forwarding and then stored in the time series database. Therefore, there is an urgent need for a method for collecting real-time production data of cold rolling processing lines based on algorithm scripts to solve this problem. Summary of the Invention

[0003] In view of the above problems, the present invention is proposed to provide a method for collecting real-time production data of cold rolling processing lines based on algorithm scripts that overcomes or at least partially solves the above problems.

[0004] To solve the above technical problems, the embodiments of the present application disclose the following technical solutions:

[0005] In a first aspect, an embodiment of the present invention discloses a method for collecting real-time production data of cold rolling processing lines based on algorithm scripts, including:

[0006] S100. Configure relevant parameters for collecting real-time production data of cold rolling processing lines;

[0007] S200. Send the real-time production data collected from the cold rolling processing line to the time series database;

[0008] S300. Determine whether the DB address of the data corresponds to the measured values of multiple measuring instruments. If the DB address of the data does not correspond to the measured values of multiple measuring instruments, directly take the data in the time series database for data analysis; if the DB address of the data corresponds to the measured values of multiple measuring instruments, then perform data analysis on the data according to the first preset rule.

[0009] Further, in S100, configuring relevant parameters for collecting real-time production data of cold rolling processing lines specifically includes configuring a tag template, configuring a gateway, configuring a channel, adding a PLC connection, and configuring and publishing point addresses.

[0010] Further, the specific methods for configuring the tag template, configuring the gateway, configuring the channel, adding a PLC connection, and configuring and publishing the point address include: confirming the required data names and types, creating an Excel table and importing it into the IOT platform; configuring the gateway on the IOT platform, establishing a network connection between the data acquisition operation station and the unit industrial control computer, and inputting the IP address of the industrial control computer for the IP address; selecting the configured gateway, selecting the PLC driver protocol based on the gateway, then adding a channel, configuring the network of each section of the PLC on the channel, and establishing a network connection between the data acquisition operation station and the PLC; importing the configured tag template on the configured channel, writing the provided DB address, and publishing it to Kepserver in the industrial control computer.

[0011] Further, in S200, the method for sending the real-time production data of the cold rolling processing line collected to the time series database specifically includes: according to the configured channel, through the broker node, using the MQTT protocol to send the data to the data acquisition operation station and store it in the time series database.

[0012] Further, in S300, if the DB address of the data has measurement values corresponding to multiple measuring instruments, the data is analyzed according to the first preset rule, and the first preset rule includes: creating a virtual point, through the JEP tool, writing a logical operation script using the point address of the data, binding the logical operation script to the virtual point, and forwarding and storing it in the time series database.

[0013] Further, the virtual point is a point where data is not collected and stored through the DB address. The virtual point is a point where the value calculated by the algorithm script through other point addresses is stored. The algorithm script is developed based on the JEP tool. By adding a point configuration on the basis of the original written tag template with a DB address through the algorithm script, a logical operation script is written using the JEP tool with the above two points, and the instrument and detection signal variable names are defined as the point address.

[0014] Further, the operation logic of the logical operation script includes: first, writing a logical judgment statement of JEP using the detection signals of the instruments provided by the Boolean value PLC in each area, judging whether the instrument is in the position of RTF4 through the logical judgment statement, and then multiplying the judgment result by the real-time value of the hydrogen content. If the instrument is not in the RTF4 section, the data will return 0; the actual value of the hydrogen content when the instrument is in the RTF4 area is collected by this method, and the data returning 0 is handed over to the data analyst for processing through the data filling method.

[0015] Furthermore, after the logical operation script is written, through the JEP script verification function of the IOT platform, click to verify the script. After successful verification, it is forwarded through the broker and then stored in the time series database, realizing the function of collecting real-time production data of the cold rolling processing line through the algorithm script, thus providing more data sources for data analysts.

[0016] In a second aspect, an embodiment of the present invention discloses an electronic device, including:

[0017] One or more processors;

[0018] A memory for storing one or more programs;

[0019] When the one or more programs are executed by the one or more processors, the one or more processors implement the method for collecting real-time production data of the cold rolling processing line based on the algorithm script.

[0020] The beneficial effects of the above technical solutions provided by the embodiments of the present invention at least include:

[0021] An embodiment of the present invention discloses a method for collecting real-time production data of a cold rolling processing line based on an algorithm script, including: configuring relevant parameters for collecting real-time production data of the cold rolling processing line; sending the real-time production data of the cold rolling processing line to the time series database; determining whether the DB address of the data corresponds to the measured values of multiple measuring instruments. If the DB address of the data does not correspond to the measured values of multiple measuring instruments, directly analyze the data in the time series database; if the DB address of the data corresponds to the measured values of multiple measuring instruments, then analyze the data according to a first preset rule. The present invention solves the problem in the prior art that when the data required by the data analyst does not exist in all DB addresses corresponding to the PLC, the DB address cannot be directly entered for broker forwarding and then stored in the time series database.

[0022] Next, through the drawings and embodiments, the technical solutions of the present invention will be further described in detail. Description of the Drawings

[0023] The drawings are used to provide a further understanding of the present invention and constitute a part of the specification. Together with the embodiments of the present invention, they are used to explain the present invention and do not constitute a limitation to the present invention. In the drawings:

[0024] Figure 1 is a flowchart of a method for collecting real-time production data of a cold rolling processing line based on an algorithm script in Embodiment 1 of the present invention;

[0025] Figure 2 is a flowchart of configuring relevant parameters for collecting real-time production data of a cold rolling processing line in Embodiment 1 of the present invention;

[0026] Figure 3 This is a schematic structural diagram of an electronic device in Embodiment 1 of the present invention. Detailed implementation manners

[0027] Hereinafter, exemplary embodiments of the present disclosure will be described in more detail with reference to the accompanying drawings. Although the exemplary embodiments of the present disclosure are shown in the drawings, it should be understood that the present disclosure can be implemented in various forms and should not be limited by the embodiments set forth herein. On the contrary, these embodiments are provided so that the present disclosure can be more thoroughly understood and the scope of the present disclosure can be fully conveyed to those skilled in the art.

[0028] In order to solve the problems existing in the prior art, an embodiment of the present invention provides a method for collecting real-time production data of a cold rolling processing line based on an algorithm script.

[0029] Embodiment 1

[0030] The present invention discloses a method for collecting real-time production data of a cold rolling processing line based on an algorithm script, as Figure 1 , including:

[0031] S100. Configure relevant parameters for collecting real-time production data of the cold rolling processing line; in S100 of this embodiment, as Figure 2 , configure relevant parameters for collecting real-time production data of the cold rolling processing line, specifically including configuring a tag template, configuring a gateway, configuring channels, adding a PLC connection, and configuring and publishing point addresses.

[0032] Among them, the process of configuring the tag template includes, before collecting data, it is necessary to confirm the required data names and types with a data analyst, make them into an Excel table and import it into the IOT platform. Among them, the process of configuring the gateway includes configuring the gateway on the IOT platform, the purpose of which is to establish a network connection between the data acquisition operation station and the unit industrial control computer, and input the IP address of the industrial control computer for the IP address. The process of configuring channels and adding a PLC connection includes selecting the gateway configured in the previous step, and on the basis of this gateway, selecting a PLC driver protocol (usually the Siemens TCP / IP Ethernet protocol), then adding a new channel, and configuring the network of each section of the PLC on this channel, so that a network connection between the data acquisition operation station and the PLC is established, and the prerequisite for collecting PLC data is met. The process of configuring and publishing point addresses includes importing the tag template written in the first step on the channel configured in the previous step, writing the DB address provided by the PLC engineer, and publishing it to Kepserver in the industrial control computer.

[0033] Among them, the IOT platform, that is, the Internet of Things platform, is an Internet-based solution that does not rely on specific hardware modules but is constructed through existing communication technologies, enabling users to connect their devices to the Internet of Things according to their device technical architectures. In the IOT platform, the DB address (database address) usually refers to the location of the database used to store the data of Internet of Things devices. This address is crucial for the Internet of Things platform because it determines how the platform accesses and processes this data. The DB address in the IOT platform usually consists of the following parts:

[0034] The IP address or hostname of the database server: This is the unique network identifier of the database server, used to determine the location of the database server. The IP address is a 32-bit binary number (IPv4), used to identify a host in network communication. The hostname is an alias for the IP address, used to facilitate people's access to other devices on the network.

[0035] The port number of the database server: The port number of the database server is the network port on which the database server listens for database connection requests. When connecting to the database, this port number needs to be specified to ensure that the connection can be established correctly.

[0036] The database name: The database name is the unique identifier of the database on the database server, used to distinguish different databases.

[0037] The database access account and password: These are the credentials used to verify database access permissions. When connecting to the database, the correct account and password need to be provided to successfully access the database.

[0038] S200. Send the real-time production data collected from the cold rolling production line to the time series database; in S200 of this embodiment, sending the real-time production data collected from the cold rolling production line to the time series database, the specific method includes: According to the configured channels, through the broker node, using the MQTT protocol to send the data to the data acquisition operation station and store it in the time series database. Among them, in the IOT platform, the Broker node plays a crucial role. The Broker node, that is, the MQTT Broker, is the core component of MQTT communication, responsible for receiving, storing, and distributing messages. The functions of the Broker node at least include:

[0039] Message reception and distribution: The Broker node receives messages from the Publisher and distributes them to the corresponding Subscribers according to the message topics. All clients communicate through the Broker node, and clients do not communicate directly with each other.

[0040] Connection Management: The Broker node is responsible for managing connections with clients, including connection establishment, maintenance, and disconnection. It can handle simultaneous connections from multiple clients and ensure the stability and reliability of the connections.

[0041] Session Management: The Broker node supports persistent sessions and non-persistent sessions. Persistent sessions allow clients to resume previous subscriptions and messages received during offline periods when reconnecting after a disconnection.

[0042] Security and Authentication: The Broker node typically provides security authentication mechanisms such as TLS / SSL encryption, username and password authentication, etc., to ensure the security of communication.

[0043] S300. Determine whether the DB address of the data corresponds to the measured values of multiple measuring instruments. If the DB address of the data does not correspond to the measured values of multiple measuring instruments, directly use the data in the time series database for data analysis; if the DB address of the data corresponds to the measured values of multiple measuring instruments, then perform data analysis on the data according to the first preset rule.

[0044] Specifically, generally, data analysts directly use the PLC data in the time series database for data analysis. However, when the DB address of a piece of data corresponds to the measured values of multiple measuring instruments, this problem needs to be solved using virtual points. The data analyst needs the hydrogen content value in the RTF4 furnace section. However, considering costs, the previous designers designed only one instrument in each furnace section to measure the hydrogen content. The instrument moves periodically in each section of the furnace area and measures each section of the furnace area periodically, rather than always measuring the hydrogen content at the RTF4 end. Obviously, the PLC in the furnace section does not specifically provide the DB address for the hydrogen content at the RTF4 position. To obtain the hydrogen content value in the RTF4 section,

[0045] First, it is necessary to collect the DB address of this hydrogen content detector at the points where the PLC exists and the DB address of the detection signal of the instrument in each area (for example, when the instrument is at the RTF4 end, this data will return 1, otherwise it will return 0), which are respectively the status of the instrument located in the RTF4 section and the real-time value of the hydrogen content measured by the instrument.

[0046] In S300 of this embodiment, if the DB address of the data corresponds to the measured values of multiple measuring instruments, then perform data analysis on the data according to the first preset rule. The first preset rule includes: creating a virtual point, using the JEP tool, writing a logical operation script using the point address of the data, binding the logical operation script to the virtual point, and forwarding and storing it in the time series database.

[0047] In some preferred embodiments, the virtual point is a point where data is not collected and stored through the DB address, but a point where the value obtained by calculating the algorithm script through other point addresses is stored. The algorithm script is developed based on the JEP tool. By using the algorithm script, a new point configuration is added to the existing tag template with a DB address. Using the above two points, a logical operation script is written with the JEP tool, and the instrument and the detection signal variable name are defined as the point address.

[0048] In some preferred embodiments, the operation logic of the logical operation script includes: First, write a logical judgment statement of JEP for the detection signals of the instruments provided by the Boolean value PLC in each area. Use the logical judgment statement to determine whether the instrument is in the position of RTF4, and then multiply the result of the judgment by the real-time value of the hydrogen content. If the instrument is not in the RTF4 section, the data will return 0; By this method, the actual value of the hydrogen content when the instrument is in the RTF4 area is collected, and the returned 0 data is handed over to the data analyst for processing by the data filling method.

[0049] In some preferred embodiments, after the logical operation script is written, through the JEP script verification function of the IOT platform, click to perform script verification. After successful verification, it is forwarded through the broker and then stored in the time series database, realizing the function of collecting real-time production data of the cold rolling processing line through the algorithm script, thereby providing more data sources for the data analyst.

[0050] This embodiment discloses a method for collecting real-time production data of a cold rolling processing line based on an algorithm script, including: configuring relevant parameters for collecting real-time production data of the cold rolling processing line; sending the real-time production data of the cold rolling processing line to the time series database; determining whether the DB address of the data corresponds to the measured values of multiple measuring instruments. If the DB address of the data does not correspond to the measured values of multiple measuring instruments, directly analyze the data in the time series database; If the DB address of the data corresponds to the measured values of multiple measuring instruments, the data is analyzed according to the first preset rule. The present invention solves the problem in the prior art that when the data required by the data analyst does not exist in all the DB addresses corresponding to the PLC, the DB address cannot be directly entered for broker forwarding and then stored in the time series database.

[0051] Embodiment 2

[0052] Based on the same inventive concept, the present disclosure embodiment also provides an electronic device. Figure 3 It is a schematic structural diagram of an electronic device according to an embodiment of the present disclosure. As Figure 3As shown in the figure, an embodiment of the present disclosure provides an electronic device including: one or more processors 101, a memory 102, and one or more I / O interfaces 103. One or more programs are stored on the memory 102. When the one or more programs are executed by the one or more processors, the one or more processors implement any of the optimization methods in the above embodiments; one or more I / O interfaces 103 are connected between the processor and the memory and are configured to implement information interaction between the processor and the memory.

[0053] Among them, the processor 101 is a device with data processing capabilities, including but not limited to a central processing unit (CPU), etc.; the memory 102 is a device with data storage capabilities, including but not limited to a random access memory (RAM, more specifically such as SDRAM, DDR, etc.), a read-only memory (ROM), an electrically erasable programmable read-only memory (EEPROM), a flash memory (FLASH); the I / O interface (read / write interface) 103 is connected between the processor 101 and the memory 102 and can implement information interaction between the processor 101 and the memory 102, including but not limited to a data bus (Bus), etc.

[0054] In some embodiments, the processor 101, the memory 102, and the I / O interface 103 are interconnected through a bus 104 and are further connected to other components of the computing device.

[0055] In some embodiments, the one or more processors 101 include a field programmable gate array.

[0056] According to an embodiment of the present disclosure, a computer-readable medium is also provided. A computer program is stored on the computer-readable medium. When the program is executed by a processor, the steps in any of the optimization methods in the above embodiments are implemented.

[0057] It should be understood that the specific order or hierarchy of steps in the disclosed process is an example of an exemplary method. Based on design preferences, it should be understood that the specific order or hierarchy of steps in the process can be rearranged without departing from the protection scope of the present disclosure. The appended method claims present the elements of various steps in an exemplary order and are not intended to be limited to the specific order or hierarchy described.

[0058] In the foregoing detailed description, various features are combined in a single embodiment to simplify the disclosure. This method of disclosure should not be interpreted as reflecting an intention that the embodiments of the claimed subject matter require more features than are expressly recited in each claim. On the contrary, as reflected in the appended claims, the invention lies in less than all of the features of a single disclosed embodiment. Accordingly, the appended claims are hereby expressly incorporated into the detailed description, with each claim standing on its own as a separate preferred embodiment of the invention.

[0059] Those skilled in the art should also understand that the various illustrative logical blocks, modules, circuits, and algorithm steps described in connection with the embodiments herein can be implemented as electronic hardware, computer software, or combinations thereof. To clearly illustrate the interchangeability of hardware and software, the various illustrative components, blocks, modules, circuits, and steps have been generally described in terms of their functionality. Whether such functionality is implemented as hardware or software depends upon the particular application and design constraints imposed on the overall system. Skilled artisans may implement the described functionality in a flexible manner for each particular application, but such implementation decisions should not be interpreted as departing from the scope of the present disclosure.

[0060] The steps of a method or algorithm described in connection with the embodiments herein may be embodied directly in hardware, in a software module executed by a processor, or in a combination thereof. The software module may be located in RAM memory, flash memory, ROM memory, EPROM memory, EEPROM memory, registers, a hard disk, a removable disk, a CD-ROM, or any other form of storage medium well known in the art. An exemplary storage medium is coupled to the processor such that the processor can read information from, and write information to, the storage medium. Of course, the storage medium may also be integral to the processor. The processor and the storage medium may be located in an ASIC. The ASIC may be located in a user terminal. Of course, the processor and the storage medium may also exist as discrete components in a user terminal.

[0061] For a software implementation, the techniques described in this application can be implemented using modules (e.g., procedures, functions, etc.) that perform the functions described in this application. These software codes can be stored in a memory unit and executed by a processor. The memory unit may be implemented within the processor or outside the processor, and in the latter case, it is coupled to the processor in a communication manner via various means, which are well known in the art.

[0062] The foregoing description includes examples of one or more embodiments. Of course, it is not possible to describe all possible combinations of components or methods for the purpose of describing the above embodiments, but those of ordinary skill in the art should recognize that the various embodiments can be further combined and arranged. Accordingly, the embodiments described herein are intended to embrace all such changes, modifications, and variations that fall within the scope of the appended claims. In addition, with respect to the term "comprising" as used in the specification or claims, that term is inclusive in a manner similar to the term "including" as that term is interpreted when used as a transitional word in a claim. Further, any use of the term "or" in the specification or claims is to be meant "non-exclusive or".

Claims

1. A method for collecting real-time production data of a cold rolling processing line based on an algorithm script, characterized in that: include: S100. Configuring relevant parameters for collecting real-time production data of the cold rolling processing line; S200. Collecting real-time production data of the cold rolling processing line and sending it to a time series database; S300. Determine whether the DB address of the data corresponds to the measurement values ​​of multiple measuring instruments. If the DB address of the data does not correspond to the measurement values ​​of multiple measuring instruments, directly use the data in the time series database for data analysis; if the DB address of the data corresponds to the measurement values ​​of multiple measuring instruments, perform data analysis on the data according to the first preset rule.

2. A method for collecting real-time production data of a cold rolling processing line based on an algorithm script as claimed in claim 1, characterized in that: In S100, the relevant parameters for collecting the real-time production data of the cold rolling processing line are configured, including configuring the label template, configuring the gateway, configuring the channel and adding the PLC connection, and configuring and publishing the point address.

3. The method for collecting real-time production data of a cold rolling processing line based on an algorithm script as claimed in claim 1, characterized in that: The specific methods for configuring label templates, configuring gateways, configuring channels, adding PLC connections, configuring and publishing point addresses include: confirming the required data name and type, making an Excel spreadsheet and importing it into the IOT platform; configuring the gateway on the IOT platform, establishing a network connection between the digital acquisition operation station and the unit's industrial computer, and inputting the IP address of the industrial computer; selecting the configured gateway, selecting the PLC driver protocol based on the gateway, and then adding a channel, configuring each PLC network on the channel, and establishing a network connection between the digital acquisition operation station and the PLC; importing the configured label template on the configured channel, writing the provided DB address, and publishing it to the Kepserver in the industrial computer.

4. A method for collecting real-time production data of a cold rolling processing line based on an algorithm script as claimed in claim 1, characterized in that: In S200, the real-time production data of the cold rolling processing line is collected and sent to the time series database. The specific method includes: according to the configured channel, through the broker node, using the MQTT protocol to send the data to the data acquisition operation station and fall into the time series database.

5. The method for collecting real-time production data of a cold rolling processing line based on an algorithm script as claimed in claim 1, characterized in that: In S300, if the DB address of the data corresponds to the measurement values ​​of multiple measuring instruments, the data is analyzed according to the first preset rule, and the first preset rule includes: creating a virtual point, using the JEP tool to write a logical operation script using the point address of the data, binding the logical operation script to the virtual point, and forwarding and storing it in the time series database.

6. A method for collecting real-time production data of a cold rolling processing line based on an algorithm script as claimed in claim 5, characterized in that: The virtual point is a point where data is not collected and stored through the DB address. The virtual point is a point where the value calculated by the algorithm script through other point addresses is stored. The algorithm script is developed based on the JEP tool. A new point configuration is added based on the original label template with the DB address through the algorithm script. The logical operation script is written using the JEP tool using the above two points, and the instrument and detection signal variable names are defined as the point addresses.

7. A method for collecting real-time production data of a cold rolling processing line based on an algorithm script as claimed in claim 5, characterized in that: The operation logic of the logic operation script includes: first, using the detection signal of the instrument provided by the Boolean value PLC in each area to write a JEP logic judgment statement, and judging whether the instrument is in the RTF4 position through the logic judgment statement, and then multiplying the judgment result by the real-time value of the hydrogen content, if the instrument is not in the RTF4 segment data, the data will return 0; through this method, the actual value of the hydrogen content when the instrument is in the RTF4 area is collected, and the data returned as 0 is handed over to the data analyst for processing through the data filling method.

8. The method for collecting real-time production data of a cold rolling processing line based on an algorithm script as claimed in claim 5, characterized in that: After the logic operation script is written, click to verify the script through the JEP script verification function of the IOT platform. After the verification is successful, it is forwarded through the broker and stored in the time series database, realizing the function of collecting real-time production data of the cold rolling processing line through the algorithm script, thereby providing data analysts with more data sources.

9. An electronic device, comprising: one or more processors; A memory for storing one or more programs; When the one or more programs are executed by the one or more processors, the one or more processors implement the method of collecting real-time production data of a cold rolling processing line based on an algorithm script as described in any one of claims 1 to 8.

Images