Application And Research Of OLAP In The Educational Administration Management System

With the fast development of information technology and scale of higher education, every university has set up the MIS of educational administration. It have heightened the level of educational administration management to a great extent, and has accumulated a large amount of data, by use of MIS in succession. But the MIS can't offer the function analyzed with profound level to the data, it makes administrative staff be unable to receive and understand the relevant information in time, and the leader can't get practical data support while making decision.The development of data warehouse technology and popularize of OLAP tools make the problem of detached island of information hopeful to be solved, it has offered a whole solution for the multi-dimension analysis of realizing the data.This thesis analyzes the existing MIS of educational administration deeply on the basis of the data warehouse and OLAP research, has designed ETL tool and set up the data centre , utilizes OLAP tool to set up the multidimensional analysis system of educational administration. The system mainly including CET-4 analysis, analysis of the workload of teaching, students register analysis, the selected lesson analysis, graduating management analysis , teaching plan analysis etc..The groundwork of the thesis lies in the design and extraction the data of data warehouse. I have used the redundant design in the design of the data warehouse theme, it help the theme construction and designing of multi-dimension analysis. I have Designed the EIS template, it make the design of multi-dimension analysis become further simple, and have accelerated the construction speed of the multi-dimension analysis system.I Have designed a function multi-dimension analysis system, it record the information of each function, such as frequency of utilization , response time , service time etc.. while using the subsystem, then analyze the data have collected, it help developer to optimize the system.It has improved the management level of the educational administration and realized the intelligent scientific process with decision of educational administration management.