College Student Information Data Warehouse Design And Application

As we enter the digital information age, information technology is the world's economic and social development trend. College management information is an important part of the national education information technology and also an important means to achieve modernization of education management.Along with the pace of information technology colleges continues to accelerate the development, various information systems have emerged to facilitate the timeliness of the colleges management, but because of the different functions of traditional application of demand-driven, information systems result in the further problem of information technology development in university management :There is a lot of inconsistencies in data between different systems and the data redundancy is high; The data from a variety of information systems is complex and different forms of organization; Not fully integrated the information systems for the construction and development of colleges and universities basis for decision making. In order to meet the modern colleges information technology development. We need to integrate data from various business systems, student information to establish a unified data platform and on-line analytical techniques for the management of colleges and universities offer different forms of wealth of reports, using data mining techniques and tap on the student information the potential valuable information for decision-making basis for the development of colleges and universities.This thesis is mainly directed against the above problem. It uses the SQL Server 2005's set of related products that is Microsoft's next-generation enterprise-class application platform's main product line. From a strategic perspective of universities' the future development, Research and build colleges students information data warehouse, its main contents are as follows :1 A discussion of data warehouse, OLAP and data mining related technologies, features and advantages;2 Studies of college students information data warehouse, the composition, functions and features;3 Studies of college students overall design of data warehouse of information technology;4 studies of college students information data warehouse fact table and dimension table design;5 studies of college students to achieve information and data technology;6 studies of college students on-line information data analysis and data mining techniques;College student information by constructing a data warehouse, can eventually be intelligent applications, supporting the management of scientific decision-making colleges and universities to develop development direction of colleges and universities to improve college and educate students in a number of university students in the core of our competitiveness, while the demand for policy-makers need to improve the data warehouse, which is the focus of research in the next step.