The Architecture and Design Strategy for Data Warehouse of Highway Management

In the modern times, the highway management needs better information supporting system to connect all these Online Transaction Processing Systems, to meet the integrated data analysis need of scientific management. Because of the deficiencies of traditional data management information system, the data warehouse technology has been used to organize and analysis the massive datas and provide a basis decision-making supporting. Combination of the highway management practices, in this paper the provincial highway management data warehouse architecture was constructed and the data model design method and strategy were put forward, and the subject, data granularity of data warehouse for highway management were analysised. In finally the meta-data organize and its implementation program were discussed. With the application of data warehouse technology in highway management, which will promote the analysis of management decision-making of China's highway modernization, scientific and information process.