Prepositions and Conjunctions in a Natural Language Interfaces to Databases

  • J. Javier González B.
  • Rodolfo A. Pazos R.
  • Alexander Gelbukh
  • Grigori Sidorov
  • Hector Fraire H.
  • I. Cristina Cruz C.
Conference paper

DOI: 10.1007/978-3-540-74767-3_19

Part of the Lecture Notes in Computer Science book series (LNCS, volume 4743)
Cite this paper as:
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

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.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Springer-Verlag Berlin Heidelberg 2007

Authors and Affiliations

  • J. Javier González B.
    • 1
  • Rodolfo A. Pazos R.
    • 2
  • Alexander Gelbukh
    • 3
  • Grigori Sidorov
    • 3
  • Hector Fraire H.
    • 1
  • I. Cristina Cruz C.
    • 1
  1. 1.Instituto Tecnológico de Ciudad MaderoMéxico
  2. 2.Centro Nacional de Investigación y Desarrollo Tecnológico (CENIDET)México
  3. 3.Centro de Investigación en Computación 

Personalised recommendations