Author:
Bazaga Adrián,Gunwant Nupur,Micklem Gos
Abstract
AbstractThe 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.
Publisher
Springer Science and Business Media LLC
Reference32 articles.
1. Affolter, K., Stockinger, K. & Bernstein, A. A comparative survey of recent natural language interfaces for databases. VLDB J. 28(5), 793–819 (2019).
2. Dar, H. S., Lali, M. I., Ul Din, M., Malik, K. M., & Bukhari, S. A. C. Frameworks for querying databases using natural language: A literature review (2019). arXiv:1909.01822.
3. Reshma, E. U. & Remya, P. C. A review of different approaches in natural language interfaces to databases. in 2017 International Conference on Intelligent Sustainable Systems (ICISS), 801–804 (IEEE, 2017).
4. Ozcan, F., Quamar, A., Sen, J., Lei, C. & Efthymiou, V. State of the art and open challenges in natural language interfaces to data. in Proceedings of the 2020 ACM SIGMOD International Conference on Management of Data. SIGMOD ’20 Series, 2629–2636 (Association for Computing Machinery, 2020).
5. Blunschi, L., Jossen, C., Kossmann, D., Mori, M. & Stockinger, K. SODA: Generating SQL for business users. Proc. VLDB Endow. 5(10), 932–943 (2012).
Cited by
3 articles.
订阅此论文施引文献
订阅此论文施引文献,注册后可以免费订阅5篇论文的施引文献,订阅后可以查看论文全部施引文献
1. NLSQL: Generating and Executing SQL Queries via Natural Language Using Large Language Models;2023 International Conference on Advanced Computing Technologies and Applications (ICACTA);2023-10-06
2. A Peer Review on Natural Language Interface: Various Challenges and Scope;2023 International Conference on Disruptive Technologies (ICDT);2023-05-11
3. Modelo de Autentificación de Doble Factor;Innovación y Software;2023-03-30