User-Friendly Interface to the Roth Relational Database

摘要

A Friendly Interface to a Relational Algebra Database System was created on the Universal Relation concept. This concept allows the user to relate to the total database as a single relation. The user inputs a query using attributes of the single relation. The interface then creates the Universal Relation by way of relational algebra JOINs. Tuples of this relation are SELECTed according to constraints placed on attributes in the query (i.e. CITY = NEW YORK), and a PROJECTion of attributes desired is made from the result. Limitations of the interface are: 1. All relations in the database must be JOINable without data loss. 2. The query must start with a verb. (Author)