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.

Research output: Chapter in Book/Report/Conference proceedingConference contributionpeer-review

1 Scopus citations

Abstract

This paper present the treatment of prepositions and conj unctions 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 Pubsof 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.

Original languageEnglish
Title of host publicationFrontiers of High Performance Computing and Networking - ISPA 2007 Workshops. ISPA 2007 International Workshops - SSDSN, UPWN, WISH, SGC, ParDMCom,HiPCoMB, and IST-AWSN, Proceedings
PublisherSpringer Verlag
Pages173-182
Number of pages10
ISBN (Print)9783540747666
DOIs
StatePublished - 2007
Externally publishedYes
Event5th International Symposium on Parallel and Distributed Processing and Applications, ISPA 2007 International Workshops: SSDSN, UPWN, WISH, SGC, ParDMCom, HiPCoMB, and IST-AWSN - Niagara Falls, ON, Canada
Duration: 29 Aug 200731 Aug 2007

Publication series

NameLecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)
Volume4743 LNCS
ISSN (Print)0302-9743
ISSN (Electronic)1611-3349

Conference

Conference5th International Symposium on Parallel and Distributed Processing and Applications, ISPA 2007 International Workshops: SSDSN, UPWN, WISH, SGC, ParDMCom, HiPCoMB, and IST-AWSN
Country/TerritoryCanada
CityNiagara Falls, ON
Period29/08/0731/08/07

Fingerprint

Dive into the research topics of 'Prepositions and conjunctions in a natural language interfaces to databases'. Together they form a unique fingerprint.

Cite this