Students Management Decision Support System Based On Data Warehouse Design And Realization

Vocational college students'management is a meticulous and complicated work. With the globalization of information, student management system has been adopted in the student management in colleges, which increase the student management and efficiency. Traditional student's management only focuses on students'information management and simple data inquiry, but it could not meet the needs of analysis of modern student's management performance data and decision support.The student management system introduces DSS, the advanced theory, adopts the most popular data warehouse technology, sets up a student management decision support system on enterprise operation. It not only consists of the basic functions of traditional student management but also with some new functions, which could extract the implicated, unknown, potential and underlying and valuable information, and it could also support reliable data for all levels of managers to have scientific management to make sure the individual decision more scientific and accurate.The system is a metadata modeling of storing data and constructing data warehouse based on the web technology of B/S, in which ASP.NET of Microsoft and C# is as the foreground developing tool and SQL Server 2005 data base management of Microsoft is as the database backing stores. The system increases the working efficiency and the quality of efficiency of student management through adopting analysis service tool that employs current individual system and daily management data to make up student management multidimensional model, which could make the browse and data analysis more intuitively and efficiently. The system has the following main functions, data Entry management, information management, daily management, achievement management, payment management, employment management, dormitory management, decision support, and system maintenance etc.