CN114299634A - Method for judging abnormality of transmission data of automobile networking equipment - Google Patents

Abstract

The invention discloses a method for judging abnormality of transmission data of an automobile network connection device. The car is communicated and connected with the car networking platform through the networking equipment, and the car networking platform is provided with a car information database; the method of the present invention includes: presetting an inspection time period, and obtaining the car operation data records recorded in the inspection time period from the car information database. ;For the car running data records, the data records with the same engine speed data of the same car in a continuous period of time are aggregated to obtain the same car speed time duration; a time duration upper limit threshold is preset to determine whether the same car speed time duration exceeds the upper limit of the duration Threshold, if it is, it is determined that the transmission data of the connected equipment of the car in the continuous time period is abnormal; the data transmission data of the connected equipment of the connected car of the car in the continuous time period that is determined to be abnormal is aggregated and set to form an abnormal data transmission table. The abnormality judging method of the present invention can efficiently and accurately judge the data records abnormally transmitted by the car network equipment.

Description

Method for determining abnormality of data transmitted by car network equipment

technical field

The invention relates to an automobile network connection technology, in particular to a method for determining abnormality of transmission data of an automobile network connection device.

Background technique

The Internet of Vehicles technology refers to the realization of the network connection between vehicles, vehicles, people, roads, and service platforms with the help of the new generation of information and communication technology, taking the moving car as the information perception object, improving the overall intelligent driving level of the vehicle, and providing users Provide safe, comfortable, intelligent and efficient driving experience and traffic services, while improving the efficiency of traffic operation and improving the intelligence level of social traffic services. As a cutting-edge application of 5G and big data technology, the Internet of Vehicles has played a key role in promoting the process of automobile intelligence.

As the hardware foundation for realizing the application of the Internet of Vehicles, the car must be equipped with connected equipment, and the vehicle can realize wireless network communication connection with the Internet of Vehicles platform through the connected equipment, so that various application technologies of the Internet of Vehicles can be realized. However, in the actual application process, due to various conditions such as electronic signal interference, signal disconnection, device stuck, abnormal program operation, etc., abnormal situations will occur in the connected devices on the car, which affects various applications of the Internet of Vehicles. , thereby causing great trouble to the car user and reducing the user's car experience. At present, there is no good method to efficiently and accurately determine the abnormality of the data transmission of the car network equipment.

SUMMARY OF THE INVENTION

The purpose of the present invention is to provide a method for judging abnormality of data transmitted by an automobile network connected device, which can efficiently and accurately determine the abnormally transmitted data records of the automobile network connected device.

In order to realize above-mentioned technical purpose, the present invention adopts following technical scheme:

A method for judging abnormality of data transmitted by a car networking device, the car realizes data communication connection with a car networking platform through the car networking device, and the car networking platform is provided with a car information database;

The abnormality determination method includes the following steps:

Step 1, pre-set the investigation time period, and obtain the vehicle operation data records recorded in the investigation time period from the automobile information database;

Step 2, for the read vehicle running data records, summarize the data records of the same vehicle with the same engine speed data in a continuous period of time, and obtain the same vehicle and same rotation speed duration;

Step 3: Preset a duration upper limit threshold, determine whether the duration of the same-vehicle simultaneous rotation speed exceeds the duration upper limit threshold, and if so, determine that the data transmission of the car's network-connected device is abnormal in the continuous time period.

Further, the step 1 includes: according to a preset investigation time period, screening the data record upload date and data record upload time of the car operation data record table DS0 stored in the car information database, and set the data record upload date and time in the The data records in the investigation time period are filtered out, so as to obtain the vehicle operation data records recorded in the investigation time period, and the obtained vehicle operation data records are aggregated to form a first data record table DS1.

Further, the step 1 further includes: presetting an abnormal rotation speed threshold, and filtering out the data records in which the engine rotation speed exceeds the abnormal rotation speed threshold in the first data recording table DS1.

Further, the step 2 includes:

Step 2.1, arranging the first data record table DS1, taking the vehicle number as the first sorting field, and taking the data record upload time as the second sorting field, reordering and sorting the data records in the first data record table DS1 , take the sorted data record table as the second data record table DS2;

