A survey on deep learning approaches for text-to-SQL

被引:54
作者
Katsogiannis-Meimarakis, George [1 ]
Koutrika, Georgia [1 ]
机构
[1] Athena Res Ctr, Athens, Greece
关键词
Text-to-SQL; Deep learning; Natural language processing; Natural language interface for databases; NATURAL-LANGUAGE; QUERIES;
D O I
10.1007/s00778-022-00776-8
中图分类号
TP3 [计算技术、计算机技术];
学科分类号
0812 ;
摘要
To bridge the gap between users and data, numerous text-to-SQL systems have been developed that allow users to pose natural language questions over relational databases. Recently, novel text-to-SQL systems are adopting deep learning methods with very promising results. At the same time, several challenges remain open making this area an active and flourishing field of research and development. To make real progress in building text-to-SQL systems, we need to de-mystify what has been done, understand how and when each approach can be used, and, finally, identify the research challenges ahead of us. The purpose of this survey is to present a detailed taxonomy of neural text-to-SQL systems that will enable a deeper study of all the parts of such a system. This taxonomy will allow us to make a better comparison between different approaches, as well as highlight specific challenges in each step of the process, thus enabling researchers to better strategise their quest towards the "holy grail" of database accessibility.
引用
收藏
页码:905 / 936
页数:32
相关论文
共 111 条
[1]   A Review of NLIDB With Deep Learning: Findings, Challenges and Open Issues [J].
Abbas, Shanza ;
Khan, Muhammad Umair ;
Lee, Scott Uk-Jin ;
Abbas, Asad ;
Bashir, Ali Kashif .
IEEE ACCESS, 2022, 10 :14927-14945
[2]   A comparative survey of recent natural language interfaces for databases [J].
Affolter, Katrin ;
Stockinger, Kurt ;
Bernstein, Abraham .
VLDB JOURNAL, 2019, 28 (05) :793-819
[3]  
amb, US
[4]  
Amer-Yahia S, 2021, SIGMOD REC, V50, P23
[5]  
Androutsopoulos Ion., 1995, Natural language engineering, V1, P29, DOI [DOI 10.1017/S135132490000005X, 10.1017/S135132490000005X]
[6]  
[Anonymous], 2017, Sqlnet. Generating structured queries from natural language without reinforcement learning
[7]  
[Anonymous], NOT AMB
[8]  
[Anonymous], 2007, P ACM SIGMOD INT C M, DOI [10.1145/1247480.1247495, DOI 10.1145/1247480.1247495]
[9]  
[Anonymous], 2020, P 28 INT C COMPUTATI, DOI DOI 10.18653/V1/2020.COLING-MAIN.92
[10]   Analysis of Database Search Systems with THOR [J].
Belmpas, Theofilos ;
Gkini, Orest ;
Koutrika, Georgia .
SIGMOD'20: PROCEEDINGS OF THE 2020 ACM SIGMOD INTERNATIONAL CONFERENCE ON MANAGEMENT OF DATA, 2020, :2681-2684