{"id":"https://openalex.org/W4415721141","doi":"https://doi.org/10.1007/978-981-95-2725-0_26","title":"DSMR-SQL: Enhancing Text-to-SQL with\u00a0Dual-Strategy SQL Generation and\u00a0Multi-role SQL Selection","display_name":"DSMR-SQL: Enhancing Text-to-SQL with\u00a0Dual-Strategy SQL Generation and\u00a0Multi-role SQL Selection","publication_year":2025,"publication_date":"2025-10-31","ids":{"openalex":"https://openalex.org/W4415721141","doi":"https://doi.org/10.1007/978-981-95-2725-0_26"},"language":"en","primary_location":{"id":"doi:10.1007/978-981-95-2725-0_26","is_oa":true,"landing_page_url":"https://doi.org/10.1007/978-981-95-2725-0_26","pdf_url":null,"source":{"id":"https://openalex.org/S106296714","display_name":"Lecture notes in computer science","issn_l":"0302-9743","issn":["0302-9743","1611-3349"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"book series"},"license":"cc-by-sa","license_id":"https://openalex.org/licenses/cc-by-sa","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Lecture Notes in Computer Science","raw_type":"book-chapter"},"type":"conference-paper","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"hybrid","oa_url":"https://doi.org/10.1007/978-981-95-2725-0_26","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5100772810","display_name":"Yiming Huang","orcid":"https://orcid.org/0009-0005-5003-2427"},"institutions":[{"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":"Yiming Huang","raw_affiliation_strings":["Harbin Institute of Technology (Shenzhen), Shenzhen, China"],"raw_orcid":"https://orcid.org/0009-0005-5003-2427","affiliations":[{"raw_affiliation_string":"Harbin Institute of Technology (Shenzhen), Shenzhen, China","institution_ids":["https://openalex.org/I204983213"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5104067103","display_name":"Jiyu Guo","orcid":"https://orcid.org/0009-0001-7055-0767"},"institutions":[{"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":"Jiyu Guo","raw_affiliation_strings":["Harbin Institute of Technology (Shenzhen), Shenzhen, China"],"raw_orcid":"https://orcid.org/0009-0001-7055-0767","affiliations":[{"raw_affiliation_string":"Harbin Institute of Technology (Shenzhen), Shenzhen, China","institution_ids":["https://openalex.org/I204983213"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5024766544","display_name":"Jichuan Zeng","orcid":"https://orcid.org/0000-0003-4073-1214"},"institutions":[{"id":"https://openalex.org/I177725633","display_name":"Chinese University of Hong Kong","ror":"https://ror.org/00t33hh48","country_code":"HK","type":"education","lineage":["https://openalex.org/I177725633"]}],"countries":["HK"],"is_corresponding":false,"raw_author_name":"Jichuan Zeng","raw_affiliation_strings":["The Chinese University of Hong Kong, Hong Kong, China"],"raw_orcid":"https://orcid.org/0000-0003-4073-1214","affiliations":[{"raw_affiliation_string":"The Chinese University of Hong Kong, Hong Kong, China","institution_ids":["https://openalex.org/I177725633"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5061699251","display_name":"Cuiyun Gao","orcid":"https://orcid.org/0000-0003-4774-2434"},"institutions":[{"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":"Cuiyun Gao","raw_affiliation_strings":["Harbin Institute of Technology (Shenzhen), Shenzhen, China","Peng Cheng Laboratory, Shenzhen, China"],"raw_orcid":"https://orcid.org/0000-0003-4774-2434","affiliations":[{"raw_affiliation_string":"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/A5101992266","display_name":"Peiyi Han","orcid":"https://orcid.org/0000-0003-0417-4473"},"institutions":[{"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":["Harbin Institute of Technology (Shenzhen), Shenzhen, China","Peng Cheng Laboratory, Shenzhen, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"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":"last","author":{"id":"https://openalex.org/A5073927368","display_name":"Chuanyi Liu","orcid":"https://orcid.org/0000-0001-8237-8979"},"institutions":[{"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":"Chuanyi Liu","raw_affiliation_strings":["Harbin Institute of Technology (Shenzhen), Shenzhen, China","Peng Cheng Laboratory, Shenzhen, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"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"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5061699251"],"corresponding_institution_ids":["https://openalex.org/I204983213","https://openalex.org/I4210136793"],"apc_list":{"value":5000,"currency":"EUR","value_usd":5392},"apc_paid":{"value":5000,"currency":"EUR","value_usd":5392},"fwci":null,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"435","last_page":"468"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10181","display_name":"Natural Language Processing Techniques","score":0.21240000426769257,"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.21240000426769257,"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.14800000190734863,"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.08370000123977661,"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.8302000164985657},{"id":"https://openalex.org/keywords/data-definition-language","display_name":"Data definition language","score":0.6751000285148621},{"id":"https://openalex.org/keywords/sql/psm","display_name":"SQL/PSM","score":0.6578999757766724},{"id":"https://openalex.org/keywords/data-transformation-services","display_name":"Data Transformation Services","score":0.6299999952316284},{"id":"https://openalex.org/keywords/stored-procedure","display_name":"Stored procedure","score":0.6079000234603882},{"id":"https://openalex.org/keywords/sql-injection","display_name":"SQL injection","score":0.580299973487854},{"id":"https://openalex.org/keywords/pl/sql","display_name":"PL/SQL","score":0.5679000020027161},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.5619000196456909}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.9143999814987183},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.8302000164985657},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.6751000285148621},{"id":"https://openalex.org/C167544706","wikidata":"https://www.wikidata.org/wiki/Q360842","display_name":"SQL/PSM","level":5,"score":0.6578999757766724},{"id":"https://openalex.org/C141589383","wikidata":"https://www.wikidata.org/wiki/Q644775","display_name":"Data Transformation Services","level":5,"score":0.6299999952316284},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.6079000234603882},{"id":"https://openalex.org/C150451098","wikidata":"https://www.wikidata.org/wiki/Q506059","display_name":"SQL injection","level":5,"score":0.580299973487854},{"id":"https://openalex.org/C32145003","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"PL/SQL","level":5,"score":0.5679000020027161},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.5619000196456909},{"id":"https://openalex.org/C179531526","wikidata":"https://www.wikidata.org/wiki/Q595637","display_name":"Language Integrated Query","level":5,"score":0.4586000144481659},{"id":"https://openalex.org/C203763787","wikidata":"https://www.wikidata.org/wiki/Q371029","display_name":"Null (SQL)","level":2,"score":0.41499999165534973},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4047999978065491},{"id":"https://openalex.org/C206384180","wikidata":"https://www.wikidata.org/wiki/Q599380","display_name":"User-defined function","level":5,"score":0.4043999910354614},{"id":"https://openalex.org/C33882796","wikidata":"https://www.wikidata.org/wiki/Q4826222","display_name":"Autocommit","level":5,"score":0.37689998745918274},{"id":"https://openalex.org/C81917197","wikidata":"https://www.wikidata.org/wiki/Q628760","display_name":"Selection (genetic algorithm)","level":2,"score":0.37059998512268066},{"id":"https://openalex.org/C2779304628","wikidata":"https://www.wikidata.org/wiki/Q3503480","display_name":"Face (sociological concept)","level":2,"score":0.3668999969959259},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3391000032424927},{"id":"https://openalex.org/C188198153","wikidata":"https://www.wikidata.org/wiki/Q1613840","display_name":"Limiting","level":2,"score":0.3140000104904175},{"id":"https://openalex.org/C123593499","wikidata":"https://www.wikidata.org/wiki/Q6008583","display_name":"In-Memory Processing","level":5,"score":0.30790001153945923},{"id":"https://openalex.org/C67186912","wikidata":"https://www.wikidata.org/wiki/Q367664","display_name":"Data modeling","level":2,"score":0.3052000105381012},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.2831999957561493}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1007/978-981-95-2725-0_26","is_oa":true,"landing_page_url":"https://doi.org/10.1007/978-981-95-2725-0_26","pdf_url":null,"source":{"id":"https://openalex.org/S106296714","display_name":"Lecture notes in computer science","issn_l":"0302-9743","issn":["0302-9743","1611-3349"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"book series"},"license":"cc-by-sa","license_id":"https://openalex.org/licenses/cc-by-sa","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Lecture Notes in Computer Science","raw_type":"book-chapter"}],"best_oa_location":{"id":"doi:10.1007/978-981-95-2725-0_26","is_oa":true,"landing_page_url":"https://doi.org/10.1007/978-981-95-2725-0_26","pdf_url":null,"source":{"id":"https://openalex.org/S106296714","display_name":"Lecture notes in computer science","issn_l":"0302-9743","issn":["0302-9743","1611-3349"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"book series"},"license":"cc-by-sa","license_id":"https://openalex.org/licenses/cc-by-sa","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Lecture Notes in Computer Science","raw_type":"book-chapter"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":28,"referenced_works":["https://openalex.org/W2890431379","https://openalex.org/W3093819145","https://openalex.org/W3102020135","https://openalex.org/W3156470785","https://openalex.org/W3175818566","https://openalex.org/W3199077625","https://openalex.org/W4309674289","https://openalex.org/W4385571050","https://openalex.org/W4389520124","https://openalex.org/W4393156701","https://openalex.org/W4393241094","https://openalex.org/W4396571402","https://openalex.org/W4396833645","https://openalex.org/W4398234583","https://openalex.org/W4399175046","https://openalex.org/W4400113788","https://openalex.org/W4400525230","https://openalex.org/W4400909496","https://openalex.org/W4400909566","https://openalex.org/W4401857088","https://openalex.org/W4402670291","https://openalex.org/W4402670728","https://openalex.org/W4402671560","https://openalex.org/W4402683779","https://openalex.org/W4404781852","https://openalex.org/W4404782209","https://openalex.org/W4404782579","https://openalex.org/W4404783178"],"related_works":[],"abstract_inverted_index":{"Recent":[0],"advancements":[1],"in":[2,36,125],"Large":[3],"Language":[4],"Models":[5],"(LLMs)":[6],"have":[7],"markedly":[8],"improved":[9],"SQL":[10,40,62,72,90,97,127],"generation.":[11,128],"Nevertheless,":[12],"existing":[13],"approaches":[14],"typically":[15],"rely":[16],"on":[17,117],"single-model":[18],"designs,":[19],"limiting":[20],"their":[21],"capacity":[22],"to":[23,66,94],"effectively":[24],"handle":[25],"complex":[26],"user":[27,101],"queries.":[28],"In":[29],"addition,":[30],"current":[31],"methods":[32],"often":[33],"face":[34],"difficulties":[35],"selecting":[37],"the":[38,96,121],"optimal":[39],"from":[41],"multiple":[42,76],"candidates.":[43],"To":[44],"mitigate":[45],"these":[46],"limitations,":[47],"this":[48],"study":[49],"presents":[50],"DSMR-SQL":[51,64,92,124],",":[52],"a":[53,68,105],"two-stage":[54],"framework":[55,107],"consisting":[56],"of:":[57],"(":[58,86],"1":[59],")":[60,88],"Dual-Strategy":[61],"Generation:":[63],"aims":[65],"produce":[67],"broader":[69],"spectrum":[70],"of":[71,123],"queries":[73],"by":[74,103],"using":[75],"models":[77],"with":[78,100],"two":[79],"strategies:":[80],"Supervised":[81],"Fine-Tuning":[82],"and":[83],"In-Context":[84],"Learning;":[85],"2":[87],"Multi-Role":[89],"Selection:":[91],"seeks":[93],"identify":[95],"most":[98],"aligning":[99],"intent":[102],"introducing":[104],"collaborative":[106],"involving":[108],"three":[109],"roles":[110],"(i.e.,":[111],"Proposer,":[112],"Critic,":[113],"Summarizer).":[114],"Extensive":[115],"experiments":[116],"various":[118],"datasets":[119],"substantiate":[120],"efficacy":[122],"enhancing":[126]},"counts_by_year":[],"updated_date":"2026-07-14T23:27:15.235271","created_date":"2025-10-31T00:00:00"}