Translating Natural Language Queries to SQL Using the T5 Model

被引：0

作者：

Wong, Albert ^{[1
]}

Pham, Lien ^{[1
]}

Lee, Young ^{[2
]}

Chan, Shek ^{[1
]}

Sadaya, Razel ^{[1
]}

Khmelevsky, Youry ^{[3
]}

Clement, Mathias ^{[3
]}

Cheng, Florence Wing Yau ^{[1
]}

Mahony, Joe ^{[4
]}

Ferri, Michael ^{[4
]}

机构：

[1] Langara Coll, Math & Stat, Vancouver, BC, Canada

[2] Okanagan Coll, Math & Stat, Kelowna, BC, Canada

[3] Okanagan Coll, Comp Sci, Kelowna, BC, Canada

[4] Harris SmartWorks, Res & Dev, Ottawa, ON, Canada

来源：

18TH ANNUAL IEEE INTERNATIONAL SYSTEMS CONFERENCE, SYSCON 2024 | 2024年

基金：

加拿大自然科学与工程研究理事会;

关键词：

Natural Language Processing; Data Query System; Text-to-SQL; Speech-to-SQL; Deep Learning; Machine Learning; T5; Model; Human-Machine-Systems; Energy Systems;

D O I：

10.1109/SysCon61195.2024.10553509

中图分类号：

TP301 [理论、方法];

学科分类号：

081202 ;

摘要：

This paper presents the development process of a natural language to SQL model using the T5 model as the basis. The models, developed in August 2022 for an online transaction processing system and a data warehouse, have a 73% and 84% exact match accuracy respectively. These models, in conjunction with other work completed in the research project, were implemented for several companies and used successfully on a daily basis. The approach used in the model development could be implemented in a similar fashion for other database environments and with a more powerful pre-trained language model.

引用

下载

页数：7

共 50 条

[1] Translating natural language questions to SQL queries (nested queries)
Swamidorai, Sindhuja
Murthy, T. Satyanarayana
Sriharsha, K., V
MULTIMEDIA TOOLS AND APPLICATIONS, 2023, 83 (15) : 45391 - 45405
[2] Translating natural language questions to SQL queries (nested queries)
Sindhuja Swamidorai
T Satyanarayana Murthy
K V Sriharsha
Multimedia Tools and Applications, 2024, 83 : 45391 - 45405
[3] A system to transform natural language queries into SQL queries
Solanki A.
Kumar A.
International Journal of Information Technology, 2022, 14 (1) : 437 - 446
[4] Using natural language processing in order to create SQL queries
djahantighi, F. Siasar
Norouzifard, M.
Davarpanah, S. H.
Shenassa, M. H.
2008 INTERNATIONAL CONFERENCE ON COMPUTER AND COMMUNICATION ENGINEERING, VOLS 1-3, 2008, : 600 - +
[5] ACL-SQL: Generating SQL Queries from Natural Language
Kaoshik, Ronak
Patil, Rohit
Prakash, R.
Agarawal, Shaurya
Jain, Naman
Singh, Mayank
CODS-COMAD 2021: PROCEEDINGS OF THE 3RD ACM INDIA JOINT INTERNATIONAL CONFERENCE ON DATA SCIENCE & MANAGEMENT OF DATA (8TH ACM IKDD CODS & 26TH COMAD), 2021, : 423 - 423
[6] QUESTION PATTERNS FOR NATURAL LANGUAGE TRANSLATION IN SQL QUERIES
Zhekova, Mariya
Totkov, George
INTERNATIONAL JOURNAL ON INFORMATION TECHNOLOGIES AND SECURITY, 2021, 13 (02): : 43 - 54
[7] Translating Web Search Queries into Natural Language Questions
Kumar, Adarsh
Dandapat, Sandipan
Chordia, Sushil
PROCEEDINGS OF THE ELEVENTH INTERNATIONAL CONFERENCE ON LANGUAGE RESOURCES AND EVALUATION (LREC 2018), 2018, : 944 - 947
[8] Natural Language Processing Technique for Generation of SQL Queries Dynamically
Sanyal, Hrithik
Shukla, Sagar
Agrawal, Rajneesh
2021 6TH INTERNATIONAL CONFERENCE FOR CONVERGENCE IN TECHNOLOGY (I2CT), 2021,
[9] Learning to Transform Vietnamese Natural Language Queries into SQL Commands
Thi-Hai-Yen Vuong
Thi-Thu-Trang Nguyen
Nhu-Thuat Tran
PROCEEDINGS OF 2019 11TH INTERNATIONAL CONFERENCE ON KNOWLEDGE AND SYSTEMS ENGINEERING (KSE 2019), 2019, : 410 - 414
[10] Articulate: A Semi-automated Model for Translating Natural Language Queries into Meaningful Visualizations
Sun, Yiwen
Leigh, Jason
Johnson, Andrew
Lee, Sangyoon
SMART GRAPHICS, PROCEEDINGS, 2010, 6133 : 184 - 195

← 1 2 3 4 5 →