| 基于MDX及MOLAP实现多维数据分析 |
| |
| 引用本文： | 张悦,赵永翼,刘燚.基于MDX及MOLAP实现多维数据分析[J].沈阳航空工业学院学报,2008,25(1):70-73. |
| |
| 作者姓名： | 张悦 赵永翼 刘燚 |
| |
| 作者单位： | 沈阳师范大学,软件学院,辽宁,沈阳,110034 |
| |
| 摘 要： | 传统的OLAP分析基于关系结构,过度依赖其数据源,影响分析效率。为此提出"独立型"数据分析的概念,采用MLOAP及父子维度等技术实现,并结合实际应用详细描述了整体解决方案,及其关键技术。该方案在实际应用中获得了理想的效果,不仅弥补了关系型OLAP分析存在的缺陷,而且实现了对宏观经济领域数据的多角度、多层次查询以及初步分析功能。
|
| 关 键 词： | 多维数据分析 星型模式 事实表 维表 MDX |
| 文章编号： | 1007-1385(2008)01-0070-04 |
| 修稿时间： | 2007年11月25 |
Implement multi-dimensional data analysis based on MDX and MOLAP |
| |
| ZHANG Yue,ZHAO Yong-yi,LIU Yi.Implement multi-dimensional data analysis based on MDX and MOLAP[J].Journal of Shenyang Institute of Aeronautical Engineering,2008,25(1):70-73. |
| |
| Authors: | ZHANG Yue ZHAO Yong-yi LIU Yi |
| |
| Abstract: | 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 te chnology 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. |
| |
| Keywords: | multi-dimensional data analysis star scheme fact table dimension table MDX |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
|
