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] 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,
[3] 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
[4] Semantic Mapping between Natural Language Questions and SQL Queries via Syntactic Pairing
Giordani, Alessandra
Moschitti, Alessandro
NATURAL LANGUAGE PROCESSING AND INFORMATION SYSTEMS, 2010, 5723 : 207 - 221
[5] Rewriting Natural Language Queries Using Patterns
Soualmia, Lina F.
Lelong, Romain
Dahamna, Badisse
Darmoni, Stefan J.
MULTIMODAL RETRIEVAL IN THE MEDICAL DOMAIN, MRMD 2015, 2015, 9059 : 40 - 53
[6] Natural Language Query to SQL conversion using Machine Learning Approach
Arefin, Minhazul
Hossen, Kazi Mojammel
Uddin, Mohammed Nasir
2021 3RD INTERNATIONAL CONFERENCE ON SUSTAINABLE TECHNOLOGIES FOR INDUSTRY 4.0 (STI), 2021,
[7] Towards an interface for translating natural language questions to SQL: A conceptual framework from a systematic review
Ahkouk K.
Machkour M.
International Journal of Reasoning-based Intelligent Systems, 2020, 12 (04) : 264 - 275
[8] Translating Speech to Indian Sign Language Using Natural Language Processing
Sharma, Purushottam
Tulsian, Devesh
Verma, Chaman
Sharma, Pratibha
Nancy, Nancy
FUTURE INTERNET, 2022, 14 (09)
[9] A Robust Model for Translating Arabic Sign Language into Spoken Arabic Using Deep Learning
Nahar, Khalid M. O.
Almomani, Ammar
Shatnawi, Nahlah
Alauthman, Mohammad
INTELLIGENT AUTOMATION AND SOFT COMPUTING, 2023, 37 (02): : 2037 - 2057
[10] An Approach for Generating SQL Query Using Natural Language Processing
More, Priyanka
Kudale, Bharti
Deshmukh, Pranali
Biswas, Indira N.
More, Neha J.
Gomes, Francisco S.
INTELLIGENT COMMUNICATION TECHNOLOGIES AND VIRTUAL MOBILE NETWORKS, ICICV 2019, 2020, 33 : 226 - 230

← 1 2 3 4 5 →