Abstract:The materialized view approach is widely adopted in implementations of data warehouse systems in or-der for efficiency purposes. In terms of the construction of a materialized data warehouse system, some managerial problems still exist to most developers and users in the view resource maintenance area in particular. Resource redundancy and data inconsistency among materialized views in a data warehouse system is a problem that many developers and users struggle with. In this article, a space-efficient protocol for materialized view maintenance with a global data view on data warehouses with embedded proxies is proposed. In the protocol set, multilevel proxy-based protocols with a data compensating mechanism are provided to certify the consistency and uniqueness of materialized data among data resources and materialized views. The authors also provide a set of evaluation experiences and derivations to verify the feasibility of proposed protocols and mechanisms. With such protocols as proxy services, the performance and space utilization of the materialized view approach will be improved. Furthermore, the consistency issue among materialized data warehouses and heterogeneous data sources can be properly accomplished by applying a dynamic compensating and synchronization mechanism. The trade-off between efficiency, storage consumption, and data validity for view maintenance tasks can be properly balanced.

Design and Selection of Materialized Views in a Data Warehousing Environment: a Case Study

Optimized Design of Materialized Views in a Real-Life Data Warehousing Environment

Materialized View Selection in a Data Warehouse

An Evolutionary Approach to Materialized Views Selection in a Data Warehouse Environment

Research on Materialized View Selection: Research on Materialized View Selection

Evolving Materialized Views in Data Warehouse

Data Mining-based Materialized View and Index Selection in Data Warehouses

Approaches for Selecting Views to Materialize Based on Multi-Maintenance Strategy

Selection Algorithm for Materialized Views Based on Query and Relative Benefit

Extended Derivation Cube Based View Materialization Selection in Distributed Data Warehouse

Materialized Views Selection of Multi-Dimensional Data in Real-Time Active Data Warehouses

Index and Materialized View Selection in Data Warehouses

Dynamic Selection of Materialized Views of Multi-Dimensional Data with a Multi-Users and Multi-Windows Method

Materialized View Selection As Constrained Evolutionary Optimization

Sélection simultanée d'index et de vues matérialisées

Approach to selecting materialized views and its implementation

A Space-Efficient Protocol for Consistency of External View Maintenance on Data Warehouse Systems

Materialized Views Selection in Distributed Networks

Research on Materialized Views Selection Based on Users' Preference

OLAP Queries Using Material Views

Materialized View Selection by Query Clustering in XML Data Warehouses