Research On The Application Of Data Warehouse In The Expressway Transportation Volume Statistics Analysis

With the operating of networked expressway toll collection system, a huge number ofhistory data has been generated. Using these data can provide us indicator data based mainlyon transportation volume in the field of transportation. We can combine volume of traffic andtransportation in order to know completely about the operation of expressway, and exactlyconfirm the status and influence on comprehensive transportation system. Then we canprovide decision-marking basis for expressway administration. These are the key problems.Base on the research of Data Warehouse, Online Analytical Processing, transportationvolume indicator and history data of networked expressway toll collection system, andcombined with the demand of expressway transportation volume statistics analysis, the thesisput forward an expressway transportation volume statistics analysis scheme based on datawarehouse technology, online analytical processing as the means, design of the overallstructure, and detailed design of the data warehouse scheme and theETL(Extraction-Transformation-Loading) scheme. Took the networked expressway tollcollection system van data from Jiangxi and Hubei province for example, Used the SQLServer2008database platform to make data warehouse scheme, ETL scheme and onlineanalytical services of the specific implementation, thus realized the expressway transportationvolume statistics analysis scheme prototype. The establishment of data warehouse forms theunified data model and the data center. The making of online analytical services converts thestar model of organization data that stores in data warehouse into Cube, formed themulti-dimensional analysis model. Use online analytical tool with multi-dimensional analysismethod to extract the data from the founded data warehouse, multi-dimensional analysis hasbeen realized at the same time we gained the original accurate results.The research based on the real history data from networked expressway toll collectionsystem, improve the utilization rate of history data and informationization level of expresswaytransportation volume statistics analysis, then the working personnel can analyze expresswayoperating conditions interactively, multi-angle, multi-level, speed up the results-getting andimprove the efficiency of analysis, find the hidden information easily, serve for theexpressway administration decision-making. The establishing data warehouse method hasstrong operability and the establishment of expressway transportation volume statisticsanalysis scheme based on data warehouse has strongly practical value.