{"id":"https://openalex.org/W7147359778","doi":"https://doi.org/10.1109/cw68232.2025.00067","title":"TC-SQL: Table Completion-Based Optimization of Schema Linking for Text-to-SQL","display_name":"TC-SQL: Table Completion-Based Optimization of Schema Linking for Text-to-SQL","publication_year":2025,"publication_date":"2025-10-14","ids":{"openalex":"https://openalex.org/W7147359778","doi":"https://doi.org/10.1109/cw68232.2025.00067"},"language":null,"primary_location":{"id":"doi:10.1109/cw68232.2025.00067","is_oa":false,"landing_page_url":"https://doi.org/10.1109/cw68232.2025.00067","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2025 International Conference on Cyberworlds (CW\uff09","raw_type":"proceedings-article"},"type":"conference-paper","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/A5132567504","display_name":"Zhewen Pan","orcid":null},"institutions":[{"id":"https://openalex.org/I9842412","display_name":"Nanjing University of Aeronautics and Astronautics","ror":"https://ror.org/01scyh794","country_code":"CN","type":"education","lineage":["https://openalex.org/I9842412"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Zhewen Pan","raw_affiliation_strings":["College of Computer Science and Technology, Nanjing University of Aeronautics and Astronautics,Nanjing,China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"College of Computer Science and Technology, Nanjing University of Aeronautics and Astronautics,Nanjing,China","institution_ids":["https://openalex.org/I9842412"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5132652267","display_name":"Yang Li","orcid":null},"institutions":[{"id":"https://openalex.org/I9842412","display_name":"Nanjing University of Aeronautics and Astronautics","ror":"https://ror.org/01scyh794","country_code":"CN","type":"education","lineage":["https://openalex.org/I9842412"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Yang Li","raw_affiliation_strings":["Unmanned Aerial Vehicles Research Institute, Nanjing University of Aeronautics and Astronautics,Nanjing,China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Unmanned Aerial Vehicles Research Institute, Nanjing University of Aeronautics and Astronautics,Nanjing,China","institution_ids":["https://openalex.org/I9842412"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5006168745","display_name":"Yunlong Zhao","orcid":"https://orcid.org/0000-0003-0870-5120"},"institutions":[{"id":"https://openalex.org/I9842412","display_name":"Nanjing University of Aeronautics and Astronautics","ror":"https://ror.org/01scyh794","country_code":"CN","type":"education","lineage":["https://openalex.org/I9842412"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Yunlong Zhao","raw_affiliation_strings":["College of Computer Science and Technology, Nanjing University of Aeronautics and Astronautics,Nanjing,China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"College of Computer Science and Technology, Nanjing University of Aeronautics and Astronautics,Nanjing,China","institution_ids":["https://openalex.org/I9842412"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I9842412"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.71541107,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"414","last_page":"421"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T12292","display_name":"Graph Theory and Algorithms","score":0.5020999908447266,"subfield":{"id":"https://openalex.org/subfields/1707","display_name":"Computer Vision and Pattern Recognition"},"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/T12292","display_name":"Graph Theory and Algorithms","score":0.5020999908447266,"subfield":{"id":"https://openalex.org/subfields/1707","display_name":"Computer Vision and Pattern Recognition"},"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.11630000174045563,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"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/T11450","display_name":"Model-Driven Software Engineering Techniques","score":0.09950000047683716,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"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/database-schema","display_name":"Database schema","score":0.5666000247001648},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.5498999953269958},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.5184000134468079},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.4925999939441681},{"id":"https://openalex.org/keywords/precision-and-recall","display_name":"Precision and recall","score":0.41029998660087585},{"id":"https://openalex.org/keywords/graph","display_name":"Graph","score":0.38370001316070557},{"id":"https://openalex.org/keywords/recall","display_name":"Recall","score":0.3634999990463257},{"id":"https://openalex.org/keywords/table","display_name":"Table (database)","score":0.3467999994754791},{"id":"https://openalex.org/keywords/data-modeling","display_name":"Data modeling","score":0.33000001311302185}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8485000133514404},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.5666000247001648},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.5498999953269958},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5184000134468079},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.4925999939441681},{"id":"https://openalex.org/C81669768","wikidata":"https://www.wikidata.org/wiki/Q2359161","display_name":"Precision and recall","level":2,"score":0.41029998660087585},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.4083000123500824},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.39089998602867126},{"id":"https://openalex.org/C132525143","wikidata":"https://www.wikidata.org/wiki/Q141488","display_name":"Graph","level":2,"score":0.38370001316070557},{"id":"https://openalex.org/C100660578","wikidata":"https://www.wikidata.org/wiki/Q18733","display_name":"Recall","level":2,"score":0.3634999990463257},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.36230000853538513},{"id":"https://openalex.org/C45235069","wikidata":"https://www.wikidata.org/wiki/Q278425","display_name":"Table (database)","level":2,"score":0.3467999994754791},{"id":"https://openalex.org/C67186912","wikidata":"https://www.wikidata.org/wiki/Q367664","display_name":"Data modeling","level":2,"score":0.33000001311302185},{"id":"https://openalex.org/C195324797","wikidata":"https://www.wikidata.org/wiki/Q33742","display_name":"Natural language","level":2,"score":0.3165999948978424},{"id":"https://openalex.org/C153440673","wikidata":"https://www.wikidata.org/wiki/Q7431119","display_name":"Schema migration","level":5,"score":0.3077999949455261},{"id":"https://openalex.org/C4554734","wikidata":"https://www.wikidata.org/wiki/Q593744","display_name":"Knowledge base","level":2,"score":0.29589998722076416},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.29350000619888306},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.2930000126361847},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.2922999858856201},{"id":"https://openalex.org/C56288433","wikidata":"https://www.wikidata.org/wiki/Q58673","display_name":"Data manipulation language","level":2,"score":0.29179999232292175},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.2838999927043915},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.28279998898506165},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.27810001373291016},{"id":"https://openalex.org/C204321447","wikidata":"https://www.wikidata.org/wiki/Q30642","display_name":"Natural language processing","level":1,"score":0.27489998936653137},{"id":"https://openalex.org/C72634772","wikidata":"https://www.wikidata.org/wiki/Q386824","display_name":"Data integration","level":2,"score":0.26460000872612},{"id":"https://openalex.org/C176225458","wikidata":"https://www.wikidata.org/wiki/Q595971","display_name":"Graph database","level":3,"score":0.2614000141620636},{"id":"https://openalex.org/C2987255567","wikidata":"https://www.wikidata.org/wiki/Q33002955","display_name":"Knowledge graph","level":2,"score":0.25929999351501465},{"id":"https://openalex.org/C16910744","wikidata":"https://www.wikidata.org/wiki/Q7705759","display_name":"Test data","level":2,"score":0.2538999915122986},{"id":"https://openalex.org/C162319229","wikidata":"https://www.wikidata.org/wiki/Q175263","display_name":"Data structure","level":2,"score":0.2529999911785126}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/cw68232.2025.00067","is_oa":false,"landing_page_url":"https://doi.org/10.1109/cw68232.2025.00067","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2025 International Conference on Cyberworlds (CW\uff09","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/9","score":0.44759151339530945,"display_name":"Industry, innovation and infrastructure"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":15,"referenced_works":["https://openalex.org/W2890431379","https://openalex.org/W3034835156","https://openalex.org/W3214600982","https://openalex.org/W4323655724","https://openalex.org/W4381326864","https://openalex.org/W4382202531","https://openalex.org/W4391136507","https://openalex.org/W4396571402","https://openalex.org/W4396573413","https://openalex.org/W4402671560","https://openalex.org/W4404782964","https://openalex.org/W7081978817","https://openalex.org/W7133183334","https://openalex.org/W7133205963","https://openalex.org/W7133233472"],"related_works":[],"abstract_inverted_index":{"Text-to-SQL,":[0],"as":[1,48],"a":[2,7,30,43,61,75],"hotspot":[3],"in":[4,147],"NLP,":[5],"is":[6],"task":[8],"of":[9,90,107],"converting":[10],"natural":[11],"language":[12,18],"text":[13],"into":[14],"the":[15,53,93,105,108,113,122],"structured":[16],"query":[17],"SQL,":[19],"which":[20],"makes":[21],"database":[22,40,70,77],"interaction":[23],"more":[24],"intuitive.":[25],"This":[26],"paper":[27],"presents":[28],"TC-SQL,":[29],"novel":[31],"framework":[32],"for":[33,57,65,143],"schema":[34,125],"linking":[35,126],"optimization":[36],"enabled":[37],"by":[38],"graph":[39,76],"modeling,":[41],"with":[42],"decoupled":[44],"table":[45,58,114],"completion":[46,117],"modules":[47],"its":[49],"core":[50],"component.":[51],"Leveraging":[52,119],"open-source":[54,120,129],"LLM":[55],"Qwen":[56],"retrieval":[59],"and":[60,72,112,116,135,140],"supervised":[62,109],"fine-tuned":[63],"CodeLlama":[64],"SQL":[66],"generation,":[67],"TC-SQL":[68],"models":[69,130],"tables":[71],"columns":[73],"within":[74],"to":[78,131],"enhance":[79,132],"recall":[80,115],"completeness.":[81],"Experiments":[82],"show":[83],"that":[84],"it":[85],"achieves":[86],"an":[87,138],"execution":[88],"accuracy":[89],"79.3%":[91],"on":[92],"Spider":[94],"test":[95],"set,":[96],"outperforming":[97],"multiple":[98],"comparative":[99],"methods.":[100],"Ablation":[101],"studies":[102],"further":[103],"confirm":[104],"effectiveness":[106],"fine-tuning":[110],"process":[111],"modules.":[118],"models,":[121],"method":[123],"optimizes":[124],"while":[127],"leveraging":[128],"system":[133],"controllability":[134],"deployability,":[136],"offering":[137],"efficient":[139],"reliable":[141],"solution":[142],"intelligent":[144],"data":[145],"access":[146],"industrial":[148],"scenarios.":[149]},"counts_by_year":[],"updated_date":"2026-07-29T14:22:42.915294","created_date":"2026-04-02T00:00:00"}