Step 2.2, add a data field based on the second data record table DS2, thereby constitute the third data record table DS3, and the added data field is a serial number;

Step 2.3, adding a data field on the basis of the third data record table DS3, thereby forming the fourth data record table DS4, the added data field is a grouping condition code, and the value of the grouping condition code is the data record upload time minus The value of the product of the serial number and the data collection cycle time;

Step 2.4, on the basis of the fourth data record table DS4, a data field is added to form a fifth data record table DS5, and the increased data field is the number of group records, and the data records in the fifth data record table DS5 are processed. Merge and summary processing, merge and summarize the data records with the same vehicle number, engine speed, and grouping condition code data into one data record, and use the number of merged and summarized data records as the value of the number of grouped records of the merged data record;

Step 2.5, on the basis of the fifth data record table DS5, a data field is added, thereby forming the sixth data record table DS6, the added data field is the same vehicle and the same rotation speed duration, and the value of the same vehicle and same rotation speed duration is the group record. The product of the number and the data acquisition cycle time.

Further, the step 3 includes: comparing the value of the duration of the same vehicle with the same rotation speed in the sixth data recording table DS6 with the upper limit threshold of the duration, and judging whether the duration of the same vehicle rotation at the same speed exceeds the upper limit threshold of the duration, and if so, it is determined that the The data transmission of the connected device of the car in the continuous time period is abnormal, otherwise it is determined that the data transmission of the connected device of the car in the continuous time period is normal.

Further, the abnormality determination method also includes:

Step 4: A summary set of the transmission data of the network-connected devices of the car in the continuous time period in which the abnormality is determined is formed to form an abnormal data transmission table.

Further, the checking time period is set to one day.

In the abnormality determination method of the present invention, by analyzing the vehicle running data records recorded in the vehicle information database, the data records of the same vehicle with the same engine speed data in a continuous time period are summarized. If the duration is longer, it is determined that the data transmitted by the connected device of the car in the continuous time period is abnormal.

Compared with the prior art, the abnormality determination method of the present invention has the beneficial effect that the abnormality determination method of the present invention can efficiently and accurately determine the abnormally transmitted data of the car networking equipment. Software and model algorithms will no longer call abnormal data records to participate in operations, thus improving the operating efficiency of the entire IoV platform and the accuracy of data processing.

Description of drawings

FIG. 1 is a flow chart of a method for determining abnormality of data transmitted by an automobile network connected device according to the present invention.

Detailed ways

The present invention will be further described below in conjunction with the accompanying drawings and specific embodiments:

This embodiment provides a method for determining the abnormality of data transmitted by a connected vehicle device. The abnormality determination method analyzes and judges the vehicle operation data records recorded in the vehicle information database in the connected vehicle platform, so as to determine the abnormal transmission of the connected vehicle device. data.

The IoV platform is a cloud data platform (running in a server) established by an automobile manufacturer. The IoV platform is provided with a car information database and a series of software and model algorithms surrounding the car information database. The car information database adopts the clickhouse database.

The cars produced by the automobile manufacturers are all equipped with connected equipment, and the car can realize data communication connection with the Internet of Vehicles platform through the connected equipment. The obtained vehicle running data is stored in the vehicle running data record table DS0 in the vehicle information database in the form of data records. The data records stored in the vehicle operation data record table DS0 are called vehicle operation data records. The vehicle operation data record table DS0 stores all vehicle operation data, which can be queried in time when executing algorithms or using software applications.

The data fields in the vehicle operation data record table DS0 include vehicle number, engine speed, data record upload time, data record upload date, ambient temperature, battery voltage, coolant temperature, fuel temperature, current fault information, and exhaust flow. , etc. There are hundreds of commonly used data fields, and there are more than 20,000 spare fields. The data in these data fields record the operating conditions of the car. The car networking platform can analyze the car or car through the combination of these data fields. Whether the parts are running normally, it can also be analyzed whether the car is running in the most economical design range, and the driver's driving behavior can also be analyzed, etc., so that car manufacturers can provide good after-sales service for car owners.

