TSCL-SQL:Two-Stage Curriculum Learning Framework for Text-to-SQL

TP391.1; Text-to-SQL is the task of translating a natural language query into a structured query language.Existing text-to-SQL approaches focus on improving the model's architecture while ignoring the relationship between queries and table schemas and the differences in difficulty between examp...

Full description

Saved in:
Bibliographic Details
Published in东华大学学报(英文版) Vol. 40; no. 4; pp. 421 - 427
Main Authors YIN Feng, CHENG Luyi, WANG Qiuyue, WANG Zhijun, DU Ming, XU Bo
Format Journal Article
LanguageEnglish
Published School of Computer Science and Technology,Donghua University,Shanghai 201620,China 31.08.2023
Subjects
Online AccessGet full text
ISSN1672-5220
DOI10.19884/j.1672-5220.202207003

Cover

Loading…
Abstract TP391.1; Text-to-SQL is the task of translating a natural language query into a structured query language.Existing text-to-SQL approaches focus on improving the model's architecture while ignoring the relationship between queries and table schemas and the differences in difficulty between examples in the dataset.To tackle these challenges,a two-stage curriculum learning framework for text-to-SQL(TSCL-SQL)is proposed in this paper.To exploit the relationship between the queries and the table schemas,a schema identification pre-training task is proposed to make the model choose the correct table schema from a set of candidates for a specific query.To leverage the differences in difficulty between examples,curriculum learning is applied to the text-to-SQL task,accompanied by an automatic curriculum learning solution,including a difficulty scorer and a training scheduler.Experiments show that the framework proposed in this paper is effective.
AbstractList TP391.1; Text-to-SQL is the task of translating a natural language query into a structured query language.Existing text-to-SQL approaches focus on improving the model's architecture while ignoring the relationship between queries and table schemas and the differences in difficulty between examples in the dataset.To tackle these challenges,a two-stage curriculum learning framework for text-to-SQL(TSCL-SQL)is proposed in this paper.To exploit the relationship between the queries and the table schemas,a schema identification pre-training task is proposed to make the model choose the correct table schema from a set of candidates for a specific query.To leverage the differences in difficulty between examples,curriculum learning is applied to the text-to-SQL task,accompanied by an automatic curriculum learning solution,including a difficulty scorer and a training scheduler.Experiments show that the framework proposed in this paper is effective.
Author WANG Qiuyue
CHENG Luyi
YIN Feng
WANG Zhijun
DU Ming
XU Bo
AuthorAffiliation School of Computer Science and Technology,Donghua University,Shanghai 201620,China
AuthorAffiliation_xml – name: School of Computer Science and Technology,Donghua University,Shanghai 201620,China
Author_xml – sequence: 1
  fullname: YIN Feng
– sequence: 2
  fullname: CHENG Luyi
– sequence: 3
  fullname: WANG Qiuyue
– sequence: 4
  fullname: WANG Zhijun
– sequence: 5
  fullname: DU Ming
– sequence: 6
  fullname: XU Bo
BookMark eNo9Ts1LwzAczWGCc-5fkF49pP7y0aT1pBQ3hYJIey_pktTVLYG0pfvzjSi-w3vw4H3coJXzziB0RyAlRZ7zhyElQlKcUQophcgSgK3Q-t-9RttxHCBCUMmhWKOnpi4rXH9Uj83icT2p3iTlHMLxMJ_mc1IZFdzR9ckuqLNZfPhKrA9JYy4TnvxP7hZdWXUazfZPN6jZvTTlK67e92_lc4VHAhxwTok-GGszoSw3GZM50YUitFCKCmG4hQyy-Fl3HUiimVVcCltIGS3CBNug-9_aRTmrXN8Ofg4uDrb6U18uXWtimMUlAuwbJVJNAg
ClassificationCodes TP391.1
ContentType Journal Article
Copyright Copyright © Wanfang Data Co. Ltd. All Rights Reserved.
Copyright_xml – notice: Copyright © Wanfang Data Co. Ltd. All Rights Reserved.
DBID 2B.
4A8
92I
93N
PSX
TCJ
DOI 10.19884/j.1672-5220.202207003
DatabaseName Wanfang Data Journals - Hong Kong
WANFANG Data Centre
Wanfang Data Journals
万方数据期刊 - 香港版
China Online Journals (COJ)
China Online Journals (COJ)
DatabaseTitleList
DeliveryMethod fulltext_linktorsrc
Discipline Engineering
EndPage 427
ExternalDocumentID dhdxxb_e202304010
GroupedDBID -02
-0B
-SB
-S~
188
2B.
4A8
5VR
5XA
5XC
8RM
92D
92I
92M
93N
9D9
9DB
ABJNI
ACGFS
ADMLS
AFUIB
ALMA_UNASSIGNED_HOLDINGS
CAJEB
CCEZO
CDRFL
CHBEP
CW9
FA0
JUIAU
PSX
Q--
R-B
RT2
S..
T8R
TCJ
TGH
TTC
U1F
U1G
U5B
U5L
UGNYK
UZ2
UZ4
ID FETCH-LOGICAL-s1040-821dceff56af4e53781d9a129aa266e4f0505202dbb071d3fa476f97702d1363
ISSN 1672-5220
IngestDate Thu May 29 03:59:43 EDT 2025
IsPeerReviewed true
IsScholarly true
Issue 4
Keywords semantic parsing
curriculum learning
text-to-SQL
Language English
LinkModel OpenURL
MergedId FETCHMERGED-LOGICAL-s1040-821dceff56af4e53781d9a129aa266e4f0505202dbb071d3fa476f97702d1363
PageCount 7
ParticipantIDs wanfang_journals_dhdxxb_e202304010
PublicationCentury 2000
PublicationDate 2023-08-31
PublicationDateYYYYMMDD 2023-08-31
PublicationDate_xml – month: 08
  year: 2023
  text: 2023-08-31
  day: 31
