arXivDaily arXiv每日学术速递 周一至周五更新
arXiv 2208.04415cs.CLcs.AI
收藏

深度学习驱动的自然语言文本到SQL查询转换:综述

Deep Learning Driven Natural Languages Text to SQL Query Conversion: A Survey

Ayush Kumar, Parth Nagarkar, Prabhav Nalhe, Sanjeev Vijayakumar

摘要:

随着未来朝着以数据为中心的决策方向发展,对数据库的无缝访问至关重要。对于创建一个高效的文本到SQL(TEXT2SQL)模型来访问数据库中的数据,有着广泛的研究。使用自然语言是最好的界面之一,可以通过有效地访问数据库来弥合数据和结果之间的差距,特别是对于非技术用户。它将为精通技术技能或不太熟悉查询语言的用户打开大门并产生巨大的兴趣。即使提出或研究了许多基于深度学习的算法,在实际工作场景中使用自然语言来解决数据查询问题的通用模型仍然是非常具有挑战性的。原因是在不同的研究中使用不同的数据集,这带来了其局限性和假设。在本文中,我们试图对最近几年研究的24种神经网络模型进行全面的概述,包括它们的架构,包括卷积神经网络,递归神经网络,指针网络,强化学习,生成模型,我们还概述了广泛用于训练TEXT 2SQL技术模型的11个数据集。我们还讨论了TEXT2SQL技术的无缝数据查询的未来应用的可能性。

英文摘要:

With the future striving toward data-centric decision-making, seamless access to databases is of utmost importance. There is extensive research on creating an efficient text-to-sql (TEXT2SQL) model to access data from the database. Using a Natural language is one of the best interfaces that can bridge the gap between the data and results by accessing the database efficiently, especially for non-technical users. It will open the doors and create tremendous interest among users who are well versed in technical skills or not very skilled in query languages. Even if numerous deep learning-based algorithms are proposed or studied, there still is very challenging to have a generic model to solve the data query issues using natural language in a real-work scenario. The reason is the use of different datasets in different studies, which comes with its limitations and assumptions. At the same time, we do lack a thorough understanding of these proposed models and their limitations with the specific dataset it is trained on. In this paper, we try to present a holistic overview of 24 recent neural network models studied in the last couple of years, including their architectures involving convolutional neural networks, recurrent neural networks, pointer networks, reinforcement learning, generative models, etc. We also give an overview of the 11 datasets that are widely used to train the models for TEXT2SQL technologies. We also discuss the future application possibilities of TEXT2SQL technologies for seamless data queries.

机构、总结、中文摘要均由AI分析而来,可能存在错误,请以论文正文为准。

↑