Design of data warehouse in teaching state based on OLAP and data mining

TitleDesign of data warehouse in teaching state based on OLAP and data mining
Publication TypeJournal Articles
Year of Publication2009
AuthorsZhou L, Wu M, Li S
JournalProceedings of SPIE
Pagination73440M - 73440M
Date Published2009///

The data warehouse and the data mining technology is one of information technology research hot topics. Atpresent the data warehouse and the data mining technology in aspects and so on commercial, financial industry as well
as enterprise's production, market marketing obtained the widespread application, but is relatively less in educational
fields' application. Over the years, the teaching and management have been accumulating large amounts of data in
colleges and universities, while the data can not be effectively used, in the light of social needs of the university
development and the current status of data management, the establishment of data warehouse in university state, the
better use of existing data, and on the basis dealing with a higher level of disposal --data mining are particularly
important. In this paper, starting from the decision-making needs design data warehouse structure of university teaching
state, and then through the design structure and data extraction, loading, conversion create a data warehouse model,
finally make use of association rule mining algorithm for data mining, to get effective results applied in practice. Based
on the data analysis and mining, get a lot of valuable information, which can be used to guide teaching management,
thereby improving the quality of teaching and promoting teaching devotion in universities and enhancing teaching
infrastructure. At the same time it can provide detailed, multi-dimensional information for universities assessment and
higher education research.