Abstract.
View materialization is an important way of improving the performance of query processing. When an update occurs to the source data from which a materialized view is derived, the materialized view has to be updated so that it is consistent with the source data. This update process is called view maintenance. The incremental method of view maintenance, which computes the new view using the old view and the update to the source data, is widely preferred to full view recomputation when the update is small in size. In this paper we investigate how to incrementally maintain views in object-relational (OR) databases. The investigation focuses on maintaining views defined in OR-SQL, a language containing the features of object referencing, inheritance, collection, and aggregate functions including user-defined set aggregate functions. We propose an architecture and algorithms for incremental OR viewmaintenance. We implement all algorithms and analyze the performance of them in comparison with full view recomputation. The analysis shows that the algorithms significantly reduce the cost of updating a vieww hen the size of an update to the source data is relatively small.
Similar content being viewed by others
Author information
Authors and Affiliations
Additional information
Received 23 May 2000 / Revised 27 March 2001 / Accepted in revised form 30 April 2001
Correspondence and offprint requests to: Jixue Liu, School of Computer and Information Science, University of South Australia, Mawson Lakes, Adelaide SA5084, Australia. Email: jixue.liu@unisa.edu.auau
Rights and permissions
About this article
Cite this article
Liu, J., Vincent, M. & Mohania, M. Maintaining Views in Object-Relational Databases . Knowl Inform Sys 5, 50–82 (2003). https://doi.org/10.1007/s10115-002-0067-z
Issue Date:
DOI: https://doi.org/10.1007/s10115-002-0067-z