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