Vehicle unloading data cleaning method, storage medium and equipment

Abstract

The invention discloses a vehicle unloading data cleaning method, a storage medium and equipment, and belongs to the technical field of industrial internet of things data processing. Uncleaned vehicle unloading data are grouped into pre-established data-unloading position groups to distinguish fragment record data of the same vehicle and continuous record data of different vehicles, then the working state of each data-unloading position group is determined according to a preset cleaning strategy, and finally a database is updated according to the working states of the different data-unloading position groups. Data merging can be accurately carried out, and the problem that data are seriously distorted due to the fact that recorded data of operating vehicles in the same parking space are easily merged wrongly in a traditional data cleaning method is solved.

Description

Technical Field

[0001] This invention relates to a method, storage medium, and equipment for cleaning vehicle unloading data, belonging to the field of industrial Internet of Things data processing technology. Background Technology

[0002] In current logistics parks or large factories, a large number of loading and unloading vehicles are engaged in loading and unloading operations. These vehicles need to be parked in designated loading and unloading spaces for operation. Typically, the system uses cameras to automatically identify the license plates of vehicles parked in the loading and unloading spaces and continuously tracks the vehicles' location status, thereby generating a large number of data records arranged in chronological order. These records are important basis for analyzing operational efficiency, parking space occupancy, vehicle scheduling, and calculating related costs.

[0003] A single, complete unloading process for the same vehicle may be broken down into multiple records with adjacent times by the system. Traditional methods cannot correctly stitch these records together into a single complete record. For example, if a vehicle unloads at a loading dock for an extended period, the monitoring equipment can only record one data point per minute, ultimately resulting in a large amount of fragmented data with continuous times. Furthermore, when different vehicles use the same loading dock consecutively, their records are sequential, and traditional methods easily lead to incorrect merging of records from consecutive vehicles, resulting in severe data distortion. Summary of the Invention

[0004] The purpose of this invention is to overcome the shortcomings of the prior art and provide a method, storage medium and equipment for cleaning vehicle unloading data. This method can distinguish between fragmented data recorded by the same vehicle and continuous data recorded by different vehicles, and accurately merge the data. This solves the problem that traditional data cleaning methods are prone to erroneously merging data recorded by vehicles operating in the same parking space, resulting in serious data distortion.

[0005] To solve the above-mentioned technical problems, the present invention is implemented using the following technical solution: This invention provides a method for cleaning vehicle unloading data, comprising: Retrieve the vehicle unloading location identifier, vehicle identification information, and timestamp from the database corresponding to the unloading data of uncleaned vehicles; Based on vehicle unloading location identifiers, vehicle identity information, and timestamps, unwashed vehicle unloading data are grouped into pre-established data-unloading location groups to distinguish fragmented data from the same vehicle from continuous data from different vehicles. According to the preset cleaning strategy, determine the working status of each data-unloading position group; Update the database based on the working status of different data-unloading location groups.

[0006] Furthermore, the method for establishing the data-unloading location group includes: Vehicle unloading data that meet the same grouping criteria in the database are grouped into the same group and sorted by timestamp to obtain the data-unloading location group; Create a new data-unloading location group, and group vehicle unloading data that do not meet the same grouping criteria into the new data-unloading location group; The unloading data of vehicles in the unloading location group that has been grouped and ended has been labeled "cleaned".

[0007] Furthermore, before grouping vehicle unloading data that meet the same grouping conditions in the database into the same group, it is also necessary to filter out valid vehicle identity information. The method for filtering out valid vehicle identity information includes: If the vehicle identification information corresponding to the vehicle unloading data meets the license plate number format, then the vehicle identification information is valid.

[0008] Furthermore, the same grouping condition includes: Vehicle unloading data with identical unloading location identifiers and vehicle identification information are grouped into the same group and sorted by timestamp order, with the time interval between the timestamp of the last unloading vehicle and the end of the current group being less than a preset time period.

[0009] Furthermore, the preset time period is between 30 and 60 seconds.

[0010] Furthermore, the preset cleaning strategy includes: Get the timestamp and current server time corresponding to the unloading data of the last vehicle in each grouped data-unloading location group; If the difference between the timestamp and the current server time is less than a preset threshold, the unloading task corresponding to the vehicle unloading data is not completed. The start time, vehicle unloading position identifier and vehicle identity information of the unloading task corresponding to the vehicle unloading data are recorded in the database, while the operation duration and end time of the unloading task corresponding to the vehicle unloading data are left blank. Otherwise, the unloading task corresponding to the vehicle's unloading data has been completed.

