Encyclopedia of Database Systems

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

View Definition

Living reference work entry
DOI: https://doi.org/10.1007/978-1-4899-7993-3_854-2

Synonyms

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: Proceeding of 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.MathSciNetCrossRefMATHGoogle Scholar
  3. 3.
    Gupta A, Jagadish HV, Mumick IS. Data integration using self-maintainable views. In: Advances in database technology, Proceeding of 5th International Conference on Extending Database Technology; 1996. p. 140–44.Google Scholar
  4. 4.
    Gupta H, Harinarayan V, Rajaraman A, Jeffrey DU. Index selection for OLAP. In: Proceeding of 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: Proceeding of ACM SIGMOD International Conference on Management of Data; 1999. p. 371–82.Google Scholar
  6. 6.
    Roussopoulos N. View indexing in relational databases. ACM Trans Database Syst. 1982;7(2):258–90.CrossRefMATHGoogle 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 2014

Authors and Affiliations

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