Data Warehouse In The National School Construction Planning Information Management System Application

Along with the education system reform of education planning system and the continuous improvement of the education planning and development of national education has become the core contents and key steps, formulate suitable for China’s national conditions of education planning scheme appears very important. Efficient education plan formulation need comprehensive information support. This article from education planning, combining with business characteristics of data warehouse and OLAP technology the ETL multi-dimension data analysis technology in the national school construction planning information management system, the application of ETL related technology and OLAP multi-dimension data analysis technology and these techniques in the national school construction planning application of information management system was discussed in the paper.Education planning in China face years of the process of accumulating down huge amounts of, complex and erratic education planning history business data, through the ETL technology will these data according to certain rules of extraction, loading and conversion, make history with the education planning service data, and then through the data characteristics of multi-dimension data analysis technology of OLAP through the ETL "clean" data analysis of a multi-angle, multi-level and display, so as to achieve the hidden useful information, let education planners from overall to the local education planning the whole grasp. According to the education planning process characteristics of business data, design the corresponding ETL model and multi-dimension data Analysis model, based on DotNefNuke framework and Microsoft SQL Server2008, with the order Services for the national education planning Services for realizing the main function of the information management system.