The Concept of Effective Incremental Maintenance for View in Data Warehousing

摘要

Through materialized views, data warehouse (DW) is improved for the availability and efficiency of the queries. However, storing data repetitively makes it difficult to maintain the consistency with the data in materialized views when changes occur in base relations. Therefore, the maintenance of the materialized views should be considered. In the recent years, many researches discuss this type of problems and provide many methods to maintain materialized views. Among these methods, the definition of materialized views is often ignoring the logic relation of relational database schema. Hence, in this paper, the materialized view is defined based on the relational database schema. For the method of materialized views maintenance, an effective incremental maintenance concept is proposed for materialized views. The maintenance operations will be further discussed in two cases as tuples insertion and deletion such that an effective algorithm can be derived to lower the maintenance cost.