Example-based graphical database query languages

Several user-friendly graphical database query languages that let users formulate a query by specifying a graphically aided example on the screen are compared. One of the earliest such languages, M.M. Zloof's (1977) Query-by-Example, is described. Other languages discussed are Aggregates-by-Example, Summary-Table-by-Example, and Query-by-Statistical-Relational-Table for statistical and scientific databases; Time-by-Example for historical databases; Generalized-Query-by-Example for relational, network, and hierarchical databases; Office-by-Example, Formanager, the Natural Forms Query Language, and System-for-Business-Automation for office environments; and Picquery and Query-by-Pictorial-Example for pictorial (image) databases. The basic features, query specification and interpretation, object manipulation, query language constructs, and query processing techniques used in each of the languages are discussed.<<ETX>>

[1]  John C. Thomas,et al.  A psychological study of query by example , 1975, AFIPS '75.

[2]  S. Peter de Jong,et al.  The System for Business Automation (SBA): Programming language , 1976, Commun. ACM.

[3]  S. Peter de Jong,et al.  The System for Business Automation (SBA): Programming language , 1976 .

[4]  Moshé M. Zloof Query-by-Example: A Data Base Language , 1977, IBM Syst. J..

[5]  King-Sun Fu,et al.  Query-by-Pictorial-Example , 1980, IEEE Trans. Software Eng..

[6]  Anthony C. Klug Abe: A Query Language for Constructing Aggregates-by-Example , 1981, SSDBM.

[7]  Anthony C. Klug Equivalence of Relational Algebra and Relational Calculus Query Languages Having Aggregate Functions , 1982, JACM.

[8]  Barry E. Jacobs,et al.  A Generalized Query-by-Example Data Manipulation Language Based on Database Logic , 1983, IEEE Transactions on Software Engineering.

[9]  Alan R. Hevner,et al.  FORMANAGER: an office forms management system , 1984, TOIS.

[10]  Sakti P. Ghosh Statistical relational tables for statistical database management , 1986, IEEE Transactions on Software Engineering.

[11]  Ravi Krishnamurthy,et al.  Office-by-example: an integrated office system and database manager , 1987, TOIS.

[12]  Abraham Silberschatz,et al.  Extended algebra and calculus for nested relational databases , 1988, TODS.

[13]  Thomas Joseph,et al.  PICQUERY: A High Level Query Language for Pictorial Database Management , 1988, IEEE Trans. Software Eng..

[14]  David W. Embley,et al.  NFQL: the natural forms query language , 1989, ACM Trans. Database Syst..

[15]  Gultekin Özsoyoglu,et al.  Query processing techniques in the summary-table-by-example database query language , 1989, TODS.

[16]  Gultekin Özsoyoglu,et al.  Time-by-Example Query Language for Historical Databases , 1989, IEEE Trans. Software Eng..

[17]  Gultekin Özsoyoglu,et al.  A Relational Calculus with Set Operators, Its Safety and Equivalent Graphical Languages , 1989, IEEE Trans. Software Eng..

[18]  Gultekin Özsoyoglu,et al.  Human factors study of two screen-oriented query languages: STBE and QBE , 1992, Inf. Softw. Technol..