Abstract
This paper present the treatment of prepositions and conjunctions in natural language interfaces to databases (NLIDB) that allows better translation of queries expressed in natural language into formal languages. Prepositions and conjunctions weren’t sufficiently studied for their usage in NLIDBs, because most of the NLIDBs just look for keywords in the sentences and focus their analysis on nouns and verbs getting rid of auxiliary words in the query. This paper shows that prepositions and conjunctions can be represented as operations using formal set theory. Additionally, since prepositions and conjunctions keep their meaning in any context, their treatment is domain independent. In our experiments we used Spanish language. We validate our approach using two databases; Northwind and Pubs of SQL Server, with a corpus of 198 different queries for the first one and 70 queries for the second one. The 84% of queries were translated correctly for the database Northwind and 80% for Pubs.
This research was supported in part by CONACYT and DGEST.
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
Popescu, A.M., Etzioni, O., Kautz, H.: Towards a Theory of Natural Language Interfaces to Databases. In: Proceedings of the 2003 International Conference on Intelligent User Interfaces, ACM Press, New York (2003)
Orea, M.Q.: Interfaz en Espanol para Recuperacion de Informacion en una Base de Datos Geografica. B.S. thesis. Universidad de las Americas. Puebla (2001)
AVENTINUS - Advanced Information System for Multinational Drug Enforcement, http://www.dcs.shef.ac.uk/nlp/funded/aventinus.html
Areas de Investigacion; Procesamiento de Lenguaje Natural (1998), http://gplsi.dlsi.ua.es/gplsi/areas.htm
Sidorov, G.: Problemas actuales de Lingüistica Computacional. Revista Digital Universitaria 2(1) (2001), http://www.revista.unam.mx/vol.2/num1/art1/
Stallard, M.S., Bobrow, D., Schwartz, R.: A Fully Statistical Approach to Natural Language Interfaces. In: Proc. 34th Annual Meeting of the Association for Computational Linguistics (1996)
Minker, W.: Stochastically-Based Natural Language Understanding Across Task and Languages. In: Proc. of EuroSpeech 1997, Rodas, Greece (1997), http://citeseer.nj.nec.com/
Moreno, L., Molina, A.: Preliminares y Tendencias en el Procesamiento del Lenguaje Natural, Departamento de Sistemas Informaticos y Computacion. Universidad Politecnica de Valencia
Profesor en Linea. Gramatica y Ortografia: http://www.profesorenlinea.cl/castellano/oracionpartesdela.htm
Enciclopedia Libre. Enciclopedia Libre Universal en Espanol (2004), http://enciclopedia.us.es/wiki.phtml
Prytz, O.: Notas sobre las Preposiciones Simples en Espanol Moderno (1994), http://www.digbib.uio.no/roman/Art/Rf1-94-1/Prytzb.pdf
Martin V., G.: Curso de Redaccion. Teoria y Practica de la Composicion del Estilo. Editorial Thomson. 33a edicion. Madrid, España. (2002).
Martin, A.: Una Propuesta de Codificacion Morfosintactica para Corpus de Referencia en Lengua Espanola. In: Martin, A. (ed.) Estudios de Lingüistica Espanola (ELiEs). Publicacion periodica de monografias sobre lingüistica espanola (1999), http://elies.rediris.es/elies3/cap31a.htm
Bridge, G., Harlow, S.: An Introduction to Computational Linguistics, Intelligent System Group. Department of Computer Science. University of York
Meng, F., Chu, W.W.: Database Query Formation from Natural Language Using Semantic Modeling and Statistical Keyword Meaning Disambiguation. Computer Science Department. University of California
InBase-Online. English queries to personnel DB. Russian Research Institute of Artificial Intelligence (2001), http://www.inbase.artint.ru/nl/kadry-eng.asp
Montero, J.M.: Sistemas de conversion texto voz. B.S.thesis. Universidad Politecnica de Madrid. http://lorien.die.upm.es/~juancho
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 2007 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
González B., J.J., Pazos R., R.A., Gelbukh, A., Sidorov, G., Fraire H., H., Cruz C., I.C. (2007). Prepositions and Conjunctions in a Natural Language Interfaces to Databases. In: Thulasiraman, P., He, X., Xu, T.L., Denko, M.K., Thulasiram, R.K., Yang, L.T. (eds) Frontiers of High Performance Computing and Networking ISPA 2007 Workshops. ISPA 2007. Lecture Notes in Computer Science, vol 4743. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-74767-3_19
Download citation
DOI: https://doi.org/10.1007/978-3-540-74767-3_19
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-74766-6
Online ISBN: 978-3-540-74767-3
eBook Packages: Computer ScienceComputer Science (R0)