Engine operation data recording and analyzing method and system
Through the classification storage and analysis method of Influxdb timing database, the problems of large amount of engine operation data collection and high storage demand are solved, effective data recording and analysis are realized, storage and transmission costs are reduced, and data integrity and utilization value are guaranteed.
Patent Information
- Application Number
- CN202411707371.3
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-11-27
- Publication Date
- 2024-12-27
- Estimated Expiration
- Not applicable · inactive patent
AI Technical Summary
The engine operating data is collected in large quantities and high frequency. It is easily restricted by network speed and wireless signals when uploading directly to the cloud. The storage demand for on-board equipment is huge, which increases costs.
Using Influxdb timing database, the data is divided into different types and stored in a classified manner by setting rules, different recording frequency and storage cycles are set, and engine operation data is collected and analyzed in real time, reducing storage requirements, and uploading the processed data to the cloud to avoid Wireless signal transmission restrictions.
Effectively record and save engine high-frequency data, reduce storage capacity requirements, ensure data integrity, and avoid wireless signal transmission restrictions by reducing upload frequency, reduce costs, and ensure data utilization value.
Smart Images

Figure CN119201865A_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the technical field of engine measurement and control, and in particular to a method and system for recording and analyzing engine operation data. Background Art
[0002] The statements in this section merely provide background information related to the present invention and do not necessarily constitute prior art.
[0003] As an energy conversion device, the engine can convert fuel energy and other forms of energy into mechanical energy. It is widely used in various fields such as automobiles, ships, and engineering machinery. As an energy supply device, maintaining the normal and stable operation of the engine is an important prerequisite for ensuring the normal operation of various machines. Therefore, it is necessary to record and analyze the engine operation data to facilitate its maintenance.
[0004] During engine operation, a large amount of data often needs to be recorded at a high frequency, and the collected data is usually stored and recorded by the machine-side equipment. With the development of cloud technology, the demand for remote data transmission and big data analysis is increasing, and it is necessary to store and upload the engine operation data to the cloud. However, the amount of data collected during engine operation is large and the frequency is high. If all the data is uploaded directly to the cloud, it is easily limited by the network speed and wireless signal. Once the wireless signal is lost, the data will not be uploaded, and it is difficult to ensure the integrity of the data record; secondly, if all the data is recorded in the machine-side equipment, and a large amount of high-frequency data requires a very large storage space, this will greatly increase the cost of the machine-side equipment and is not suitable for field applications. Summary of the invention
[0005] In order to solve the deficiencies of the above-mentioned prior art, the present invention provides an engine operation data recording and analysis method and system, applies the Influxdb time series database to the engine field, records and analyzes the engine operation data, classifies and stores the collected data by setting rules, and sets different recording frequencies and storage periods for different data. It can record and save the effective high-frequency data of engine operation to ensure the integrity of data records and reduce storage capacity requirements at the same time, and can also statistically analyze the data and send the analyzed and processed data to the cloud server to avoid the problem of wireless signal transmission limitations.
[0006] In a first aspect, the present invention provides a method for recording and analyzing engine operation data.
[0007] A method for recording and analyzing engine operation data, wherein the engine and the sensors installed thereon are electrically connected to a control device, an Influxdb client program is installed in the control device and executed, and the engine operation data is recorded and analyzed. The method comprises: Collect engine operation data in real time, and record and store the collected data in the Influxdb time series database according to the set rules; the set rules are: divide the real-time collected engine operation data into multiple types of data, and classify and store them in the corresponding storage areas divided by the Influxdb time series database; different types of storage areas are set with different recording frequencies and storage periods; Perform logical judgment on the data stored in different types of storage areas and upload the logical judgment results to the remote cloud server.
[0008] In a second aspect, the present invention provides an engine operation data recording and analysis system.
[0009] An engine operation data recording and analysis system includes a control device; the control device is electrically connected to the engine and a sensor installed thereon, an Influxdb client program is installed in the control device and executed, and the control device includes: The data classification storage module is used to collect engine operation data in real time, and record and store the collected data in the Influxdb time series database according to the set rules; the set rules are: the real-time collected engine operation data is divided into multiple types of data, and classified and stored in the corresponding storage areas divided by the Influxdb time series database; wherein different types of storage areas are set with different recording frequencies and storage periods; The data processing and uploading module is used to perform logical judgment on the data stored in different types of storage areas and upload the logical judgment results to the remote cloud server.
[0010] In a third aspect, the present invention further provides an electronic device comprising a memory and a processor, and computer instructions stored in the memory and executed on the processor, wherein when the computer instructions are executed by the processor, the steps of the method described in the first aspect are completed.
[0011] In a fourth aspect, the present invention further provides a computer-readable storage medium for storing computer instructions, which, when executed by a processor, complete the steps of the method described in the first aspect.
[0012] One or more of the above technical solutions have the following beneficial effects: 1. The present invention provides an engine operation data recording and analysis method and system, which applies the Influxdb time series database to the engine field, writes the engine data into the Influxdb database, and the Influxdb client program is installed in the control device next to the engine. The control device acts as an edge terminal device to transmit data with the cloud server; the Influxdb database collects high-frequency data during the operation of the engine in real time, and classifies the original data into low-frequency data and statistical data by setting rules, so as to complete the classification recording and storage of the data, and can record and save the effective high-frequency data of the engine operation for engine operation fault analysis; at the same time, different recording frequencies and storage periods are set for different data, which can minimize the requirements for storage space and storage capacity, reduce costs and ensure that valuable data is effectively used.
[0013] 2. The present invention statistically analyzes the data after classification and storage. When the network condition is good, the analyzed and processed data is sent to the cloud server by reducing the sending frequency to avoid the problem of wireless signal transmission limitation; when the network condition is poor, the processed data is stored in the edge terminal device to avoid data loss and ensure the integrity of data records. BRIEF DESCRIPTION OF THE DRAWINGS
[0014] The accompanying drawings in the specification, which constitute a part of the present invention, are used to provide a further understanding of the present invention. The exemplary embodiments of the present invention and their descriptions are used to explain the present invention and do not constitute improper limitations on the present invention.
[0015] Figure 1 It is a schematic diagram of recording and analyzing operating data during engine operation in an embodiment of the present invention. DETAILED DESCRIPTION
[0016] It should be noted that the following detailed descriptions are exemplary only, are intended to describe specific embodiments, are intended to provide further explanation of the present invention, and are not intended to limit exemplary embodiments according to the present invention. Unless otherwise specified, all technical and scientific terms used herein have the same meanings as those of ordinary skill in the art to which the present invention belongs. In addition, it should also be understood that when the terms "comprising" and / or "including" are used in this specification, it indicates the presence of features, steps, operations, devices, components and / or combinations thereof.
[0017] Embodiment 1 To solve the problems pointed out in the background technology, the present embodiment provides an engine operation data recording and analysis method, in which the engine data is written into the Influxdb database (a type of time series database), and the Influxdb client program is installed in the control device next to the engine, and the control device acts as an edge terminal device to transmit data with the cloud server; the Influxdb database collects high-frequency data during the operation of the engine in real time, and classifies and stores the collected data by setting rules, and sets different recording frequencies and storage periods for different data. It can not only record and save the effective high-frequency data of the engine, but also reduce the storage capacity requirements, and can also statistically analyze the data, and send the processed data to the cloud server to avoid the problem of wireless signal transmission limitations.
[0018] The engine operation data recording and analysis method proposed in this embodiment is based on the Influxdb database, which stores data by category, sets the storage time by category, and performs real-time aggregation operations on the data. The above characteristics are used to process the data and complete the recording and analysis of the engine operation data. Specifically, the engine and the sensors installed on it are electrically connected to the control device, and the Influxdb client program is installed and executed in the control device to record and analyze the engine operation data. The method includes: Collect engine operation data in real time, and record and store the collected data in the Influxdb time series database according to the set rules; the set rules are: divide the real-time collected engine operation data into multiple types of data, and classify and store them in the corresponding storage areas divided by the Influxdb time series database; different types of storage areas are set with different recording frequencies and storage periods; Perform logical judgment on the data stored in different types of storage areas and upload the logical judgment results to the remote cloud server.
[0019] In this embodiment, the engine status data detected by sensors (such as temperature sensors, pressure sensors, speed sensors, etc.) are written into the influxdb database, and the influxdb client program is installed in the control device next to the engine, and the control device is used as an edge terminal device to transmit data with the cloud server. Specifically, the engine operation data is collected in real time, and the real-time collected engine operation data is divided into multiple types of data, and classified and stored in the corresponding storage area divided by the Influxdb time series database. Among them, the engine operation data includes engine status data and engine speed data, and the engine status data includes temperature data and pressure data; the real-time collected engine operation data is processed and divided into: engine status original data, temperature data, temperature 10s average data, temperature 10s difference data, temperature 30min average data, pressure data, pressure 5s average data, pressure 5s difference data, engine speed original data, speed 1s average data, speed 1s difference data, speed 3s average data, speed 3s difference data, a total of 13 types of data, these data are typical data of engine operation, convenient for subsequent data processing and viewing.
[0020] At the same time, in the Influxdb time series database, 13 storage areas (i.e., buckets) corresponding to the above 13 types of data are divided to store the corresponding types of data. Figure 1 As shown, each box represents a storage bucket, which is used to classify and store data to facilitate data processing.
[0021] Furthermore, each storage area stores data of the corresponding type, and the recording frequency (i.e., storage frequency) of the storage area is inversely proportional to the retention period, i.e., the higher the recording frequency, the shorter the retention period is set. By storing and releasing data in different situations according to different data types and different recording frequencies, the required data can be effectively stored while avoiding the problem of requiring a large storage space. Specifically, the data stored in each storage bucket is: First, the engine status raw data and engine speed raw data are high-frequency raw data collected in real time during engine operation. The engine status raw data are divided into temperature data and pressure data, and these high-frequency data are directly recorded and stored in the corresponding storage space, including: (1) The "Engine Status Raw Data" bucket is used to store the raw high-frequency data of all engine status collected in real time during the operation of the engine. These data are not processed by any calculations and remain in the original record state. The data is recorded every 1 second and the retention period is set to 1 month. Data older than 1 month is automatically deleted to avoid the problem of requiring a large amount of storage space. When the engine fails or data analysis is required, the data can be directly retrieved or viewed from this bucket.
[0022] (2) The "Temperature Data" bucket is used to store all raw high-frequency temperature data collected in real time during the operation of the transmitter. The data is recorded every 1 second and the retention period is set to 1 month. Data older than 1 month will be automatically deleted.
[0023] (3) The "pressure data" bucket is used to store all the raw high-frequency pressure data collected in real time during the operation of the transmitter. The data is recorded every 1 second and the storage time is set to 1 month. Data older than 1 month will be automatically deleted.
[0024] (4) For the engine, the speed data is particularly important. Therefore, the "engine speed raw data" storage bucket is used to store all the original speed values collected in real time during the operation of the engine. The data is recorded every 10ms and is kept for 1 month. Data older than 1 month is automatically deleted.
[0025] Secondly, based on the temperature data, the low-frequency 10s temperature average data, 10s temperature difference data, and 30min temperature average data are calculated and stored in the corresponding storage space; based on the pressure data, the low-frequency 5s pressure average data and 5s pressure difference data are calculated and stored in the corresponding storage space; based on the original engine speed data, the low-frequency 1s speed average data, 1s speed difference data, 3s speed average data, and 3s speed difference data are calculated and stored in the corresponding storage space. The specific analysis is: (5) Calculate the average value of the data in the "temperature data" bucket every 10 seconds, and then record and store the calculated data in the "temperature 10s average value data" bucket. The data is recorded every 10 seconds and the storage period is set to 1 year.
[0026] (6) Perform a subtraction operation on two adjacent data in the "10s temperature average data" storage bucket (subtract the previous data from the latter data), and then save the difference in the "10s temperature difference data" storage bucket. The data in the "10s temperature difference data" storage bucket is used to judge the temperature change in real time to achieve the purpose of temperature warning. The data is recorded every 10 seconds and the storage time is set to 1 year.
[0027] (7) Calculate the average value of the data in the "temperature data" bucket every 30 minutes, and then save the calculated data to the "temperature 30-minute average value data" bucket. The data in the "temperature 30-minute average value data" bucket is used to count the engine's operating conditions over a long period of time. The data is recorded every 30 minutes and the storage period is set to 3 years.
[0028] (8) The data in the "pressure data" bucket is averaged every 5 seconds, and then the calculated data is saved in the "pressure 5s average data" bucket. The data is recorded every 5 seconds and the storage period is set to 1 year.
[0029] (9) Perform a subtraction operation on two adjacent data in the "pressure 5s average data" storage bucket (subtract the previous data from the latter data), and then save the difference in the "pressure 5s difference data" storage bucket. The data in the "pressure 5s difference data" storage bucket is used to judge the pressure change in real time to achieve the purpose of pressure warning. The data is recorded every 5 seconds and the storage time is set to 1 year.
[0030] (10) The data in the "engine speed raw data" bucket is averaged every 1 second, and then the calculated data is saved in the "speed 1s average data" bucket. The data is recorded every 1 second and the storage period is set to 1 year.
[0031] (11) Subtract two adjacent data in the "1s average speed data" storage bucket (subtract the previous data from the latter data), and then save the difference in the "1s difference speed data" storage bucket. The data in the "1s difference speed data" storage bucket is used to judge the speed change in real time and to judge the transient change of the engine. The data is recorded every 1s and the storage time is set to 1 year.
[0032] (12) The data in the "engine speed raw data" bucket is averaged every 3 seconds, and then the calculated data is saved in the "speed 3s average data" bucket. The data is recorded every 3 seconds and the storage period is set to 1 year.
[0033] (13) Subtract two adjacent data in the "3s average speed data" bucket (subtract the previous data from the latter data), and then save the difference in the "3s difference speed data" bucket. The data in the "3s difference speed data" bucket is used to determine the starting and stopping conditions, and is used for statistical analysis and fault diagnosis. The data is recorded every 3 seconds and the storage time is set to 1 year.
[0034] Through the above data processing method, according to the characteristics and needs of the engine operation data, the data storage frequency is divided into 6 categories: 10ms / time, 1s / time, 3s / time, 5s / time, 10s / time, and 30min / time. On the one hand, the original data can be classified into low-frequency data and statistical data according to the set rules to complete the classification, recording and storage of the data. On the other hand, different recording frequencies and storage periods are set for different data. The higher the recording frequency, the shorter the storage period. In this way, while ensuring the effective storage of data, the requirements for storage space and storage capacity can be minimized, reducing costs while ensuring the effective use of valuable data.
[0035] Furthermore, after all data is classified and stored in the corresponding storage buckets, logical judgment is performed and the processing results are sent to the cloud server. By uploading after analysis, the frequency of transmission can be reduced again, and the limitation of wireless signal transmission can be avoided while ensuring the acquisition of valid data, and the data analysis and processing and status monitoring of the cloud server are not affected. The above logical judgment is specifically: compare the temperature 10s difference data, pressure 5s difference data, speed 1s difference data, speed 3s difference data with the corresponding set thresholds, and generate the logical judgment results to be uploaded according to the comparison results. Figure 1 As shown, the round box represents the logical judgment results that need to be uploaded, which are divided into 7 types: temperature increase warning, pressure increase warning, pressure reduction warning, sudden speed drop, sudden speed increase, start, stop (or parking).
[0036] The judgment logic for each upload result is: (1) When the data in the "Temperature 10s difference data" bucket is greater than 2°C, it means that the temperature has an increasing trend. At this time, the temperature value has not reached the alarm limit, and a temperature increase warning needs to be issued.
[0037] (2) When the data in the "Pressure 5s difference data" storage bucket is greater than 50 kPa, it indicates that the pressure has an increasing trend. At this time, the pressure value has not reached the alarm limit, and a pressure increase warning needs to be issued.
[0038] (3) When the data in the "Pressure 5s difference data" storage bucket is less than -50 kPa, it means that the pressure has a decreasing trend. At this time, the pressure value has not reached the alarm limit, and a pressure reduction warning needs to be issued.
[0039] (4) When the data in the "speed 1s difference data" storage bucket is less than -20 rpm (revolutions / minute), it indicates that the speed has a tendency to drop suddenly, and a speed drop prompt needs to be issued.
[0040] (5) When the data in the "speed 1s difference data" storage bucket is greater than 20 rpm, it indicates that the speed has a tendency to increase suddenly, and a speed sudden increase prompt needs to be issued.
[0041] (6) Compare the two adjacent data in the "3s speed difference data" storage bucket. The data with the previous timestamp is "data point 1" and the data with the next timestamp is "data point 2". When the value of data point 1 is equal to 0 and the value of data point 2 is greater than 100 rpm, it means that the engine is in the starting state. At this time, a starting condition prompt needs to be issued.
[0042] (7) Compare the two adjacent data in the "3s speed difference data" storage bucket. The data with the previous timestamp is "data point 1" and the data with the next timestamp is "data point 2". When the value of data point 1 is less than -100 rpm and the value of data point 2 is equal to 0, it means that the engine has stopped from the running state. At this time, a stop condition prompt needs to be issued.
[0043] By analyzing and processing data in real time and only sending the processing results to the cloud server, the size of wirelessly transmitted data can be reduced and the problem of wireless signal transmission limitations can be avoided. Preferably, when the network condition is poor, the processed data can be stored in the edge terminal device to avoid data loss and ensure the integrity of the data record. When the network condition improves, the processing results can be sent to the cloud server for subsequent data analysis and processing.
[0044] Embodiment 2 This embodiment provides an engine operation data recording and analysis system, which includes a control device, the control device is electrically connected to the engine and a sensor installed thereon, and an Influxdb client program is installed and executed in the control device. The control device includes: The data classification storage module is used to collect engine operation data in real time, and record and store the collected data in the Influxdb time series database according to the set rules; the set rules are: the real-time collected engine operation data is divided into multiple types of data, and classified and stored in the corresponding storage areas divided by the Influxdb time series database; wherein different types of storage areas are set with different recording frequencies and storage periods; The data processing and uploading module is used to perform logical judgment on the data stored in different types of storage areas and upload the logical judgment results to the remote cloud server.
[0045] Embodiment 3 This embodiment provides an electronic device, including a memory and a processor, and computer instructions stored in the memory and running on the processor. When the computer instructions are run by the processor, the steps in the engine operation data recording and analysis method as described above are completed.
[0046] Embodiment 4 This embodiment also provides a computer-readable storage medium for storing computer instructions. When the computer instructions are executed by a processor, the steps in the engine operation data recording and analysis method as described above are completed.
[0047] The steps involved in the above embodiments 2 to 4 correspond to the method embodiment 1, and the specific implementation methods can refer to the relevant description part of embodiment 1. The term "computer-readable storage medium" should be understood as a single medium or multiple media including one or more instruction sets; it should also be understood to include any medium that can store, encode or carry an instruction set for execution by a processor and enable the processor to execute any method in the present invention.
[0048] Those skilled in the art should understand that the modules or steps of the present invention described above can be implemented by a general-purpose computer device, or alternatively, they can be implemented by a program code executable by a computing device, so that they can be stored in a storage device and executed by the computing device, or they can be made into individual integrated circuit modules, or multiple modules or steps therein can be made into a single integrated circuit module for implementation. The present invention is not limited to any specific combination of hardware and software.
[0049] The above description is only a preferred embodiment of the present invention. Although the specific implementation mode of the present invention is described in conjunction with the accompanying drawings, it is not a limitation of the protection scope of the present invention. Those skilled in the art should understand that on the basis of the technical solution of the present invention, various modifications or variations that can be made by those skilled in the art without creative work are still within the protection scope of the present invention.
Claims
1. A method for recording and analyzing engine operation data, characterized in that: The engine and the sensors installed thereon are electrically connected to the control device. The Influxdb client program is installed and executed in the control device to record and analyze the engine operation data. The method includes: Collect engine operation data in real time, and record and store the collected data in the Influxdb time series database according to the set rules; the set rules are: divide the real-time collected engine operation data into multiple types of data, and classify and store them in the corresponding storage areas divided by the Influxdb time series database; different types of storage areas are set with different recording frequencies and storage periods; Perform logical judgment on the data stored in different types of storage areas and upload the logical judgment results to the remote cloud server.
2. The engine operation data recording and analysis method according to claim 1, characterized in that: The engine operation data collected in real time is processed and divided into: engine status raw data, temperature data, 10s temperature average data, 10s temperature difference data, 30min temperature average data, pressure data, 5s pressure average data, 5s pressure difference data, engine speed raw data, 1s speed average data, 1s speed difference data, 3s speed average data, 3s speed difference data, a total of 13 types of data.
3. The engine operation data recording and analysis method according to claim 2, characterized in that: In the Influxdb time series database, 13 storage areas corresponding to 13 types of data are divided to store the corresponding types of data.
4. The engine operation data recording and analysis method according to claim 2, characterized in that: The engine operation data includes engine status data and engine speed data; The engine status raw data and the engine speed raw data are high-frequency raw data collected in real time during the operation of the engine. The engine status raw data is divided into temperature data and pressure data, and the high-frequency data is directly recorded and stored in the corresponding storage space; Based on the temperature data, the low-frequency temperature 10s average value data, the temperature 10s difference data, and the temperature 30min average value data are calculated respectively, and then the low-frequency data is stored in the corresponding storage space; Based on the pressure data, the low-frequency pressure 5s average value data and the pressure 5s difference data are calculated respectively, and then the low-frequency data is stored in the corresponding storage space; Based on the original data of engine speed, the low-frequency 1s speed average data, 1s speed difference data, 3s speed average data, and 3s speed difference data are calculated respectively, and then the low-frequency data is stored in the corresponding storage space.
5. The engine operation data recording and analysis method according to claim 1, characterized in that: The recording frequency of the set storage area is inversely proportional to the preservation period.
6. The engine operation data recording and analysis method according to claim 1, characterized in that: Perform logical judgment on data stored in different types of storage areas, including: Compare the temperature 10s difference data, pressure 5s difference data, speed 1s difference data, and speed 3s difference data with the corresponding set thresholds, and generate the logic judgment results to be uploaded according to the comparison results; The logic judgment results include: temperature increase warning, pressure increase warning, pressure reduction warning, sudden speed drop, sudden speed increase, start, and stop.
7. An engine operation data recording and analysis system, characterized in that: The control device includes a control device, the control device is electrically connected to the engine and the sensor installed thereon, the Influxdb client program is installed and executed in the control device, and the control device includes: The data classification storage module is used to collect engine operation data in real time, and record and store the collected data in the Influxdb time series database according to the set rules; the set rules are: the real-time collected engine operation data is divided into multiple types of data, and classified and stored in the corresponding storage areas divided by the Influxdb time series database; wherein different types of storage areas are set with different recording frequencies and storage periods; The data processing and uploading module is used to perform logical judgment on the data stored in different types of storage areas and upload the logical judgment results to the remote cloud server.
8. The engine operation data recording and analysis system according to claim 7, characterized in that: The recording frequency of the set storage area is inversely proportional to the preservation period.
9. An electronic device, characterized in that: The method comprises a memory and a processor, and computer instructions stored in the memory and executed on the processor. When the computer instructions are executed by the processor, the steps of an engine operation data recording and analysis method as claimed in any one of claims 1 to 6 are completed.
10. A computer-readable storage medium, characterized in that: Used to store computer instructions, which, when executed by a processor, complete the steps of an engine operation data recording and analysis method as described in any one of claims 1-6.
Citation Information
Patent Citations
Time series database based cluster type body-building management system and implementation method thereof
CN108538360A
InfluxDB-based cluster data monitoring method
CN112162896A
Deep learning training duration prediction management method, device and equipment
CN115511186A
Method and system for managing time series data by data lake and electronic equipment
CN118170818A