View
Used in the context of a relational or other database, a view is the result set from a stored query. It is a virtual table dynamically derived from data in the database, usually a subset of data. A view is defined in the database dictionary. Since a view is saved as a definition, and exists as a virtual table, as opposed to traditional base table, it take up less storage space in a database.A view offers important functionality in database processing. For example, it can:
- Limit access to parts of the base table
- Join multiple tables into a single virtual table
- Aggregated data and display results as part of the view
