Programmable construction method of novel equipment data relationship, application and computer program product

Through a storage information model for tree-shaped constraint relationships and a programmable configuration software platform, the time and logical relationship of industrial equipment data is constructed, and the redundancy and low management efficiency of massive equipment data storage is solved, and the efficiency of data storage is achieved and saving.

CN118964679APending Publication Date: 2024-11-15HANGZHOU VOCATIONAL & TECHN COLLEGE
View PDF 0 Cites 0 Cited by

Patent Information

Application Number
CN202411029301.7
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2024-07-30
Publication Date
2024-11-15

AI Technical Summary

Technical Problem

In the industrial production process, the island-style real-time storage of massive heterogeneous equipment data leads to redundant storage space and low data management efficiency. The lack of effective data relationships leads to less effective data, making it difficult to read and manage efficiently.

Method used

Using a storage information model for tree-shaped constraint relationships, the time and logical relationships between device data can be programmable, the device data is reconstructed and stored using programmable configuration software platform, and the data is stored using path encoding and format markup language. Information, construct a serial and parallel one-way graph network to reflect data dependencies.

Benefits of technology

It reduces the amount of stored data in the timing database, saves storage space, improves data management efficiency, and simplifies the later data reading and use.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN118964679A_ABST
    Figure CN118964679A_ABST
Patent Text Reader

Abstract

The invention relates to the field of industrial control, in particular to a programmable construction method of a novel equipment data relation, application and a computer program product. The invention discloses a programmable construction method for a novel equipment data relationship. The method comprises the following steps of: 1) acquiring various different types of equipment data on an automatic production line; (2) collecting equipment data by utilizing a programmable configuration software platform, and reconstructing a relationship among the data by utilizing a programmable mode; wherein the relationship between the equipment data comprises a time relationship and a logic relationship; and 3) storing the data relationship in a structural body file. According to the method, the quantity of stored data of the time sequence database is reduced, the storage space is saved, later data reading is facilitated, and the data management efficiency is greatly improved.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention relates to the field of industrial control, and in particular to a programmable construction method, application and computer program product of a novel device data relationship. Background Art

[0002] Industrial Internet is a new industrial ecology, infrastructure construction and new application model that deeply integrates the new generation of information and communication technology and industrial manufacturing. Whether it is the IIRA V1.9 network architecture released by the United States, the RAMI 4.0 architecture model of Germany, the IVRA architecture of Japan, or the "Industrial Internet Architecture 2.0" functional architecture released by the China Industrial Internet Industry Alliance, these architectures are designed to build a new Internet functional structure with "data", "network" and "security" as typical features, so as to achieve the deep integration of information technology (IT) and operational technology (OT).

[0003] With the development of industrial Internet technology, the data generated by mechanical equipment in the process of industrial production and operation and maintenance has become a new core asset. For example, many operation and maintenance and monitoring systems need to store industrial field data related to time. For example, when monitoring the temperature of a certain device, a series of data is generated by collecting the value of the device temperature every second. This type of data has a simple structure, and a certain metric will only have one value at a certain point in time, without complex structures (nesting, hierarchy, etc.) and relationships (associations, primary and foreign keys, etc.).

[0004] However, in the actual production process, manufacturers use intelligent industrial production lines to complete products, and coordinate the equipment in different production links to achieve interconnection, intercommunication, and interoperability. There are massive heterogeneous data sources on the industrial site, which continuously generate a large amount of analog, switch, image, video, audio and other structured and unstructured mixed data day and night. Each device has its own device time beat, that is, the cycle time to complete the corresponding process. There are certain constraints and dependencies between the data of each device in time and logic. In the existing technology, the massive polymorphic device data is either not stored, or the time series data collected on the device generating the terminal data is simply stored in real time without screening, and the data between each device is isolated from each other. This isolated real-time storage mode leads to serious redundancy of storage space, and the stored data is disorganized and has little effective data. When reading and using it later, the lack of effective data relationship leads to low data management efficiency. Summary of the invention

