@inproceedings{DBLP:conf/vldb/Zloof75, author = {Mosh{\'e} M. Zloof}, editor = {Douglas S. Kerr}, title = {Query-by-Example: the Invocation and Definition of Tables and Forms}, booktitle = {Proceedings of the International Conference on Very Large Data Bases, September 22-24, 1975, Framingham, Massachusetts, USA}, publisher = {ACM}, year = {1975}, pages = {1-24}, ee = {db/conf/vldb/Zloof75.html}, crossref = {DBLP:conf/vldb/75}, bibsource = {DBLP, http://dblp.uni-trier.de} }
Query-by-Example is a query language for use by non-programmers querying a relational data base. In an earlier paper, the features of this language were introduced; however, it was assumed that the data base was already defined and available to the user.
In the first part of this paper we demonstrate that the operations of Query-by-Example can be used not only to query the data base but also to define it, including data descriptions and declarations of various integrity constraints. This is an attempt to provide the user with a simplified, unified interface for a variety of functions.
In the second part of this paper it is shown how one can make preliminary interrogations to retrieve a subset of the data base needed for the formulation of a specific query. This becomes very useful in cases where the data-base is very large and the user's initial task of scanning the tables for the ones relevant to his specific query becomes by itself horrendous.
Copyright © 1975 by the ACM, Inc., used by permission. Permission to make digital or hard copies is granted provided that copies are not made or distributed for profit or direct commercial advantage, and that copies show this notice on the first page or initial screen of a display along with the full citation.