Data Warehouse Technology In College Enrollment Management Research

In this paper, systematic study of the data warehouse and online analytical processing technology, based on the work of the college enrollment management needs some work to do more detailed research, design enrollment management decision support system, the main contents are:1The management of college and university admissions decisions from the actual needs, analysis of the introduction of data warehousing and online analytical processing technology for data query, data analysis of the benefits and advantages to study the feasibility of data2From a number of data warehouse and online analytical software to choose a software platform in this study, the final choice of Microsoft SQL Server2000system software3According to the demand for enrollment management, creating four themes warehouse4For online admission system to produce a detailed analysis of student data and use it as the main data sources, data extraction, transformation and loading, the establishment of multi-dimensional data sets5Using Analysis Services browser, you can study the data slice, dice, spinning operation, the multi-angle multi-level analysis6The use of Microsoft EXCEL import cube, create a table and histogram, more intuitive query from different angles, different levels of analysis of data, provide decision support for specificIn this paper, the use of data warehouse technology, the establishment of enrollment management decision-making system development strategy, research methods and technology choice has made some interesting explorations and attempts...