[0005] The purpose of the present invention is to provide a new type of programmable construction method for equipment data relationships in order to address the real-time massive storage of data with a single data structure and no correlation between data stored on existing automated production lines. The method establishes a tree-like constraint relationship storage information model, which can construct constraint dependency relationships between various types of equipment data according to actual on-site needs, and parses and stores the data collected on-site in the organizational format of a mixed time period file.

[0006] The objective of the present invention is achieved through the following technical solutions:

[0007] A programmable construction method for a new type of device data relationship includes the following steps:

[0008] 1) Acquire various types of equipment data on the automated production line; wherein the equipment data on the automated production line includes data collected by various sensors, cameras, programmable controllers, and robotic arms, D = {Sen, Ph, Plc, Machine}, Sen represents sensor data, Ph represents camera data, Plc represents controller data, and Machine represents data of various special machines;

[0009] The device data types are divided into structured data S and unstructured data US. The types corresponding to structured data are integer, floating point, string, and Boolean, that is, S = {INT, REAL, TEXT, BOOL}. The unstructured data types include image and video stream data, that is, US = {IMAGE, VIDEO}.

[0010] 2) After collecting device data using a programmable configuration software platform, reconstruct the relationship between the data in a programmable manner; wherein the relationship between the device data includes a time relationship and a logical relationship;

[0011] 3) Data relations are stored in structured files.

[0012] Preferably, the data of various types of equipment on the automated production line are obtained, and a data template is set according to the actual on-site environment. All data is collected according to the template requirements in the later stage. The mathematical model used in this method is as follows:

[0013]

[0014] PDSM represents the overall structure of the edge-cloud collaborative programmable data acquisition model, including the cloud programmable data operation platform C, the edge acquisition node set E, the edge storage node S, the programmable edge acquisition node set E and the set of all complex devices that need to store data CE; Represents the edge node e iThe jth data point contained in , from which it can be deduced that the data stored in the edge storage node S is the sum of all data on all edge collection nodes; i is the ith edge node, m is the number of edge nodes, ce n is the set of field devices connected to the nth edge node, Indicates the ith field complex device connected to the nth edge node, Indicates the number of field devices in the nth edge scenario.

[0015] As a preferred method, the time relationship between equipment data: Each production line contains multiple processes, and is equipped with a variety of different equipment according to the process flow. In the actual production process, effective equipment data should be collected according to the time period of the equipment's working beat. The production beat of the production line T line The time T of each process P Combination of T line =T P1 +T P2 +T P3 +……+T Pn ; Each T Pi Including several devices T d , each device also has its own working cycle T dj ,

[0016] The equipment working time has a mounting inclusion relationship or a serial relationship according to the sequence of process steps and a parallel relationship within the same step.

[0017] As a preference, the production time relationship tree is defined as follows: Indicates that there are m types of device nodes with different working time cycles, among which r i It indicates the working cycle size of each node in the production time relationship tree. In the tree structure, the data contained in each node is the data set of all the nodes mounted below it.

[0018] As a preferred method, path encoding is used to identify nodes on the production time relationship tree. The node path represents the path from the root node to the current node, which records each passed node. The nodes are separated by ".". The complete path of the bottom leaf node is represented by formula (1.2). Path {L x .U i .P j .N k .C h .d}=xijkhd (1.2)

[0019] The nodes at each level are represented by serial numbers, where x, i, j, k, and h are the serial numbers of the specific nodes passed through in the path, and the specific data represented by the leaf nodes are represented by letters.

[0020] Preferably, the logical relationship between the device data includes: linear constraint dependency between predecessor elements and subsequent elements between the data, that is, series-parallel relationship; the series relationship is represented by “->”, and the parallel relationship is represented by “⊙”. The relationship between the data A, B, and C can be constructed into multiple data logical relationships such as A->B->C, A⊙B⊙C, A->B⊙C, and A⊙B->C.

[0021] Preferably, a programmable configuration software platform is used to programmably construct the device data relationship, including:

