Q-TRANS, which stands for Query-TRANSlation System, translates formal database queries into English to enhance the usability of both natural and formal language database access systems. Q-TRANS is designed for the database query language SQL, whose query expressions serve as an abstract representation from which an English paraphrase is generated. Q-TRANS is also intended to be part of the Transformational Question Answering System (TQA system), which provides a natural language interface for database query, analyzing and ultimately translating the English queries into SQL expressions. The concepts and methods used in Q-TRANS to arrive at a query translation are, however, independent from the TQA system except for compatibility of lexical and grammatical coverage of the paraphrar.es produced. The paraphrases generated are true translations of the SQL expressions which are the input to Q-TRANS and serve in a sense as deep structures that get mapped into English imperatives. The grammatical English structures Q-TRANS produces obey somewhat conflicting constraints in that they preserve as much of the SQL structure as necessary to reflect the internal logic to the user, and at the same time represent as natural English sentences as possible.
[1]
S. R. Petrick,et al.
Semantic Interpretation in the REQUEST System
,
1973,
COLING.
[2]
Irving L. Traiger,et al.
System R: relational approach to database management
,
1976,
TODS.
[3]
Warren J. Plath.
Request: a natural language question-answering system
,
1977,
SGAR.
[4]
E. F. Codd,et al.
RENDEZVOUS Version 1: An Experimental English Language Query Formulation System for Casual Users of Relational Data Bases
,
1978,
Research Report / RJ / IBM / San Jose, California.
[5]
David L. Waltz,et al.
An English language question answering system for a large relational database
,
1978,
CACM.
[6]
Kathleen McKeown,et al.
Paraphrasing Using Given and New Information in a Question-Answer System
,
1979,
ACL.
[7]
Ralph Grishman.
Response Generation in Question - Answering Systems
,
1979,
ACL.
[8]
Fred J. Damerau,et al.
Operating Statistics for the Transformational Question Answering System
,
1981,
CL.
[9]
S. R. Patrick.
Field Testing the Transformational Question Answering (Tqa) System
,
1981,
ACL.