Machine tool equipment operation data processing method and device, equipment and medium

Abstract

The invention discloses a machine tool equipment operation data processing method and device, equipment and a medium, and is applied to an operation data processing system, the operation data processing system comprises an edge gateway and a time sequence database, and the method comprises the following steps: obtaining measurement data of machine tool equipment in an operation state; determining high-frequency measurement data and low-frequency measurement data corresponding to the machine tool equipment in the measurement data; the high-frequency measurement data and the low-frequency measurement data are respectively acquired according to a preset acquisition frequency based on an acquisition module in the edge gateway; the high-frequency measurement data and the low-frequency measurement data are cached and compressed and then transmitted to a time sequence database to be stored, and the time sequence database stores processed column type storage data; the stable data source of the machine tool equipment is obtained after data cleaning and data conversion processing are conducted on the column type storage data, the pressure of too large data transmission amount and data cleaning is relieved, and stable and reliable data are provided for follow-up big data analysis modeling.

Description

Technical Field

[0001] The present application relates to the technical field of machine tool management, and in particular to a method, device, equipment and medium for processing machine tool equipment operation data. Background Art

[0002] With the continuous deepening of computer technology and network technology in the manufacturing industry, the development of CNC machine tools towards digitalization, networking, and intelligent management has become a trend. This not only helps enterprises achieve informatization and digital transformation, but also enhances the overall competitiveness of enterprises.

[0003] However, in the related technologies, in the intelligent management of CNC machine tools, the data collection for CNC machine tools has the problems of fast data generation frequency, too frequent disk I / O operations, heavy reliance on collection time, and large number of measurement points and large amount of information.

[0004] Therefore, how to reduce the pressure of excessive data transmission and data cleaning, and provide a reliable and regular data source in the operation and management of CNC machine tools is an urgent problem to be solved. Summary of the invention

[0005] In view of the above problems, the present application provides a method, device, equipment and medium for processing machine tool equipment operation data to at least solve the problems existing in the related technology.

[0006] In a first aspect, an embodiment of the present application provides a method for processing operation data of a machine tool device, which is applied to an operation data processing system, wherein the operation data processing system includes an edge gateway and a time series database, and the method includes:

[0007] Obtain measurement data of machine tools in operation;

[0008] Determining high-frequency measurement data and low-frequency measurement data corresponding to the machine tool equipment in the measurement data;

[0009] Based on the acquisition module in the edge gateway, the high-frequency measurement data and the low-frequency measurement data are respectively collected according to the preset acquisition frequency;

[0010] The high-frequency measurement data and the low-frequency measurement data are cached, compressed, and then transmitted to the time series database for storage, wherein the time series database stores the processed column-type storage data;

[0011] After data cleaning and data conversion processing are performed on the column-type stored data, a stable data source for machine tool equipment is obtained.

[0012] In some embodiments, the operation data processing system further includes a sensor, and the method for processing the operation data of the machine tool equipment further includes:

[0013] Acquire target data transmitted by the sensor according to a preset monitoring cycle, wherein the sensor corresponding to each part of the machine tool equipment is registered to the monitoring device of the edge gateway;

[0014] If the target data is not received for a preset time threshold, reestablishing the connection between the monitoring device and the sensor;

[0015] When the monitoring device fails to connect to the sensor after a preset number of connections, the data corresponding to the sensor in the queue of the edge gateway is removed from the time series database.

[0016] In some embodiments, the caching and compressing the high-frequency measurement data and the low-frequency measurement data and transmitting them to the time series database for storage includes:

[0017] Before transmitting to the edge gateway, caching and compressing the high-frequency measurement data and the low-frequency measurement data to obtain first processed data;

[0018] The first processed data is transmitted to the time series database for storage using the 4G communication protocol and the message queue telemetry transmission protocol.

[0019] In some embodiments, the time series database generates corresponding time series for the stored data.

