The Approaches of Materialize View Maintenance Process in Data Warehousing

Materialized view maintenance is a significant issue due to the growing use of warehouse technology for information integration and data analysis. Materialized views are used to speed up query processing on large amounts of data. In large databases particularly in distributed database, query response time plays an important role as timely access to information and it is the basic requirement of successful business application. These views need to be maintained in response to updates in the source data.

Typically, a view is maintained immediately, as a part of the transaction that updates the base tables called as eager view maintenance. Immediate view maintenance imposes a significant overhead on update transaction that cannot be tolerated in many applications. A materialized view can be maintained lazily as maintenance is postponed until the system has free cycle or after a specific time period called a deferred view maintenance. Experiments using a prototype implementation in Oracle 9i show much faster response times for updates and also significant reduction in maintenance cost when combining updates.