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: Proceeding of 6th International Conference Symposium on Very Data Bases; 1980. p. 86–91.Google Scholar
- 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.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.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