In this embodiment, in order to ensure the smooth implementation of the abnormality determination method, an abnormality information database is set up on the basis of the original car information database of the Internet of Vehicles platform, and the abnormality information database is used to cooperate with the abnormality determination method of this embodiment. specific implementation. The abnormal information database adopts the mysql database.

In addition, a method execution program is added to the Internet of Vehicles platform, and the method execution program specifically executes the abnormality determination method of this embodiment.

Referring to FIG. 1, the abnormality determination method of this embodiment includes the following steps:

In step 1, an investigation time period is preset, and the vehicle operation data records recorded in the investigation time period are obtained from the vehicle operation data record table DS0 in the vehicle information database.

This step 1 includes the following specific processes:

According to the pre-set investigation time period, filter the data field "data record upload date" of the car operation data record table DS0 stored in the car information database, and filter out the data records whose data record upload date is within the investigation time period, so as to Obtain the vehicle operation data records recorded during the troubleshooting period.

Only the data of four data fields are retained for the obtained vehicle operation data records, the four data fields are "vehicle number", "engine speed", "data record upload time" and "data record upload date", and the remaining data fields are The data is discarded, and then the filtered data is recorded in the abnormal information database to form a first data record table DS1.

In this embodiment, the investigation time period is set to one day, that is, 24 hours.

In addition, in order to avoid abnormal mutation values in the data records caused by the interference of external noise signals, some abnormal data records can also be filtered out by means of data filtering. In this embodiment, an abnormal speed threshold is preset, and the abnormal speed threshold is used to filter the data field "engine speed" in the first data record table DS1, and the data records whose engine speed exceeds the abnormal speed threshold are filtered out. In this embodiment, the abnormal rotation speed threshold is set to 6000 rpm.

It should be noted that, in other embodiments, when filtering according to the investigation time period, the data record upload date and time obtained by combining the data fields "data record upload time" and "data record upload date" may also be filtered.

Step 2: For the read vehicle operation data records, the data records of the same vehicle with the same engine speed data in consecutive time periods are aggregated, so as to obtain the same vehicle and same rotation speed duration.

The duration of the same rotation speed in the same vehicle refers to the duration of the continuous time period in which the rotation speed data of the same vehicle engine is the same.

This step 2 includes the following specific processes:

Step 2.1, in the abnormal information database, sort out the first data record table DS1, take the vehicle number as the first sort field, take the data record upload time as the second sort field, and sort the data in the first data record table DS1. The data records are rearranged, and the sorted data record table is used as the second data record table DS2.

Step 2.2, in the abnormal information database, a data field named "serial number" is added based on the second data record table DS2, thereby forming a third data record table DS3.

The sequence number is the sequence number of all data records in the third data record table DS3, and the sequence number is a natural number starting from 1.

Step 2.3, in the abnormal information database, add a data field named "grouping condition code" on the basis of the third data record table DS3, thereby forming the fourth data record table DS4, each entry in the fourth data record table DS4. The value of the grouping condition code of the data record is the value of the data record upload time minus the product of the serial number and the data collection cycle time, which is expressed as: data record upload time - serial number × data collection cycle time. The data collection cycle time refers to the periodic interval time during which the network-connected device obtains and sends the vehicle operation data.

Step 2.4, in the abnormal information database, add a data field named "number of grouped records" on the basis of the fourth data record table DS4, thereby forming the fifth data record table DS5, and then to the fifth data record table DS5. The data records in DS5 are merged and summarized, and the data records with the same vehicle number, engine speed, and grouping condition code data are merged and summarized into one data record, and the number of merged and summarized data records is used as the data field of the merged data record. Numerical value for "Number of Grouped Records".

Step 2.5, in the abnormal information database, add a data field named "same vehicle speed duration" on the basis of the fifth data record table DS5, thereby forming the sixth data record table DS6, in the sixth data record table DS6 The value of the time duration of the same vehicle and the same rotation speed of each data record is the product of the number of grouped records and the data collection cycle time, which is expressed as: the number of grouped records × the data collection cycle time.

