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.
- 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 ScholarDigital Library
- 2 BRADLEY, J. File and Data Base Techn+es. Holt, Rinehart & Winston, New York, 1982.Google Scholar
- 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 Scholar
- 4 CHESTER, D. The translation of formal proofs into English. Artif. Intell. 7 (1976), 261-278.Google ScholarCross Ref
- 5 CODD, E. F. A relational model of data for large shared data banks. Commun. ACM 13,6 (June 1970), 377-387. Google ScholarDigital Library
- 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 Scholar
- 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 ScholarDigital Library
- 8 DATE, C. J. An Introduction to Database Systems. Addison-Wesley, Reading, Mass., 1981. Google ScholarDigital Library
- 9 DATE, C. J. A critique of the SQL database language. ACM SIGMOD Rec. 14,3 (1984), 8-54. Google ScholarDigital Library
- 10 KIM, W. On optimizing an SQL-like nested query. ACM Trans. Database Syst. 7, 3 (1982), 443-469. Google ScholarDigital Library
- 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 Scholar
- 12 SHNEIDERMAN, B. Improving the human factors aspects of database interactions. ACM Trans. Database Syst. 3,4 (Dec. 1978), 417-439. Google ScholarDigital Library
- 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 ScholarDigital Library
Index Terms
ELFS: English language from SQL
Comments