View (database)

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 System s have extended the views from read-only subsets of Data .
The Oracle Database introduced the concept of Materialized View s, 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.

SEE ALSO

Stored Procedure

Trigger

	APPAREL
	BABY
	BEAUTY
	BOOKS
	CAR TOYS
	CELL PHONES
	DVD'S
	ELECTRONICS
	GOURMET FOOD
	GROCERIES
	HEALTH & PERSONAL
	HOME & GARDEN
	JEWELRY
	MUSIC
	MUSIC INSTRUMENTS
	OFFICE PRODUCTS
	SOFTWARE
	SPORTING GOODS
	TOOLS & HARDWARE
	TOYS
	VIDEO GAMES
	SHOPPING HOME

	MORE SHOPPING...

Information About

View (database)