[0011] Furthermore, updating the database based on the working status of different data-unloading position groups includes: If the current data-unloading location group's work status is incomplete, then search the database for incomplete records associated with the current data-unloading location group; If there are associated incomplete records, compare the start time of the unloading task corresponding to the current data - unloading location group with the start time of the unloading task corresponding to the incomplete record, and retain the earlier start time of the unloading task. If no related incomplete record exists, then add an incomplete record based on the current data - unloading location group's working status.

[0012] Furthermore, updating the database based on the working status of different data-unloading location groups also includes: If the current data-unloading location group's work status is completed, then search the database for incomplete records associated with the current data-unloading location group; If there are associated incomplete records, the unloading task operation time is calculated based on the timestamp corresponding to the unloading data of the last vehicle in the current data unloading position group. The unloading task operation time and timestamp corresponding to the unloading data of the last vehicle in the current data unloading position group are used to fill in the unloading task operation time and end time left blank in the incomplete records. Update incomplete records to complete records; If there are no associated incomplete records, calculate the unloading task duration based on the timestamp corresponding to the unloading data of the last vehicle in the current data unloading position group, and add a new completed record.

[0013] Another aspect of the present invention provides a computer-readable storage medium having a computer program stored thereon, which, when executed by a processor, implements the vehicle unloading data cleaning method described above.

[0014] The present invention also provides a computer device, comprising: Memory, used to store instructions; A processor is configured to execute the instructions, causing the device to perform the vehicle unloading data cleaning method described above.

[0015] Compared with the prior art, the beneficial effects achieved by the present invention are as follows: This invention uses vehicle unloading location identifiers, vehicle identity information, and timestamps corresponding to unwashed vehicle unloading data in a database to group unwashed vehicle unloading data into pre-established data-unloading location groups. This distinguishes between fragmented records of the same vehicle and continuous records of different vehicles. Then, according to a preset cleaning strategy, the working status of each data-unloading location group is determined. Finally, the database is updated based on the working status of different data-unloading location groups, which can accurately merge data and solves the problem that traditional data cleaning methods easily merge records of vehicles operating at the same location incorrectly, leading to serious data distortion. Attached Figure Description

[0016] Figure 1 This is a flowchart of a vehicle unloading data cleaning method provided in an embodiment of the present invention; Figure 2 This is a flowchart for determining the working status of each data-unloading position group provided in an embodiment of the present invention; Figure 3 This is a flowchart of updating the database provided in an embodiment of the present invention; (Current data - unloading position group working status is incomplete) Figure 4 This is a flowchart of the database update process provided in an embodiment of the present invention. (Current data - unloading position group working status is completed) Detailed Implementation

[0017] The present invention will be further described below with reference to the accompanying drawings. The following embodiments are only used to more clearly illustrate the technical solution of the present invention, and should not be used to limit the scope of protection of the present invention. Example 1

[0018] like Figure 1 As shown, this embodiment 1 provides a method for cleaning vehicle unloading data, including: Retrieve the vehicle unloading location identifier, vehicle identification information, and timestamp from the database corresponding to the unloading data of uncleaned vehicles; In this embodiment, the vehicle identity information is the vehicle license plate number, which is captured by cameras around the unloading area. To avoid situations where the vehicle license plate number cannot be recognized, such as "garbled characters", it is first necessary to filter out valid vehicle identity information. Specifically: if the vehicle identity information corresponding to the vehicle unloading data meets the license plate number format, the vehicle identity information is valid; otherwise, the vehicle unloading data is filtered out.

[0019] Based on vehicle unloading location identifiers, vehicle identity information, and timestamps, unwashed vehicle unloading data are grouped into pre-established data-unloading location groups to distinguish fragmented data from the same vehicle from continuous data from different vehicles. The methods for establishing data-unloading location groups include: Vehicle unloading data that meet the same grouping criteria in the database are grouped into the same group and sorted by timestamp to obtain the data-unloading location group; Create a new data-unloading location group, and group vehicle unloading data that do not meet the same grouping criteria into the new data-unloading location group; The unloading data of vehicles in the unloading location group that has been grouped and ended has been labeled "cleaned". The same grouping conditions include: Vehicles with identical unloading location identifiers and vehicle identification information are grouped together and sorted by timestamp. The time interval between the timestamp of the last unloading vehicle and the end of the current group is less than a preset time period. The preset time period is between 30 and 60 seconds. In this embodiment, the preset time period is 60 seconds. If the vehicle identity information corresponding to the unwashed vehicle unloading data already exists in the existing data-unloading position group, and the time interval between the timestamp of the unwashed vehicle unloading data and the timestamp of the last washed vehicle unloading data in the existing data-unloading position group is less than 60 seconds, then the unwashed vehicle unloading data meets the same grouping conditions of "identical license plate" and "continuous time", and the unwashed vehicle unloading data is assigned to the existing data-unloading position group. If the unloading data of uncleaned vehicles does not meet the same grouping conditions of "identical license plate" and "continuous time", then a new data-unloading location group will be created starting from the unloading data of the uncleaned vehicle.

