Encyclopedia of Database Systems

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

View Definition

  • Yannis Kotidis
Reference work entry
DOI: https://doi.org/10.1007/978-1-4614-8265-9_854

Synonyms

View expression

Definition

The definition of a view consists of the name of the view and of a view query, whose result is used to determine the content of the view. Unlike ordinary relational tables (often referred to as base tables), the result set of the view query is, typically, not stored in the database. Views have many uses in data management applications. They are used as shortcuts when forming complex expressions; help make applications immune to changes to the database schema and provide the foundation when designing integration systems. Views can also help encode complex analytical expressions in OLAP applications.

Key Points

A view is a virtual relation. Its content depends on the evaluation of a query over a set of base tables or other views in the database. This query is part of the view definition and is, typically, recomputed every time the view is referenced. In some cases, for efficiency, the tuples of a view may be materialized as a separate table in the...

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

Recommended Reading

  1. 1.
    Adiba ME, Lindsay BG. Database snapshots. In: Proceedings of the 6th International Conference Symposium on Very Data Bases; 1980. p. 86–91.Google Scholar
  2. 2.
    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
  3. 3.
    Gupta A, Jagadish HV, Mumick IS. Data integration using self-maintainable views. In: Advances in Database Technology, Proceedings of the 5th International Conference on Extending Database Technology; 1996. p. 140–44.CrossRefGoogle Scholar
  4. 4.
    Gupta H, Harinarayan V, Rajaraman A, Jeffrey DU. Index selection for OLAP. In: Proceedings of the 13th International Conference on Data Engineering; 1997. p. 208–19.Google Scholar
  5. 5.
    Kotidis Y, Roussopoulos N. DynaMat: a dynamic view management system for data warehouses. In: Proceedings of the ACM SIGMOD International Conference on Management of Data; 1999. p. 371–82.CrossRefGoogle Scholar
  6. 6.
    Roussopoulos N. View indexing in relational databases. ACM Trans Database Syst. 1982;7(2):258–90.zbMATHCrossRefGoogle Scholar
  7. 7.
    Roussopoulos N. An incremental access method for viewCache: concept, algorithms, and cost analysis. ACM Trans Database Syst. 1991;16(3):535–63.CrossRefGoogle Scholar

Copyright information

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

Authors and Affiliations

  1. 1.Department of InformaticsAthens Universitu of Economics and BusinessAthensGreece

Section editors and affiliations

  • Yannis Kotidis
    • 1
  1. 1.Computer Science Dept.Athens Univ. of Economics and BusinessAthensGreece