The Application Of Data Warehouse In Gansu Post Freight Settlement System

With the improvement of science and technology, enterprise development is more dependent on Information Technology, more and more data are generated in the production and business systems within the information technology. However, due to the construction of branches or different departments of information technology is not unity, these data can’t reflect the value and provide the data samples or support for the manager of enterprise. Establishment of a database, to use data analysis and data mining technology, enable to solve the difficulties, make the decision managers and business department more clearly know the current enterprise running state and the future trend of development.This thesis first introduced the concept of the database and basic characteristics,detailed introduces of the architecture, database storage ways and related technologies, the design of the database modeling method and the common data model.Then, the freight settlement system of Gansupost use freight settlement work which in the practical project as an example, analyzed in details of the business needs of the enterprise whose faceing, combined with the postal business production the characteristics of the system, proposed the concept of the theme for building a database. Through ETL data processing technology of database, settle the data analysis of the structure statistical freight. Using the application of data extraction, conversion, loading and online analysis technology, we design process of the freight and settlement system database. Discuss the use of database model, combined with the actual system business needs to show statistical reporting and analysis results.The freight settlement system of Gansupostuse Data warehouse technology, filling the blank of information construction in database and data mining of Gansupostsupporting the services of the management, profit and loss to provide effective accounting decision for enterprise, Played a good role in the development of the ehterprise’s future development goals, improve economic efficiency of enterprises.