Cargando…

Comparative study on the customization of natural language interfaces to databases

In the last decades the popularity of natural language interfaces to databases (NLIDBs) has increased, because in many cases information obtained from them is used for making important business decisions. Unfortunately, the complexity of their customization by database administrators make them diffi...

Descripción completa

Detalles Bibliográficos
Autores principales: Pazos R., Rodolfo A., Aguirre L., Marco A., González B., Juan J., Martínez F., José A., Pérez O., Joaquín, Verástegui O., Andrés A.
Formato: Online Artículo Texto
Lenguaje:English
Publicado: Springer International Publishing 2016
Materias:
Acceso en línea:https://www.ncbi.nlm.nih.gov/pmc/articles/PMC4851672/
https://www.ncbi.nlm.nih.gov/pubmed/27190752
http://dx.doi.org/10.1186/s40064-016-2164-y
_version_ 1782429840696147968
author Pazos R., Rodolfo A.
Aguirre L., Marco A.
González B., Juan J.
Martínez F., José A.
Pérez O., Joaquín
Verástegui O., Andrés A.
author_facet Pazos R., Rodolfo A.
Aguirre L., Marco A.
González B., Juan J.
Martínez F., José A.
Pérez O., Joaquín
Verástegui O., Andrés A.
author_sort Pazos R., Rodolfo A.
collection PubMed
description In the last decades the popularity of natural language interfaces to databases (NLIDBs) has increased, because in many cases information obtained from them is used for making important business decisions. Unfortunately, the complexity of their customization by database administrators make them difficult to use. In order for a NLIDB to obtain a high percentage of correctly translated queries, it is necessary that it is correctly customized for the database to be queried. In most cases the performance reported in NLIDB literature is the highest possible; i.e., the performance obtained when the interfaces were customized by the implementers. However, for end users it is more important the performance that the interface can yield when the NLIDB is customized by someone different from the implementers. Unfortunately, there exist very few articles that report NLIDB performance when the NLIDBs are not customized by the implementers. This article presents a semantically-enriched data dictionary (which permits solving many of the problems that occur when translating from natural language to SQL) and an experiment in which two groups of undergraduate students customized our NLIDB and English language frontend (ELF), considered one of the best available commercial NLIDBs. The experimental results show that, when customized by the first group, our NLIDB obtained a 44.69 % of correctly answered queries and ELF 11.83 % for the ATIS database, and when customized by the second group, our NLIDB attained 77.05 % and ELF 13.48 %. The performance attained by our NLIDB, when customized by ourselves was 90 %.
format Online
Article
Text
id pubmed-4851672
institution National Center for Biotechnology Information
language English
publishDate 2016
publisher Springer International Publishing
record_format MEDLINE/PubMed
spelling pubmed-48516722016-05-17 Comparative study on the customization of natural language interfaces to databases Pazos R., Rodolfo A. Aguirre L., Marco A. González B., Juan J. Martínez F., José A. Pérez O., Joaquín Verástegui O., Andrés A. Springerplus Research In the last decades the popularity of natural language interfaces to databases (NLIDBs) has increased, because in many cases information obtained from them is used for making important business decisions. Unfortunately, the complexity of their customization by database administrators make them difficult to use. In order for a NLIDB to obtain a high percentage of correctly translated queries, it is necessary that it is correctly customized for the database to be queried. In most cases the performance reported in NLIDB literature is the highest possible; i.e., the performance obtained when the interfaces were customized by the implementers. However, for end users it is more important the performance that the interface can yield when the NLIDB is customized by someone different from the implementers. Unfortunately, there exist very few articles that report NLIDB performance when the NLIDBs are not customized by the implementers. This article presents a semantically-enriched data dictionary (which permits solving many of the problems that occur when translating from natural language to SQL) and an experiment in which two groups of undergraduate students customized our NLIDB and English language frontend (ELF), considered one of the best available commercial NLIDBs. The experimental results show that, when customized by the first group, our NLIDB obtained a 44.69 % of correctly answered queries and ELF 11.83 % for the ATIS database, and when customized by the second group, our NLIDB attained 77.05 % and ELF 13.48 %. The performance attained by our NLIDB, when customized by ourselves was 90 %. Springer International Publishing 2016-04-30 /pmc/articles/PMC4851672/ /pubmed/27190752 http://dx.doi.org/10.1186/s40064-016-2164-y Text en © Pazos R. et al. 2016 Open AccessThis article is distributed under the terms of the Creative Commons Attribution 4.0 International License (http://creativecommons.org/licenses/by/4.0/), which permits unrestricted use, distribution, and reproduction in any medium, provided you give appropriate credit to the original author(s) and the source, provide a link to the Creative Commons license, and indicate if changes were made.
spellingShingle Research
Pazos R., Rodolfo A.
Aguirre L., Marco A.
González B., Juan J.
Martínez F., José A.
Pérez O., Joaquín
Verástegui O., Andrés A.
Comparative study on the customization of natural language interfaces to databases
title Comparative study on the customization of natural language interfaces to databases
title_full Comparative study on the customization of natural language interfaces to databases
title_fullStr Comparative study on the customization of natural language interfaces to databases
title_full_unstemmed Comparative study on the customization of natural language interfaces to databases
title_short Comparative study on the customization of natural language interfaces to databases
title_sort comparative study on the customization of natural language interfaces to databases
topic Research
url https://www.ncbi.nlm.nih.gov/pmc/articles/PMC4851672/
https://www.ncbi.nlm.nih.gov/pubmed/27190752
http://dx.doi.org/10.1186/s40064-016-2164-y
work_keys_str_mv AT pazosrrodolfoa comparativestudyonthecustomizationofnaturallanguageinterfacestodatabases
AT aguirrelmarcoa comparativestudyonthecustomizationofnaturallanguageinterfacestodatabases
AT gonzalezbjuanj comparativestudyonthecustomizationofnaturallanguageinterfacestodatabases
AT martinezfjosea comparativestudyonthecustomizationofnaturallanguageinterfacestodatabases
AT perezojoaquin comparativestudyonthecustomizationofnaturallanguageinterfacestodatabases
AT verasteguioandresa comparativestudyonthecustomizationofnaturallanguageinterfacestodatabases