基于缓存机制的ROLAP系统改进方法研究  

Research on Methods of Performance Improvement in ROLAP System

作　　者：田英爱[1] 张志华[1] 蒋玉茹 

机构地区：[1]北京机械工业学院计算机及自动化,北京100085

出　　处：《微计算机信息》2008年第3期180-182,共3页Control & Automation

摘　　要：ROLAP相对于MOLAP在处理多维数据性能方面有很多不足。给出ROLAP的体系结构,研究了改进ROLAP系统性能的若干方法,如实视图技术、索引技术以及并行处理技术,重点分析了如何在SQL生成器中处理查询优化,并提出在ROLAP设计和应用中引入缓存机制,进一步提高ROLAP系统的查询性能。Compared with MOLAP,there are some shortcomings in ROLAP system in processing multi-dimensioned data.The architecture of ROLAP and several performance improvement methods are described,such as materialized views,index and parallel processing technologies.Query optimization technology is analyzed and at the same time an idea is presented that cache mechanism is introduced in ROLAP designing and applying,enhancing ROLAP query performance much more.

关 键 词：联机分析处理 ROLAP体系结构 查询优化 缓存机制 

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