{"id":"https://openalex.org/W4360604821","doi":"https://doi.org/10.1109/icaiic57133.2023.10067134","title":"On Modern Text-to-SQL Semantic Parsing Methodologies for Natural Language Interface to Databases: A Comparative Study","display_name":"On Modern Text-to-SQL Semantic Parsing Methodologies for Natural Language Interface to Databases: A Comparative Study","publication_year":2023,"publication_date":"2023-02-20","ids":{"openalex":"https://openalex.org/W4360604821","doi":"https://doi.org/10.1109/icaiic57133.2023.10067134"},"language":"en","primary_location":{"id":"doi:10.1109/icaiic57133.2023.10067134","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icaiic57133.2023.10067134","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2023 International Conference on Artificial Intelligence in Information and Communication (ICAIIC)","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5035568035","display_name":"Moses Visperas","orcid":"https://orcid.org/0009-0000-8573-5193"},"institutions":[{"id":"https://openalex.org/I87074743","display_name":"University of the Philippines Diliman","ror":"https://ror.org/03tbh6y23","country_code":"PH","type":"education","lineage":["https://openalex.org/I103911934","https://openalex.org/I87074743"]}],"countries":["PH"],"is_corresponding":true,"raw_author_name":"Moses Visperas","raw_affiliation_strings":["Advanced Science and Technology Institute,Computer Software Division,Department of Science and Technology,Diliman,Quezon City,Philippines","Department of Science and Technology, Computer Software Division, Advanced Science and Technology Institute, Diliman,Quezon City, Philippines"],"affiliations":[{"raw_affiliation_string":"Advanced Science and Technology Institute,Computer Software Division,Department of Science and Technology,Diliman,Quezon City,Philippines","institution_ids":["https://openalex.org/I87074743"]},{"raw_affiliation_string":"Department of Science and Technology, Computer Software Division, Advanced Science and Technology Institute, Diliman,Quezon City, Philippines","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5023267962","display_name":"Aunhel John M. Adoptante","orcid":"https://orcid.org/0000-0001-5490-2665"},"institutions":[{"id":"https://openalex.org/I87074743","display_name":"University of the Philippines Diliman","ror":"https://ror.org/03tbh6y23","country_code":"PH","type":"education","lineage":["https://openalex.org/I103911934","https://openalex.org/I87074743"]}],"countries":["PH"],"is_corresponding":false,"raw_author_name":"Aunhel John Adoptante","raw_affiliation_strings":["Advanced Science and Technology Institute,Computer Software Division,Department of Science and Technology,Diliman,Quezon City,Philippines","Department of Science and Technology, Computer Software Division, Advanced Science and Technology Institute, Diliman,Quezon City, Philippines"],"affiliations":[{"raw_affiliation_string":"Advanced Science and Technology Institute,Computer Software Division,Department of Science and Technology,Diliman,Quezon City,Philippines","institution_ids":["https://openalex.org/I87074743"]},{"raw_affiliation_string":"Department of Science and Technology, Computer Software Division, Advanced Science and Technology Institute, Diliman,Quezon City, Philippines","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5068407642","display_name":"Christalline Joie Borjal","orcid":null},"institutions":[{"id":"https://openalex.org/I87074743","display_name":"University of the Philippines Diliman","ror":"https://ror.org/03tbh6y23","country_code":"PH","type":"education","lineage":["https://openalex.org/I103911934","https://openalex.org/I87074743"]}],"countries":["PH"],"is_corresponding":false,"raw_author_name":"Christalline Joie Borjal","raw_affiliation_strings":["Advanced Science and Technology Institute,Computer Software Division,Department of Science and Technology,Diliman,Quezon City,Philippines","Department of Science and Technology, Computer Software Division, Advanced Science and Technology Institute, Diliman,Quezon City, Philippines"],"affiliations":[{"raw_affiliation_string":"Advanced Science and Technology Institute,Computer Software Division,Department of Science and Technology,Diliman,Quezon City,Philippines","institution_ids":["https://openalex.org/I87074743"]},{"raw_affiliation_string":"Department of Science and Technology, Computer Software Division, Advanced Science and Technology Institute, Diliman,Quezon City, Philippines","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5075634729","display_name":"Ma. Teresita Abia","orcid":null},"institutions":[{"id":"https://openalex.org/I87074743","display_name":"University of the Philippines Diliman","ror":"https://ror.org/03tbh6y23","country_code":"PH","type":"education","lineage":["https://openalex.org/I103911934","https://openalex.org/I87074743"]}],"countries":["PH"],"is_corresponding":false,"raw_author_name":"Ma. Teresita Abia","raw_affiliation_strings":["Advanced Science and Technology Institute,Computer Software Division,Department of Science and Technology,Diliman,Quezon City,Philippines","Department of Science and Technology, Computer Software Division, Advanced Science and Technology Institute, Diliman,Quezon City, Philippines"],"affiliations":[{"raw_affiliation_string":"Advanced Science and Technology Institute,Computer Software Division,Department of Science and Technology,Diliman,Quezon City,Philippines","institution_ids":["https://openalex.org/I87074743"]},{"raw_affiliation_string":"Department of Science and Technology, Computer Software Division, Advanced Science and Technology Institute, Diliman,Quezon City, Philippines","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5006619044","display_name":"Jasper Kyle Catapang","orcid":"https://orcid.org/0000-0002-4510-0975"},"institutions":[{"id":"https://openalex.org/I79619799","display_name":"University of Birmingham","ror":"https://ror.org/03angcq70","country_code":"GB","type":"education","lineage":["https://openalex.org/I79619799"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"Jasper Kyle Catapang","raw_affiliation_strings":["University of Birmingham,Department of English Language and Linguistics,United Kingdom","Department of English Language and Linguistics, University of Birmingham, United Kingdom"],"affiliations":[{"raw_affiliation_string":"University of Birmingham,Department of English Language and Linguistics,United Kingdom","institution_ids":["https://openalex.org/I79619799"]},{"raw_affiliation_string":"Department of English Language and Linguistics, University of Birmingham, United Kingdom","institution_ids":["https://openalex.org/I79619799"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5090312919","display_name":"Elmer C. Peramo","orcid":"https://orcid.org/0000-0003-1949-3442"},"institutions":[{"id":"https://openalex.org/I87074743","display_name":"University of the Philippines Diliman","ror":"https://ror.org/03tbh6y23","country_code":"PH","type":"education","lineage":["https://openalex.org/I103911934","https://openalex.org/I87074743"]}],"countries":["PH"],"is_corresponding":false,"raw_author_name":"Elmer Peramo","raw_affiliation_strings":["Advanced Science and Technology Institute,Computer Software Division,Department of Science and Technology,Diliman,Quezon City,Philippines","Department of Science and Technology, Computer Software Division, Advanced Science and Technology Institute, Diliman,Quezon City, Philippines"],"affiliations":[{"raw_affiliation_string":"Advanced Science and Technology Institute,Computer Software Division,Department of Science and Technology,Diliman,Quezon City,Philippines","institution_ids":["https://openalex.org/I87074743"]},{"raw_affiliation_string":"Department of Science and Technology, Computer Software Division, Advanced Science and Technology Institute, Diliman,Quezon City, Philippines","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":6,"corresponding_author_ids":["https://openalex.org/A5035568035"],"corresponding_institution_ids":["https://openalex.org/I87074743"],"apc_list":null,"apc_paid":null,"fwci":0.5245,"has_fulltext":false,"cited_by_count":3,"citation_normalized_percentile":{"value":0.69334983,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":96},"biblio":{"volume":null,"issue":null,"first_page":"390","last_page":"396"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10181","display_name":"Natural Language Processing Techniques","score":0.9991000294685364,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10181","display_name":"Natural Language Processing Techniques","score":0.9991000294685364,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10028","display_name":"Topic Modeling","score":0.9986000061035156,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T12016","display_name":"Web Data Mining and Analysis","score":0.9959999918937683,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8748563528060913},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7041841745376587},{"id":"https://openalex.org/keywords/parsing","display_name":"Parsing","score":0.622344970703125},{"id":"https://openalex.org/keywords/benchmark","display_name":"Benchmark (surveying)","score":0.5725920796394348},{"id":"https://openalex.org/keywords/natural-language-processing","display_name":"Natural language processing","score":0.5342392921447754},{"id":"https://openalex.org/keywords/data-definition-language","display_name":"Data definition language","score":0.5104305148124695},{"id":"https://openalex.org/keywords/process","display_name":"Process (computing)","score":0.5102360248565674},{"id":"https://openalex.org/keywords/natural-language","display_name":"Natural language","score":0.5101757049560547},{"id":"https://openalex.org/keywords/selection","display_name":"Selection (genetic algorithm)","score":0.5009748935699463},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.5002412796020508},{"id":"https://openalex.org/keywords/natural-language-user-interface","display_name":"Natural language user interface","score":0.4699184000492096},{"id":"https://openalex.org/keywords/field","display_name":"Field (mathematics)","score":0.44962674379348755},{"id":"https://openalex.org/keywords/interface","display_name":"Interface (matter)","score":0.440758615732193},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.32753700017929077},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.32520192861557007},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.2672361433506012}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8748563528060913},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7041841745376587},{"id":"https://openalex.org/C186644900","wikidata":"https://www.wikidata.org/wiki/Q194152","display_name":"Parsing","level":2,"score":0.622344970703125},{"id":"https://openalex.org/C185798385","wikidata":"https://www.wikidata.org/wiki/Q1161707","display_name":"Benchmark (surveying)","level":2,"score":0.5725920796394348},{"id":"https://openalex.org/C204321447","wikidata":"https://www.wikidata.org/wiki/Q30642","display_name":"Natural language processing","level":1,"score":0.5342392921447754},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.5104305148124695},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.5102360248565674},{"id":"https://openalex.org/C195324797","wikidata":"https://www.wikidata.org/wiki/Q33742","display_name":"Natural language","level":2,"score":0.5101757049560547},{"id":"https://openalex.org/C81917197","wikidata":"https://www.wikidata.org/wiki/Q628760","display_name":"Selection (genetic algorithm)","level":2,"score":0.5009748935699463},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.5002412796020508},{"id":"https://openalex.org/C174252522","wikidata":"https://www.wikidata.org/wiki/Q3816772","display_name":"Natural language user interface","level":3,"score":0.4699184000492096},{"id":"https://openalex.org/C9652623","wikidata":"https://www.wikidata.org/wiki/Q190109","display_name":"Field (mathematics)","level":2,"score":0.44962674379348755},{"id":"https://openalex.org/C113843644","wikidata":"https://www.wikidata.org/wiki/Q901882","display_name":"Interface (matter)","level":4,"score":0.440758615732193},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.32753700017929077},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.32520192861557007},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.2672361433506012},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0},{"id":"https://openalex.org/C157915830","wikidata":"https://www.wikidata.org/wiki/Q2928001","display_name":"Bubble","level":2,"score":0.0},{"id":"https://openalex.org/C205649164","wikidata":"https://www.wikidata.org/wiki/Q1071","display_name":"Geography","level":0,"score":0.0},{"id":"https://openalex.org/C129307140","wikidata":"https://www.wikidata.org/wiki/Q6795880","display_name":"Maximum bubble pressure method","level":3,"score":0.0},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.0},{"id":"https://openalex.org/C13280743","wikidata":"https://www.wikidata.org/wiki/Q131089","display_name":"Geodesy","level":1,"score":0.0},{"id":"https://openalex.org/C202444582","wikidata":"https://www.wikidata.org/wiki/Q837863","display_name":"Pure mathematics","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/icaiic57133.2023.10067134","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icaiic57133.2023.10067134","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2023 International Conference on Artificial Intelligence in Information and Communication (ICAIIC)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.7599999904632568,"id":"https://metadata.un.org/sdg/4","display_name":"Quality Education"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":36,"referenced_works":["https://openalex.org/W1539162551","https://openalex.org/W2536574992","https://openalex.org/W2751448157","https://openalex.org/W2890431379","https://openalex.org/W2945102109","https://openalex.org/W2945989699","https://openalex.org/W2952032096","https://openalex.org/W2963477458","https://openalex.org/W2963617989","https://openalex.org/W2970605129","https://openalex.org/W3034835156","https://openalex.org/W3093819145","https://openalex.org/W3093923671","https://openalex.org/W3094344961","https://openalex.org/W3103801878","https://openalex.org/W3115880855","https://openalex.org/W3126918322","https://openalex.org/W3134636006","https://openalex.org/W3152893301","https://openalex.org/W3153008428","https://openalex.org/W3170698273","https://openalex.org/W3170721718","https://openalex.org/W3175488485","https://openalex.org/W3176472386","https://openalex.org/W3200079259","https://openalex.org/W3212464620","https://openalex.org/W4210287336","https://openalex.org/W4293819888","https://openalex.org/W4312419558","https://openalex.org/W4385245566","https://openalex.org/W6632425215","https://openalex.org/W6728662599","https://openalex.org/W6739901393","https://openalex.org/W6769642167","https://openalex.org/W6783935634","https://openalex.org/W6842258776"],"related_works":["https://openalex.org/W1592149428","https://openalex.org/W650213220","https://openalex.org/W2183574112","https://openalex.org/W2159231020","https://openalex.org/W1564573743","https://openalex.org/W4387850597","https://openalex.org/W1566119189","https://openalex.org/W4225472555","https://openalex.org/W4281962965","https://openalex.org/W2567961046"],"abstract_inverted_index":{"NLIDB":[0],"research":[1],"has":[2,29,135],"gained":[3],"popularity":[4],"recently,":[5],"mainly":[6],"as":[7,38,40,114,141],"a":[8,90],"means":[9],"of":[10,43,48,68,86,124,131,147,206],"enhancing":[11],"outcomes":[12],"and":[13,36,46,61,64,103,110,119],"performance.":[14],"This":[15],"study":[16,126],"makes":[17],"an":[18,41,66,169],"effort":[19],"to":[20],"give":[21],"readers":[22],"background":[23],"information":[24],"on":[25,106,160,209],"how":[26],"the":[27,44,59,69,84,129,144,148,161,193,196,210],"subject":[28],"evolved":[30],"recently":[31],"using":[32,115],"different":[33],"text-to-SQL":[34,132],"procedures":[35],"approaches,":[37],"well":[39],"appraisal":[42],"advantages":[45],"disadvantages":[47],"each":[49,73,87,99,166],"methodology.":[50],"In":[51],"contrast":[52],"with":[53,96],"past":[54],"studies,":[55],"this":[56,125,200],"paper":[57],"describes":[58],"search":[60],"selection":[62,205],"processes":[63],"provide":[65],"overview":[67],"complete":[70],"process":[71],"for":[72,178,191,201],"approach":[74],"under":[75,150],"review":[76],"before":[77],"making":[78],"comparisons.":[79],"The":[80,122,172,204],"authors":[81,197],"also":[82,189],"evaluated":[83],"performance":[85,146],"methodology":[88],"against":[89],"widely":[91],"recognized":[92],"benchmark":[93],"dataset.":[94],"Along":[95],"model":[97,100],"performance,":[98],"was":[101,153,188],"compared":[102],"assessed":[104],"based":[105],"its":[107],"overall":[108],"structure":[109],"associated":[111],"processes,":[112],"such":[113],"pre-trained":[116,185],"language":[117,186],"models":[118,149,187],"intermediate":[120,207],"representations.":[121],"results":[123],"show":[127],"that":[128,155],"field":[130],"semantic":[133],"parsing":[134],"advanced":[136],"significantly":[137],"in":[138,181],"recent":[139,157],"years,":[140],"seen":[142],"by":[143],"improved":[145],"consideration.":[151],"It":[152],"clear":[154],"most":[156],"developments":[158],"concentrated":[159],"encoder":[162],"side,":[163],"even":[164],"if":[165],"technique":[167],"follows":[168],"encoder-decoder":[170],"design.":[171],"imbalance":[173],"opens":[174],"up":[175],"much":[176],"room":[177],"decoder":[179],"advancement":[180],"subsequent":[182],"studies.":[183],"Using":[184],"noteworthy":[190],"improving":[192],"models'":[194],"performances;":[195],"will":[198],"consider":[199],"future":[202],"efforts.":[203],"representations,":[208],"other":[211],"hand,":[212],"is":[213],"wholly":[214],"arbitrary.":[215]},"counts_by_year":[{"year":2025,"cited_by_count":2},{"year":2024,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}