基于MDX及MOLAP实现多维数据分析  

Implement multi-dimensional data analysis based on MDX and MOLAP

作　　者：张悦[1] 赵永翼[1] 刘燚[1] 

机构地区：[1]沈阳师范大学软件学院,辽宁沈阳110034

出　　处：《沈阳航空工业学院学报》2008年第1期70-73,共4页Journal of Shenyang Institute of Aeronautical Engineering

摘　　要：传统的OLAP分析基于关系结构,过度依赖其数据源,影响分析效率。为此提出"独立型"数据分析的概念,采用MLOAP及父子维度等技术实现,并结合实际应用详细描述了整体解决方案,及其关键技术。该方案在实际应用中获得了理想的效果,不仅弥补了关系型OLAP分析存在的缺陷,而且实现了对宏观经济领域数据的多角度、多层次查询以及初步分析功能。Traditional OLAP bases on relational structure and on data resource mostly, so it affects analyzing efficiency. This paper proposes an independent data analysis conception. It is implemented by the technology of MOLAP and paarwt-child dimension. Besides, the whole resolving strategy and key technologies are described in details. This strategy has been applied in practical and perfect purpose has been obtained. It not only makes up shortage of relational OLAP, but also implements the query requirement based on multi-view or multi-level, including primary data analysis function.

关 键 词：多维数据分析 星型模式 事实表 维表 MDX 

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