Basic HTML version of Foils prepared 7 October 97

Foil 22 Major Use of Views in a Database I

From Untitled presentation ARL Database Tutorial -- February 98. by Gang Cheng, C.W. Ou, Geoffrey C. Fox


1 Provide an additional level of table security by restricting access to a predetermined set of rows and columns of a table.
2 For example, a view of a table can be created so that columns with sensitive data (for example, SSN) are not included in the definition of the view
3 Hide data complexity.
4 For example, a single view can be used to create a join, which is a display of related columns or rows in multiple tables.
5 However, the view hides the fact that this fact that this data actually originates from several tables

in Table To:


© Northeast Parallel Architectures Center, Syracuse University, npac@npac.syr.edu

If you have any comments about this server, send e-mail to webmaster@npac.syr.edu.

Page produced by wwwfoil on Tue Jan 27 1998