[0020] In some embodiments, the step of performing data cleaning and data conversion on the column-type stored data to obtain a stable data source for machine tool equipment includes:

[0021] Based on the time series, the column-type stored data is identified for missing values ​​and filled, deleted or retained to obtain first column-type stored data;

[0022] Based on the time series, duplicate data in the first column-type stored data is detected, and the duplicate data is deleted or merged to obtain a stable data source for the machine tool equipment.

[0023] In some embodiments, the method for processing machine tool equipment operation data further includes:

[0024] When the monitoring device fails to connect to the sensor after a preset number of connections, the sensor is determined to be abnormal and an early warning prompt is triggered.

[0025] In some embodiments, the method for processing machine tool equipment operation data further includes:

[0026] A visual display is provided for each link of obtaining the stable data source of the machine tool equipment, including: displaying the target data of the sensor monitored by the monitoring device of the edge gateway, the measurement data associated with the target data, the high-frequency measurement data, the low-frequency measurement data, the column storage data and the stable data source of the machine tool equipment.

[0027] In a second aspect, an embodiment of the present application provides a device for processing operation data of a machine tool device, which is applied to an operation data processing system, wherein the operation data processing system includes an edge gateway and a time series database, including:

[0028] An acquisition module is used to acquire measurement data of the machine tool equipment in operation;

[0029] A determination module, used to determine the high-frequency measurement data and the low-frequency measurement data corresponding to the machine tool equipment in the measurement data;

[0030] A collection module, used to collect the high-frequency measurement data and the low-frequency measurement data respectively according to a preset collection frequency based on the collection module in the edge gateway;

[0031] A storage module, used to cache and compress the high-frequency measurement data and the low-frequency measurement data and transmit them to the time series database for storage, wherein the time series database stores the processed column storage data;

[0032] The processing module is used to perform data cleaning and data conversion on the column-type stored data to obtain a stable data source for machine tool equipment.

[0033] In a third aspect, an embodiment of the present application provides an electronic device, comprising a memory and a processor, wherein the memory stores program code that can be executed on the processor, and when the program code is executed by the processor, a method for processing machine tool equipment operation data as described in any implementation method of the first aspect is implemented.

[0034] In a fourth aspect, an embodiment of the present application provides a computer storage medium storing one or more programs, which can be executed by an electronic device as described in the third aspect to implement a method for processing machine tool equipment operation data as described in any implementation method of the first aspect.

[0035] A method, device, equipment and medium for processing operation data of machine tool equipment provided in an embodiment of the present application are applied to an operation data processing system, wherein the operation data processing system includes an edge gateway and a time series database, including: obtaining measurement data of the machine tool equipment in an operating state; determining high-frequency measurement data and low-frequency measurement data corresponding to the machine tool equipment in the measurement data; collecting the high-frequency measurement data and the low-frequency measurement data respectively according to a preset collection frequency based on an acquisition module in the edge gateway; caching and compressing the high-frequency measurement data and the low-frequency measurement data and transmitting them to a time series database for storage, wherein the time series database stores the processed column-type storage data; performing data cleaning and data conversion on the column-type storage data to obtain a stable data source for the machine tool equipment, and storing the collected data in the time series database for data cleaning and data conversion according to the priority level. Standardized data is formed after the collected data is transmitted separately, thereby reducing the pressure of excessive data transmission and data cleaning, and providing stable and reliable data for subsequent big data analysis and modeling.

[0036] It should be understood that the content described in this section is not intended to identify the key or important features of the embodiments of the present application, nor is it intended to limit the scope of the present application. Other features of the present application will become easily understood through the following description. BRIEF DESCRIPTION OF THE DRAWINGS

[0037] Hereinafter, the present application will be described in more detail based on embodiments and with reference to the accompanying drawings.

[0038] Figure 1 A schematic flow chart of a method for processing machine tool equipment operation data proposed in an embodiment of the present application is shown;