[0020] According to the preset cleaning strategy, determine the working status of each data-unloading location group; specifically: like Figure 2 As shown, the preset cleaning strategy includes: Get the timestamp and current server time corresponding to the unloading data of the last vehicle in each grouped data-unloading location group; If the difference between the timestamp and the current server time is less than a preset threshold, the unloading task corresponding to the vehicle unloading data is not completed. The start time, vehicle unloading position identifier and vehicle identity information of the unloading task corresponding to the vehicle unloading data are recorded in the database, while the operation duration and end time of the unloading task corresponding to the vehicle unloading data are left blank. In this embodiment, the preset threshold value is 120 seconds; Otherwise, the unloading task corresponding to the vehicle's unloading data has been completed.

[0021] like Figure 3 As shown, if the current data-unloading location group's working status is incomplete, then search the database for incomplete records associated with the current data-unloading location group; If there are associated incomplete records, compare the start time of the unloading task corresponding to the current data - unloading location group with the start time of the unloading task corresponding to the incomplete record, and retain the earlier start time of the unloading task. If there are no associated incomplete records, then add an incomplete record based on the current data - unloading location group's working status; like Figure 4 As shown, if the current data-unloading location group's work status is "completed", then search the database for incomplete records associated with the current data-unloading location group; If there are associated incomplete records, the unloading task operation time is calculated based on the timestamp corresponding to the unloading data of the last vehicle in the current data unloading position group. The unloading task operation time and timestamp corresponding to the unloading data of the last vehicle in the current data unloading position group are used to fill in the unloading task operation time and end time left blank in the incomplete records. Update incomplete records to complete records; If there are no associated incomplete records, calculate the unloading task duration based on the timestamp corresponding to the unloading data of the last vehicle in the current data unloading position group, and add a new completed record. Example 2

[0022] This embodiment 2 provides a computer-readable storage medium storing a computer program thereon, which, when executed by a processor, implements the following method steps: Retrieve the vehicle unloading location identifier, vehicle identification information, and timestamp from the database corresponding to the unloading data of uncleaned vehicles; Based on vehicle unloading location identifiers, vehicle identity information, and timestamps, unwashed vehicle unloading data are grouped into pre-established data-unloading location groups to distinguish fragmented data from the same vehicle from continuous data from different vehicles. According to the preset cleaning strategy, determine the working status of each data-unloading position group; Update the database based on the working status of different data-unloading location groups. Example 3

[0023] This embodiment 3 provides a computer device, including: Memory, used to store instructions; A processor, used to execute instructions that cause a device to perform the following method steps: Retrieve the vehicle unloading location identifier, vehicle identification information, and timestamp from the database corresponding to the unloading data of uncleaned vehicles; Based on vehicle unloading location identifiers, vehicle identity information, and timestamps, unwashed vehicle unloading data are grouped into pre-established data-unloading location groups to distinguish fragmented data from the same vehicle from continuous data from different vehicles. According to the preset cleaning strategy, determine the working status of each data-unloading position group; Update the database based on the working status of different data-unloading location groups.

[0024] Those skilled in the art will understand that embodiments of this application can be provided as methods, apparatus, or computer program products. Therefore, this application can take the form of a completely hardware embodiment, a completely software embodiment, or an embodiment combining software and hardware aspects. Furthermore, this application can take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage CD-ROMs, optical storage, etc.) containing computer-usable program code.

[0025] This application is described with reference to flowchart illustrations of methods, apparatus (systems), and computer program products according to embodiments of this application. It should be understood that each step in the flowchart can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, special-purpose computer, embedded processor, or other programmable data processing device to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing device, generate instructions for implementing the process. Figure 1 One or more processes or boxes Figure 1 A device that provides the functions specified in one or more boxes.

[0026] These computer program instructions may also be stored in a computer-readable storage medium that can direct a computer or other programmable data processing device to function in a particular manner, such that the instructions stored in the computer-readable storage medium produce an article of manufacture including instruction means, which are implemented in a process Figure 1 The function specified in one or more processes.

