尽管多维度OLAP(MOLAP)分区提供了更好的查询性能,但是需要回写功能的公司以前都需要使用关系型OLAP(ROLAP)分区来维护回写表。SQL Server 2008增加了对MOLAP分区执行回写操作的能力,这消除了由维护ROLAP回写表所引起的性能下降的问题。
基于4个网页-相关网页
While in ROLAP, data is stored as rows and columns in relation form, and exhibited to customers as business dimension.
在ROLAP模型中,数据是以关系形式的行和列来存储的,以商业维度的形式为用户显示数据。
This text goes deep into discussing the query of ROLAP in optimization based on pre-count summary and the query of sample based on query optimization.
而查询优化是解决ROLAP性能问题的重要环节之一,本文针对基于预计算汇总的ROLAP查询优化及基于采样的查询优化进行深入的探讨。
The ROLAP data cube is implemented as a collection of relational tables (up to twice as many as the number of dimensions) instead of as a multidimensional array.
ROLAP数据立方体是按关系表格的集合实现的(最多可达维度数目的两倍),来代替多维阵列。
应用推荐