The Construction Of The Data Source System For The OLAP Analysis Based On The Ordinary Primary School Supervisory Assessment System

The third session of the national basic education proposed "to explore the establishment of a modern school management system, to establish a development, management and monitoring mechanisms of school centered by the government and covered every community to participate in, encouraging the community and parents to participate in the school management, actively support the reform and development of the basic education." According to these, relevant government functional departments and each level of government actor very important roles and bear relevant responsibilities in promoting the building of the modern school system.Evaluation is an important management tool for modern education, education evaluation process is a scientific and orderly management process, the "normative and developing"-type mode of operation process in the supervision evaluation of primary and secondary school is also a process to strengthen the school management.However, the existing supervision evaluation process is based on the evaluation of the program throughout the development of business process done by hand. It has a lot of operational limitations and analysis limitations.Against of these limitations, this subject designed a multi-dimensional data model of the data warehouse system, it also used implemented the data warehouse system physically by the Microsoft's business Intelligent tools,by the tools, it realized the data extraction - transform - load (ETL) process of the dimension tables and the fact tables, finally, it used an OLAP server-Mondrian implemented the multi-dimensional analysis model and the comprehensive display of the data in the data warehouse. In the use of the multidimensional analysis model to oversee the evaluation results, it will do the analysis from the evaluation program perspective, school district perspective, the school-level perspective, evaluator perspective, the historical evaluation results of the school perspective and so on, the final comprehensive analysis Results will be used for the education sector supervising and guidance the development of the schools.