Instruction Data Management And Analysis System Of Changchun Foreign Languages School

With the widely use of computer, large amount of data exists in many school. Although the Data bring to us management workload, there is valuable information hidden in it. But this information is usually invisible. To uncover it, some analysis is necessary.In order to discover this useful information, we must collect and manage large amount of data, exploit the relationship and analyze the logical relations in it. The task will be on both data warehouse and OLAP.This paper attempts to collect and normalize the teaching data from Changchun Foreign Languages School, design and create data warehouse, load data into warehouse, apply OLAP technique to analyze the data. The results are very helpful to real teaching and management.In practice, the research here can not only improve the present patterns of teaching management but also help the administrative staff get the information of teaching management easily and quickly as well. Meanwhile, it can help the administrative staff analyze different situations so that they can make good strategic decisions. This research can help to solve the problems in real teaching activity and is agreed by the school authority so that its significant value in application can be proved.