skip to main content
article
Free Access

A Block Structured Query Language for accessing a relational data base

Published:01 May 1978Publication History
Skip Abstract Section

Abstract

This paper describes a Block Structured Query Language (BSQL) to be used with relational data bases. The syntax of the language is presented and discussed. Facilities of the language are illustrated by examples of actual queries. In particular we demonstrate the ability of BSQL to obtain useful information from a relational data base that is incomplete. A relational calculus is then presented which forms a basis for a formalism which precisely describes the semantics of BSQL. Finally, comparative examples with other query languages are given.

References

  1. 1 D. D. Chamberlin, et al, "SEQUEL 2: A Unified Approach to Data Definition, Manipulation, and Control", IBM Journal of Research and Development, 20, 6, Nov. 1976.Google ScholarGoogle ScholarDigital LibraryDigital Library
  2. 2 D. D. Chamberlin and R. F. Boyce, "SEQUEL: A Structured English Query Language". Proc. 1974 ACM SIGMOD Workshop on Data Description, Access and Control. Google ScholarGoogle ScholarDigital LibraryDigital Library
  3. 3 E. F. Codd, "Relational Completeness of Data Base Sublanguages". In Data Base Systems, Courant Computer Science Symposia Series, Vol. 6. Englewood Cliffs, N. J.: Prentice-Hall (1972).Google ScholarGoogle Scholar
  4. 4 E. F. Codd, "A Relational Model of Data for Large Shared Data Banks". CACM 13, No. 6. (June 1970). Google ScholarGoogle ScholarDigital LibraryDigital Library
  5. 5 C. J. Date, An Introduction to Database Systems, Second Edition; Addison-Wesley (1975). Google ScholarGoogle ScholarDigital LibraryDigital Library
  6. 6 D. Kroenke, Database Processing, SRA (1977). Google ScholarGoogle ScholarDigital LibraryDigital Library
  7. 7 C. J. Prenner, "A Uniform Notation for Expressing Queries". Memorandum No. UCB/ERL M77/60 Electronics Research Laboratory, University of California, Berkeley (Sept. 1977).Google ScholarGoogle Scholar
  8. 8 P. Reisner, "Use of Psychological Experimentation as an Aid to Development of a Query Language". IEEE Transactions on Software Engineering, SE-3, 3 (May 1977).Google ScholarGoogle Scholar

Index Terms

  1. A Block Structured Query Language for accessing a relational data base

      Recommendations

      Comments

      Login options

      Check if you have access through your login credentials or your institution to get full access on this article.

      Sign in

      Full Access

      • Published in

        cover image ACM SIGIR Forum
        ACM SIGIR Forum  Volume 13, Issue 1
        May 1978
        180 pages
        ISSN:0163-5840
        DOI:10.1145/1013234
        Issue’s Table of Contents

        Copyright © 1978 ACM

        Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

        Publisher

        Association for Computing Machinery

        New York, NY, United States

        Publication History

        • Published: 1 May 1978

        Check for updates

        Qualifiers

        • article
      • Article Metrics

        • Downloads (Last 12 months)16
        • Downloads (Last 6 weeks)5

        Other Metrics

      PDF Format

      View or Download as a PDF file.

      PDF

      eReader

      View online with eReader.

      eReader