Encyclopedia of Database Systems

2018 Edition
| Editors: Ling Liu, M. Tamer Özsu

Updates Through Views

  • Yannis VelegrakisEmail author
Reference work entry
DOI: https://doi.org/10.1007/978-1-4614-8265-9_847


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...

This is a preview of subscription content, log in to check access.

Recommended Reading

  1. 1.
    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.Google Scholar
  2. 2.
    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.Google Scholar
  3. 3.
    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.Google Scholar
  4. 4.
    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.Google Scholar
  5. 5.
    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.CrossRefGoogle Scholar
  6. 6.
    Dayal U, Bernstein P. On the correct translation of update operations on relational views. ACM Trans Database Syst. 1982;8(3):381–416.MathSciNetzbMATHCrossRefGoogle Scholar
  7. 7.
    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.Google Scholar
  8. 8.
    Kotidis Y, Srivastava D, Velegrakis Y. Updates through views: a new hope. In: Proceedings of the 21st International Conference on Data Engineering; 2005.Google Scholar
  9. 9.
    Shu H. Using constraint satisfaction for view update translation. In: Proceedings of the 21st International Conference on Data Engineering; 2005.Google Scholar
  10. 10.
    Widom J. Research problems in data warehousing. In: Proceedings of the International Conference on Information and Knowledge Management; 1995. p. 25–30.Google Scholar
  11. 11.
    Lawrence M, Pottinger R, Staub-French S. Data coordination: supporting contingent updates. Proc VLDB Endow. 2011;4(11):831–42.Google Scholar
  12. 12.
    Fegaras L. Propagating updates through XML views using lineage tracing. In: Proceedings of the 26th International Conference on Data Engineering; 2010. p. 309–20.Google Scholar

Copyright information

© Springer Science+Business Media, LLC, part of Springer Nature 2018

Authors and Affiliations

  1. 1.Department of Information Engineering and Computer ScienceUniversity of TrentoTrentoItaly

Section editors and affiliations

  • Yannis Kotidis
    • 1
  1. 1.Department of InformaticsAthens University of Economics and BusinessAthensGreece