高校一卡通消费数据OLAP多维分析系统与应用

OLAP Multidimensional Analysis System of Consumptions Data in College Campus One-card-through

针对高校一卡通系统中积累的海量消费数据,为了能够从多个角度查询分析高校在校生的消费状况和消费特点,以支持高校学生工作的分析和决策,提出应用MDX(多维表达式)语言的OLAP多维数据分析系统,建立数据仓库,分析事实表和维表的结构,构建多维数据模型,实现对多维查询结果进行数据分析的功能.通过对比MDX与SQL查询在效率上的差别,及在高校学生管理中的实际应用,表明该系统在效率上远优于传统关系数据库,且更适合于帮助高校管理者进行分析决策.

There were mass consumption data accumulated in the college campus One-card-through system, in order to query and analyze the consumption characteristics of the college students from multiple perspectives, to support analysis and decision in college students work, a OLAP multidimensional data analysis system which based on MDX （ Multidimensional Expressions） was presented. this paper described the establishment of the data warehouse, then focused on the structure of the fact and the dimension tables and built a muhidimensional data model, also compared the MDX and SQL query difference in efficiency, results indicated the proposed sys- tem was better in efficiency and helped decision.