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

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

作　　者：廖华江[1] 黄宁[1] 

机构地区：[1]赣南师范学院现代教育技术中心,江西赣州341000

出　　处：《赣南师范学院学报》2015年第3期11-14,共4页Journal of Gannan Teachers' College(Social Science(2))

摘　　要：针对高校一卡通系统中积累的海量消费数据,为了能够从多个角度查询分析高校在校生的消费状况和消费特点,以支持高校学生工作的分析和决策,提出应用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.

关 键 词：一卡通 数据仓库 OLAP MDX 

分 类 号：TP311.1[自动化与计算机技术—计算机软件与理论]