{"id":"https://openalex.org/W4411403530","doi":"https://doi.org/10.1145/3725331","title":"OpenSearch-SQL: Enhancing Text-to-SQL with Dynamic Few-shot and Consistency Alignment","display_name":"OpenSearch-SQL: Enhancing Text-to-SQL with Dynamic Few-shot and Consistency Alignment","publication_year":2025,"publication_date":"2025-06-17","ids":{"openalex":"https://openalex.org/W4411403530","doi":"https://doi.org/10.1145/3725331"},"language":"en","primary_location":{"id":"doi:10.1145/3725331","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3725331","pdf_url":null,"source":{"id":"https://openalex.org/S4387289859","display_name":"Proceedings of the ACM on Management of Data","issn_l":"2836-6573","issn":["2836-6573"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the ACM on Management of Data","raw_type":"journal-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":null,"display_name":"Xiangjin Xie","orcid":"https://orcid.org/0009-0008-7696-0434"},"institutions":[{"id":"https://openalex.org/I45928872","display_name":"Alibaba Group (China)","ror":"https://ror.org/00k642b80","country_code":"CN","type":"company","lineage":["https://openalex.org/I45928872"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Xiangjin Xie","raw_affiliation_strings":["Alibaba Cloud Computing, Hangzhou, China"],"raw_orcid":"https://orcid.org/0009-0008-7696-0434","affiliations":[{"raw_affiliation_string":"Alibaba Cloud Computing, Hangzhou, China","institution_ids":["https://openalex.org/I45928872"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100852856","display_name":"Guohuan Xu","orcid":"https://orcid.org/0000-0003-1849-2595"},"institutions":[{"id":"https://openalex.org/I45928872","display_name":"Alibaba Group (China)","ror":"https://ror.org/00k642b80","country_code":"CN","type":"company","lineage":["https://openalex.org/I45928872"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Guangwei Xu","raw_affiliation_strings":["Alibaba Cloud Computing, Hangzhou, China"],"raw_orcid":"https://orcid.org/0000-0003-1849-2595","affiliations":[{"raw_affiliation_string":"Alibaba Cloud Computing, Hangzhou, China","institution_ids":["https://openalex.org/I45928872"]}]},{"author_position":"middle","author":{"id":null,"display_name":"Lingyan Zhao","orcid":"https://orcid.org/0009-0000-5209-5724"},"institutions":[{"id":"https://openalex.org/I45928872","display_name":"Alibaba Group (China)","ror":"https://ror.org/00k642b80","country_code":"CN","type":"company","lineage":["https://openalex.org/I45928872"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Lingyan Zhao","raw_affiliation_strings":["Alibaba Cloud Computing, Hangzhou, China"],"raw_orcid":"https://orcid.org/0009-0000-5209-5724","affiliations":[{"raw_affiliation_string":"Alibaba Cloud Computing, Hangzhou, China","institution_ids":["https://openalex.org/I45928872"]}]},{"author_position":"last","author":{"id":null,"display_name":"Ruijie Guo","orcid":"https://orcid.org/0009-0000-5278-3172"},"institutions":[{"id":"https://openalex.org/I45928872","display_name":"Alibaba Group (China)","ror":"https://ror.org/00k642b80","country_code":"CN","type":"company","lineage":["https://openalex.org/I45928872"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Ruijie Guo","raw_affiliation_strings":["Alibaba Cloud Computing, Beijing, China"],"raw_orcid":"https://orcid.org/0009-0000-5278-3172","affiliations":[{"raw_affiliation_string":"Alibaba Cloud Computing, Beijing, China","institution_ids":["https://openalex.org/I45928872"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I45928872"],"apc_list":null,"apc_paid":null,"fwci":31.3018,"has_fulltext":false,"cited_by_count":24,"citation_normalized_percentile":{"value":0.99639639,"is_in_top_1_percent":true,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":99,"max":100},"biblio":{"volume":"3","issue":"3","first_page":"1","last_page":"24"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10028","display_name":"Topic Modeling","score":0.9955000281333923,"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.9955000281333923,"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/T11986","display_name":"Scientific Computing and Data Management","score":0.9944999814033508,"subfield":{"id":"https://openalex.org/subfields/1802","display_name":"Information Systems and Management"},"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/T12016","display_name":"Web Data Mining and Analysis","score":0.979200005531311,"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.8749047517776489},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7927022576332092},{"id":"https://openalex.org/keywords/task","display_name":"Task (project management)","score":0.534489631652832},{"id":"https://openalex.org/keywords/software-portability","display_name":"Software portability","score":0.5257973074913025},{"id":"https://openalex.org/keywords/consistency","display_name":"Consistency (knowledge bases)","score":0.5078323483467102},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.482769638299942},{"id":"https://openalex.org/keywords/data-definition-language","display_name":"Data definition language","score":0.4683641195297241},{"id":"https://openalex.org/keywords/preprocessor","display_name":"Preprocessor","score":0.4583451449871063},{"id":"https://openalex.org/keywords/stored-procedure","display_name":"Stored procedure","score":0.4462057948112488},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.40825119614601135},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.38810473680496216},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.3640095591545105},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.34445035457611084},{"id":"https://openalex.org/keywords/natural-language-processing","display_name":"Natural language processing","score":0.32088178396224976},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.22812089323997498}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8749047517776489},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7927022576332092},{"id":"https://openalex.org/C2780451532","wikidata":"https://www.wikidata.org/wiki/Q759676","display_name":"Task (project management)","level":2,"score":0.534489631652832},{"id":"https://openalex.org/C63000827","wikidata":"https://www.wikidata.org/wiki/Q3080428","display_name":"Software portability","level":2,"score":0.5257973074913025},{"id":"https://openalex.org/C2776436953","wikidata":"https://www.wikidata.org/wiki/Q5163215","display_name":"Consistency (knowledge bases)","level":2,"score":0.5078323483467102},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.482769638299942},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.4683641195297241},{"id":"https://openalex.org/C34736171","wikidata":"https://www.wikidata.org/wiki/Q918333","display_name":"Preprocessor","level":2,"score":0.4583451449871063},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.4462057948112488},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.40825119614601135},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.38810473680496216},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.3640095591545105},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.34445035457611084},{"id":"https://openalex.org/C204321447","wikidata":"https://www.wikidata.org/wiki/Q30642","display_name":"Natural language processing","level":1,"score":0.32088178396224976},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.22812089323997498},{"id":"https://openalex.org/C187736073","wikidata":"https://www.wikidata.org/wiki/Q2920921","display_name":"Management","level":1,"score":0.0},{"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/C162324750","wikidata":"https://www.wikidata.org/wiki/Q8134","display_name":"Economics","level":0,"score":0.0},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3725331","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3725331","pdf_url":null,"source":{"id":"https://openalex.org/S4387289859","display_name":"Proceedings of the ACM on Management of Data","issn_l":"2836-6573","issn":["2836-6573"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the ACM on Management of Data","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/4","display_name":"Quality Education","score":0.4300000071525574}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":12,"referenced_works":["https://openalex.org/W2148942721","https://openalex.org/W2626990892","https://openalex.org/W2990138404","https://openalex.org/W3015937477","https://openalex.org/W3156729426","https://openalex.org/W4287816933","https://openalex.org/W4317716303","https://openalex.org/W4393065402","https://openalex.org/W4404782579","https://openalex.org/W6600234944","https://openalex.org/W6601926947","https://openalex.org/W6602389902"],"related_works":["https://openalex.org/W1980548249","https://openalex.org/W650213220","https://openalex.org/W2340883001","https://openalex.org/W1592149428","https://openalex.org/W4388053677","https://openalex.org/W2974218799","https://openalex.org/W151494989","https://openalex.org/W20807724","https://openalex.org/W3097122560","https://openalex.org/W2373982268"],"abstract_inverted_index":{"Although":[0],"multi-agent":[1],"collaborative":[2],"Large":[3],"Language":[4],"Models":[5],"(LLMs)":[6],"have":[7],"achieved":[8],"significant":[9],"breakthroughs":[10],"in":[11,85,189],"the":[12,26,29,47,73,80,98,122,130,135,150,156,175,182,186],"Text-to-SQL":[13,48],"task,":[14],"their":[15],"performance":[16],"is":[17],"still":[18],"constrained":[19],"by":[20],"various":[21],"factors.":[22],"These":[23,179],"factors":[24],"include":[25],"incompleteness":[27],"of":[28,77,116,147,166,177,185],"framework,":[30],"failure":[31],"to":[32],"follow":[33],"instructions,":[34],"and":[35,57,75,88,105,133,159,192],"model":[36,117],"hallucinations.":[37],"To":[38],"address":[39],"these":[40],"problems,":[41],"we":[42,91,119],"propose":[43],"OpenSearch-SQL,":[44],"which":[45],"divides":[46],"task":[49,131],"into":[50],"four":[51],"main":[52],"modules:":[53],"Preprocessing,":[54],"Extraction,":[55],"Generation,":[56],"Refinement,":[58],"along":[59],"with":[60,168],"an":[61,144],"Alignment":[62,81],"module":[63],"based":[64,102],"on":[65,103,149,155],"a":[66,107,160],"consistency":[67],"alignment":[68],"mechanism.":[69],"This":[70],"architecture":[71],"aligns":[72],"inputs":[74],"outputs":[76],"agents":[78],"through":[79],"module,":[82],"reducing":[83],"failures":[84],"instruction":[86],"following":[87],"hallucination.":[89],"Furthermore,":[90],"introduce":[92],"SQL-Like":[93],"(an":[94],"intermediate":[95],"language),":[96],"optimize":[97],"structured":[99],"Chain-of-Thought":[100],"(CoT)":[101],"SQL-Like,":[104],"develop":[106],"dynamic":[108],"few-shot":[109],"strategy":[110],"via":[111],"self-taught":[112],"Query-CoT-SQL.":[113],"In":[114],"terms":[115],"selection,":[118],"directly":[120],"applied":[121],"base":[123],"LLMs":[124],"without":[125],"any":[126],"post-training,":[127],"thereby":[128],"simplifying":[129],"chain":[132],"enhancing":[134],"framework's":[136],"portability.":[137],"Experimental":[138],"results":[139,180],"show":[140],"that":[141],"OpenSearch-SQL":[142],"achieves":[143],"execution":[145],"accuracy(EX)":[146],"69.3%":[148],"BIRD":[151],"development":[152],"set,":[153,158],"72.28%":[154],"test":[157],"reward-based":[161],"validity":[162],"efficiency":[163],"score":[164],"(R-VES)":[165],"69.36%,":[167],"all":[169],"three":[170],"metrics":[171],"ranking":[172],"first":[173],"at":[174],"time":[176],"submission.":[178],"demonstrate":[181],"comprehensive":[183],"advantages":[184],"proposed":[187],"method":[188],"both":[190],"effectiveness":[191],"efficiency.":[193]},"counts_by_year":[{"year":2026,"cited_by_count":11},{"year":2025,"cited_by_count":13}],"updated_date":"2026-07-15T18:14:33.161393","created_date":"2025-10-10T00:00:00"}