EUVIMEDEUVIMED entdecken
Open Access · CC BY 4.0

Text-to-SQL: A methodical review of challenges and models

Ali Buğra KANBUROĞLU, Faik Boray TEK

Turkish Journal of Electrical Engineering and Computer Sciences · 20.05.2024 · 32 (3) · 403-419

DOI: 10.55730/1300-0632.4077 ↗

Kurz gefasst

Fachartikel in der Zeitschrift Turkish Journal of Electrical Engineering and Computer Sciences, online erschienen am 20.05.2024. Verfasst von Ali Buğra KANBUROĞLU und 1 weiteren Autor:innen. Die Arbeit wurde bisher 33-mal zitiert (Crossref). Der Volltext ist frei zugänglich (Open Access, CC BY 4.0).

AbstractBibliografische AngabenZitierenVerwandte Studien

Abstract (Originalsprache)

This survey focuses on Text-to-SQL, automated translation of natural language queries into SQL queries. Initially, we describe the problem and its main challenges. Then, by following the PRISMA systematic review methodology, we survey the existing Text-to-SQL review papers in the literature. We apply the same method to extract proposed Text-to-SQL models and classify them with respect to used evaluation metrics and benchmarks. We highlight the accuracies achieved by various models on Text-to-SQL datasets and discuss execution-guided evaluation strategies. We present insights into model training times and implementations of different models. We also explore the availability of Text-to-SQL datasets in non-English languages. Additionally, we focus on large language model (LLM) based approaches for the Text-to-SQL task, where we examine LLM-based studies in the literature and subsequently evaluate the LLMs on the cross-domain Spider dataset. Finally, we conclude with a discussion of future directions for Text-to-SQL research, identifying potential areas of improvement and advancements in this field.

Zitieren

APA

KANBUROĞLU, A. B., & TEK, F. B. (2024). Text-to-SQL: A methodical review of challenges and models. Turkish Journal of Electrical Engineering and Computer Sciences, 32(3), 403-419. https://doi.org/10.55730/1300-0632.4077

Vancouver

KANBUROĞLU AB, TEK FB. Text-to-SQL: A methodical review of challenges and models. Turkish Journal of Electrical Engineering and Computer Sciences. 2024;32(3):403-419. doi:10.55730/1300-0632.4077

BibTeX
@article{KANBUROLU2024,
  author = {KANBUROĞLU, Ali Buğra and TEK, Faik Boray},
  title = {Text-to-SQL: A methodical review of challenges and models},
  journal = {Turkish Journal of Electrical Engineering and Computer Sciences},
  year = {2024},
  volume = {32},
  number = {3},
  pages = {403--419},
  doi = {10.55730/1300-0632.4077}
}
Kostenlos starten →