Reduction of Materialized View Staleness Using Online Updates
| dc.contributor.author | Labrinidis, Alexandros | en_US |
| dc.contributor.author | Roussopoulos, Nick | en_US |
| dc.date.accessioned | 2004-05-31T22:50:20Z | |
| dc.date.available | 2004-05-31T22:50:20Z | |
| dc.date.created | 1998-02 | en_US |
| dc.date.issued | 1998-10-15 | en_US |
| dc.description.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 top of the Informix Universal Server and used a synthetic workload generator to experiment with various update workloads and different view update 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. (Also cross-referenced as UMIACS-TR-98-13) | en_US |
| dc.format.extent | 267629 bytes | |
| dc.format.mimetype | application/postscript | |
| dc.identifier.uri | http://hdl.handle.net/1903/942 | |
| dc.language.iso | en_US | |
| dc.relation.isAvailableAt | Digital Repository at the University of Maryland | en_US |
| dc.relation.isAvailableAt | University of Maryland (College Park, Md.) | en_US |
| dc.relation.isAvailableAt | Tech Reports in Computer Science and Engineering | en_US |
| dc.relation.isAvailableAt | UMIACS Technical Reports | en_US |
| dc.relation.ispartofseries | UM Computer Science Department; CS-TR-3878 | en_US |
| dc.relation.ispartofseries | UMIACS; UMIACS-TR-98-13 | en_US |
| dc.title | Reduction of Materialized View Staleness Using Online Updates | en_US |
| dc.type | Technical Report | en_US |