skip to main content
article
Free Access

ELFS: English language from SQL

Published:01 December 1986Publication History
Skip Abstract Section

Abstract

In this paper we describe a system which, given a query in SQL-like relational database language, will display its meaning in clear, unambiguous natural language. The syntax-driven translation mechanism is independent of the application domain. It has direct applications in designing computer-based SQL tutorial systems and program debugging systems. The research results obtained in the paper will also be useful in query optimization and design of a more user-friendly language front-end for casual users.

References

  1. 1 ATZENI, P., AND PARKER, D. S. Assumptions in relational database theory. In Proceedings of the ACM Symposium on Principles of Database Systems (1982), ACM, New York, 1-9. Google ScholarGoogle ScholarDigital LibraryDigital Library
  2. 2 BRADLEY, J. File and Data Base Techn+es. Holt, Rinehart & Winston, New York, 1982.Google ScholarGoogle Scholar
  3. 3 CHAMBERLIN, D. D. ET AL. SEQUEL 2: A unified approach to data definition, manipulation, and control. IBM J. Res. Dev. (Nov. 1978), 560-575.Google ScholarGoogle Scholar
  4. 4 CHESTER, D. The translation of formal proofs into English. Artif. Intell. 7 (1976), 261-278.Google ScholarGoogle ScholarCross RefCross Ref
  5. 5 CODD, E. F. A relational model of data for large shared data banks. Commun. ACM 13,6 (June 1970), 377-387. Google ScholarGoogle ScholarDigital LibraryDigital Library
  6. 6 CODD, E. F., ET AL. Rendezvous version 1: An experimental English-language query formulation system for casual users of relational data bases. Res. Rep. RJ2144, IBM Research Lab., San Jose, Calif., 1978.Google ScholarGoogle Scholar
  7. 7 DAMERAU, F. J. Problems and some solutions in customization of natural language database front end. ACM Trans. Office Znf. Syst. 3,2 (Apr. 1985), 165-184. Google ScholarGoogle ScholarDigital LibraryDigital Library
  8. 8 DATE, C. J. An Introduction to Database Systems. Addison-Wesley, Reading, Mass., 1981. Google ScholarGoogle ScholarDigital LibraryDigital Library
  9. 9 DATE, C. J. A critique of the SQL database language. ACM SIGMOD Rec. 14,3 (1984), 8-54. Google ScholarGoogle ScholarDigital LibraryDigital Library
  10. 10 KIM, W. On optimizing an SQL-like nested query. ACM Trans. Database Syst. 7, 3 (1982), 443-469. Google ScholarGoogle ScholarDigital LibraryDigital Library
  11. 11 KING, J. J. QUIST: A system for semantic query optimization in relational databases. In Proceedings of the Conference on Very Large Data Bases (1981), 510-517.Google ScholarGoogle Scholar
  12. 12 SHNEIDERMAN, B. Improving the human factors aspects of database interactions. ACM Trans. Database Syst. 3,4 (Dec. 1978), 417-439. Google ScholarGoogle ScholarDigital LibraryDigital Library
  13. 13 ULLMAN, J. D. The U.R. strikes back. In Proceedings of the ACM Symposium on Principks of Database Systems (1982), ACM, New York, 1982,10-22. Google ScholarGoogle ScholarDigital LibraryDigital Library

Index Terms

  1. ELFS: English language from SQL

      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 Transactions on Database Systems
        ACM Transactions on Database Systems  Volume 11, Issue 4
        Dec. 1986
        153 pages
        ISSN:0362-5915
        EISSN:1557-4644
        DOI:10.1145/7239
        Issue’s Table of Contents

        Copyright © 1986 ACM

        Publisher

        Association for Computing Machinery

        New York, NY, United States

        Publication History

        • Published: 1 December 1986
        Published in tods Volume 11, Issue 4

        Permissions

        Request permissions about this article.

        Request Permissions

        Check for updates

        Qualifiers

        • article

      PDF Format

      View or Download as a PDF file.

      PDF

      eReader

      View online with eReader.

      eReader