An Experimental Performance Evaluation of Incremental Materialized View Maintenance in Object Databases

Authors:
M. Akhtar Ali;Norman W. Paton;Alvaro A. A. Fernandes
Affiliations:
-;-;-
Venue:
DaWaK '01 Proceedings of the Third International Conference on Data Warehousing and Knowledge Discovery
Year:
2001

Citing 10
Cited 0

A performance analysis of view materialization strategies

SIGMOD '87 Proceedings of the 1987 ACM SIGMOD international conference on Management of data
A general framework for the optimization of object-oriented queries

SIGMOD '92 Proceedings of the 1992 ACM SIGMOD international conference on Management of data
The 007 Benchmark

SIGMOD '93 Proceedings of the 1993 ACM SIGMOD international conference on Management of data
Materialized views: techniques, implementations, and applications

Materialized views: techniques, implementations, and applications
Design and selection of materialized views in a data warehousing environment: a case study

Proceedings of the 2nd ACM international workshop on Data warehousing and OLAP
The object data standard: ODMG 3.0

The object data standard: ODMG 3.0
Incremental maintenance of materialized OQL views

Proceedings of the 3rd ACM international workshop on Data warehousing and OLAP
Optimizing object queries using an effective calculus

ACM Transactions on Database Systems (TODS)
Incremental Maintenance of Materialized Object-Oriented Views in MultiView: Strategies and Performance Evaluation

IEEE Transactions on Knowledge and Data Engineering
Genetic Algorithm for Materialized View Selection in Data Warehouse Environments

DaWaK '99 Proceedings of the First International Conference on Data Warehousing and Knowledge Discovery

Quantified Score

Hi-index	0.00

Visualization

Abstract

The development of techniques for supporting incremental maintenance of materialized views has been an active research area for over twenty years. However, although there has been much research on methods and algorithms, there are surprisingly few systematic studies on the performance of different approaches. As a result, understanding of the circumstances in which materialized views are beneficial (or not) can be seen to lag behind research on incremental maintenance techniques. This paper presents the results of an experimental performance analysis carried out in a system that incrementally maintains OQL views in an ODMG compliant object database. The results indicate how the effectiveness of incremental maintenance is affected by issues such as database size, and the complexity and selectivity of views.