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 条

[21] Translating synthetic natural language to database queries with a polyglot deep learning framework
Bazaga, Adrian
Gunwant, Nupur
Micklem, Gos
SCIENTIFIC REPORTS, 2021, 11 (01)
[22] Translating synthetic natural language to database queries with a polyglot deep learning framework
Adrián Bazaga
Nupur Gunwant
Gos Micklem
Scientific Reports, 11
[23] A Question and Answering Service of Typhoon Disasters Based on the T5 Large Language Model
Xia, Yongqi
Huang, Yi
Qiu, Qianqian
Zhang, Xueying
Miao, Lizhi
Chen, Yixiang
ISPRS INTERNATIONAL JOURNAL OF GEO-INFORMATION, 2024, 13 (05)
[24] 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
[25] 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
[26] Inspecting Data Using Natural Language Queries
Bacci, Franscesca
Cau, Federico Maria
Spano, Lucio Davide
COMPUTATIONAL SCIENCE AND ITS APPLICATIONS - ICCSA 2020, PT VI, 2020, 12254 : 771 - 782
[27] A Robust Ontology-Based Method for Translating Natural Language Queries to Conceptual Graphs
Cao, Tru H.
Cao, Truong D.
Tran, Thang L.
SEMANTIC WEB, PROCEEDINGS, 2008, 5367 : 479 - 492
[28] Towards an interface for translating natural language questions to SQL: A conceptual framework from a systematic review
Ahkouk, Karam
Machkour, Mustapha
International Journal of Reasoning-based Intelligent Systems, 2020, 12 (04) : 264 - 275
[29] Searching a Video Database using Natural Language Queries
Shubha, M.
Kapoor, Kritika
Shrutiya, M.
Mamatha, H. R.
2021 INTERNATIONAL CONFERENCE ON EMERGING SMART COMPUTING AND INFORMATICS (ESCI), 2021, : 190 - 196
[30] Mathematical Formula Search using Natural Language Queries
Yang, Seon
Ko, Youngjoong
ADVANCES IN ELECTRICAL AND COMPUTER ENGINEERING, 2014, 14 (04) : 99 - 104

← 1 2 3 4 5 →