{"id":"https://openalex.org/W4386470315","doi":"https://doi.org/10.1109/tnnls.2023.3309824","title":"GTR: An SQL Generator With Transition Representation in Cross-Domain Database Systems","display_name":"GTR: An SQL Generator With Transition Representation in Cross-Domain Database Systems","publication_year":2023,"publication_date":"2023-09-06","ids":{"openalex":"https://openalex.org/W4386470315","doi":"https://doi.org/10.1109/tnnls.2023.3309824","pmid":"https://pubmed.ncbi.nlm.nih.gov/37672375"},"language":"en","primary_location":{"id":"doi:10.1109/tnnls.2023.3309824","is_oa":false,"landing_page_url":"https://doi.org/10.1109/tnnls.2023.3309824","pdf_url":null,"source":{"id":"https://openalex.org/S4210175523","display_name":"IEEE Transactions on Neural Networks and Learning Systems","issn_l":"2162-237X","issn":["2162-237X","2162-2388"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319808","host_organization_name":"Institute of Electrical and Electronics Engineers","host_organization_lineage":["https://openalex.org/P4310319808"],"host_organization_lineage_names":["Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Transactions on Neural Networks and Learning Systems","raw_type":"journal-article"},"type":"article","indexed_in":["crossref","pubmed"],"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/A5074090518","display_name":"Shaojie Qiao","orcid":"https://orcid.org/0000-0002-4703-780X"},"institutions":[{"id":"https://openalex.org/I24201400","display_name":"Chengdu University of Information Technology","ror":"https://ror.org/01yxwrh59","country_code":"CN","type":"education","lineage":["https://openalex.org/I24201400"]}],"countries":["CN"],"is_corresponding":true,"raw_author_name":"Shaojie Qiao","raw_affiliation_strings":["School of Software Engineering, Chengdu University of Information Technology, Chengdu, China"],"raw_orcid":"https://orcid.org/0000-0002-4703-780X","affiliations":[{"raw_affiliation_string":"School of Software Engineering, Chengdu University of Information Technology, Chengdu, China","institution_ids":["https://openalex.org/I24201400"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5111035621","display_name":"Chenxu Liu","orcid":"https://orcid.org/0000-0002-4604-491X"},"institutions":[{"id":"https://openalex.org/I24201400","display_name":"Chengdu University of Information Technology","ror":"https://ror.org/01yxwrh59","country_code":"CN","type":"education","lineage":["https://openalex.org/I24201400"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Chenxu Liu","raw_affiliation_strings":["School of Software Engineering, Chengdu University of Information Technology, Chengdu, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"School of Software Engineering, Chengdu University of Information Technology, Chengdu, China","institution_ids":["https://openalex.org/I24201400"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5012856780","display_name":"Guo\u2010Ping Yang","orcid":"https://orcid.org/0000-0002-0230-6834"},"institutions":[{"id":"https://openalex.org/I24201400","display_name":"Chengdu University of Information Technology","ror":"https://ror.org/01yxwrh59","country_code":"CN","type":"education","lineage":["https://openalex.org/I24201400"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Guoping Yang","raw_affiliation_strings":["School of Software Engineering, Chengdu University of Information Technology, Chengdu, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"School of Software Engineering, Chengdu University of Information Technology, Chengdu, China","institution_ids":["https://openalex.org/I24201400"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5092761884","display_name":"Nan Han","orcid":"https://orcid.org/0000-0003-3188-2811"},"institutions":[{"id":"https://openalex.org/I24201400","display_name":"Chengdu University of Information Technology","ror":"https://ror.org/01yxwrh59","country_code":"CN","type":"education","lineage":["https://openalex.org/I24201400"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Nan Han","raw_affiliation_strings":["School of Management, Chengdu University of Information Technology, Chengdu, China"],"raw_orcid":"https://orcid.org/0000-0003-3188-2811","affiliations":[{"raw_affiliation_string":"School of Management, Chengdu University of Information Technology, Chengdu, China","institution_ids":["https://openalex.org/I24201400"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5084398329","display_name":"Yuhan Peng","orcid":"https://orcid.org/0000-0002-0120-668X"},"institutions":[{"id":"https://openalex.org/I24201400","display_name":"Chengdu University of Information Technology","ror":"https://ror.org/01yxwrh59","country_code":"CN","type":"education","lineage":["https://openalex.org/I24201400"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Yuhan Peng","raw_affiliation_strings":["School of Software Engineering, Chengdu University of Information Technology, Chengdu, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"School of Software Engineering, Chengdu University of Information Technology, Chengdu, China","institution_ids":["https://openalex.org/I24201400"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5112991732","display_name":"Lingchun Wu","orcid":null},"institutions":[{"id":"https://openalex.org/I24201400","display_name":"Chengdu University of Information Technology","ror":"https://ror.org/01yxwrh59","country_code":"CN","type":"education","lineage":["https://openalex.org/I24201400"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Lingchun Wu","raw_affiliation_strings":["School of Software Engineering, Chengdu University of Information Technology, Chengdu, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"School of Software Engineering, Chengdu University of Information Technology, Chengdu, China","institution_ids":["https://openalex.org/I24201400"]}]},{"author_position":"middle","author":{"id":null,"display_name":"He Li","orcid":"https://orcid.org/0000-0001-5437-7063"},"institutions":[{"id":"https://openalex.org/I149594827","display_name":"Xidian University","ror":"https://ror.org/05s92vm98","country_code":"CN","type":"education","lineage":["https://openalex.org/I149594827"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"He Li","raw_affiliation_strings":["School of Computer Science and Technology, Xidian University, Xi’an, China"],"raw_orcid":"https://orcid.org/0000-0001-5437-7063","affiliations":[{"raw_affiliation_string":"School of Computer Science and Technology, Xidian University, Xi’an, China","institution_ids":["https://openalex.org/I149594827"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5038687122","display_name":"Guan Yuan","orcid":"https://orcid.org/0000-0003-3148-9817"},"institutions":[{"id":"https://openalex.org/I25757504","display_name":"China University of Mining and Technology","ror":"https://ror.org/01xt2dr21","country_code":"CN","type":"education","lineage":["https://openalex.org/I25757504"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Guan Yuan","raw_affiliation_strings":["School of Computer Science and Technology, China University of Mining and Technology, Xuzhou, China"],"raw_orcid":"https://orcid.org/0000-0003-3148-9817","affiliations":[{"raw_affiliation_string":"School of Computer Science and Technology, China University of Mining and Technology, Xuzhou, China","institution_ids":["https://openalex.org/I25757504"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":8,"corresponding_author_ids":["https://openalex.org/A5074090518"],"corresponding_institution_ids":["https://openalex.org/I24201400"],"apc_list":null,"apc_paid":null,"fwci":0.3408,"has_fulltext":false,"cited_by_count":2,"citation_normalized_percentile":{"value":0.65753709,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":95,"max":96},"biblio":{"volume":"35","issue":"12","first_page":"17908","last_page":"17920"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10181","display_name":"Natural Language Processing Techniques","score":0.991100013256073,"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.991100013256073,"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/T11719","display_name":"Data Quality and Management","score":0.9886000156402588,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T10028","display_name":"Topic Modeling","score":0.9871000051498413,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8132013082504272},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7612139582633972},{"id":"https://openalex.org/keywords/stored-procedure","display_name":"Stored procedure","score":0.5665858387947083},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.553385317325592},{"id":"https://openalex.org/keywords/pl/sql","display_name":"PL/SQL","score":0.5331289768218994},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4717593789100647},{"id":"https://openalex.org/keywords/data-definition-language","display_name":"Data definition language","score":0.46959105134010315},{"id":"https://openalex.org/keywords/generator","display_name":"Generator (circuit theory)","score":0.4671548902988434},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.45616254210472107},{"id":"https://openalex.org/keywords/sql-injection","display_name":"SQL injection","score":0.4287897050380707},{"id":"https://openalex.org/keywords/sql/psm","display_name":"SQL/PSM","score":0.42182791233062744},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.39085882902145386},{"id":"https://openalex.org/keywords/natural-language-processing","display_name":"Natural language processing","score":0.3554689288139343},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.34462738037109375},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.2361859381198883}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8132013082504272},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7612139582633972},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.5665858387947083},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.553385317325592},{"id":"https://openalex.org/C32145003","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"PL/SQL","level":5,"score":0.5331289768218994},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4717593789100647},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.46959105134010315},{"id":"https://openalex.org/C2780992000","wikidata":"https://www.wikidata.org/wiki/Q17016113","display_name":"Generator (circuit theory)","level":3,"score":0.4671548902988434},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.45616254210472107},{"id":"https://openalex.org/C150451098","wikidata":"https://www.wikidata.org/wiki/Q506059","display_name":"SQL injection","level":5,"score":0.4287897050380707},{"id":"https://openalex.org/C167544706","wikidata":"https://www.wikidata.org/wiki/Q360842","display_name":"SQL/PSM","level":5,"score":0.42182791233062744},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.39085882902145386},{"id":"https://openalex.org/C204321447","wikidata":"https://www.wikidata.org/wiki/Q30642","display_name":"Natural language processing","level":1,"score":0.3554689288139343},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.34462738037109375},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.2361859381198883},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.0},{"id":"https://openalex.org/C163258240","wikidata":"https://www.wikidata.org/wiki/Q25342","display_name":"Power (physics)","level":2,"score":0.0},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.0},{"id":"https://openalex.org/C121332964","wikidata":"https://www.wikidata.org/wiki/Q413","display_name":"Physics","level":0,"score":0.0},{"id":"https://openalex.org/C62520636","wikidata":"https://www.wikidata.org/wiki/Q944","display_name":"Quantum mechanics","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1109/tnnls.2023.3309824","is_oa":false,"landing_page_url":"https://doi.org/10.1109/tnnls.2023.3309824","pdf_url":null,"source":{"id":"https://openalex.org/S4210175523","display_name":"IEEE Transactions on Neural Networks and Learning Systems","issn_l":"2162-237X","issn":["2162-237X","2162-2388"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319808","host_organization_name":"Institute of Electrical and Electronics Engineers","host_organization_lineage":["https://openalex.org/P4310319808"],"host_organization_lineage_names":["Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Transactions on Neural Networks and Learning Systems","raw_type":"journal-article"},{"id":"pmid:37672375","is_oa":false,"landing_page_url":"https://pubmed.ncbi.nlm.nih.gov/37672375","pdf_url":null,"source":{"id":"https://openalex.org/S4306525036","display_name":"PubMed","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I1299303238","host_organization_name":"National Institutes of Health","host_organization_lineage":["https://openalex.org/I1299303238"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE transactions on neural networks and learning systems","raw_type":null}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/4","display_name":"Quality Education","score":0.8299999833106995}],"awards":[{"id":"https://openalex.org/G3209473978","display_name":null,"funder_award_id":"2022NSFSC0511","funder_id":"https://openalex.org/F4320333335","funder_display_name":"Sichuan Province Science and Technology Support Program"},{"id":"https://openalex.org/G4997149588","display_name":null,"funder_award_id":"62272066","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G5012457786","display_name":null,"funder_award_id":"2023YFG0027","funder_id":"https://openalex.org/F4320333335","funder_display_name":"Sichuan Province Science and Technology Support Program"},{"id":"https://openalex.org/G6138722804","display_name":null,"funder_award_id":"2022YFG0186","funder_id":"https://openalex.org/F4320333335","funder_display_name":"Sichuan Province Science and Technology Support Program"},{"id":"https://openalex.org/G6934172100","display_name":null,"funder_award_id":"61962006","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G8520410813","display_name":null,"funder_award_id":"2021JDJQ0021","funder_id":"https://openalex.org/F4320333335","funder_display_name":"Sichuan Province Science and Technology Support Program"}],"funders":[{"id":"https://openalex.org/F4320321001","display_name":"National Natural Science Foundation of China","ror":"https://ror.org/01h0zpd94"},{"id":"https://openalex.org/F4320333335","display_name":"Sichuan Province Science and Technology Support Program","ror":null}],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":34,"referenced_works":["https://openalex.org/W2043794661","https://openalex.org/W2057670927","https://openalex.org/W2153710242","https://openalex.org/W2890431379","https://openalex.org/W2891691255","https://openalex.org/W2896457183","https://openalex.org/W2945102109","https://openalex.org/W2962713807","https://openalex.org/W2963617989","https://openalex.org/W2964102284","https://openalex.org/W2964271186","https://openalex.org/W2971323043","https://openalex.org/W2974265398","https://openalex.org/W2997970380","https://openalex.org/W3000508506","https://openalex.org/W3019166713","https://openalex.org/W3034835156","https://openalex.org/W3103962261","https://openalex.org/W3118268131","https://openalex.org/W3150263485","https://openalex.org/W3153008428","https://openalex.org/W3176134318","https://openalex.org/W3192605935","https://openalex.org/W3198067439","https://openalex.org/W4210287336","https://openalex.org/W4220955952","https://openalex.org/W4385245566","https://openalex.org/W6631190155","https://openalex.org/W6679436768","https://openalex.org/W6684081719","https://openalex.org/W6691770232","https://openalex.org/W6743367031","https://openalex.org/W6745921949","https://openalex.org/W6758814090"],"related_works":["https://openalex.org/W151073879","https://openalex.org/W2463360381","https://openalex.org/W580797181","https://openalex.org/W621362137","https://openalex.org/W2125092986","https://openalex.org/W2791515211","https://openalex.org/W2359391484","https://openalex.org/W1890767558","https://openalex.org/W4238156210","https://openalex.org/W2803214644"],"abstract_inverted_index":{"Recent":[0],"studies":[1,52],"have":[2],"focused":[3],"on":[4,183,190],"using":[5],"natural":[6],"language":[7],"(NL)":[8],"to":[9,81,90,105,117,171],"automatically":[10],"retrieve":[11],"useful":[12],"data":[13],"from":[14,180],"database":[15],"(DB)":[16],"systems.":[17,147],"As":[18],"an":[19,97,136],"important":[20],"component":[21],"of":[22,61,68,74,129,204],"autonomous":[23],"DB":[24,31,146,163],"systems,":[25],"the":[26,56,59,65,71,103,107,127,158,184,201,205,210,224],"NL-to-SQL":[27],"technique":[28],"can":[29],"assist":[30],"administrators":[32],"in":[33,96,126,144],"writing":[34],"high-quality":[35],"SQL":[36,43,48,95,125,138,152,179],"statements":[37],"and":[38,70,124,162,175,198,207,217],"make":[39,118],"persons":[40],"with":[41,55,121,140],"no":[42],"background":[44],"knowledge":[45],"learn":[46],"complex":[47],"languages.":[49],"However,":[50],"existing":[51],"cannot":[53],"deal":[54],"issue":[57],"that":[58,195,213],"expression":[60],"NL":[62,93,123],"inevitably":[63],"mismatches":[64],"implementation":[66],"details":[67],"SQLs,":[69],"large":[72],"number":[73],"out-of-domain":[75],"(OOD)":[76],"words":[77],"makes":[78],"it":[79,87,101,119],"difficult":[80,89],"predict":[82],"table":[83],"columns.":[84],"In":[85,131],"particular,":[86],"is":[88,115],"accurately":[91],"convert":[92],"into":[94],"end-to-end":[98],"fashion.":[99],"Intuitively,":[100],"facilitates":[102],"model":[104,170],"understand":[106],"relations":[108],"if":[109],"a":[110,168,173],"\"bridge\"":[111],"[transition":[112],"representation":[113],"(TR)]":[114],"employed":[116],"compatible":[120],"both":[122],"phase":[128],"conversion.":[130],"this":[132],"article,":[133],"we":[134],"propose":[135],"automatic":[137],"generator":[139],"TR":[141,181],"called":[142],"GTR":[143,149,156,166,177,214],"cross-domain":[145],"Specifically,":[148],"contains":[150],"three":[151],"generation":[153],"steps:":[154],"1)":[155],"learns":[157],"relation":[159],"between":[160],"questions":[161],"schemas;":[164],"2)":[165],"uses":[167],"grammar-based":[169],"synthesize":[172],"TR;":[174],"3)":[176],"predicts":[178],"based":[182],"rules.":[185],"We":[186],"conduct":[187],"extensive":[188],"experiments":[189],"two":[191],"commonly":[192],"used":[193],"datasets,":[194,209],"is,":[196],"WikiSQL":[197,208],"Spider.":[199],"On":[200],"testing":[202],"set":[203],"Spider":[206],"results":[211],"show":[212],"achieves":[215],"58.32%":[216],"71.29%":[218],"exact":[219],"matching":[220],"accuracy":[221],"which":[222],"outperforms":[223],"state-of-the-art":[225],"methods,":[226],"respectively.":[227]},"counts_by_year":[{"year":2025,"cited_by_count":2}],"updated_date":"2026-03-27T05:58:40.876381","created_date":"2025-10-10T00:00:00"}