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...

Descripción completa

Detalles Bibliográficos
Autores principales: Bazaga, Adrián, Gunwant, Nupur, Micklem, Gos
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