GQL : a graphical query interface for relational databases (1989)

Type of Content
Discussion / Working PapersPublisher
University of Canterbury. Dept. of Computer ScienceCollections
- Engineering: Reports [732]
Abstract
The linear data manipulation languages (DMLs) used to query typical relational databases have a number of practical disadvantages for users of all levels. The aim of graphical query languages is to provide efficiency for the expert and ease of use for the novice, without losing the power of a traditional DML. GQL provides a graphical query interface for relational databases. Queries are expressed graphically and translated into a DML before being passed to the host database for execution. The graphical interface of the Macintosh is used to provide facilities for incremental editing of queries as well as the display of results. A local dictionary is used to store metadata, which may be extracted from the host database or defined within GQL, for use in query formulation. Predefined relationships (or "join recipes") may be used to construct linkage conditions in queries. Parametrized subqueries may be stored for reuse, enabling both the provision of "black box" query components for use by novices and the maintenance of libraries of frequently-used components by experts.
Keywords
Graphical query languages; Graphical interfaces; Database managementANZSRC Fields of Research
08 - Information and Computing Sciences::0803 - Computer Software::080309 - Software Engineering08 - Information and Computing Sciences::0806 - Information Systems::080604 - Database Management
Rights
All Rights ReservedRelated items
Showing items related by title, author, creator and subject.
-
DB drafter : a bubble diagrammer for database design
Wilson, R. P. (University of Canterbury, 1989)Many of the methods and models so far developed for database schema design have proved to be complex, highly theoretical in nature, and often have NP complete aspects. The method investigated in this project [Smith 1985] ... -
An Incident Reporting and Information Retrieval System for the Fire Service
Carswell, A. D. (University of Canterbury. Computer Science, 1977)This year the students of COSC203 were involved with Dr R.E.M. Cooper and the Christchurch Fire Brigade in designing and implementing an on-line mobilising system for the Christchurch Fire Brigade. It was envisaged that ... -
Ecstasy : An Object Oriented Graphics System
Holling, K. (University of Canterbury, 1983)The purpose of this report is to describe the design and implementation of a simple two dimensional drawing system for use from within the Computer Science Department's DG SIMULA implementation. This includes a description ...