[0022] The operations related to the equipment data are mapped to data graph function blocks that can be dragged and dropped in the database operation toolbox of the programmable configuration software platform, and the equipment data are mapped to the input nodes on the function blocks;

[0023] Through the connection of graphic elements, a ladder diagram network of series-parallel one-way diagram is constructed. The data relationship is implied as a section of visual diagram function code. The data relationship is programmed and managed through the graphic elements. The visual graphics can reflect the dependency relationship between various device data.

[0024] Use format markup language to store data information.

[0025] Furthermore, the present invention discloses the application of the method in a wheel hub automated production line.

[0026] Furthermore, the present invention also discloses a computer device, including a memory, a processor and a computer program stored in the memory, wherein the processor executes the computer program to implement the method.

[0027] Furthermore, the present invention also discloses a computer-readable storage medium, on which a computer program or instruction is stored, and the method is implemented when the computer program or instruction is executed by a processor.

[0028] Furthermore, the present invention also discloses a computer program product, including a computer program or instructions, which implement the method when executed by a processor.

[0029] The present invention has the following beneficial effects and advantages:

[0030] The present invention provides a novel device data relationship programmable construction method, which reduces the amount of stored data in a time series database, saves storage space, facilitates later data reading, and greatly improves data management efficiency. BRIEF DESCRIPTION OF THE DRAWINGS

[0031] Figure 1 It is a flow chart of the programmable construction method of data relations of the present invention.

[0032] Figure 2 It is a schematic diagram of the process flow of the wheel hub automated production line.

[0033] Figure 3 It is an abstract schematic program of a functional block diagram of a complex data relationship structure of the present invention.

[0034] Figure 4 It is a schematic diagram of the interface of the programmable data relationship construction method of the present invention.

[0035] Figure 5 It is a partial operation interface diagram in the programmable configuration software platform.

[0036] Figure 6 This is a schematic diagram of the implementation of the entire storage process. DETAILED DESCRIPTION

[0037] The following is a clear and complete description of the technical solutions in the embodiments of the present invention in conjunction with the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0038] The present invention proposes a programmable construction method for a new type of equipment data relationship. This embodiment is a wheel hub automated production line. Combining advanced sensing, flexible robots and machine vision technology, an automated wheel hub processing and testing line is designed and manufactured to achieve flexible and rapid processing of electric vehicle wheel hub products and digital automatic testing of products. Figure 1 It is a flow chart of the programmable construction method of data relations of the present invention. Figure 1 , provides a new device data relationship programmable construction method, including:

[0039] S101: Acquire various types of equipment data on the automated production line. The wheel hub automated production line includes four processes: casting, heat treatment, machining, and painting. Each process is composed of a corresponding series of processing procedures. The production line is highly automated and refined, and the collected data types are rich, including not only structural data such as switch quantities and analog quantities, but also non-structural data such as detected images. The amount of data that needs to be stored is large. In this embodiment, the heat treatment and machining units are selected as real case scenarios. Equipment data collection is implemented according to the production line and equipment conditions. The collected equipment data will be reconstructed and stored into a new data stream through programmable technology. The specific process flow of these two units is as follows: Figure 2 shown.

[0040] The entire production line includes heterogeneous programmable controller runtime software, programmable configuration platform, edge storage terminal, 5G / WIFI6 network and network management platform. The entire hardware system will use multiple heterogeneous programmable controllers and remote IO, connected through a 5G / WIFI6 network. The hardware system will uniformly control equipment groups such as single-sequence, two-sequence, and three-sequence lathes, robotic arms, balance testers, cleaning centers, and air tightness testers. In the end, the PLC group controls the equipment group, and the edge equipment database stores customized data. In order to ensure the security of the stored data, the edge equipment database uses UDP one-way communication to communicate with the PLC group to obtain field data, and the stored data can be used for data intelligent analysis and PLC control optimization. The PLC group hardware configuration table is as follows

[0041] As shown in the table:

