Algorithm for Processing Queries that Involve Boolean Columns for a Natural Language Interface to Databases
Título del documento: Algorithm for Processing Queries that Involve Boolean Columns for a Natural Language Interface to Databases
Revista: Computación y Sistemas
Base de datos: PERIÓDICA
Número de sistema: 000457625
ISSN: 1405-5546
Autores: 1
1
1
1
Instituciones: 1Tecnológico Nacional de México, Instituto Tecnológico de Ciudad Madero, Ciudad Madero, Tamaulipas. México
Año:
Periodo: Ene-Mar
Volumen: 24
Número: 1
Paginación: 61-74
País: México
Idioma: Inglés
Tipo de documento: Artículo
Enfoque: Aplicado, descriptivo
Resumen en inglés In the last decades, the use of natural language interfaces to databases (NLIDBs) has increased exponentially; 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
Disciplinas: Ciencias de la computación
Palabras clave: Inteligencia artificial,
Procesamiento de datos,
Programación,
Interfaz,
Procesamiento de lenguaje natural,
Bases de datos,
SQL
Keyword: Artificial intelligence,
Data processing,
Programming,
Interface,
Natural language processing,
Databases,
SQL
Texto completo: Texto completo (Ver HTML) Texto completo (Ver PDF)