The comparison of SQL, QBE, and DFQL as query languages for relational databases

Download
Author
Girsang, Paruntungan
Date
1994-03Advisor
Wu, C. Thomas
Second Reader
NA
Metadata
Show full item recordAbstract
Structure Query Language (SQL) and Query By Example (QBE) are the most widely used query languages for Relational Database Management Systems (RDBMS's). However, both of them have problems concerning ease-of-use issues, especially in expressing universal quantification, specifying complex nested queries, and flexibility and consistency in specifying queries with respect to data retrieval. To alleviate these problems, a new query language called 'DataFlow Query Language' (DFQL) was proposed. This thesis investigates the relative strengths and weaknesses of these three languages. We divide queries into four categories: single-value, set-value, statistical result, and set-count value. In each category, a representative set of queries from each language is specified and compared. Some of the queries specified are logical extensions of the other (already defined) queries, which are used to analyze the query languages' flexibility and consistency in formulating logically related queries. We perform a simple experiment of asking NPS CS students to write a small set of queries in all three languages. Based on the analysis, we conclude that DFQL eliminates the problems of SQL and QBE mentioned above. The relative strengths of DFQL comes mainly from its strict adherence to relational algebra and dataflow-based visuality.
Rights
This publication is a work of the U.S. Government as defined in Title 17, United States Code, Section 101. Copyright protection is not available for this work in the United States.Collections
Related items
Showing items related by title, author, creator and subject.
-
Implementation of Data Flow Query Language (DFQL)
Sahin, Ilker; Aksoy, Baybora (Monterey, California. Naval Postgraduate School, 2001-03);A relational database management system (RDBMS) is a software product that structures data in accordance with the relational data model and permits data manipulation based on relational algebra. There are two widely-used ... -
A conceptual approach to object-oriented data modeling
Barnes, Gerald Byron (Monterey, California. Naval Postgraduate School, 1994-09);Object-oriented data modeling is starting to replace the relational model for many recently emerging database applications. The complex nature of these databases precludes mapping of their data directly into a tabular ... -
DFQL : a graphical dataflow query language.
Clark, Gard J. (Monterey, California. Naval Postgraduate School, 1991-09);In nearly all large organizations, the Navy and Department of Defense being no exceptions, the use of database management systems (DBMS's) has become widespread. The prevailing data model for modern DBMS's is the relational ...