[0042] Table 1 PLC group configuration

[0043]

[0044] The data collection table for qualified typical workstations in the heat treatment and machining units is shown in the table.

[0045] Table 2 Wheel hub production line data collection table

[0046]

[0047] S102: Using programmable configuration software to programmably construct the data relationship, including:

[0048] (1) The time relationship between equipment data is represented by a production time relationship tree. According to the detailed customization requirements of the on-site engineer, the production time relationship tree structure of the entire wheel production line is Figure 3 As shown, the machining process in the wheel hub production line is described in detail. Figure 3 In the formula, o represents the door opening time; c represents the door closing time; P represents the time when the clamp is clamped in place; R represents the time when the clamp is released. According to the production time relationship tree, the time template file that meets the machining data acquisition requirements is given as shown in Table 3:

[0049] Table 3 Time template file

[0050]

[0051] (2) The operations on the device data are mapped to data graph function blocks that can be dragged and dropped in the programmable configuration software database operation toolbox, and the device data is mapped to the input nodes on the function blocks; through the connection of graphic elements, a ladder diagram network of series-parallel one-way diagram is constructed, and the data relationship is implicitly mapped to a section of visual graph function code. The data relationship is programmed and managed through the graph elements, and the visual graphics can reflect the constraint dependency relationship between various device data;

[0052] This embodiment uses Figure 4 The abstract schematic diagram of the function block diagram program shown in the figure represents the structural schematic diagram of the data relationship. In the process of editing the function block diagram program, the basic function block diagram in the programmable configuration software platform is combined with the function block diagram related to the database operation, and the relationship between the data is recorded according to the logical relationship between the symbols. The series relationship is represented by "->", and the parallel relationship is represented by "⊙". Figure 4 The relationship is described as follows:

[0053] (A1->A2)⊙(B1->B2->B3)⊙((C1⊙C2->C3)⊙D1)->E1)->F1

[0054] For the specific data relationship structure in the embodiment, some operation interfaces in the programmable configuration software platform are as follows: Figure 5 As shown, a specially customized function block library provided by a programmable data configuration operating platform is utilized to write program data storage functions through programmable LD language, including data search, sorting, aggregation statistics and other functions, to realize the programmable construction of new data relationships.

[0055] S103: Data relationships are stored in structured files, and the corresponding equipment data related to the production line hub products is stored in the production line folder according to the structure format of the time template in Table 3. Storage is mainly divided into three steps: (1) Realizing the communication between the production line equipment group data and the edge data storage terminal; (2) Parsing the communication frame according to Table 3; (3) The parsed equipment data related to the hub automation production line and the hub product manufacturing process is stored in the corresponding production line folder according to new structured files. The implementation code of the entire storage process is as follows: Figure 6 shown.

[0056] The above is a description of the embodiments of the present invention. Through the above description of the disclosed embodiments, professionals and technicians in the field can implement or use the present invention. Various modifications to these embodiments will be apparent to professionals and technicians in the field. The general principles defined herein can be implemented in other embodiments without departing from the spirit or scope of the present invention. Therefore, the present invention will not be limited to these embodiments shown in this article, but will conform to the widest range consistent with the principles and novelties disclosed herein.

Claims

1. A programmable construction method for a new type of device data relationship, characterized in that: include: 1) Acquire various types of equipment data on the automated production line; wherein the equipment data on the automated production line includes data collected by various sensors, cameras, programmable controllers, and robotic arms, D={Sen,Ph,Plc,Machine}, Sen represents sensor data, Ph represents camera data, and Plc represents controller data. Machine represents the data of various special machines; The device data types are divided into structured data S and unstructured data US. The types corresponding to structured data are integer, floating point, string, and Boolean, that is, S = {INT, REAL, TEXT, BOOL}. The unstructured data types include image and video stream data, that is, US = {IMAGE, VIDEO}. 2) After collecting device data using a programmable configuration software platform, reconstruct the relationship between the data in a programmable manner; wherein the relationship between the device data includes a time relationship and a logical relationship; 3) Data relations are stored in structured files.

