Application Study Of Data Warehouse And OLAP Technology Analysis In The Management And Analysis Of Highway Toll Data

In recent years, with the rapid development of the highway charging business, a mass of data has been accumulated in the management of highway charging business. How to give an effective analysis to these data, and get knowledge to direct the business decision, has already been the key in competition for enterprises. The development of DW, OLAP offers an effective way. However, at present, successful samples and systematic research results in employment of DW in highway data analysis have not been achieved. Under this circumstance, the thesis designs an analysis system for highway charging business based on investigation in the data management of highway charging business and also the analytical technology of DW and OLAP.The thesis mainly focuses on the following parts.Firstly, it introduces the basis design of DW and the technology of OLAP.Secondly, it analyzes the features of the charging data and function and main operation process of the charging business for carrying out the analysis system, which based on the survey and study of the highway charging business operation.Thirdly, the thesis investigates the multi-dimension, model-making technology, and further elaborates realization and design of analytical sub-system for operation of highway charging business. It expounds the design and realization of the specific plan upon three aspects: data storing layer, data acquiring layer and data accessing layer. The storing layer adopts the DW technology, which is oriented to the subject, and designs the substantive connections of the DW concept model, star chart of logic model, and factual form of physics model, table construction of the multi-dimension and the total relationship. On data acquiring layer, it designs ETL programmer and formulated the transformation tactics, and fulfills the transformation and loading of drawing data. The data-accessing layer adopts an analysis form called OLAP.In the end, the essay gives a whole summary to the thesis, and prospect to the development orientation of data analysis technology of DW.