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).

[1]  . S.K.Srivatsa,et al.  Automatic Incremental View Maintenance in SchemaSQL , 2006 .

[2]  Inderpal Singh Mumick,et al.  Selection of views to materialize in a data warehouse , 1997, IEEE Transactions on Knowledge and Data Engineering.

[3]  Leonid Libkin,et al.  Incremental maintenance of views with duplicates , 1995, SIGMOD '95.

[4]  Eric N. Hanson,et al.  A performance analysis of view materialization strategies , 1987, SIGMOD '87.

[5]  Nancy L. Martin,et al.  Join index, materialized view, and hybrid-hash join: a performance analysis , 1990, [1990] Proceedings. Sixth International Conference on Data Engineering.

[6]  Norman W. Paton,et al.  MOVIE: An incremental maintenance system for materialized object views , 2003, Data Knowl. Eng..

[7]  Gang Zhou,et al.  Towards the Study of Performance Trade-offs Between Materialized and Virtual Integrated Views , 1996, VIEWS.

[8]  Surajit Chaudhuri,et al.  An overview of data warehousing and OLAP technology , 1997, SGMD.

[9]  Jennifer Widom,et al.  View maintenance in a warehousing environment , 1995, SIGMOD '95.

[10]  Ambuj K. Singh,et al.  Efficient view maintenance at data warehouses , 1997, SIGMOD '97.

[11]  Inderpal Singh Mumick,et al.  Selection of Views to Materialize Under a Maintenance Cost Constraint , 1999, ICDT.

[12]  Rada Chirkova,et al.  A formal perspective on the view selection problem , 2002, The VLDB Journal.

[13]  Kamalakar Karlapalem,et al.  View Relevance Driven Materialized View Selection in Data Warehousing Environment , 2002, Australasian Database Conference.

[14]  Myoung-Ho Kim,et al.  Optimizing the incremental maintenance of multiple join views , 2005, DOLAP '05.

[15]  Elke A. Rundensteiner,et al.  GPIVOT: efficient incremental maintenance of complex ROLAP views , 2005, 21st International Conference on Data Engineering (ICDE'05).