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 条

[31] 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):
[32] Abstractive Text Summarization Using T5 Architecture
Ramesh, G. S.
Manyam, Vamsi
Mandula, Vijoosh
Myana, Pavan
Macha, Sathvika
Reddy, Suprith
PROCEEDINGS OF SECOND INTERNATIONAL CONFERENCE ON ADVANCES IN COMPUTER ENGINEERING AND COMMUNICATION SYSTEMS, ICACECS 2021, 2022, : 535 - 543
[33] SONGS CONTINUATION GENERATION TECHNOLOGY BASED ON TEST GENERATION STRATEGIES, TEXTMINING AND LANGUAGE MODEL T5
Mediakov, O.
Vysotska, V.
RADIO ELECTRONICS COMPUTER SCIENCE CONTROL, 2023, (04) : 157 - 174
[34] 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
[35] Formation of SQL from Natural Language Query using NLP
Uma, M.
Sneha, V
Sneha, G.
Bhuvana, J.
Bharathi, B.
2019 SECOND INTERNATIONAL CONFERENCE ON COMPUTATIONAL INTELLIGENCE IN DATA SCIENCE (ICCIDS 2019), 2019,
[36] Evaluation of Datasets Focused on Grammatical Error Correction Using the T5 Model in Slovak
Harahus, Maros
Sokolova, Zuzana
Pleva, Matus
Juhar, Jozef
Hladek, Daniel
Stas, Jan
Kocturova, Marianna
2024 34TH INTERNATIONAL CONFERENCE RADIOELEKTRONIKA, RADIOELEKTRONIKA 2024, 2024,
[37] Searching for music using natural language queries and relevance feedback
Knees, Peter
Widmer, Gerhard
ADAPTIVE MULTIMEDIAL RETRIEVAL: RETRIEVAL, USER, AND SEMANTICS, 2008, 4918 : 109 - 121
[38] Processing of Korean Natural Language Queries Using Local Grammars
Noh, Tac-Gil
Han, Yong-Jin
Park, Seong-Bae
Park, Se-Young
COMPUTER PROCESSING OF ORIENTAL LANGUAGES: LANGUAGE TECHNOLOGY FOR THE KNOWLEDGE-BASED ECONOMY, 2009, 5459 : 34 - 44
[39] 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,
[40] Reformulating natural language queries using sequence-to-sequence models
Liu, Xiaoyu
Pan, Shunda
Zhang, Qi
Jiang, Yu-Gang
Huang, Xuanjing
SCIENCE CHINA-INFORMATION SCIENCES, 2019, 62 (12)

← 1 2 3 4 5 →