基于MDD的OLAP数据膨胀问题研究  

Research on the Data Growth of OLAP Based on MDD

作　　者：许建[1] 罗永强 

机构地区：[1]清远职业技术学院网络信息中心,广东清远511510 [2]Sybase(软件)中国有限公司广州分公司,广东广州510620

出　　处：《清远职业技术学院学报》2009年第3期29-31,共3页Journal of Qingyuan Polytechnic

摘　　要：由于MOLAP以多维数据库的形式存储数据,在实现OLAP分析时,将存在一些局限,尤其对于MOLAP数据的膨胀,其影响因素和OLAP模型的应用设计关系密切,OLAP模型将严重影响最终cube的大小、系统性能及系统的可扩展性。本文从多维数据库的存储组织入手,分别从维的汇总层次、组合膨胀系数CGF、预计算量与查询效率的关系等方面进行了相关研究,对如何处理MOLAP的数据膨胀问题进行了简要分析。The data storages of MOLAP based on Multi-dimensional database （MDDB）, which is based on multidimensional arrays is suitable to express and store muhidimensional data.To implement OLAP, some localization is ineluctable, particularly as data growth. The influencing factor of MOLAP data growth come down to OLAP model, the models will influence the size of cubes, performance and expansibility of OLAP system. This paper studies the approaches of MOLAP data storage organization, aggregate levels of dimension, compound growth factor （CGF）, the relationship of query performance and percentage pre-calculated, and gives a brief analysis on how to ravel out the data growth of MOLAP.

关 键 词：数据仓库 MOLAP 数据立方体 组合膨胀系数 

分 类 号：TP309.2[自动化与计算机技术—计算机系统结构]