The Application And Show Of Data Warehouse And Data Statistics In Graduate Data

This article to Shandong university graduate management information system in the background, the use of data and statistics in data of the key technology for Shandong university, graduate student in a database for the model of modeling and data for statistical analysis. This article according to the various business needs of Shandong university graduate management information system, introduce the whole process of setting up data warehouse of the business needs in details, and statistic the relevant data, provides unified, accurate and stable data for education quality control and predictive to meet the needs of the query and statistic of various base data in the Shandong university graduate education.Based on the statistical data of the extraction, cleaning, conversion and loading technology (i.e. ETL process), describes the detailed student status changes for graduate students, grade analysis and employment data such as a statistical analysis of the process. According to the different needs of the business, will need data according to different conditions to carry on the data extraction, cleaning, conversion and loading. Ensure that the data in statistical analysis in the process of accuracy, consistency and stability, Will eventually business statistics produced in business data storage to the corresponding data model, so as to form the standard, unified data format, convenient the statistical analysis of the business execution speed, and improve work efficiency.In this paper, according to the actual data of Shandong University graduate student statistical analysis of the needs of the business, and analyzed the necessity of the data warehouse modeling. Secondly according to the data warehouse technologies are introduced, and star multidimensional data model and the type of data model related concepts, solve the statistical analysis for different data storage problem in the business. Thirdly this paper according to its actual business requirements, using relevant data statistic methods have detailed description of the whole of the ETL process data. Finally data analysis results of the business will in the form of statements intuitively show to relevant business users.This paper used the report generation system eventually to UIMS show results of data show, its according to the needs of different clients, this article introduces the statistical data message of graduate student assembly process in detail. And according to the statistical data of different business detailed introduces the related statements assembly method and way of generating, and finally shows Shandong university graduate students to enter oneself for an examination information and information statistics admitted.