PublicationDecade 2020
PublicationTitle 东华大学学报(英文版)
PublicationTitle_FL Journal of Donghua University(English Edition)
PublicationYear 2023
Publisher School of Computer Science and Technology,Donghua University,Shanghai 201620,China
Publisher_xml – name: School of Computer Science and Technology,Donghua University,Shanghai 201620,China
SSID ssj0000627409
Score 2.2498164
Snippet TP391.1; Text-to-SQL is the task of translating a natural language query into a structured query language.Existing text-to-SQL approaches focus on improving...
SourceID wanfang
SourceType Aggregation Database
StartPage 421
Title TSCL-SQL:Two-Stage Curriculum Learning Framework for Text-to-SQL
URI https://d.wanfangdata.com.cn/periodical/dhdxxb-e202304010
Volume 40
hasFullText 1
inHoldings 1
isFullTextHit
isPrint
link http://utb.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwnV3db5swELei9mV7mPapfXQTmuaniI5gA2ZPI4Qum9JIVZjU7SUyYCfZA5HaoLX7V_fP7AzG8dQ-dHtB1tmA8B2-353vzgi9qwilnIbcJaKSYKDEquRtzF1ZRiQsi9ITlfJDns7D6Vf65Tw4Hwx-W1FLza44Ln_dmlfyP1wFGvBVZcn-A2fNQ4EAbeAvXIHDcL0bjxfpzF2czWB8_nPrAnBciWFqnHp98dSVgqddCFYbVZgra3e3VXfa2BRnFI8ZjlOcBZhNMMtUI6E4idrGBCeh1QgxS3AS4OwEj1PMGM4YZmM8HqmuGHrhrgizuO3qxhinw7fP8yHM5MrsgEyz-afhrLneGCWRAOFs01w34i_S9_XmR1Pbvgqf9M7X3lfZFRZVcSb6yAqzgqldgv1mAojXZFuv1g234lOAuFBO9DXfDAG2hL4HFHPKuF6_w0jZ1r5nL_BdPSgtyNRarWmXnK0VP-2KFNzQKTFjtFMq_cOPfZWfHHke2WtRE9tYraurq2Ip1PfDCqnS_w59sGFAaxwmk9PZwrgAVYVo2gYhmSfrHHb1yve3vrDNLaslTIMFg_KH6IG2X5ykE8ZHaCDqx-i-VdXyCfrYi-UHI5TOXiidXigdI5QOCKVjCeVTlJ9keTp19UEd7uVIRaQyf1SVQsog5JKKgERgBMUckCTngP8Ele1xiZ5fFQUg2opITqNQguUBpBEJyTN0UG9r8Rw5tAxKXnmAinlEheS8IGpfvADYqorv-S_QW_35S_0fXi5vTPjLuwx6he7tJfQIHewuGvEa8OWueKP59AeJMmrh
linkProvider EBSCOhost
openUrl ctx_ver=Z39.88-2004&ctx_enc=info%3Aofi%2Fenc%3AUTF-8&rfr_id=info%3Asid%2Fsummon.serialssolutions.com&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Ajournal&rft.genre=article&rft.atitle=TSCL-SQL%3ATwo-Stage+Curriculum+Learning+Framework+for+Text-to-SQL&rft.jtitle=%E4%B8%9C%E5%8D%8E%E5%A4%A7%E5%AD%A6%E5%AD%A6%E6%8A%A5%EF%BC%88%E8%8B%B1%E6%96%87%E7%89%88%EF%BC%89&rft.au=YIN+Feng&rft.au=CHENG+Luyi&rft.au=WANG+Qiuyue&rft.au=WANG+Zhijun&rft.date=2023-08-31&rft.pub=School+of+Computer+Science+and+Technology%2CDonghua+University%2CShanghai+201620%2CChina&rft.issn=1672-5220&rft.volume=40&rft.issue=4&rft.spage=421&rft.epage=427&rft_id=info:doi/10.19884%2Fj.1672-5220.202207003&rft.externalDocID=dhdxxb_e202304010
thumbnail_s http://utb.summon.serialssolutions.com/2.0.0/image/custom?url=http%3A%2F%2Fwww.wanfangdata.com.cn%2Fimages%2FPeriodicalImages%2Fdhdxxb-e%2Fdhdxxb-e.jpg