In database theory, a view is a virtual or logical table composed of the result set of a pre-compiled query. Unlike ordinary tables in a relational database, a view is not part of the physical schema: it is a dynamic, virtual table computed or collated from data in the database. Changing the data in a view alters the data stored in the database.
Types of views Views can be of three types Inline views,database views and materialised views. Materialised views are different from all in the sense that, it is a snapshot of a main database distributed over different geographical areas, a so called distributed database. It has permanent existence. Other views are created using SELECT operation for query processing.
See also
 | This computing article is a stub. You can help Wikipedia by expanding it. |