The Proceedings of the Information Systems Education Conference 2001: §27c Home Papers/Indices prev (§27b) Next (§28a)

Paper (refereed) Information Systems Curriculum

Recommended Citation: Slazinski, E D. Views - The 'Other' Database Object. In The Proceedings of the Information Systems Education Conference 2001, v 18 (Cincinnati): §27c.

Views - The 'Other' Database Object

Refereed

Erick D. Slazinski    [a1] [a2]
Department of Computer Technology
Purdue University    [u1] [u2]
West Lafayette, Indiana, USA    [c1] [c2]

Database views are a powerful and versatile construct that, if used creatively, can solve several commonly occurring business problems. These problems include integration issues and backwards compatibility, location transparency, managing overly complex Structured Query Language (SQL) queries and overcoming some limitations of the SQL language. This paper documents some tips and techniques that the author has found in his many years (12+) in industry. Database (DB) views are basic objects defined in the ANSI SQL-92 standard. As an integral part of the SQL language, which builds upon the select statement, views are easy to teach and generally well understood by students. With the ease of development of views coupled with the expressive power that is contained in the select statement, it is the author's recommendation that views should be included in any intermediate to advanced database course.

Keywords: Views, RDBMS, SQL, RAD

Read this refereed paper in Adobe Portable Document (PDF) format. (125 K bytes)
Preview this refereed paper in Plain Text (TXT) format. (21 K bytes)

CDpic
Comments and corrections to
webmaster@isedj.org