The design and implementation of view facilities for a relational database management system

Views, virtual relations which are derived from other existing relations, can enhance logical data independence, simplify user interfaces, and increase system security. In this thesis view facilities are designed and implemented in a Relational Data Base Management System (DBMS) using the Structured Query Language (SQL). View definition facility is used to create views, delete views, and modify views. Queries involving views are translated into equivalent queries on underlying base tables using query modification. In addition, view updates are supported to allow a user to insert a record into a view, delete records from a view, or change records in a view. The general concepts of views and their maintenance are discussed and the implementation of a view facility for the REQUEST DBMS is presented.