Query generation in an instructional database management system

ABSTRACT

The objectives and the general structure of a database management system designed for instructional use are described in this paper. Two high level interfaces which can be used to assist a student in query formulation are discussed. First of these interfaces is graphical and uses Macintosh microcomputer as a user's workstation. The other interface guides a student through the process of query formulation using a menu-driven approach. Preliminary experiences with these interfaces have shown that they can facilitate teaching of query formulation and help students to understand better the syntax and semantics of non-procedural query languages.

REFERENCES

• Bach73: Charles W. Bachman, The programmer as navigator, Communications of the ACM, v.16 n.11, p.653-658, Nov. 1973 [doi>10.1145/355611.362534]
• Bern81: Philip A. Bernstein , Nathan Goodman, Concurrency Control in Distributed Database Systems, ACM Computing Surveys (CSUR), v.13 n.2, p.185-221, June 1981 [doi>10.1145/356842.356846]
• Chen76: Peter Pin-Shan Chen, The entity-relationship model—toward a unified view of data, ACM Transactions on Database Systems (TODS), v.1 n.1, p.9-36, March 1976 [doi>10.1145/320434.320440]
• Czej84a: Bogdan Czejdo , Marek> Rusinkiewioz, Query transformation in an instructional database management system, ACM SIGCSE Bulletin, v.16 n.1, p.217-223, February 1984
• Czej84b: Czejdo, B. ana M. Rusinkiewicz. ."REQUEST: a TestbeQ Relational Database Management System for Instructional ana Research Purposes", Proceedings oZ the National Computer Conference, June 1984.
• Czej86: Czejdo, B. D. Embley ano M. Rusinkiewicz, "Graphical Query Formulation by Manipulating Relational Schema Diagrams",Proceedings of IX International Conference on System Science, Wroclaw, September 1986.
• Kell86: Keith L. Kelley , Marek Rusinkiewicz, Implementation of Multi-Key Extendible Hashing as an Access Method for a Relational DBMS, Proceedings of the Second International Conference on Data Engineering, p.124-131, February 05-07, 1986
• McDo75: Nancy Harriet Mcdonald, Cupid: a graphics oriented facility for support of non-programmer interactions with a data base., 1975
• Redd86: Venugopal Putta Reddy, A graphical query language for relational databases, 1986
• Rusi85: Rusinkiewicz,M. ,ana B. Czejdo, "Query Transformation in Heterogeneous Di str ibuted Database Systems", Proceeaings of 5-th International Conference on Distributeo Computing Systems, Denver, May 1985.
• Ullm83: Jeffrey D. Ullman, Principles of Database Systems, W. H. Freeman & Co., New York, NY, 1983
• Zloo75: Zloo~, M M "Query by Example" Proceeoings of the 1975 National Computer Conference, Volume 44, Anaheim, California, May 1975.

INDEX TERMS

Primary Classification:
  H. Information Systems
  H.2 DATABASE MANAGEMENT

Additional Classification:
  H. Information Systems
  H.2 DATABASE MANAGEMENT

  K. Computing Milieux
  K.3 COMPUTERS AND EDUCATION
      K.3.2 Computer and Information Science Education
          Subjects: Curriculum

General Terms:
Design, Human Factors