[0039] Figure 2 A schematic diagram of a hierarchical structure of an operation data processing system proposed in an embodiment of the present application is shown;

[0040] Figure 3 A structural block diagram of a device for processing machine tool equipment operation data proposed in an embodiment of the present application is shown;

[0041] Figure 4 A structural block diagram of an electronic device for executing a method for processing machine tool equipment operation data according to an embodiment of the present application is shown;

[0042] Figure 5 A computer-readable storage medium for storing or carrying a method for processing machine tool equipment operation data according to an embodiment of the present application is shown. DETAILED DESCRIPTION

[0043] In order to make the objectives, technical solutions and advantages of the present invention more clearly understood, the present invention is further described in detail below in conjunction with embodiments and drawings. The exemplary embodiments of the present invention and their description are only used to explain the present invention and are not intended to limit the present invention.

[0044] In the research on related technologies, it has become a trend for CNC machine tools to develop in the direction of digitalization, networking, and intelligent management. This not only helps enterprises to achieve informatization and digital transformation, but also enhances the overall competitiveness of enterprises. In the process of CNC machine tool information collection and processing, there is pressure of excessive data volume and data cleaning. To realize the intelligent management of CNC machine tools, it is necessary to provide accurate and reliable data sources.

[0045] In response to the above problem description, the applicant has proposed a method, device, equipment and medium for processing the operation data of machine tool equipment provided in the embodiments of the present application. The method is based on an operation data processing system composed of a time series database, equipment sensors and an edge gateway, which realizes the transmission of real-time data of machine tool operation. The edge gateway monitors and manages the sensor equipment to ensure that the sensors can work normally in the production environment. At the same time, the collected data are transmitted separately according to the priority and importance, and the collected data are stored in the time series database. The data is cleaned and converted into regular, effective and reliable data by using its high performance, high data compression ratio, fast query speed and support for streaming computing. Finally, the processed data is persisted, which lays a solid foundation for the subsequent big data analysis and the intelligentization of CNC machine tools. Among them, the method for processing the operation data of machine tool equipment is described in detail in the subsequent embodiments.

[0046] The following is an introduction to the application scenarios of the method for processing machine tool equipment operation data provided by the embodiment of the present application:

[0047] See also Figure 1 , Figure 1 FIG. 1 is a flow chart of a method for processing machine tool equipment operation data provided in an embodiment of the present application. In this embodiment, the method for processing machine tool equipment operation data can be applied to the following: Figure 2 In the hierarchical structure of the operating data processing system shown, Figure 3 The processing device 300 for processing the machine tool equipment operation data and Figure 4 The electronic device 200 shown in the figure may include a mobile terminal, a computer, a tablet, etc., which is not limited in this application. Figure 1 The process shown is explained in detail and applied to an operation data processing system. The operation data processing system may include an edge gateway and a time series database. The method for processing the operation data of the machine tool equipment may include S110 to S150.

[0048] S110: Acquire measurement data of the machine tool equipment in operation.

[0049] In an embodiment of the present application, the measurement data of the machine tool equipment in the operating state may include: the temperature of the CNC machine tool during operation, the temperature of the tool during operation, the force applied to the tool during operation, torque and other motion parameters, tool information, processing technology templates, operation logs, etc.

[0050] S120: Determine the high-frequency measurement data and the low-frequency measurement data corresponding to the machine tool equipment in the measurement data.

[0051] In this embodiment, data with high update frequency, such as the temperature of the CNC machine tool during operation, the temperature of the tool during operation, the force applied to the tool, torque, and motion parameters, are classified as high-frequency measurement data, and data with low update frequency, such as tool information, processing technology templates, and operation logs, are classified as low-frequency measurement data.

[0052] S130: Based on the collection module in the edge gateway, the high-frequency measurement data and the low-frequency measurement data are collected according to the preset collection frequency.

