View (database)

Encyclopedia : V : VI : VIE : View (database)

---

Originally, in database theory, a view is a read only virtual or logical table composed of the result set of a 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 table alters the data shown in the view.

Views can provide advantages over tables;

• They can subset the data contained in a table
• They can join and simplify multiple tables into a single virtual view
• Views can act as aggregated tables, where aggregated data (sum, average etc.) are calculated and presented as part of the data
• Views can hide the complexity of data, for example a view could appear as Sales2000 or Sales2001, transparently partitioning the actual underlying table
• Views do not incur any extra storage overhead
• Depending on the SQL engine used, views can provide extra security.

Various database management systems have extended the views from read-only subsets of data. The Oracle database introduced the concept of materialized views, which are pre-executed, non-virtual views commonly used in data warehousing. They are a static snapshot of the data and may include data from remote sources. The accuracy of a materialized view depends on the frequency or trigger mechanisms behind its updates. The equivalent of this in Microsoft SQL Server, introduced in the 2000 version, is an indexed view.

External links

• [Views in Microsoft SQL Server]
• [Views in MySQL]

Topics in database management systems (DBMS) ( [ view] • [ talk] • [ edit] )

Concepts Database | Database model | Relational database | Relational model | Relational algebra | Primary key - Foreign key - Surrogate key - Superkey Database normalization | Referential integrity | Relational DBMS | Distributed DBMS | ACID Objects Trigger | View | Table | Cursor | Log | Transaction | Index | Stored procedure | Partition Topics in SQL Select | Insert | Update | Merge | Delete | Join | Union | Create | Drop Comparison of syntax

Implementations of database management systems

Types of implementations Flat file | Deductive | Dimensional | Hierarchical | Object oriented | Temporal Products dBASE | Oracle | Sybase | MySQL | Microsoft SQL Server | PostgreSQL | DB2 | Comparison - relational | Comparison - object-relational Components Query language | Query optimizer | Query plan | ODBC | JDBC Lists List of object-oriented database management systems List of relational database management systems List of truly relational database management systems

 

---

From Wikipedia, the Free Encyclopedia. Original article here. Support Wikipedia by contributing or donating.
All text is available under the terms of the GNU Free Documentation License See Wikipedia Copyrights for details.

Search Titles

0

1

2

3

4

5

6

7

8

9

A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

P

Q

R

S

T

U

V

W

X

Y

Z

?