What is a database view and why should the business analyst understand it?

While the business analyst usual works in the logical domain, understanding what a database view is and the advantages of using them can be helpful when the analyst is tasked with documenting requirements and creating specifications for reports and user interfaces that present data from database queries.

A database view is a stored query that returns data from one or more database tables.  The stored query, or view, is a virtual table.   Once you have defined a view, you can reference it just as you would any other table in a database.  Since the view is the result of a stored query, it does not contain a copy of the data itself.  Instead, it references the data in the underlying base tables. 

Views provide a number of advantages:

Some examples of the ways views are used are:

posted @ Saturday, October 2, 2010 8:38 PM by Chris Adams