[0053] In the embodiment of the present application, the edge gateway sets a high-speed acquisition module and a low-speed acquisition module to respectively collect the measurement data using different modules according to the priority and importance of actual production needs.

[0054] Exemplarily, the edge gateway uses a high-speed collector and a low-speed collector to collect data with high priority, high importance, and high collection frequency and data with relatively low priority, relatively low importance, and relatively low collection frequency, respectively.

[0055] S140: caching and compressing the high-frequency measurement data and the low-frequency measurement data and transmitting them to a time series database for storage, wherein the time series database stores the processed column-type storage data.

[0056] At the transport layer, the collected data is cached, compressed, and then transmitted to the time series database to reduce the pressure of massive data storage and transmission.

[0057] Considering further optimizing data storage and data transmission pressure.

[0058] In some embodiments, S140 includes S141 to S142.

[0059] S141: Before transmitting to the edge gateway, cache and compress the high-frequency measurement data and the low-frequency measurement data to obtain first processed data.

[0060] In an embodiment of the present application, in order to avoid data loss caused by network delays, network congestion and other problems that may occur in a real production environment, the collected data is cached before being transmitted to the edge gateway; in order to reduce the transmission pressure of the edge gateway, the high-frequency measurement data and the low-frequency measurement data are further compressed.

[0061] S142: Transmit the first processed data to a time series database for storage using a 4G communication protocol and a message queue telemetry transmission protocol.

[0062] In an embodiment of the present application, in order to ensure data transmission efficiency, the high-speed data transmission capability provided by the 4G communication module and the efficient device-to-device message communication capability provided by the MQTT protocol module are transmitted to the timing database.

[0063] Exemplarily, the edge gateway caches the collected data to avoid data loss due to network congestion, equipment failure and other problems, and then compresses the data to improve network transmission efficiency and reduce the pressure on network components. Finally, the data is converted into time series data through the 4G communication module and MQTT protocol module and transmitted to the time series database for storage.

[0064] S150: After data cleaning and data conversion processing are performed on the column-type stored data, a stable data source for the machine tool equipment is obtained.

[0065] Stable data is obtained after data cleaning and data conversion.

[0066] In some embodiments, the time series database generates corresponding time series for the stored data.

[0067] Among them, the time series database is also called the time series database, which is mainly used for data collected and generated by various types of real-time monitoring, inspection and analysis equipment in the power industry, chemical industry, meteorological industry, geographic information, etc. Considering the typical characteristics of industrial data: fast generation frequency (each monitoring point can generate multiple data within one second), heavy reliance on collection time (each data requires a unique time), and large amount of information at many measurement points. The time series database effectively compresses data and speeds up query speed by storing data in columns instead of rows in traditional relational databases, because related data points are physically continuous, reducing disk I / O operations.

[0068] In this embodiment, the characteristics of the time series database, such as high performance, high data compression ratio, fast query speed, and support for streaming computing, can be used to store the collected data and form a time series.

[0069] In order to further optimize and reduce the amount of data and ensure data quality.

[0070] In some embodiments, S150 includes S151 to S152.

[0071] S151: Based on the time series, missing values ​​are identified and filled, deleted or retained for the column-type stored data to obtain first column-type stored data.

[0072] In the embodiment of the present application, considering that the operating data of industrial-grade equipment is in the millions per second, the processing layer needs to process the data in the storage layer in sequence, identify missing values, and decide whether to delete these records, fill in missing values, or retain missing values ​​to obtain the first columnar storage data.

[0073] S152: Detect duplicate data in the first column-type stored data based on the time series, and delete or merge the duplicate data to obtain a stable data source for the machine tool equipment.

[0074] In an embodiment of the present application, duplicate records in a data set are checked, and these duplicate records are deleted or merged to obtain a stable data source for machine tool equipment.

[0075] In this embodiment, the collected data is stored in a time series database, and the data is processed into regular, effective and reliable data by utilizing its high performance, high data compression ratio, fast query speed and support for streaming computing.

[0076] Taking into account the abnormal situation of the sensors of machine tool equipment, in order to further optimize the data reliability and reduce the pressure of data transmission and storage.

[0077] In some embodiments, the operation data processing system further includes a sensor, and the method for processing the operation data of the machine tool equipment further includes S101 to S103.

[0078] S101: Acquire target data transmitted by sensors according to a preset monitoring cycle, wherein sensors corresponding to various parts of the machine tool equipment are registered to the monitoring device of the edge gateway.

[0079] In an embodiment of the present application, various types of sensors deployed in various parts of the CNC machine tool are registered to the monitoring device in the edge gateway in a unified format according to unified rules, such as "area ID, plant ID, workshop ID, equipment ID, sensor ID", thereby performing unified management. The sensor transmits a "heartbeat" data packet to the device monitoring module at a fixed frequency, which contains the sender's IP address, port number, simple identification information and a checksum. When the device monitoring device receives it, it considers the sensor active.

[0080] S102: When the target data is not received for a period of time that meets a preset time threshold, re-establish the connection between the monitoring device and the sensor.

[0081] S103: When the monitoring device fails to connect to the sensor after a preset number of connections, the data corresponding to the sensor in the queue of the edge gateway is removed from the time series database.

[0082] In the embodiment of the present application, if the device monitoring module does not receive the "heartbeat" data packet sent by the sensor after a certain period of time, it will try to reconnect to the sensor. If the connection is not successful after exceeding the number of reconnections, it will be removed from the active list and moved to the abnormal list.

[0083] In some embodiments, the method for processing machine tool equipment operation data further includes S104.

[0084] S104: When the monitoring device fails to connect to the sensor after a preset number of connections, the sensor is determined to be abnormal and an early warning prompt is triggered.

[0085] For example, the sensors associated with the CNC machine tool are registered to the monitoring device in the edge gateway. The registered sensors send "survival" data packets to the monitoring device at a fixed frequency. After receiving the data packets, the monitoring device updates the status of the sensor. If the "survival" data packets sent by the sensor are not received after a certain period of time, it will try to reconnect. If there is still no response after a certain number of times, the sensor status will be updated to "abnormal" and a warning will be sent upward. If the sensor is reconnected later, it will be updated to "active status".

[0086] In this embodiment, the edge gateway monitors and manages sensor devices to ensure that the sensors can work normally and transmit data in the production environment, optimize abnormal storage data, and issue abnormal warnings for sensor devices.

[0087] In some embodiments, the method for processing machine tool equipment operation data further includes:

[0088] Each link of the stable data source for machine tool equipment is visualized, including: displaying the target data of the monitoring sensor of the monitoring equipment of the edge gateway, the measurement data associated with the target data, high-frequency measurement data, low-frequency measurement data, column storage data and the stable data source of machine tool equipment.

[0089] In this embodiment, information such as device monitoring status and data collection status in the edge gateway can be displayed in a visual form on a mobile smart terminal, a WEB terminal, or a digital large screen.

[0090] For example, the details of the entire architecture, such as the sensor's operating status, data collection status, edge gateway transmission status, and time series database storage status, are extracted and displayed in visual forms such as charts and animations through mobile smart terminals, WEB terminals, digital large screens and other display media, so that relevant personnel can grasp and analyze the operating details of the overall collection architecture in a timely and convenient manner, which helps to discover problems in a timely manner and quickly troubleshoot them.

[0091] See also Figure 2 A schematic diagram of the hierarchical structure in a running data processing system is provided.

[0092] In the figure, the hierarchical structure in the running data processing system includes device layer, data layer, transmission layer, storage layer, processing layer, persistence layer and presentation layer.