Step 3: Preset a duration upper limit threshold, determine whether the duration of the same-vehicle rotation at the same time exceeds the duration upper limit threshold, and if so, determine that the transmission data of the car's network-connected device in the continuous time period is abnormal, otherwise determine that the continuous time The network-connected devices of the cars in the segment transmit data normally.

This step 3 includes the following specific processes:

Compare the value of the data field "same-vehicle with the same rotation speed duration" in the data record in the sixth data record table DS6 with the upper limit threshold of the duration, and judge whether the duration of the same vehicle at the same rotation speed exceeds the upper limit of the duration, and if so, determine the The data transmission of the connected device of the car in the continuous time period is abnormal, otherwise, it is determined that the data transmission of the connected device of the car in the continuous time period is normal.

Step 4: Summarize and set the transmission data of the car's connected equipment in the continuous time period in which the abnormality is determined to form an abnormal data transmission table, and store the abnormal data transmission table in the Internet of Vehicles platform for other software on the Internet of Vehicles platform. and model algorithms to read the data.

This step 4 includes the following specific processes:

The data records in the sixth data recording table DS6 are screened according to the upper limit of the duration, and the data records whose duration is greater than the upper limit of the duration of the same vehicle are screened out to form a seventh data recording table DS7. The seventh data recording table DS7 can be used as an exception data transfer table.

The software and model algorithms on the Internet of Vehicles platform are based on the abnormal data transmission table. During the data call operation, some abnormal data records in the car information database can be cleaned and screened, and abnormal data records are no longer called to participate in the operation. In this way, the operation efficiency of the entire Internet of Vehicles platform and the accuracy of data operation and processing can be improved.

The abnormality determination method of this embodiment is based on the principle that the engine speed cannot be kept constant during the normal driving of the vehicle. If it remains unchanged for a continuous period of time, then the data transmitted in this continuous period of time must be abnormal data, so that it can be further determined that there is an abnormal situation in the connected equipment of the car.

Based on the above principles, in the abnormality determination method of this embodiment, by analyzing the vehicle operation data records recorded in the vehicle information database, the data records with the same engine speed data in a continuous time period of the same vehicle are summarized, If the same duration of the engine speed data is longer, it is determined that the data transmitted by the network-connected device of the car in the continuous time period is abnormal.

The abnormality determination method of this embodiment has the advantage that: by using the abnormality determination method of this embodiment, it is possible to efficiently and accurately determine the abnormally transmitted data of the car network equipment, and after cleaning and screening the data that is determined to be abnormally transmitted, the vehicle Other software and model algorithms on the networking platform will no longer call abnormal data records to participate in operations, thereby improving the operating efficiency of the entire IoV platform and the accuracy of data processing. In addition, when analyzing and judging the abnormally transmitted data of the network-connected device, it is only necessary to analyze the engine speed, so there is no need to process a large amount of data, and the abnormality judgment efficiency is high.

A specific example is provided below:

In this embodiment, the car operation data record table DS0 in the car information database is shown in Table 1 (for the convenience of description, only four fields are listed in the table):

Table 1: Vehicle Operation Data Record Sheet DS0

On the basis of the original car information database of the Internet of Vehicles platform, an exception information database is added.

The steps of this embodiment are as follows:

1), pre-set the 24-hour inspection time period on November 16, 2021, and obtain the vehicle operation data records recorded within 24 hours a day on November 16, 2021 from the vehicle operation data record table DS0 in the vehicle information database.

Specifically, use "2021-11-16" to filter the data field "data record upload date" of the car operation data record table DS0 stored in the car information database, and set the data record upload date as "2021-11-16" The data records are filtered out to obtain the vehicle operation data records recorded on November 16, 2021.

Only the data of four data fields are retained for the obtained vehicle operation data records, the four data fields are "vehicle number", "engine speed", "data record upload time" and "data record upload date", and the remaining data fields are The data is discarded, and then the filtered data is recorded in the abnormal information database to form a first data record table DS1.

