摘要
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.
出处
《微计算机信息》
北大核心
2008年第3期180-182,共3页
Control & Automation