Issues in Translating from Natural Language to SQL in a Domain-Independent Natural Language Interface to Databases

• Published in: MICAI 2006: Advances in Artificial Intelligence pp. 922 - 931
• Main Authors: Juan J. González, B., Rangel, Rodolfo A. Pazos, Cruz C., I. Cristina, Héctor J. Fraire, H., de Santos Aguilar, L., Joaquín Pérez, O.
• Format: Book Chapter
• Language: English
• Published: Berlin, Heidelberg Springer Berlin Heidelberg
• Series: Lecture Notes in Computer Science
• Subjects: Dialogue System; Fare Class; Natural Language Interface; Noun Location; Structure Query Language
• DOI: 10.1007/11925231_88
• ISBN: 9783540490265; 3540490264
• ISSN: 0302-9743

This paper deals with a domain-independent natural language interface to databases (NLIDB) for the Spanish language. This NLIDB had been previously tested for the Northwind and Pubs domains and had attained good performance (86% success rate). However, domain independence complicates the task of achieving high translation success, and to this end the ATIS (Air Travel Information System) database, which has been used by several natural language interfaces, was selected to conduct a new evaluation. The purpose of this evaluation was to asses the efficiency of the interface after the reconfiguration for another domain and to detect the problems that affect translation success. For the tests a corpus of queries was gathered and the results obtained showed that the interface can easily be reconfigured and that attained a 50% success rate. When the found problems concerning query translation were analyzed, wording deficiencies of some user queries and several errors in the synonym dictionary were discovered. After correcting these problems a second test was conducted, in which the interface attained a 61.4% success rate. These experiments showed that user training is necessary as well as a dialogue system that permits to clarify a query when it is deficiently formulated.