Choose Index below for a list of all words and phrases defined in this glossary.


index | Index

View - definitions

View - A presentation of data from one or more tables. A view can include all or some of the columns contained in the table or tables on which it is defined. See also Information view

[Category=Data Quality ]

Source: Larry English, External, 14-Feb-2009 11:30

These advertisers support this free service

View - A database component that behaves exactly like a table but has no independent existence of its own; a virtual table.

[Category=Database Management ]

Source: Northwest Database Services, 15 November 2009 12:13:30, External

View - Data structure that results from an SQL query. It's a filtered or combined information set that is built from data in one or more tables.

[Category=Data Governance ]

Source: The Data Governance Institute, 29 December 2009 14:57:38, External

View - pictorial representation; extent of range of vision.

[Category=Information Management ]

Source:, 15 July 2010 13:07:35, External

View - A means of accessing a subset of data in a database.

[Category=Data Warehousing ]

Source: Aexis Business Intelligence, 27 December 2010 11:59:56, External

view - SQL `Select`, Statement, used to provide temporary information about a given table(s) of a database management system (DBMS) without actually creating a subset or new table.

[Category=Geospatial ]

Source: Open Geospatial Consortium, 11 July 2011 09:58:27, External

view - In a database management system, a view is a way of portraying information in the database. This can be done by arranging the data items in a specific order, by highlighting certain items, or by showing only certain items. For any database, there are a number of possible views that may be specified. Databases with many items tend to have more possible views than databases with few items. Often thought of as a virtual table, the view doesn't actually store information itself, but just pulls it out of one or more existing tables. Although impermanent, a view may be accessed repeatedly by storing its criteria in a query.

The best view for a particular purpose depends on the information the user needs. For example, in a telephone directory, a user might want to look up the name associated with a number, without concern for the street address. The best view for this purpose would have two columns: the phone numbers (in numeric sequence) in the first column, and the name associated with each number in the second column. Another user might want to look up the phone number associated with a street address, without any need to know the name. The best view for this purpose would have two columns: the street addresses (in alphanumeric order) in the first column, and the phone number in the second column.

Related glossary terms: Binary Large Object (BLOB), data structure, catalog, data mart, ECMAScript (European Computer Manufacturers Association Script), Visual FoxPro, segment, block, flat file

[Category=Data Management ]

Source:, 15 September 2013 09:25:25, External  



Data Quality Glossary.  A free resource from GRC Data Intelligence. For comments, questions or feedback: