An Incremental View Materialization Approach in ORDBMS

Materialized view is like a cache that resembles like tables or partitioned tables and behaves like indexes and it is used for improving query performance. All of the views cannot be materialized since for any changes to the base tables it incurs huge maintenance cost but materialized views need to be updated periodically with minimum cost for efficient maintenance in a large database or data warehouse environment. So it is necessary to determine the circumstances in which a view is beneficial to be materialized for improving query performance considering the incremental materialized view maintenance cost. In this paper, we have developed a methodology that determines the circumstances a view is beneficial for selecting to be materialized considering the incremental materialized view maintenance cost in object-relational database management system (ORDBMS).