{"id":"https://openalex.org/W4415930562","doi":"https://doi.org/10.1049/cit2.70071","title":"TCSR\u2010SQL: Towards Table Content\u2010Aware Text\u2010to\u2010SQL With Self\u2010Retrieval","display_name":"TCSR\u2010SQL: Towards Table Content\u2010Aware Text\u2010to\u2010SQL With Self\u2010Retrieval","publication_year":2025,"publication_date":"2025-11-05","ids":{"openalex":"https://openalex.org/W4415930562","doi":"https://doi.org/10.1049/cit2.70071"},"language":"en","primary_location":{"id":"doi:10.1049/cit2.70071","is_oa":true,"landing_page_url":"https://doi.org/10.1049/cit2.70071","pdf_url":"https://onlinelibrary.wiley.com/doi/pdfdirect/10.1049/cit2.70071","source":{"id":"https://openalex.org/S2898415742","display_name":"CAAI Transactions on Intelligence Technology","issn_l":"2468-2322","issn":["2468-2322","2468-6557"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310311714","host_organization_name":"Institution of Engineering and Technology","host_organization_lineage":["https://openalex.org/P4310311714"],"host_organization_lineage_names":["Institution of Engineering and Technology"],"type":"journal"},"license":"cc-by-nc","license_id":"https://openalex.org/licenses/cc-by-nc","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"CAAI Transactions on Intelligence Technology","raw_type":"journal-article"},"type":"article","indexed_in":["crossref","doaj"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://onlinelibrary.wiley.com/doi/pdfdirect/10.1049/cit2.70071","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5088700209","display_name":"Wenbo Xu","orcid":"https://orcid.org/0000-0002-5558-3018"},"institutions":[{"id":"https://openalex.org/I158809036","display_name":"Shenzhen Institute of Information Technology","ror":"https://ror.org/03wrf9427","country_code":"CN","type":"education","lineage":["https://openalex.org/I158809036"]},{"id":"https://openalex.org/I204983213","display_name":"Harbin Institute of Technology","ror":"https://ror.org/01yqg2h08","country_code":"CN","type":"education","lineage":["https://openalex.org/I204983213"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Wenbo Xu","raw_affiliation_strings":["Department of Computer Science Harbin Institute of Technology (Shenzhen)  Shenzhen China","Department of Computer Science, Harbin Institute of Technology (Shenzhen), Shenzhen, China"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science Harbin Institute of Technology (Shenzhen)  Shenzhen China","institution_ids":["https://openalex.org/I158809036","https://openalex.org/I204983213"]},{"raw_affiliation_string":"Department of Computer Science, Harbin Institute of Technology (Shenzhen), Shenzhen, China","institution_ids":["https://openalex.org/I204983213"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100646875","display_name":"Yan Liang","orcid":"https://orcid.org/0000-0003-4798-4257"},"institutions":[{"id":"https://openalex.org/I158809036","display_name":"Shenzhen Institute of Information Technology","ror":"https://ror.org/03wrf9427","country_code":"CN","type":"education","lineage":["https://openalex.org/I158809036"]},{"id":"https://openalex.org/I204983213","display_name":"Harbin Institute of Technology","ror":"https://ror.org/01yqg2h08","country_code":"CN","type":"education","lineage":["https://openalex.org/I204983213"]},{"id":"https://openalex.org/I4210144143","display_name":"Inspur (China)","ror":"https://ror.org/0474p4r72","country_code":"CN","type":"company","lineage":["https://openalex.org/I4210144143"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Liang Yan","raw_affiliation_strings":["Department of Computer Science Harbin Institute of Technology (Shenzhen)  Shenzhen China","Inspur Cloud Information Technology Co. Ltd  Jinan China","Department of Computer Science, Harbin Institute of Technology (Shenzhen), Shenzhen, China","Inspur Cloud Information Technology Co. Ltd, Jinan, China"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science Harbin Institute of Technology (Shenzhen)  Shenzhen China","institution_ids":["https://openalex.org/I158809036","https://openalex.org/I204983213"]},{"raw_affiliation_string":"Inspur Cloud Information Technology Co. Ltd  Jinan China","institution_ids":["https://openalex.org/I4210144143"]},{"raw_affiliation_string":"Department of Computer Science, Harbin Institute of Technology (Shenzhen), Shenzhen, China","institution_ids":["https://openalex.org/I204983213"]},{"raw_affiliation_string":"Inspur Cloud Information Technology Co. Ltd, Jinan, China","institution_ids":["https://openalex.org/I4210144143"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5073927368","display_name":"Chuanyi Liu","orcid":"https://orcid.org/0000-0001-8237-8979"},"institutions":[{"id":"https://openalex.org/I158809036","display_name":"Shenzhen Institute of Information Technology","ror":"https://ror.org/03wrf9427","country_code":"CN","type":"education","lineage":["https://openalex.org/I158809036"]},{"id":"https://openalex.org/I204983213","display_name":"Harbin Institute of Technology","ror":"https://ror.org/01yqg2h08","country_code":"CN","type":"education","lineage":["https://openalex.org/I204983213"]},{"id":"https://openalex.org/I4210136793","display_name":"Peng Cheng Laboratory","ror":"https://ror.org/03qdqbt06","country_code":"CN","type":"facility","lineage":["https://openalex.org/I4210136793"]}],"countries":["CN"],"is_corresponding":true,"raw_author_name":"Chuanyi Liu","raw_affiliation_strings":["Department of Computer Science Harbin Institute of Technology (Shenzhen)  Shenzhen China","Peng Cheng Laboratory  Shenzhen China","Peng Cheng Laboratory, Shenzhen, China","Department of Computer Science, Harbin Institute of Technology (Shenzhen), Shenzhen, China"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science Harbin Institute of Technology (Shenzhen)  Shenzhen China","institution_ids":["https://openalex.org/I158809036","https://openalex.org/I204983213"]},{"raw_affiliation_string":"Peng Cheng Laboratory  Shenzhen China","institution_ids":["https://openalex.org/I4210136793"]},{"raw_affiliation_string":"Peng Cheng Laboratory, Shenzhen, China","institution_ids":["https://openalex.org/I4210136793"]},{"raw_affiliation_string":"Department of Computer Science, Harbin Institute of Technology (Shenzhen), Shenzhen, China","institution_ids":["https://openalex.org/I204983213"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101992266","display_name":"Peiyi Han","orcid":"https://orcid.org/0000-0003-0417-4473"},"institutions":[{"id":"https://openalex.org/I158809036","display_name":"Shenzhen Institute of Information Technology","ror":"https://ror.org/03wrf9427","country_code":"CN","type":"education","lineage":["https://openalex.org/I158809036"]},{"id":"https://openalex.org/I204983213","display_name":"Harbin Institute of Technology","ror":"https://ror.org/01yqg2h08","country_code":"CN","type":"education","lineage":["https://openalex.org/I204983213"]},{"id":"https://openalex.org/I4210136793","display_name":"Peng Cheng Laboratory","ror":"https://ror.org/03qdqbt06","country_code":"CN","type":"facility","lineage":["https://openalex.org/I4210136793"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Peiyi Han","raw_affiliation_strings":["Department of Computer Science Harbin Institute of Technology (Shenzhen)  Shenzhen China","Peng Cheng Laboratory  Shenzhen China","Department of Computer Science, Harbin Institute of Technology (Shenzhen), Shenzhen, China","Peng Cheng Laboratory, Shenzhen, China"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science Harbin Institute of Technology (Shenzhen)  Shenzhen China","institution_ids":["https://openalex.org/I158809036","https://openalex.org/I204983213"]},{"raw_affiliation_string":"Peng Cheng Laboratory  Shenzhen China","institution_ids":["https://openalex.org/I4210136793"]},{"raw_affiliation_string":"Department of Computer Science, Harbin Institute of Technology (Shenzhen), Shenzhen, China","institution_ids":["https://openalex.org/I204983213"]},{"raw_affiliation_string":"Peng Cheng Laboratory, Shenzhen, China","institution_ids":["https://openalex.org/I4210136793"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5064158813","display_name":"Haifeng Zhu","orcid":"https://orcid.org/0000-0002-6561-309X"},"institutions":[{"id":"https://openalex.org/I158809036","display_name":"Shenzhen Institute of Information Technology","ror":"https://ror.org/03wrf9427","country_code":"CN","type":"education","lineage":["https://openalex.org/I158809036"]},{"id":"https://openalex.org/I204983213","display_name":"Harbin Institute of Technology","ror":"https://ror.org/01yqg2h08","country_code":"CN","type":"education","lineage":["https://openalex.org/I204983213"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Haifeng Zhu","raw_affiliation_strings":["Department of Computer Science Harbin Institute of Technology (Shenzhen)  Shenzhen China","Department of Computer Science, Harbin Institute of Technology (Shenzhen), Shenzhen, China"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science Harbin Institute of Technology (Shenzhen)  Shenzhen China","institution_ids":["https://openalex.org/I158809036","https://openalex.org/I204983213"]},{"raw_affiliation_string":"Department of Computer Science, Harbin Institute of Technology (Shenzhen), Shenzhen, China","institution_ids":["https://openalex.org/I204983213"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5010277066","display_name":"Yong Xu","orcid":"https://orcid.org/0000-0001-7183-3155"},"institutions":[{"id":"https://openalex.org/I158809036","display_name":"Shenzhen Institute of Information Technology","ror":"https://ror.org/03wrf9427","country_code":"CN","type":"education","lineage":["https://openalex.org/I158809036"]},{"id":"https://openalex.org/I204983213","display_name":"Harbin Institute of Technology","ror":"https://ror.org/01yqg2h08","country_code":"CN","type":"education","lineage":["https://openalex.org/I204983213"]},{"id":"https://openalex.org/I4210136793","display_name":"Peng Cheng Laboratory","ror":"https://ror.org/03qdqbt06","country_code":"CN","type":"facility","lineage":["https://openalex.org/I4210136793"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Yong Xu","raw_affiliation_strings":["Department of Computer Science Harbin Institute of Technology (Shenzhen)  Shenzhen China","Peng Cheng Laboratory  Shenzhen China","Peng Cheng Laboratory, Shenzhen, China","Department of Computer Science, Harbin Institute of Technology (Shenzhen), Shenzhen, China"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science Harbin Institute of Technology (Shenzhen)  Shenzhen China","institution_ids":["https://openalex.org/I158809036","https://openalex.org/I204983213"]},{"raw_affiliation_string":"Peng Cheng Laboratory  Shenzhen China","institution_ids":["https://openalex.org/I4210136793"]},{"raw_affiliation_string":"Peng Cheng Laboratory, Shenzhen, China","institution_ids":["https://openalex.org/I4210136793"]},{"raw_affiliation_string":"Department of Computer Science, Harbin Institute of Technology (Shenzhen), Shenzhen, China","institution_ids":["https://openalex.org/I204983213"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5114043469","display_name":"Yingwei Liang","orcid":null},"institutions":[{"id":"https://openalex.org/I74872605","display_name":"China Southern Power Grid (China)","ror":"https://ror.org/03hkh9419","country_code":"CN","type":"company","lineage":["https://openalex.org/I74872605"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Yingwei Liang","raw_affiliation_strings":["Guangdong Power Grid Co. Ltd  Guangzhou China","Guangdong Power Grid Co. Ltd, Guangzhou, China"],"affiliations":[{"raw_affiliation_string":"Guangdong Power Grid Co. Ltd  Guangzhou China","institution_ids":["https://openalex.org/I74872605"]},{"raw_affiliation_string":"Guangdong Power Grid Co. Ltd, Guangzhou, China","institution_ids":["https://openalex.org/I74872605"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5048088901","display_name":"Bob Zhang","orcid":"https://orcid.org/0000-0003-2497-9519"},"institutions":[{"id":"https://openalex.org/I204512498","display_name":"University of Macau","ror":"https://ror.org/01r4q9n85","country_code":"MO","type":"education","lineage":["https://openalex.org/I204512498"]}],"countries":["MO"],"is_corresponding":false,"raw_author_name":"Bob Zhang","raw_affiliation_strings":["Faculty of Science and Technology University of Macau  Macau China","Faculty of Science and Technology University of Macau  Taipa China","Faculty of Science and Technology, University of Macau, Taipa, China"],"affiliations":[{"raw_affiliation_string":"Faculty of Science and Technology University of Macau  Macau China","institution_ids":["https://openalex.org/I204512498"]},{"raw_affiliation_string":"Faculty of Science and Technology University of Macau  Taipa China","institution_ids":["https://openalex.org/I204512498"]},{"raw_affiliation_string":"Faculty of Science and Technology, University of Macau, Taipa, China","institution_ids":["https://openalex.org/I204512498"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":8,"corresponding_author_ids":["https://openalex.org/A5073927368"],"corresponding_institution_ids":["https://openalex.org/I158809036","https://openalex.org/I204983213","https://openalex.org/I4210136793"],"apc_list":{"value":2200,"currency":"USD","value_usd":2200},"apc_paid":{"value":2200,"currency":"USD","value_usd":2200},"fwci":0.0,"has_fulltext":true,"cited_by_count":0,"citation_normalized_percentile":{"value":0.16916389,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"11","issue":"1","first_page":"26","last_page":"40"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10028","display_name":"Topic Modeling","score":0.31470000743865967,"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/T10028","display_name":"Topic Modeling","score":0.31470000743865967,"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/T10601","display_name":"Handwritten Text Recognition Techniques","score":0.1152999997138977,"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/T10286","display_name":"Information Retrieval and Search Behavior","score":0.09059999883174896,"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/sql","display_name":"SQL","score":0.7239000201225281},{"id":"https://openalex.org/keywords/table","display_name":"Table (database)","score":0.7067999839782715},{"id":"https://openalex.org/keywords/column","display_name":"Column (typography)","score":0.6784999966621399},{"id":"https://openalex.org/keywords/benchmark","display_name":"Benchmark (surveying)","score":0.6195999979972839},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.6062999963760376},{"id":"https://openalex.org/keywords/encoding","display_name":"Encoding (memory)","score":0.534500002861023},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.44339999556541443},{"id":"https://openalex.org/keywords/database-index","display_name":"Database index","score":0.3804999887943268}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7778000235557556},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7239000201225281},{"id":"https://openalex.org/C45235069","wikidata":"https://www.wikidata.org/wiki/Q278425","display_name":"Table (database)","level":2,"score":0.7067999839782715},{"id":"https://openalex.org/C2780551164","wikidata":"https://www.wikidata.org/wiki/Q2306599","display_name":"Column (typography)","level":3,"score":0.6784999966621399},{"id":"https://openalex.org/C185798385","wikidata":"https://www.wikidata.org/wiki/Q1161707","display_name":"Benchmark (surveying)","level":2,"score":0.6195999979972839},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.6062999963760376},{"id":"https://openalex.org/C125411270","wikidata":"https://www.wikidata.org/wiki/Q18653","display_name":"Encoding (memory)","level":2,"score":0.534500002861023},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4839000105857849},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.4787999987602234},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.46239998936653137},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.44339999556541443},{"id":"https://openalex.org/C59276292","wikidata":"https://www.wikidata.org/wiki/Q580427","display_name":"Database index","level":3,"score":0.3804999887943268},{"id":"https://openalex.org/C120567893","wikidata":"https://www.wikidata.org/wiki/Q1582085","display_name":"Knowledge extraction","level":2,"score":0.3668000102043152},{"id":"https://openalex.org/C135598885","wikidata":"https://www.wikidata.org/wiki/Q1366302","display_name":"Row","level":2,"score":0.3465000092983246},{"id":"https://openalex.org/C4554734","wikidata":"https://www.wikidata.org/wiki/Q593744","display_name":"Knowledge base","level":2,"score":0.3422999978065491},{"id":"https://openalex.org/C2778915421","wikidata":"https://www.wikidata.org/wiki/Q3643177","display_name":"Performance improvement","level":2,"score":0.29350000619888306},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.29330000281333923},{"id":"https://openalex.org/C2989134064","wikidata":"https://www.wikidata.org/wiki/Q288510","display_name":"Execution time","level":2,"score":0.2888999879360199},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.28290000557899475},{"id":"https://openalex.org/C68476402","wikidata":"https://www.wikidata.org/wiki/Q1456936","display_name":"Table of contents","level":2,"score":0.28189998865127563},{"id":"https://openalex.org/C67186912","wikidata":"https://www.wikidata.org/wiki/Q367664","display_name":"Data modeling","level":2,"score":0.263700008392334},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.2596000134944916},{"id":"https://openalex.org/C24394798","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database management system","level":3,"score":0.25870001316070557},{"id":"https://openalex.org/C204321447","wikidata":"https://www.wikidata.org/wiki/Q30642","display_name":"Natural language processing","level":1,"score":0.25850000977516174},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.25780001282691956}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1049/cit2.70071","is_oa":true,"landing_page_url":"https://doi.org/10.1049/cit2.70071","pdf_url":"https://onlinelibrary.wiley.com/doi/pdfdirect/10.1049/cit2.70071","source":{"id":"https://openalex.org/S2898415742","display_name":"CAAI Transactions on Intelligence Technology","issn_l":"2468-2322","issn":["2468-2322","2468-6557"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310311714","host_organization_name":"Institution of Engineering and Technology","host_organization_lineage":["https://openalex.org/P4310311714"],"host_organization_lineage_names":["Institution of Engineering and Technology"],"type":"journal"},"license":"cc-by-nc","license_id":"https://openalex.org/licenses/cc-by-nc","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"CAAI Transactions on Intelligence Technology","raw_type":"journal-article"}],"best_oa_location":{"id":"doi:10.1049/cit2.70071","is_oa":true,"landing_page_url":"https://doi.org/10.1049/cit2.70071","pdf_url":"https://onlinelibrary.wiley.com/doi/pdfdirect/10.1049/cit2.70071","source":{"id":"https://openalex.org/S2898415742","display_name":"CAAI Transactions on Intelligence Technology","issn_l":"2468-2322","issn":["2468-2322","2468-6557"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310311714","host_organization_name":"Institution of Engineering and Technology","host_organization_lineage":["https://openalex.org/P4310311714"],"host_organization_lineage_names":["Institution of Engineering and Technology"],"type":"journal"},"license":"cc-by-nc","license_id":"https://openalex.org/licenses/cc-by-nc","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"CAAI Transactions on Intelligence Technology","raw_type":"journal-article"},"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G4404944658","display_name":null,"funder_award_id":"2023YFB3106504","funder_id":"https://openalex.org/F4320335777","funder_display_name":"National Key Research and Development Program of China"}],"funders":[{"id":"https://openalex.org/F4320335777","display_name":"National Key Research and Development Program of China","ror":null}],"has_content":{"grobid_xml":false,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4415930562.pdf"},"referenced_works_count":21,"referenced_works":["https://openalex.org/W2584230735","https://openalex.org/W2890431379","https://openalex.org/W3027879771","https://openalex.org/W3199077625","https://openalex.org/W4366835679","https://openalex.org/W4367860052","https://openalex.org/W4375869868","https://openalex.org/W4389519331","https://openalex.org/W4389519829","https://openalex.org/W4389520163","https://openalex.org/W4389520463","https://openalex.org/W4398234583","https://openalex.org/W4399175046","https://openalex.org/W4400909566","https://openalex.org/W4402670079","https://openalex.org/W4402670291","https://openalex.org/W4402683779","https://openalex.org/W4403577425","https://openalex.org/W4404782579","https://openalex.org/W4409346543","https://openalex.org/W4409362830"],"related_works":[],"abstract_inverted_index":{"ABSTRACT":[0],"Large":[1],"language":[2],"model\u2010based":[3],"(LLM\u2010based)":[4],"text\u2010to\u2010SQL":[5,60],"methods":[6],"have":[7],"achieved":[8],"important":[9],"progress":[10],"in":[11,24,121,174],"generating":[12],"SQL":[13,90,134],"queries":[14],"for":[15],"real\u2010world":[16,25],"applications.":[17],"When":[18],"confronted":[19],"with":[20,61,106],"table":[21,58],"content\u2010aware":[22,59],"questions":[23],"scenarios,":[26],"ambiguous":[27],"data":[28,72],"content":[29,73,118],"keywords":[30,74],"and":[31,78,115],"nonexistent":[32],"database":[33,82],"schema":[34],"column":[35,113],"names":[36,114],"within":[37,75],"the":[38,42,76,103,107,122,131,162],"question":[39,77],"lead":[40],"to":[41,70,87,91,101,129,178],"poor":[43],"performance":[44,164],"of":[45,137,165,170],"existing":[46],"methods.":[47,181],"To":[48,140],"solve":[49],"this":[50,159],"problem,":[51],"we":[52,144],"propose":[53],"a":[54,146],"novel":[55],"approach":[56],"towards":[57],"self\u2010retrieval":[62],"(TCSR\u2010SQL).":[63],"It":[64],"leverages":[65],"LLM's":[66],"in\u2010context":[67],"learning":[68],"capability":[69],"extract":[71],"infer":[79],"possible":[80],"related":[81],"schema,":[83],"which":[84],"is":[85,127],"used":[86,100,120],"generate":[88],"Seed":[89],"fuzz":[92],"search":[93,96],"databases.":[94],"The":[95,124],"results":[97],"are":[98],"further":[99],"confirm":[102],"encoding":[104,109,125],"knowledge":[105,110,126],"designed":[108],"table,":[111],"including":[112],"exact":[116],"stored":[117],"values":[119],"SQL.":[123],"sent":[128],"obtain":[130],"final":[132],"Precise":[133],"following":[135],"multi\u2010rounds":[136],"generation\u2010execution\u2010revision":[138],"process.":[139],"validate":[141],"our":[142],"approach,":[143],"introduce":[145],"table\u2010content\u2010aware,":[147],"question\u2010related":[148],"benchmark":[149,160],"dataset,":[150],"containing":[151],"2115":[152],"question\u2010SQL":[153],"pairs.":[154],"Comprehensive":[155],"experiments":[156],"conducted":[157],"on":[158],"demonstrate":[161],"remarkable":[163],"TCSR\u2010SQL,":[166],"achieving":[167],"an":[168],"improvement":[169],"at":[171],"least":[172],"27.8%":[173],"execution":[175],"accuracy":[176],"compared":[177],"other":[179],"state\u2010of\u2010the\u2010art":[180]},"counts_by_year":[],"updated_date":"2026-04-09T08:11:56.329763","created_date":"2025-11-05T00:00:00"}