A data warehouse stores materialized views,with the purpose of efficiently implementing OLAP queries or decision-support. Hence,selecting views to materialize is one of the most important decisions in designing a data ware- house.
物化视图是数据仓库环境中提高 OLAP 查询效率的重要手段,因此,物化视图的选择是数据仓库设计中重要的决策之一。
参考来源 - 基于多维护策略的物化视图选择方法 in C·2,447,543篇论文数据，部分数据来源于NoteExpress
It can be used to compress entire tables, table partitions, and materialized views.
它可以用于压缩整个表、表分区和物化视图。
Besides query optimization, another efficient way is query rewrite using materialized views.
除了对查询进行优化外，另外一种方式就是用物化视图改写查询。
However, when high performance is required, materialized views are created to de-normalize the data.
不过，当要求实现更高的性能时，则需要创建物化视图来反规范化(de - normalize)数据。
应用推荐