Reduction of Materialized View Staleness Using Online Updates
DocUID: 1998-002 Full Text: PDFAuthor: Alexandros Labrinidis, Nick Roussopoulos
Abstract: Updating the materialized views stored in data warehouses usually implies making the warehouse unavailable to users. We propose MAUVE , a new algorithm for online incremental view updates that uses timestamps and allows consistent read-only access to the warehouse while it being updated. The algorithm propagates the updates to the views more often than the typical once a day in order to reduce view staleness. We have implemented MAUVE on top of the InformixUniversal Server and used a syntheticworkload generator to experimentwith various updateworkloads and different viewupdate frequencies. Our results show that, all kinds of update streams benefit from more frequent view updates, instead of just once a day. However, there is a clear maximum for the view update frequency, for which view staleness is minimal.
Published In: Department of Computer Science, University of Maryland, Technical Report CS-TR-3878
Pages: pp. 1-21
Year Published: 1998
Project: Others Subject Area: Data Warehousing
Publication Type: Technical Report
Sponsor: Others