Materialized view maintenance; View update
View maintenance typically refers to the updating of a materialized view (also known as a derived relation) to make it consistent with the base relations it is derived from. Such an update typically happens immediately, with the transaction that updates the base relations also updating the materialized views. However, such immediate updates impose significant overheads on update transactions that cannot be tolerated by many applications. Deferred view maintenance, on the other hand, allows the view to become inconsistent with its definition, and a refresh operation is required to establish consistency. Typically, under deferred maintenance, a view is incrementally updated only just before data is retrieved from it (i.e., on-demand, just before a query is performed on the view).
Early systems that supported views did so in their “pure form,” i.e., by storing just the view definition and using query...
- 4.Colby LS, Griffin T, Libkin L, Mumick IS, Trickey H. Algorithms for deferred view maintenance. In: Proceedings of the ACM SIGMOD International Conference on Management of Data; 1996. p. 469–80.Google Scholar
- 5.Gupta A, Mumick IS. Maintenance of materialized views: problems, techniques, and applications. IEEE Data Eng Bull. 1995;18(2):3–18.Google Scholar
- 6.Gupta A, Mumick IS, Subrahmanian VS. Maintaining views incrementally. In: Proceedings of the ACM SIGMOD International Conference on Management of Data; 1993. p. 157–66.Google Scholar
- 7.Hanson EN. A performance analysis of view materialization strategies. In: Proceedings of the ACM SIGMOD International Conference on Management of Data; 1987. p. 440–53.Google Scholar
- 8.Labrinidis A, Roussopoulos N. A performance evaluation of online warehouse update algorithms. Technical report CS-TR-3954, Department of Computer Science, University of Marylan. 1998.Google Scholar
- 9.Quass D, Widom J. On-line warehouse view maintenance. In: Proceedings of the ACM SIGMOD International Conference on Management of Data; 1997. p. 393–404.Google Scholar
- 11.Stonebraker M. Implementation of integrity constraints and views by query modification. In: Proceedings of the ACM SIGMOD International Conference on Management of Data; 1975. p. 65–78.Google Scholar
- 12.Woodfill J, Stonebraker M. An implementation of hypothetical relations. In: Proceedings of the 9th International Conference on Very Data Bases; 1983. p. 157–66.Google Scholar