Olap Technology Applied Research, Computer Grade Examination Data Analysis

Along with information technology unceasing development, Very many schools have all established a set of own management system management system, These system establishment raised the teaching management level to a great extent, But these systems only can carry on processing to some simple data, Cannot provide the corresponding decision information for the policy-maker, Data warehouse technology development and OLAP tool maturity and popular, Enables the information isolated island question to be solved hopefully, It has provided an overall solution for the realization data multi-dimensional analysis。This topic applies the data warehouse knowledge and the OLAP technology the student computer rank test result analysis system, Through to the poor and friendless household class result analysis, is carried over to the following year the result analysis and so on, Unifies the school the student management and so on other data analysis result, Studies the influence to the student which the method, cognition ability, teacher's teaching level and the teaching produce and so on various aspects to carry on the appraisal summary, Then enables the computer rank result analysis system provides the reliable basis for the teaching management and the decision-making。This article mainly introduced the data warehouse concept,Present development present situation,Key technologies,Related model establishment and so on,Detailed elaboration OLAP multi-dimensional construction of data,OLAP analysis method,Take student's computer rank test result as analysis subject,Take star mold as memory structure,Completes the multi-dimensional database through SQL server2000 the construction,Carries on the analysis from the different angle to the computer rank result,Through analysis result,Grasping decision information,Thus formulates the school development general and specific policies well。...