In order to avoid abnormal sudden changes in data records caused by external noise signal interference, an abnormal speed threshold of 6000rpm is preset, and the abnormal speed threshold of 6000rpm is used to filter the data field "engine speed" in the first data record table DS1. Data records with engine speeds above 6000 rpm were filtered out. The obtained first data record table DS1 is shown in Table 2:

Table 2: The first data record sheet DS1

2), for the read car running data records, the data records with the same engine speed data in the same car in a continuous period of time are aggregated, so as to obtain the same car speed time duration.

Specifically, it includes the following processes:

2.1), in the abnormal information database, organize the first data record table DS1, take the vehicle number as the first sorting field, and use the data record upload time as the second sorting field, and compare the data in the first data record table DS1. The data records are rearranged, and the sorted data record table is used as the second data record table DS2. The second data record table DS2 is shown in Table 3:

Table 3: Second Data Record Table DS2

2.2) In the abnormal information database, a data field named "serial number" is added based on the second data record table DS2, thereby forming a third data record table DS3. The "serial number" can also be understood as the row number of the data record in the second data record table DS2. The third data record table DS3 is shown in Table 4:

Table 4: Third data record sheet DS3

2.3), in the abnormal information database, a data field named "grouping condition code" is added on the basis of the third data record table DS3, thereby forming the fourth data record table DS4, each of the fourth data record table DS4. The value of the grouping condition code of the data record is the value obtained by subtracting the product of the serial number and the data collection cycle time from the data record upload time, and the data collection cycle time is 1 second. The fourth data record table DS4 is shown in Table 5:

Table 5: Fourth Data Record Sheet DS4

2.4), in the abnormal information database, on the basis of the fourth data record table DS4, add a data field named "number of grouping records", thereby forming the fifth data record table DS5, and then to the fifth data record table. The data records in DS5 are merged and summarized, and the data records with the same vehicle number, engine speed, and grouping condition code data are merged and summarized into one data record, and the number of merged and summarized data records is used as the data field of the merged data record. Numerical value for "Number of Grouped Records". The fifth data record table DS5 is shown in Table 6:

Table 6: Fifth data record sheet DS5

2.5), in the abnormal information database, on the basis of the fifth data record table DS5, add a data field named "same speed with the same vehicle speed", thereby forming the sixth data record table DS6, in the sixth data record table DS6 The value of the time duration of the same vehicle and the same speed of each data record is the product of the number of grouped records and the data collection cycle time. The sixth data record table DS6 is shown in Table 7:

Table 7: Sixth Data Record Sheet DS6

3), pre-set a 5-second duration upper limit threshold, determine whether the duration of the same-vehicle rotation at the same speed exceeds the duration upper limit threshold, and if so, determine that the transmission data of the car's networked equipment in the continuous time period is abnormal, otherwise determine that the The connected devices of the car transmit data normally during the continuous period of time.

Specifically, compare the value of the data field "same-vehicle-same-speed duration" in the data record in the sixth data record table DS6 with the 5-second duration upper limit threshold to determine whether the same-vehicle-same-speed duration exceeds 5 seconds, and if so, determine In the continuous period of time, the data transmission of the network-connected device of the car is abnormal, otherwise, it is determined that the data transmission of the network-connected device of the car in the continuous time period is normal.

4), summarize and set the transmission data of the car's connected equipment in the continuous time period when the abnormality is determined to form an abnormal data transmission table, and store the abnormal data transmission table in the Internet of Vehicles platform for other software on the Internet of Vehicles platform. and model algorithms to read the data.

Specifically, the data records in the sixth data record table DS6 are screened according to the upper limit threshold of the duration of 5 seconds, and the data records with the same vehicle and the same rotation speed longer than 5 seconds are screened out and aggregated to form the seventh data record table DS7. Seven data record table DS7 can be used as abnormal data transmission table. The seventh data record table DS7 is shown in Table 8:

Table 8: Seventh Data Record Sheet DS7

Other software and model algorithms on the Internet of Vehicles platform filter out the vehicle operation data records in the time period recorded in the seventh data record table DS7 before running and calculating. The data is accurate and non-abnormal, and the results obtained by running the calculation will naturally not be affected by abnormal data.

