Study On Gps-based Speeding Regularity Multidimensional Analysis Of Commercial Vehicles

Speeding is one of the main causes of traffic accidents. How to make scientific management of vehicle speed is an important problem facing the management department. Based on analyzing the current research status of vehicle speed, it is pointed out that rely mainly on human and expensive hardware equipments for vehicle speeding data acquisition. The analysis for vehicle speed relies mainly on the experience, lack of sufficient data and advanced technical support. So managers cannot to conduct diversification, multi-level and multi-angle analysis, lead to the decision lacks pertinence and effectiveness.According to the above-mentioned problems, the paper provide basis for vehicle speed analysis based on the GPS device and GPS data, in order to realize the targeted for vehicle speed auxiliary management.GPS data as papers will be based on analysis of vehicle speed. Paper's research clues are speeding data acquisition and processing, the overall solutions, speeding data warehouse model research, OLAP multi-dimension data design, data warehouse and multi-dimension data updates. For speeding alarm data, the paper realizing speeding data pretreatment use nearest point estimated map matching. Combining the demand of road transportation security administration departments for speeding analysis, a general solution to multidimensional analysis of vehicle speeding is presented according to the design thought of economics, rationality, stability, maneuverability and maintainability.Aiming at the key problems which need to be solved in the general solution, a universal data extractor is designed in the article in terms of the current data environment and data traits of the transportation management sectors. The paper researched the model of data warehouse and OLAP database, including the study on the speeding data granularity, speeding data based on granularity of generalized, choose the minimal granularity as data grand. Then, the star-snowflake model of the data warehouse is constructed and physically realized.Based on the data warehouse model, a cube was created for speeding analysis, and the road, enterprise and time were choosing as the dimension of cube. Finally, the practical application of the environment, the paper studied the method and procedure of data warehouse update, then improved the existing update method of multi-dimension. This paper puts forward the multi-dimension data cube updating method based on optimal time model.Finally, OLAP system for Chongqing City's roadway transportation safety management is developed and realized with the application of the achievements in the above research, using the vehicle alarm data collected by the GPS monitoring system in Chongqing. This system is of significance in supporting the improvement of the scientific in actual transportation management and decision-making.