[0093] In the device layer, the sensor is registered to the device monitoring module for easy management. In the data layer, the collected data is classified according to priority and transmitted in sequence. For important indicator parameters with high collection frequency such as temperature, tool motion parameters, tool force and torque, the high-speed collection module in the edge gateway is used for collection. For indicator parameters with relatively low importance and low collection frequency such as tool information, operation logs, and processing technology templates, the low-speed collection module in the edge gateway is used for collection. Then, the data is cached and compressed in the transport layer and sent to the time series database in the storage layer for storage through the 4G communication module and MQTT protocol module in the edge gateway.

[0094] In the processing layer, the data in the time series database is cleaned and converted, and standardized data is generated in the persistence layer and persisted in HIVE, HDFS, MYSQL and other databases to provide stable and reliable data for subsequent big data analysis and modeling. Finally, the display layer displays information such as sensor activity anomalies and data collection status in a visual manner on display media (such as mobile smart terminals, WEB terminals, digital large screens), comprehensively monitoring the entire collection process and facilitating relevant personnel to conduct troubleshooting and maintenance.

[0095] In summary, the present application provides a method, device, equipment and medium for processing machine tool equipment operation data, which is applied to an operation data processing system composed of a time series database, equipment sensors, and an edge gateway to realize the transmission of real-time data of machine tool operation. The edge gateway monitors and manages the sensor equipment to ensure that the sensors can work normally in the production environment, and transmits the collected data separately according to the priority and importance. The collected data is stored in the time series database, and its high performance, high data compression ratio, fast query speed and support for streaming computing are used to process the data into regular, effective and reliable data. Finally, the processed data is persisted, and the entire collection process is fully monitored to facilitate the relevant personnel to conduct investigation and maintenance, which will lay a solid foundation for the subsequent big data analysis and the intelligentization of CNC machine tools.

[0096] See also Figure 3 , Figure 3 The structural block diagram of a processing device for machine tool equipment operation data provided by the present application is applied to an operation data processing system, the operation data processing system at least includes an edge gateway and a time series database, and the processing device 300 for machine tool equipment operation data includes: an acquisition module 310, a determination module 320, a collection module 330, a storage module 340 and a processing module 350, wherein:

[0097] The acquisition module 310 is used to acquire measurement data of the machine tool equipment in operation.

[0098] The determination module 320 is used to determine the high-frequency measurement data and the low-frequency measurement data corresponding to the machine tool equipment in the measurement data.

[0099] The collection module 330 is used to collect the high-frequency measurement data and the low-frequency measurement data respectively according to the preset collection frequency based on the collection module in the edge gateway.

[0100] The storage module 340 is used to cache and compress the high-frequency measurement data and the low-frequency measurement data and transmit them to the time series database for storage, wherein the time series database stores the processed column storage data.

[0101] The processing module 350 is used to perform data cleaning and data conversion processing on the column-type stored data to obtain a stable data source for the machine tool equipment.

[0102] The device embodiment in the present application may also include other modules, which specifically correspond to part of the content of the above method.

[0103] It should be noted that the device embodiments in the present application correspond to each other with the aforementioned method embodiments. The specific principles in the device embodiments can be found in the contents of the aforementioned method embodiments and will not be repeated here.

[0104] In several embodiments provided in this embodiment, the coupling between modules may be electrical, mechanical or other forms of coupling.

[0105] In addition, each functional module in each embodiment of the present invention may be integrated into one processing module, or each module may exist physically separately, or two or more modules may be integrated into one module. The above-mentioned integrated module may be implemented in the form of hardware or in the form of software functional modules.

[0106] See also Figure 4 , Figure 4 The present application provides a structural block diagram of an electronic device 200 that can execute the above-mentioned method for processing machine tool equipment operation data. The electronic device 200 can be a smart phone, tablet computer, computer or portable computer and other devices.

[0107] The electronic device 200 further includes a processor 202 and a memory 204. The memory 204 stores a program that can execute the contents of the aforementioned embodiments, and the processor 202 can execute the program stored in the memory 204.

