Cargando…
Translating synthetic natural language to database queries with a polyglot deep learning framework
The number of databases as well as their size and complexity is increasing. This creates a barrier to use especially for non-experts, who have to come to grips with the nature of the data, the way it has been represented in the database, and the specific query languages or user interfaces by which d...
Autores principales: | , , |
---|---|
Formato: | Online Artículo Texto |
Lenguaje: | English |
Publicado: |
Nature Publishing Group UK
2021
|
Materias: | |
Acceso en línea: | https://www.ncbi.nlm.nih.gov/pmc/articles/PMC8445976/ https://www.ncbi.nlm.nih.gov/pubmed/34531510 http://dx.doi.org/10.1038/s41598-021-98019-3 |
_version_ | 1784568774388613120 |
---|---|
author | Bazaga, Adrián Gunwant, Nupur Micklem, Gos |
author_facet | Bazaga, Adrián Gunwant, Nupur Micklem, Gos |
author_sort | Bazaga, Adrián |
collection | PubMed |
description | The number of databases as well as their size and complexity is increasing. This creates a barrier to use especially for non-experts, who have to come to grips with the nature of the data, the way it has been represented in the database, and the specific query languages or user interfaces by which data are accessed. These difficulties worsen in research settings, where it is common to work with many different databases. One approach to improving this situation is to allow users to pose their queries in natural language. In this work we describe a machine learning framework, Polyglotter, that in a general way supports the mapping of natural language searches to database queries. Importantly, it does not require the creation of manually annotated data for training and therefore can be applied easily to multiple domains. The framework is polyglot in the sense that it supports multiple different database engines that are accessed with a variety of query languages, including SQL and Cypher. Furthermore Polyglotter supports multi-class queries. Good performance is achieved on both toy and real databases, as well as a human-annotated WikiSQL query set. Thus Polyglotter may help database maintainers make their resources more accessible. |
format | Online Article Text |
id | pubmed-8445976 |
institution | National Center for Biotechnology Information |
language | English |
publishDate | 2021 |
publisher | Nature Publishing Group UK |
record_format | MEDLINE/PubMed |
spelling | pubmed-84459762021-09-20 Translating synthetic natural language to database queries with a polyglot deep learning framework Bazaga, Adrián Gunwant, Nupur Micklem, Gos Sci Rep Article The number of databases as well as their size and complexity is increasing. This creates a barrier to use especially for non-experts, who have to come to grips with the nature of the data, the way it has been represented in the database, and the specific query languages or user interfaces by which data are accessed. These difficulties worsen in research settings, where it is common to work with many different databases. One approach to improving this situation is to allow users to pose their queries in natural language. In this work we describe a machine learning framework, Polyglotter, that in a general way supports the mapping of natural language searches to database queries. Importantly, it does not require the creation of manually annotated data for training and therefore can be applied easily to multiple domains. The framework is polyglot in the sense that it supports multiple different database engines that are accessed with a variety of query languages, including SQL and Cypher. Furthermore Polyglotter supports multi-class queries. Good performance is achieved on both toy and real databases, as well as a human-annotated WikiSQL query set. Thus Polyglotter may help database maintainers make their resources more accessible. Nature Publishing Group UK 2021-09-16 /pmc/articles/PMC8445976/ /pubmed/34531510 http://dx.doi.org/10.1038/s41598-021-98019-3 Text en © The Author(s) 2021 https://creativecommons.org/licenses/by/4.0/Open AccessThis article is licensed under a Creative Commons Attribution 4.0 International License, which permits use, sharing, adaptation, distribution and reproduction in any medium or format, as long as you give appropriate credit to the original author(s) and the source, provide a link to the Creative Commons licence, and indicate if changes were made. The images or other third party material in this article are included in the article's Creative Commons licence, unless indicated otherwise in a credit line to the material. If material is not included in the article's Creative Commons licence and your intended use is not permitted by statutory regulation or exceeds the permitted use, you will need to obtain permission directly from the copyright holder. To view a copy of this licence, visit http://creativecommons.org/licenses/by/4.0/ (https://creativecommons.org/licenses/by/4.0/) . |
spellingShingle | Article Bazaga, Adrián Gunwant, Nupur Micklem, Gos Translating synthetic natural language to database queries with a polyglot deep learning framework |
title | Translating synthetic natural language to database queries with a polyglot deep learning framework |
title_full | Translating synthetic natural language to database queries with a polyglot deep learning framework |
title_fullStr | Translating synthetic natural language to database queries with a polyglot deep learning framework |
title_full_unstemmed | Translating synthetic natural language to database queries with a polyglot deep learning framework |
title_short | Translating synthetic natural language to database queries with a polyglot deep learning framework |
title_sort | translating synthetic natural language to database queries with a polyglot deep learning framework |
topic | Article |
url | https://www.ncbi.nlm.nih.gov/pmc/articles/PMC8445976/ https://www.ncbi.nlm.nih.gov/pubmed/34531510 http://dx.doi.org/10.1038/s41598-021-98019-3 |
work_keys_str_mv | AT bazagaadrian translatingsyntheticnaturallanguagetodatabasequerieswithapolyglotdeeplearningframework AT gunwantnupur translatingsyntheticnaturallanguagetodatabasequerieswithapolyglotdeeplearningframework AT micklemgos translatingsyntheticnaturallanguagetodatabasequerieswithapolyglotdeeplearningframework |