The Consistency of Materialized View Maintenance and Drill-Down in a Warehousing Environment

As the primary information entity stored in the data warehouse, the data of materialized views is extracted, transformed, transmitted, or loaded from last or remote sources. Since a warehouse effectively implements materialized views, we must maintain the views while data sources are updated. In this paper, the authors introduce an improved complete algorithm Glide* to eliminates the anomalies. The algorithm Glide* is based on previous incremental view maintenance algorithms, but extra compensating queries are used to eliminate anomalies, therefore the cost of memory and maintenance will be optimized. At the end of the paper, the application of the algorithm is illustrated by a typical example.