The above are only preferred embodiments of the present invention, and are not intended to limit the protection scope of the present invention. Therefore, any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present invention shall be included in the present invention. within the scope of protection of the invention.

Claims (7)

1. A method for judging data transmission abnormity of automobile networking equipment is characterized in that an automobile is in data communication connection with an Internet of vehicles platform through the networking equipment, and an automobile information database is arranged on the Internet of vehicles platform;

the method is characterized in that: the abnormality determination method includes the steps of:

step 1, presetting a troubleshooting time period, and acquiring automobile operation data records recorded in the troubleshooting time period from an automobile information database;

step 2, summarizing the data records of the same automobile with the same engine speed data in continuous time periods to obtain the same-automobile same-speed duration for the read automobile running data records;

and 3, presetting a time length upper limit threshold, judging whether the time length of the same-vehicle same-rotation speed exceeds the time length upper limit threshold, and if so, judging that the data transmission of the networking equipment of the vehicle in the continuous time period is abnormal.

2. The method for determining the abnormality in the transmission data of the automobile internet device according to claim 1, characterized in that: the step 1 comprises the following steps: according to a preset investigation time period, screening the data record uploading date and the data record uploading time of an automobile operation data record table DS0 stored in an automobile information database, screening the data records with the data record uploading date and time within the investigation time period, thereby obtaining the automobile operation data records recorded within the investigation time period, and summarizing the obtained automobile operation data records to form a first data record table DS 1.

3. The method for determining the abnormality in the transmission data of the automobile internet device according to claim 2, characterized in that: the step 1 further comprises: an abnormal rotation speed threshold value is preset, and data records in the first data record table DS1, of which the engine rotation speed exceeds the abnormal rotation speed threshold value, are filtered out.

4. The method for determining the abnormality in the transmission data of the automobile internet device according to claim 2, characterized in that: the step 2 comprises the following steps:

step 2.1, sorting the first data record table DS1, taking the vehicle number as a first sorting field, taking the data record uploading time as a second sorting field, re-sorting and sorting the data records in the first data record table DS1, and taking the sorted and sorted data record table as a second data record table DS 2;

step 2.2, adding a data field based on the second data record table DS2 to form a third data record table DS3, wherein the added data field is a serial number;

step 2.3, adding a data field on the basis of the third data record table DS3 to form a fourth data record table DS4, where the added data field is a grouping condition code, and the numerical value of the grouping condition code is the product of the upload time of the data record minus the product of the serial number and the data acquisition cycle time;

step 2.4, adding a data field on the basis of the fourth data record table DS4 to form a fifth data record table DS5, wherein the added data field is the number of grouped records, merging and summarizing the data records in the fifth data record table DS5, merging and summarizing the data records with the same vehicle number, engine speed and grouped condition code data into one data record, and taking the number of the merged and summarized data records as the numerical value of the number of the grouped records of the merged data records;

and 2.5, adding a data field on the basis of the fifth data record table DS5 to form a sixth data record table DS6, wherein the added data field is the same-vehicle same-rotation-speed time length, and the value of the same-vehicle same-rotation-speed time length is the product of the number of the grouped records and the data acquisition cycle time.

5. The method for determining the abnormality in the transmission data of the automobile internet device according to claim 4, characterized in that: the step 3 comprises the following steps: and comparing the value of the same-vehicle same-rotation-speed time length in the sixth data record table DS6 with a time length upper limit threshold, judging whether the same-vehicle same-rotation-speed time length exceeds the time length upper limit threshold, if so, judging that the data transmission of the internet connection equipment of the automobile in the continuous time period is abnormal, and otherwise, judging that the data transmission of the internet connection equipment of the automobile in the continuous time period is normal.

6. The method for determining the abnormality in the transmission data of the automobile internet device according to claim 1, characterized in that: the abnormality determination method further includes:

and 4, summarizing and collecting the transmission data of the networking equipment of the automobile in the abnormal continuous time period to form an abnormal data transmission table.

7. The method for determining the abnormality in the transmission data of the automobile internet device according to claim 1, characterized in that: the troubleshooting time period is set to a time of day.

Images