Study And Development Of Campus Card Decision Support System

The campus smart card system could help to realize digital consume in campus and standardization on management and the goal of finance concentrative management ,it is one of important part of digital campus.however,it is an application system based on relation database,it is required to respond the user consume request fastly, data analysis not being taken into account during the course of system design.but, by analyzing consume data can help to discover consume orderliness and hidden problem,and can guide job lately.so,it is necessary to construct a consume data analysis system.The thesis is focused on the analysis of the campus card consume data and construct of the campus card data analysis system based on data warehouse ,online analysis process (OLAP) and data mining techniques in order to mine the useful knowledge in the data. Firstly, the basic theory of data warehouse, OLAP, data mining and the core algorithm of the mining are introduced. Then we analyze the information of campus card system elementarily, integrate and transfer several correlative databases into a synthetical database so as to mine work expediently. After these pretreatments, we construct the data warehouse using Microsoft Analysis Services. K-means algorithm is adopted to carry the cluster analysis, and some useful knowledge are found, and Algorithm of association Rules based on the cluster analysis is adopted to discover the association relation grade and sex on water-consume.The results of this paper show that knowledge detect based on campus card system is meaningful. The preliminary experiment results made a good foundation of deeper knowledge acquiring and complete decision support system development in real sense when unified platform has been founded in the future.