Definition
Views are windows to a database. They provide access to only a portion of the data that is either of interest or related to an application. Views are relations without independent existence, as is the case of database tables created with the “create table” command. The contents of the instance of a view are determined by the result of a query on a set of database tables, typically referred to as base tables. Applications deal with views the same way they deal with any other relation. In fact, an application is rarely aware of whether a relation it is accessing is a base table or a view. This means that the application may issue updates on the view relation as it would have done with any other database table. Since the view instance depends on the instances of the base tables, to execute an update on the view one needs to find a number of base table modifications whose effect on the view instance is the modification described by the update command. These modifications are...
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Recommended Reading
Aaron B, Vaughan JA, Pierce BC. Relational lenses: a language for updatable views. In: Proceedings of the 27th ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems; 2006. p. 338–47.
Barsalou T, Siambela N, Keller AM, Wiederhold G. Updating relational databases through object-based views. In: Proceedings of the ACM SIGMOD International Conference on Management of Data; 1991. p. 248–57.
Braganholo VP, Davidson SB, Heuser CA. On the updatability of XML views over relational databases. In: Proceedings of the 6th International Workshop on the World Wide Web and Databases; 2003. p. 31–6.
Buneman P, Khanna S, Tan WC. On propagation of deletions and annotations through views. In: Proceedings of the 21st ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems; 2002. p. 150–8.
Cui Y, Widom J, Wiener JL. Tracing the lineage of view data in a data warehousing environment. ACM Trans Database Syst. 2000;25(2):179–227.
Dayal U, Bernstein P. On the correct translation of update operations on relational views. ACM Trans Database Syst. 1982;8(3):381–416.
Keller AM. Choosing a view update translator by dialog at view definition time. In: Proceedings of the 12th International Conference on Very Large Data Bases; 1986. p. 467–74.
Kotidis Y, Srivastava D, Velegrakis Y. Updates through views: a new hope. In: Proceedings of the 21st International Conference on Data Engineering; 2005.
Shu H. Using constraint satisfaction for view update translation. In: Proceedings of the 21st International Conference on Data Engineering; 2005.
Widom J. Research problems in data warehousing. In: Proceedings of the International Conference on Information and Knowledge Management; 1995. p. 25–30.
Lawrence M, Pottinger R, Staub-French S. Data coordination: supporting contingent updates. Proc VLDB Endow. 2011;4(11):831–42.
Fegaras L. Propagating updates through XML views using lineage tracing. In: Proceedings of the 26th International Conference on Data Engineering; 2010. p. 309–20.
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Section Editor information
Rights and permissions
Copyright information
© 2018 Springer Science+Business Media, LLC, part of Springer Nature
About this entry
Cite this entry
Velegrakis, Y. (2018). Updates Through Views. In: Liu, L., Özsu, M.T. (eds) Encyclopedia of Database Systems. Springer, New York, NY. https://doi.org/10.1007/978-1-4614-8265-9_847
Download citation
DOI: https://doi.org/10.1007/978-1-4614-8265-9_847
Published:
Publisher Name: Springer, New York, NY
Print ISBN: 978-1-4614-8266-6
Online ISBN: 978-1-4614-8265-9
eBook Packages: Computer ScienceReference Module Computer Science and Engineering