Current studentsExisting staffContact us
 

Maintaining views in object-relational databases

Simple item page
dc.contributor.authorLiu, J.
dc.contributor.authorVincent, M.
dc.contributor.authorMohania, M.
dc.date.issued2003
dc.description.abstractView 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.
dc.identifier.citationKnowledge and Information Systems, 2003; 5(1):50-82
dc.identifier.doi10.1007/s10115-002-0067-z
dc.identifier.issn0219-1377
dc.identifier.issn0219-3116
dc.identifier.orcidLiu, J. [0000-0002-0794-0404]
dc.identifier.urihttps://hdl.handle.net/1959.8/43930
dc.language.isoen
dc.publisherSpringer
dc.rightsCopyright 2003 Springer
dc.source.urihttps://doi.org/10.1007/s10115-002-0067-z
dc.titleMaintaining views in object-relational databases
dc.typeJournal article
pubs.publication-statusPublished
ror.mmsid9915912593601831

Files

Collections