Abstract
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.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Androutsopoulos, I., Ritchie, G.D., Thanisch, P.: Natural Language Interfaces to DataBases - An Introduction. Department of Artificial Intelligence, University of Edinburgh (1995)
Pazos, R., Pérez, O.J., González, B.J., Gelbukh, A.F., Sidorov, G., Rodríguez, M.M.: A Domain Independent Natural Language Interface to Databases Capable of Processing Complex Queries. In: Gelbukh, A., de Albornoz, Á., Terashima-Marín, H. (eds.) MICAI 2005. LNCS (LNAI), vol. 3789, pp. 833–842. Springer, Heidelberg (2005)
Gelbukh, A., Sidorov, G.: Approach to construction of automatic morphological analysis systems for inflective languages with little effort. In: Gelbukh, A. (ed.) CICLing 2003. LNCS, vol. 2588, pp. 215–222. Springer, Heidelberg (2003)
Montero, J.M.: Sistemas de conversión texto voz. B.S.thesis. Universidad Polit, http://lorien.die.upm.es/~juancho
Ward, W.: Evaluation of the CMU ATIS System. In: Proc. DARPA Speech and Natural Language Workshop, pp. 101–105 (1991)
Zue, V., Glass, J., Goodine, D., Leung, H., Philips, M., Polifroni, J., Seneff, S.: Preliminary ATIS Development MIT. In: Proc. DARPA Speech and Natural Language Workshop, pp. 130–135 (1990)
Kubala, F., Austin, S., Barry, C., Makhoul, J., Placeway, P., Schwartz, R.: BYBLOS Speech Recognition Benchmark Results. In: Proc. Workshop on Speech and Natural Language, pp. 77–82 (1991)
Pieraccini, R., Tzoukermann, E., Gorelov, Z., Levin, E., Lee, C., Gauvain, J.: Progress Report on the Chronus System: ATIS Benchmark Results (1992)
Popescu, A.M., Armanasu, A., Etzioni, O., Ko, D., Yates, A.: Modern Natural Language Interfaces to Databases: Composing Statical Parsing with Semantic Tractability. University of Washington (2004)
Calvo, H., Gelbukh, A.: Improving Prepositional Phrase Attachment Disambiguation Using the Web as Corpus. In: Sanfeliu, A., Ruiz-Shulcloper, J. (eds.) CIARP 2003. LNCS, vol. 2905, pp. 604–610. Springer, Heidelberg (2003)
Calvo, H., Gelbukh, A.: Acquiring Selectional Preferences from Untagged Text for Prepositional Phrase Attachment Disambiguation. In: Meziane, F., Métais, E. (eds.) NLDB 2004. LNCS, vol. 3136, pp. 207–216. Springer, Heidelberg (2004)
Fagin, R.: Degrees of Acyclicity for Hypergraphs and Relational Database Schemes. Journal of the ACM 30(3), 514–550 (1983)
Microsoft English Query Tutorials available with standard installation in SQL SERVER 7.0
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2006 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Juan J. González, B., Rangel, R.A.P., Cruz C., I.C., Héctor J. Fraire, H., de Santos Aguilar, L., Joaquín Pérez, O. (2006). Issues in Translating from Natural Language to SQL in a Domain-Independent Natural Language Interface to Databases. In: Gelbukh, A., Reyes-Garcia, C.A. (eds) MICAI 2006: Advances in Artificial Intelligence. MICAI 2006. Lecture Notes in Computer Science(), vol 4293. Springer, Berlin, Heidelberg. https://doi.org/10.1007/11925231_88
Download citation
DOI: https://doi.org/10.1007/11925231_88
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-49026-5
Online ISBN: 978-3-540-49058-6
eBook Packages: Computer ScienceComputer Science (R0)