You can think of an MQT as a kind of materialized view.
您可以将MQT看作一种物化的视图。
Predicates that are pushed down to a nested table expression or materialized view without changing the result, and not already done automatically by DB2.
下推到嵌套表表达式或物化视图而不会改变结果,并且不是由DB2自动完成的谓词。
SQL> create materialized view log on t;
实体化视图日志已创建。
SQL> create materialized view log on dim_a with row id;
实体化视图日志已创建。
SQL> create materialized view log on fact with rowid, sequence (aid, num);
实体化视图日志已创建。
The materialized view selection algorithms are closely related to the size of the search space.
数据仓库中物化视图选择算法的代价与搜索空间的尺寸紧密相关。
During maintaining the materialized view in the data warehouse, how to efficiently handle the concurrent updates is an important and intractable problem.
在数据仓库的实化视图维护处理中,如何有效地处理并发更新是一个重要而又棘手的问题。
The materialized view is an important means of increasing the execution efficiency of a data warehouse, but the storage of the materialized view costs space.
物化视图是提高数据仓库执行效率的有力方法,但是物化视图的保存会占用存储空间。
The latter is one way to maintain the materialized view at the DW without access to the base relations by replicating all or parts of the base data at the DW.
视图自维护方法通过在数据仓库中复制所有或部分源关系的数据,从而使维护数据仓库实化视图时不需要访问数据源。
Materialized view is a method for improving the efficiency of queries in data warehouse system, the selection of it is a hot issue in data warehouse area.
物化视图是数据仓库中提高查询效率的有力方法,物化视图的选择一直是数据仓库领域的研究热点。
Materialized view is a method for improving the efficiency of queries in data warehouse system, the selection of it is a hot issue in data warehouse area.
物化视图是数据仓库中提高查询效率的有力方法,物化视图的选择一直是数据仓库领域的研究热点。
应用推荐