EUVIMEDEUVIMED entdecken
Crossref

The Dawn of Natural Language to SQL: Are We Fully Ready?

Boyan Li, Yuyu Luo, Chengliang Chai, Guoliang Li, Nan Tang

Proceedings of the VLDB Endowment · 2024-07 · 17 (11) · 3318-3331

DOI: 10.14778/3681954.3682003 ↗

Kurz gefasst

Fachartikel in der Zeitschrift Proceedings of the VLDB Endowment, online erschienen am 30.08.2024. Verfasst von Boyan Li und 4 weiteren Autor:innen. Die Arbeit wurde bisher 98-mal zitiert (Crossref) und nennt 61 Literaturangaben.

AbstractBibliografische AngabenZitierenVerwandte Studien

Abstract (Originalsprache)

Translating users' natural language questions into SQL queries ( i.e. , nl2sql) significantly lowers the barriers to accessing relational databases. The emergence of Large Language Models has introduced a novel paradigm in nl2sql tasks, enhancing capabilities dramatically. However, this raises a critical question: Are we fully prepared to deploy nl2sql models in production? To address the posed questions, we present a multi-angle nl2sql evaluation framework, NL2SQL360 , to facilitate the design and test of new nl2sql methods for researchers. Through NL2SQL360 , we conduct a detailed comparison of leading nl2sql methods across a range of application scenarios, such as different data domains and sql characteristics, offering valuable insights for selecting the most appropriate nl2sql methods for specific needs. Moreover, we explore the nl2sql design space, leveraging NL2SQL360 to automate the identification of an optimal nl2sql solution tailored to user-specific needs. Specifically, NL2SQL360 identifies an effective nl2sql method, SuperSQL , distinguished under the Spider dataset using the execution accuracy metric. Remarkably, SuperSQL achieves competitive performance with execution accuracy of 87 % and 62.66 % on the Spider and BIRD test sets, respectively.

Zitieren

APA

Li, B., Luo, Y., Chai, C., Li, G., & Tang, N. (2024). The Dawn of Natural Language to SQL: Are We Fully Ready?. Proceedings of the VLDB Endowment, 17(11), 3318-3331. https://doi.org/10.14778/3681954.3682003

Vancouver

Li B, Luo Y, Chai C, Li G, Tang N. The Dawn of Natural Language to SQL: Are We Fully Ready?. Proceedings of the VLDB Endowment. 2024;17(11):3318-3331. doi:10.14778/3681954.3682003

BibTeX
@article{Li2024,
  author = {Li, Boyan and Luo, Yuyu and Chai, Chengliang and Li, Guoliang and Tang, Nan},
  title = {The Dawn of Natural Language to SQL: Are We Fully Ready?},
  journal = {Proceedings of the VLDB Endowment},
  year = {2024},
  volume = {17},
  number = {11},
  pages = {3318--3331},
  doi = {10.14778/3681954.3682003}
}
Kostenlos starten →