Method for judgment and statistics of vehicle beyond bounds by a storage process

Abstract

The invention discloses a method which is used for the storage process and realizes the determining and accounting for vehicles which cross the border. A service centre which comprises a service layer, a data layer and a network layer is established, all the operations of the service layer and the network layer of the service centre to a data base in the data layer are realized through a storage process, the network layer of the service centre stores the data uploaded by a vehicle terminal into the driving data sheet in the data base of the data layer after the data is analyzed, the service layer stores the definite regional parameters logged by a vehicle manager in a definite regional sheet in the data base, when the service center receives determining and accounting for the vehicles which cross the border of a vehicle manager, the service center determines whether the vehicle crosses the border, and accounts the vehicle border crossing condition. The invention realizes that the border crossing state of tracing points of large scale vehicles is accounted in the data base, further accounts the border crossing frequency, the border crossing time span and the driving distance during the border crossing period, then returns the statistical result to the service layer, the purposes for improving the speed and reducing the date transmission quantity are achieved, therefore, the system processing time is shortened.

Description

technical field [0001] The invention relates to a vehicle statistics method, in particular to a method for realizing vehicle cross-border judgment and statistics by using stored procedures. Background technique [0002] Area crossing means that the vehicle's driving trajectory exceeds the limited area, and it is one of the assessment indicators for evaluating vehicle driving and driver driving performance. Counting the number of vehicle crossings, the duration of crossing the boundary, and the driving distance during the crossing period, the management of vehicles and the evaluation of drivers provide a quantitative indicator, which is conducive to the efficient management of vehicles and drivers. In the existing vehicle management method, the vehicle manager can use the driving data regularly uploaded by the vehicle platform to judge and count the vehicle's crossing state according to the given limited area. The operation of data in the database can be realized through app...

AI Technical Summary

Problems solved by technology

However, for SQL Server 2000 and previous versions, only SQL language can be used to write stored procedures. When the data operation is more complicated, especially when each piece of data needs to be processed one by one, the operation speed is relatively slow, and the writing of statements is also very complicated.

Images