Incremental Maintenance of View Based on Auxiliary Views in Data Warehouse

We often store data in the warehouse as materialized views in order to speedup query processing on large amounts of data. These views need to be maintained in response to update in the source data. The issue of self-maintainability and consistency of the view is an important issue in data warehousing. In the paper we show that the warehouse views can be made self-maintainable with the auxiliary views , which derived from the intermediate results of the view computation can be materialized in the warehouse. Then proposed an efficient incremental maintenance algorithm that computes the exact updates to both the materialized view and auxiliary views.