[0027] These computer program instructions may also be loaded onto a computer or other programmable data processing equipment to cause a series of operational steps to be performed on the computer or other programmable equipment to produce a computer-implemented process, thereby providing instructions that execute on the computer or other programmable equipment for implementing the process. Figure 1 Steps of a specified function in one or more processes.

[0028] The embodiments of the present invention have been described above with reference to the accompanying drawings. However, the present invention is not limited to the specific embodiments described above. The specific embodiments described above are merely illustrative and not restrictive. Those skilled in the art can make many other forms under the guidance of the present invention without departing from the spirit and scope of the claims. All of these forms are within the protection scope of the present invention.

Claims

1. A method for cleaning vehicle unloading data, characterized in that, include: Retrieve the vehicle unloading location identifier, vehicle identification information, and timestamp from the database corresponding to the unloading data of uncleaned vehicles; Based on vehicle unloading location identifiers, vehicle identity information, and timestamps, unwashed vehicle unloading data are grouped into pre-established data-unloading location groups to distinguish fragmented data from the same vehicle from continuous data from different vehicles. According to the preset cleaning strategy, determine the working status of each data-unloading position group; Update the database based on the working status of different data-unloading location groups.

2. The vehicle unloading data cleaning method according to claim 1, characterized in that, The method for establishing the data-unloading location group includes: Vehicle unloading data that meet the same grouping criteria in the database are grouped into the same group and sorted by timestamp to obtain the data-unloading location group; Create a new data-unloading location group, and group vehicle unloading data that do not meet the same grouping criteria into the new data-unloading location group; The unloading data of vehicles in the unloading location group that has been grouped and ended has been labeled "cleaned".

3. The vehicle unloading data cleaning method according to claim 2, characterized in that, Before grouping vehicle unloading data that meet the same grouping conditions in the database into the same group, it is also necessary to filter out the valid vehicle identity information. The method for filtering out valid vehicle identity information includes: If the vehicle identification information corresponding to the vehicle unloading data meets the license plate number format, then the vehicle identification information is valid.

4. The vehicle unloading data cleaning method according to claim 2, characterized in that, The same grouping conditions include: Vehicle unloading data with identical unloading location identifiers and vehicle identification information are grouped into the same group and sorted by timestamp order, with the time interval between the timestamp of the last unloading vehicle and the end of the current group being less than a preset time period.

5. The vehicle unloading data cleaning method according to claim 4, characterized in that, The preset time period is between 30 and 60 seconds.

6. The vehicle unloading data cleaning method according to claim 2, characterized in that, The preset cleaning strategy includes: Get the timestamp and current server time corresponding to the unloading data of the last vehicle in each grouped data-unloading location group; If the difference between the timestamp and the current server time is less than a preset threshold, the unloading task corresponding to the vehicle unloading data is not completed. The start time, vehicle unloading position identifier and vehicle identity information of the unloading task corresponding to the vehicle unloading data are recorded in the database, while the operation duration and end time of the unloading task corresponding to the vehicle unloading data are left blank. Otherwise, the unloading task corresponding to the vehicle's unloading data has been completed.

7. The vehicle unloading data cleaning method according to claim 6, characterized in that, The process of updating the database based on the working status of different data-unloading location groups includes: If the current data-unloading location group's work status is incomplete, then search the database for incomplete records associated with the current data-unloading location group; If there are associated incomplete records, compare the start time of the unloading task corresponding to the current data - unloading location group with the start time of the unloading task corresponding to the incomplete record, and retain the earlier start time of the unloading task. If no related incomplete record exists, then add an incomplete record based on the current data - unloading location group's working status.

8. The vehicle unloading data cleaning method according to claim 6, characterized in that, The method of updating the database based on the working status of different data-unloading location groups also includes: If the current data-unloading location group's work status is completed, then search the database for incomplete records associated with the current data-unloading location group; If there are associated incomplete records, the unloading task operation time is calculated based on the timestamp corresponding to the unloading data of the last vehicle in the current data unloading position group. The unloading task operation time and timestamp corresponding to the unloading data of the last vehicle in the current data unloading position group are used to fill in the unloading task operation time and end time left blank in the incomplete records. Update incomplete records to complete records; If there are no associated incomplete records, calculate the unloading task duration based on the timestamp corresponding to the unloading data of the last vehicle in the current data unloading position group, and add a new completed record.

9. A computer-readable storage medium having a computer program stored thereon, characterized in that, When the computer program is executed by the processor, it implements the vehicle unloading data cleaning method as described in any one of claims 1 to 8.

10. A computer device, characterized in that, include: Memory, used to store instructions; A processor is configured to execute the instructions, causing the device to perform the vehicle unloading data cleaning method as described in any one of claims 1 to 8.

Images