[0108] Among them, the processor 202 may include one or more cores and message matrix units for processing data. The processor 202 uses various interfaces and lines to connect various parts of the entire electronic device 200, and executes various functions and processes data of the electronic device 200 by running or executing instructions, programs, code sets or instruction sets stored in the memory 204, and calling data stored in the memory 204. Optionally, the processor 202 can be implemented in at least one hardware form of digital signal processing (Digital Signal Processing, DSP), field programmable gate array (Field-Programmable Gate Array, FPGA), and programmable logic array (Programmable Logic Array, PLA). The processor 202 can integrate one or a combination of a central processing unit (Central Processing Unit, CPU), a graphics processing unit (Graphics Processing Unit, GPU) and a modulation decoder. Among them, the CPU mainly processes the operating system, user interface and application programs; the GPU is responsible for rendering and drawing display content; and the modem is used to process wireless communications. It can be understood that the above-mentioned modulation decoder may not be integrated into the processor, but may be implemented separately through a communication chip.

[0109] The memory 204 may include a random access memory (RAM) or a read-only memory (ROM). The memory 204 may be used to store instructions, programs, codes, code sets or instruction sets. The memory 204 may include a program storage area and a data storage area, wherein the program storage area may store instructions for implementing an operating system, instructions for implementing at least one function (e.g., instructions for a user to obtain a random number), instructions for implementing the following various method embodiments, etc. The data storage area may also store data (e.g., random numbers) created by the terminal during use, etc.

[0110] The electronic device 200 may also include a network module and a screen. The network module is used to receive and send electromagnetic waves, realize the mutual conversion between electromagnetic waves and electrical signals, and thus communicate with a communication network or other devices, such as communicating with an audio playback device. The network module may include various existing circuit components for performing these functions, such as antennas, radio frequency transceivers, digital signal processors, encryption / decryption chips, user identity modules (SIM) cards, memories, etc. The network module may communicate with various networks such as the Internet, corporate intranets, wireless networks, or communicate with other devices via wireless networks. The above-mentioned wireless networks may include cellular telephone networks, wireless local area networks, or metropolitan area networks. The screen may display interface content and perform data interaction.

[0111] Please refer to Figure 5 , Figure 5 The computer-readable storage medium 400 stores program code 410, which can be called by a processor to execute the method described in the above method embodiment.

[0112] The computer-readable storage medium 400 may be an electronic memory such as a flash memory, an EEPROM (electrically erasable programmable read-only memory), an EPROM, a hard disk, or a ROM. Optionally, the computer-readable storage medium includes a non-transitory computer-readable storage medium. The computer-readable storage medium 400 has storage space for program codes 410 that perform any method steps in the above method. These program codes 410 can be read from or written to one or more computer program products. The program codes 410 can be compressed, for example, in an appropriate form.

[0113] The embodiment of the present application also provides a computer program product or a computer program, which includes a computer instruction stored in a computer-readable storage medium. The processor of the computer device reads the computer instruction from the computer-readable storage medium, and the processor executes the computer instruction, so that the computer device executes the method for processing the operation data of the machine tool device described in the above various optional implementations.

[0114] The above embodiments are only used to illustrate the technical solutions of the present application, rather than to limit it. Although the present application has been described in detail with reference to the aforementioned embodiments, a person skilled in the art should understand that the technical solutions described in the aforementioned embodiments can still be modified, or some of the technical features can be replaced by equivalents. However, these modifications or replacements do not cause the essence of the corresponding technical solutions to deviate from the spirit and scope of the technical solutions of the embodiments of the present application.

Claims

