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...
Autores principales: | , , , , , |
---|---|
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 |