| Most of the traditional database management system is designated for simple data processing, which can't provide the corresponding information for policy makers. Data warehouse and OLAP technology that make up for the inadequacies of the existing database systems, integrity extensive collection of data to the data warehouse, and extract useful information from the operation, so that policy makers can acquire knowledge and insight, thereby improve the quality and efficiency of decision-making.The subject in the thesis applies the concept of the data warehouse and OLAP technology to students score analysis system. With the analysis of a separate subject analysis of results between subjects and many straddling ,combination students of the school management and teaching applications and other data analysis, the author of the shesis studied students attitude, cognitive ability, teachers and the teaching of various aspects teaching management ,and provide a reliable basis for decision-making.This paper presents research on a data warehouse and on-line analytical processing technology principles of Data Warehouse Development architecture,data organization development process and model design technology,and gives a detailed explanation of OLAP multidimensional data structure framework storage structure and analysis method, and the differences between ROLAP and MOLAP. With analysis of results for the theme to students storage structure based on star model, the author designated the concept and logic model of the data warehouse separately. Finally by using SQL Server 2000 to complete construction of multidimensional database, rolling and slice technology to analysis score data from different angles by Delphi Decision cube, and showing the analysis results by visualization components DecisionGraph, teaching management staffs ensure understanding of visual analysis and controlling the decision-making information, therefore making out better school development of strategies and policies. |
PDF Full Text Request