Research On Application Of Teaching Management Based On Data Warehouse

In recent years, with the increasing enrollment scales in universities, some new problems arise such as fall of students' quality, lack of funds, and shortage of teachers. We find it urgent to improve management standard and quality of operation. At present, information management system, such as the student management system, teaching management system and teacher information system, has been established in some departments of a majority of universities. However, various resources of information is scattered in different departments without centralized management and organization, accumulating a large amount of historical data. It is hard for the management of the university to extract useful information for policy decisions from them. Therefore, it is a suitable way to build the data warehouse to comprehensively manage and analyze the existing data and extract the useful information, so as to help the management to make decisions and make the university more competitive.This thesis analyzes the data warehouse technology and its application, as well as the relevant technology such as Online Analytical Processing (OLAP). On the basis of existing management system a program based on data warehouse and OLAP is put forward, which is applied in university teaching management system. The thesis introduces in detail the general design of the system, including the design of conception model, logic model and physics model, the development and implement process of the system, as well as the display and analysis of results.It was indicated that the design of the system has reached the anticipated goal from the systematic operation result.