SQL> create materialized view log on t;
实体化视图日志已创建。
You can think of an MQT as a kind of materialized view.
您可以将MQT看作一种物化的视图。
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.
数据仓库中物化视图选择算法的代价与搜索空间的尺寸紧密相关。
In many case, there is a question, why so slowly in my inserting, creating index, materialized view …
很多时候,有一种问题,就是为啥我insert慢,建索引慢,建物化视图慢…
In the meantime, the cost model of the query cost view selection problem and the process of materialized views selection are presented.
同时给出了查询代价视图选择问题的代价模型和实视图选择的过程。
The radical database collection which are considered as auxiliary views of multiple materialized view are saved on the integration point.
基于基库的多实化视图维护将基库集作为多个实化视图的辅助视图集保存在集成端。
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自动完成的谓词。
During maintaining the materialized view in the data warehouse, how to efficiently handle the concurrent updates is an important and intractable problem.
在数据仓库的实化视图维护处理中,如何有效地处理并发更新是一个重要而又棘手的问题。
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.
物化视图是数据仓库中提高查询效率的有力方法,物化视图的选择一直是数据仓库领域的研究热点。
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.
视图自维护方法通过在数据仓库中复制所有或部分源关系的数据,从而使维护数据仓库实化视图时不需要访问数据源。
This paper deals with two ways to manage aggregate queries: materialized view and approximate query, concludes the processing methods of each way and presents future research directions.
讨论了目前聚集查询处理的两种方法,即实化视图和近似查询,总结了国内外对其研究现状,并对未来的研究方向提出看法。
The statistical view is kind of like the Materialized Query Table (MQT), except that there is no need for materialization.
统计视图有点类似于物化查询表(MaterializedQueryTable,MQT),不同的是统计视图不需要物化。
It only will be materialized if query merge is impossible or if requested by view creator.
只有在无法合并查询或者试图创建者请求时才需要被显式处理。
It only will be materialized if query merge is impossible or if requested by view creator.
只有在无法合并查询或者试图创建者请求时才需要被显式处理。
应用推荐