Query-by-Example: the Invocation and Definition of Tables and Forms.

@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}
}

Abstract

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.

ACM SIGMOD Anthology

• Windows: Click the letter of your CD drive
  A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
• Mac: Click here
• UNIX/LINUX: mount the CD and click on the path of your mount point:
  /Anthology/vldb7588 or /cdrom

• Windows: Click the letter of your CD drive
  A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
• Mac: Click here
• UNIX/LINUX: mount the DVD and click on the path of your mount point:
  /Anthology/aDVD1 or /dvd

Printed Edition

References

[1]

...

[2]

...

[3]

...

[4]

...

[5]

...

[6]

...

[7]

...

[8]

Moshé M. Zloof, S. Peter de Jong: The System for Business Automation (SBA): Programming Language. Commun. ACM 20(6): 385-396(1977) BibTeX

[9]

...

[10]

...

[11]

E. F. Codd: A Relational Model of Data for Large Shared Data Banks. Commun. ACM 13(6): 377-387(1970) BibTeX

[12]

E. F. Codd: Further Normalization of the Data Base Relational Model. IBM Research Report, San Jose, California RJ909: (1971) BibTeX

[13]

E. F. Codd: Normalized Data Structure: A Brief Tutorial. SIGFIDET Workshop 1971: 1-17 BibTeX

[14]

E. F. Codd: Relational Completeness of Data Base Sublanguages. In: R. Rustin (ed.): Database Systems: 65-98, Prentice Hall and IBM Research Report RJ 987, San Jose, California : (1972) BibTeX

[15]

...

[16]

...

[17]

...

[18]

...

Referenced by

1. Carmem S. Hara, Susan B. Davidson: Reasoning about Nested Functional Dependencies. PODS 1999: 91-100
2. Eben M. Haber, Yannis E. Ioannidis, Miron Livny: OPOSSUM: Desk-Top Schema Management through Customizable Visualization. VLDB 1995: 527-538
3. Eliezer Kantorowitz, Fred J. Maryanski, Dennis Shasha: Distributed Office By Example (D-OBE). ICDE 1986: 166-174
4. Kenneth J. Goldman, Sally A. Goldman, Paris C. Kanellakis, Stanley B. Zdonik: ISIS: Interface for a Semantic Information System. SIGMOD Conference 1985: 328-342
5. Georges Louis, Alain Pirotte: A Denotational Definition of the Semantics of DRC, A Domain Relational Calculus. VLDB 1982: 348-356
6. Frederick H. Lochovsky, Dennis Tsichritzis: An Interactive Query Language for External Data Bases. VLDB 1982: 11-21
7. Alfred V. Aho, Yehoshua Sagiv, Jeffrey D. Ullman: Efficient Optimization of a Class of Relational Expressions. ACM Trans. Database Syst. 4(4): 435-454(1979)
8. Won Kim: Relational Database Systems. ACM Comput. Surv. 11(3): 187-211(1979)
9. Patricia G. Selinger, Morton M. Astrahan, Donald D. Chamberlin, Raymond A. Lorie, Thomas G. Price: Access Path Selection in a Relational Database Management System. SIGMOD Conference 1979: 23-34
10. John C. Thomas: Psychological Issues in Data Base Management. VLDB 1977: 169-186
11. Donald D. Chamberlin: Relational Data-Base Management Systems. ACM Comput. Surv. 8(1): 43-66(1976)
12. C. Robert Carlson, Robert S. Kaplan: A Generalized Access Path Model and its Application to a Relational Data Base System. SIGMOD Conference 1976: 143-154