2. A programmable construction method of a new type of device data relationship according to claim 1, characterized in that: The method acquires data of various types of equipment on the automated production line, sets a data template according to the actual on-site environment, and collects all data in the later stage according to the template requirements; the mathematical model used in this method is as follows: PDSM represents the overall structure of the edge-cloud collaborative programmable data acquisition model, including the cloud programmable data operation platform C, the edge acquisition node set E, the edge storage node S, the programmable edge acquisition node set E and all the complex devices cE that need to store data; Represents the edge node e i The jth data point contained in , from which it can be deduced that the data stored in the edge storage node S is the sum of all data on all edge collection nodes; i is the ith edge node, m is the number of edge nodes, ce n is the set of field devices connected to the nth edge node, Indicates the ith field complex device connected to the nth edge node, Indicates the number of field devices in the nth edge scenario.

3. A programmable construction method of a new type of device data relationship according to claim 1, characterized in that: Time relationship between equipment data: Each production line contains multiple processes, and is equipped with a variety of different equipment according to the process flow. In the actual production process, effective equipment data should be collected according to the time cycle of the equipment's working beat. The production beat of the production line is T line The time T of each process P Combination of T line =T P1 +T P2 +T P3 +……+T Pn ; Each T Pi Including several devices T d , each device also has its own working cycle T dj , The equipment working time has a mounting inclusion relationship or a serial relationship according to the sequence of process steps and a parallel relationship within the same step.

4. A programmable construction method of a new type of device data relationship according to claim 3, characterized in that: The production time relationship tree is defined as follows: Indicates that there are m types of device nodes with different working time cycles, among which r i It indicates the working cycle size of each node in the production time relationship tree. In the tree structure, the data contained in each node is the data set of all the nodes mounted below it.

5. A programmable construction method of a new type of device data relationship according to claim 4, characterized in that: Path encoding is used to identify nodes on the production time relationship tree. The node path represents the path from the root node to the current node, which records each node passed through. The nodes are separated by ". ". The complete path of the bottom leaf node is expressed by formula (1.2). Path {L x .U i .P j .N k .C h .d}=xijkhd (1.2) The nodes at each level are represented by serial numbers, where x, i, j, k, and h are the serial numbers of the specific nodes passed through in the path, and the specific data represented by the leaf nodes are represented by letters.

6. A programmable construction method of a new type of device data relationship according to claim 1, characterized in that: The logical relationship between the device data includes: the linear constraint dependency between the predecessor elements and the subsequent elements, that is, the series-parallel relationship; the series relationship is represented by "->", and the parallel relationship is represented by "⊙". The relationship between the data A, B, and C can construct multiple data logical relationships such as A->B->C, A⊙B⊙C, A->B⊙C, and A⊙B->C.

7. A programmable construction method of a new type of device data relationship according to claim 1, characterized in that: Use the programmable configuration software platform to programmably construct device data relationships, including: The operations related to the equipment data are mapped to data graph function blocks that can be dragged and dropped in the database operation toolbox of the programmable configuration software platform, and the equipment data are mapped to the input nodes on the function blocks; Through the connection of graphic elements, a ladder diagram network of series-parallel one-way diagram is constructed. The data relationship is implied as a section of visual diagram function code. The data relationship is programmed and managed through the graphic elements. The visual graphics can reflect the dependency relationship between various device data. Use format markup language to store data information.

8. A computer device comprising a memory, a processor and a computer program stored in the memory, characterized in that: The processor executes the computer program to implement the method according to any one of claims 1 to 7.

9. A computer-readable storage medium having a computer program or instruction stored thereon, characterized in that: When the computer program or instruction is executed by a processor, the method described in any one of claims 1 to 7 is implemented.

10. A computer program product comprising a computer program or instructions, characterized in that When the computer program or instruction is executed by a processor, the method described in any one of claims 1 to 7 is implemented.