Algorithm for Processing Queries that Involve Boolean Columns for a Natural Language Interface to Databases

Authors

  • Rodolfo A. Pazos R. Tecnológico Nacional de México, Instituto Tecnológico de Ciudad Madero
  • José A. Martínez F. Tecnológico Nacional de México, Instituto Tecnológico de Ciudad Madero
  • J. Javier Gonzalez B. Tecnológico Nacional de México, Instituto Tecnológico de Ciudad Madero
  • Andrés A. Verástegui O. Tecnológico Nacional de México, Instituto Tecnológico de Ciudad Madero

DOI:

https://doi.org/10.13053/cys-1-1-3313

Keywords:

Natural language interfaces to databases, natural language processing, databases, SQL

Abstract

In the last decades, the use of natural language interfaces to databases (NLIDBs) has increased exponentialy; unfortunately, the complexity of natural language has limited their effectiveness. The presence of Boolean columns in databases increases the difficulty for translating natural language queries to SQL. A Boolean column is a column that can only store two possible values: true/false, yes/no, 1/0. The problem for processing queries that involve Boolean columns, is that the search value for these columns (true/false, yes/no, 1/0) is not explicit in the queries. This problem makes NLIDBs generate erroneous translations as shown in experimental tests. A survey of the literature on NLIDBs has shown that this problem has not been identified, much less addressed. In this article, a new algorithm for processing queries that involve Boolean columns is presented. The algorithm uses syntactic and semantic information that facilitates detecting Boolean columns and their implicit values in a query. The experimental tests show that it is highly effective for translating this type of queries.

Downloads

Published

2020-03-25

Issue

Vol. 24 No. 1 (2020): 24(1)2020

Section

Articles

License 

Hereby I transfer exclusively to the Journal "Computación y 
Sistemas", published by the Computing Research Center (CIC-IPN),
the Copyright of the aforementioned paper. I also accept that these 
rights will not be transferred to any other publication, in any other 
format, language or other existing means of developing.
I certify that the paper has not been previously disclosed or simultaneo
usly submitted to any other publication, and that it does not contain 
material whose publication would violate the Copyright or other 
proprietary rights of any person, company or institution. I certify that 
I have the permission from the institution or company where I work or 
study to publish this work.
The representative author accepts the responsibility for the publication
of this paper on behalf of each and every one of the authors. 
This transfer is subject to the following conditions:
  • The authors retain all ownership rights (such as patent rights) of this work, except for the publishing rights transferred to the CIC, through this document.
  • Authors retain the right to publish the work in whole or in part in any book they are the authors or publishers. They can also make use of this work in conferences, courses, personal web pages, and so on.
  • Authors may include working as part of his thesis, for non-profit distribution only.