实体化视图日志已创建。
实体化视图日志已创建。
SQL> create materialized view log on fact with rowid, sequence (aid, num);
实体化视图日志已创建。
通常,数据仓库中存储了大量实体化视图,这些视图中的数据主要用于决策分析。
Usually, there are a large number of material views are stored in data warehouse, whose data is mainly used for decision analyzing.
在移动数据库中,数据缓存普遍采取实体化视图的方式,数据更新通过传输增量部分,以降低对网络带宽的要求。
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.
使用这些实体化视图,用户的查询能够被迅速地回答,因为这种办法可以避免查询基数据中所包含的其他数据源。
Using these materialized views, user queries can be answered quickly because querying the external sources where the base data reside is avoided.
实体化视图作为数据仓库中存储的主要信息实体,是由对上一级或外部数据源进行抽取、转化、传输和上载的数据构成的。
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.
实体化视图作为数据仓库中存储的主要信息实体,是由对上一级或外部数据源进行抽取、转化、传输和上载的数据构成的。
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.
应用推荐