1. A method for processing machine tool equipment operation data, characterized in that: Applied to an operation data processing system, the operation data processing system includes an edge gateway and a time series database, and the method includes: Obtain measurement data of machine tools in operation; Determining high-frequency measurement data and low-frequency measurement data corresponding to the machine tool equipment in the measurement data; Based on the acquisition module in the edge gateway, the high-frequency measurement data and the low-frequency measurement data are respectively collected according to the preset acquisition frequency; The high-frequency measurement data and the low-frequency measurement data are cached, compressed, and then transmitted to the time series database for storage, wherein the time series database stores the processed column-type storage data; After data cleaning and data conversion processing are performed on the column-type stored data, a stable data source for machine tool equipment is obtained.

2. The method for processing machine tool equipment operation data according to claim 1, characterized in that: The operation data processing system further includes a sensor, and the method for processing the operation data of the machine tool equipment further includes: Acquire target data transmitted by the sensor according to a preset monitoring cycle, wherein the sensor corresponding to each part of the machine tool equipment is registered to the monitoring device of the edge gateway; If the target data is not received for a preset time threshold, reestablishing the connection between the monitoring device and the sensor; When the monitoring device fails to connect to the sensor after a preset number of connections, the data corresponding to the sensor in the queue of the edge gateway is removed from the time series database.

3. The method for processing machine tool equipment operation data according to claim 1, characterized in that: The caching and compressing the high-frequency measurement data and the low-frequency measurement data and then transmitting them to the time series database for storage includes: Before transmitting to the edge gateway, caching and compressing the high-frequency measurement data and the low-frequency measurement data to obtain first processed data; The first processed data is transmitted to the time series database for storage using the 4G communication protocol and the message queue telemetry transmission protocol.

4. The method for processing machine tool equipment operation data according to claim 1, characterized in that: The time series database generates corresponding time series for the stored data.

5. The method for processing machine tool equipment operation data according to claim 4, characterized in that: The step of performing data cleaning and data conversion on the column-type stored data to obtain a stable data source for machine tool equipment includes: Based on the time series, the column-type stored data is identified for missing values ​​and filled, deleted or retained to obtain first column-type stored data; Based on the time series, duplicate data in the first column-type stored data is detected, and the duplicate data is deleted or merged to obtain a stable data source for the machine tool equipment.

6. The method for processing machine tool equipment operation data according to claim 2, characterized in that: The method for processing machine tool equipment operation data also includes: When the monitoring device fails to connect to the sensor after a preset number of connections, the sensor is determined to be abnormal and an early warning prompt is triggered.

7. The method for processing machine tool equipment operation data according to claim 2, characterized in that: The method for processing machine tool equipment operation data further includes: A visual display is provided for each link of obtaining the stable data source of the machine tool equipment, including: displaying the target data of the sensor monitored by the monitoring device of the edge gateway, the measurement data associated with the target data, the high-frequency measurement data, the low-frequency measurement data, the column storage data and the stable data source of the machine tool equipment.

8. A device for processing machine tool equipment operation data, characterized in that: Applied to an operation data processing system, the operation data processing system includes an edge gateway and a time series database, and the device includes: An acquisition module is used to acquire measurement data of the machine tool equipment in operation; A determination module, used to determine the high-frequency measurement data and the low-frequency measurement data corresponding to the machine tool equipment in the measurement data; A collection module, used to collect the high-frequency measurement data and the low-frequency measurement data respectively according to a preset collection frequency based on the collection module in the edge gateway; A storage module, used to cache and compress the high-frequency measurement data and the low-frequency measurement data and transmit them to the time series database for storage, wherein the time series database stores the processed column storage data; The processing module is used to perform data cleaning and data conversion on the column-type stored data to obtain a stable data source for machine tool equipment.

9. An electronic device, characterized in that: The electronic device includes a memory and a processor, the memory stores program codes that can be run on the processor, and when the program codes are executed by the processor, the method for processing machine tool equipment operation data according to any one of claims 1 to 7 is implemented.

10. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores program codes, and the program codes can be called by one or more processors to execute the method for processing machine tool equipment operation data according to any one of claims 1 to 7.

Images