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)数据。
Alternatively investigate the question of which materialized views to create in a data-warehousing system, such as C-Store.
或是研究如c - Store的数据仓库系统创建物化视图的问题。
Query tables in conjunction with materialized views perform well, but they use native database joins to retrieve the related records.
将查询表与物化视图结合使用会带来很好的性能,但是它们使用本机数据库联接来检索相关记录。
In the meantime, the cost model of the query cost view selection problem and the process of materialized views selection are presented.
同时给出了查询代价视图选择问题的代价模型和实视图选择的过程。
Using these materialized views, user queries can be answered quickly because querying the external sources where the base data reside is avoided.
使用这些实体化视图,用户的查询能够被迅速地回答,因为这种办法可以避免查询基数据中所包含的其他数据源。
In mobile databases, data caching take the form of materialized views. Data is updated by communicating only the incremental part to reduce the demand for network bandwidth.
在移动数据库中,数据缓存普遍采取实体化视图的方式,数据更新通过传输增量部分,以降低对网络带宽的要求。
As the primary information entity stored in the data warehouse, the data of Materialized views is extracted, transformed, transmit-ted, or loaded from last or remote sources.
实体化视图作为数据仓库中存储的主要信息实体,是由对上一级或外部数据源进行抽取、转化、传输和上载的数据构成的。
Database query optimization for some of the APIs' operations like querying business process and task related objects (usage of materialized views or stored queries) (see the Resources section).
针对某些API操作(如查询与业务流程和任务相关的对象)的数据库查询优化(使用物化视图或存储查询)(请参见参考资料部分)。
When the data warehouse is maintained in usual way, change information will be directly applied to the tables and materialized views in the warehouse. In this paper, a Delta table method is proposed.
当采用传统的方法对数据仓库进行维护时,所捕获到的变化信息将被直接应用到仓库中相应的表或实视图上。
The radical database collection which are considered as auxiliary views of multiple materialized view are saved on the integration point.
基于基库的多实化视图维护将基库集作为多个实化视图的辅助视图集保存在集成端。
Organizing the multidimensional views properly and selecting a set of views to be materialized is an effective way to improve query performances of data warehouse.
合理地组织数据仓库的多维视图,并将部分视图物化,是提高数据仓库查询性能的一个有效途径。
Some of the event and subscription views could not be materialized.
无法具体化某些事件和订阅视图。
Views on other hand do not have to be materialized and normally executed by rewriting the query.
视图则不同,它无需被显式处理,只是把查询简单地重写了一下。
Views on other hand do not have to be materialized and normally executed by rewriting the query.
视图则不同,它无需被显式处理,只是把查询简单地重写了一下。
应用推荐