{"id":"https://openalex.org/W4402351866","doi":"https://doi.org/10.1109/ijcnn60899.2024.10650552","title":"Chain-of-Program Prompting with Open-Source Large Language Models for Text-to-SQL","display_name":"Chain-of-Program Prompting with Open-Source Large Language Models for Text-to-SQL","publication_year":2024,"publication_date":"2024-06-30","ids":{"openalex":"https://openalex.org/W4402351866","doi":"https://doi.org/10.1109/ijcnn60899.2024.10650552"},"language":"en","primary_location":{"id":"doi:10.1109/ijcnn60899.2024.10650552","is_oa":false,"landing_page_url":"http://dx.doi.org/10.1109/ijcnn60899.2024.10650552","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2024 International Joint Conference on Neural Networks (IJCNN)","raw_type":"proceedings-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":"https://openalex.org/A5020681500","display_name":"Bo Xu","orcid":"https://orcid.org/0000-0002-2083-4307"},"institutions":[{"id":"https://openalex.org/I181326427","display_name":"Donghua University","ror":"https://ror.org/035psfh38","country_code":"CN","type":"education","lineage":["https://openalex.org/I181326427"]}],"countries":["CN"],"is_corresponding":true,"raw_author_name":"Bo Xu","raw_affiliation_strings":["Donghua University,School of Computer Science and Technology,Shanghai,China"],"affiliations":[{"raw_affiliation_string":"Donghua University,School of Computer Science and Technology,Shanghai,China","institution_ids":["https://openalex.org/I181326427"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5058018789","display_name":"Shufei Li","orcid":"https://orcid.org/0000-0002-5684-6756"},"institutions":[{"id":"https://openalex.org/I181326427","display_name":"Donghua University","ror":"https://ror.org/035psfh38","country_code":"CN","type":"education","lineage":["https://openalex.org/I181326427"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Shufei Li","raw_affiliation_strings":["Donghua University,School of Computer Science and Technology,Shanghai,China"],"affiliations":[{"raw_affiliation_string":"Donghua University,School of Computer Science and Technology,Shanghai,China","institution_ids":["https://openalex.org/I181326427"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100638144","display_name":"Yifei Wu","orcid":"https://orcid.org/0009-0008-4280-8901"},"institutions":[{"id":"https://openalex.org/I181326427","display_name":"Donghua University","ror":"https://ror.org/035psfh38","country_code":"CN","type":"education","lineage":["https://openalex.org/I181326427"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Yifei Wu","raw_affiliation_strings":["Donghua University,School of Computer Science and Technology,Shanghai,China"],"affiliations":[{"raw_affiliation_string":"Donghua University,School of Computer Science and Technology,Shanghai,China","institution_ids":["https://openalex.org/I181326427"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101230084","display_name":"Shouang Wei","orcid":null},"institutions":[{"id":"https://openalex.org/I181326427","display_name":"Donghua University","ror":"https://ror.org/035psfh38","country_code":"CN","type":"education","lineage":["https://openalex.org/I181326427"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Shouang Wei","raw_affiliation_strings":["Donghua University,School of Computer Science and Technology,Shanghai,China"],"affiliations":[{"raw_affiliation_string":"Donghua University,School of Computer Science and Technology,Shanghai,China","institution_ids":["https://openalex.org/I181326427"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5053377266","display_name":"Ming Du","orcid":null},"institutions":[{"id":"https://openalex.org/I181326427","display_name":"Donghua University","ror":"https://ror.org/035psfh38","country_code":"CN","type":"education","lineage":["https://openalex.org/I181326427"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Ming Du","raw_affiliation_strings":["Donghua University,School of Computer Science and Technology,Shanghai,China"],"affiliations":[{"raw_affiliation_string":"Donghua University,School of Computer Science and Technology,Shanghai,China","institution_ids":["https://openalex.org/I181326427"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5107916174","display_name":"Hongya Wang","orcid":null},"institutions":[{"id":"https://openalex.org/I181326427","display_name":"Donghua University","ror":"https://ror.org/035psfh38","country_code":"CN","type":"education","lineage":["https://openalex.org/I181326427"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Hongya Wang","raw_affiliation_strings":["Donghua University,School of Computer Science and Technology,Shanghai,China"],"affiliations":[{"raw_affiliation_string":"Donghua University,School of Computer Science and Technology,Shanghai,China","institution_ids":["https://openalex.org/I181326427"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5061863093","display_name":"Hui Song","orcid":"https://orcid.org/0000-0002-0458-5136"},"institutions":[{"id":"https://openalex.org/I181326427","display_name":"Donghua University","ror":"https://ror.org/035psfh38","country_code":"CN","type":"education","lineage":["https://openalex.org/I181326427"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Hui Song","raw_affiliation_strings":["Donghua University,School of Computer Science and Technology,Shanghai,China"],"affiliations":[{"raw_affiliation_string":"Donghua University,School of Computer Science and Technology,Shanghai,China","institution_ids":["https://openalex.org/I181326427"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":7,"corresponding_author_ids":["https://openalex.org/A5020681500"],"corresponding_institution_ids":["https://openalex.org/I181326427"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.1463916,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"34","issue":null,"first_page":"1","last_page":"8"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11986","display_name":"Scientific Computing and Data Management","score":0.9973000288009644,"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"}},"topics":[{"id":"https://openalex.org/T11986","display_name":"Scientific Computing and Data Management","score":0.9973000288009644,"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/T10260","display_name":"Software Engineering Research","score":0.9970999956130981,"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"}},{"id":"https://openalex.org/T10054","display_name":"Parallel Computing and Optimization Techniques","score":0.9955999851226807,"subfield":{"id":"https://openalex.org/subfields/1708","display_name":"Hardware and Architecture"},"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.8176019191741943},{"id":"https://openalex.org/keywords/open-source","display_name":"Open source","score":0.6943156123161316},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.6133851408958435},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.5920248031616211},{"id":"https://openalex.org/keywords/language-integrated-query","display_name":"Language Integrated Query","score":0.4401068687438965},{"id":"https://openalex.org/keywords/natural-language-processing","display_name":"Natural language processing","score":0.33499598503112793},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.3300411105155945},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.3292008936405182},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.2011871635913849},{"id":"https://openalex.org/keywords/software","display_name":"Software","score":0.13747426867485046}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8176019191741943},{"id":"https://openalex.org/C3018397939","wikidata":"https://www.wikidata.org/wiki/Q3644502","display_name":"Open source","level":3,"score":0.6943156123161316},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.6133851408958435},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5920248031616211},{"id":"https://openalex.org/C179531526","wikidata":"https://www.wikidata.org/wiki/Q595637","display_name":"Language Integrated Query","level":5,"score":0.4401068687438965},{"id":"https://openalex.org/C204321447","wikidata":"https://www.wikidata.org/wiki/Q30642","display_name":"Natural language processing","level":1,"score":0.33499598503112793},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3300411105155945},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.3292008936405182},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.2011871635913849},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.13747426867485046},{"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/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.1109/ijcnn60899.2024.10650552","is_oa":false,"landing_page_url":"http://dx.doi.org/10.1109/ijcnn60899.2024.10650552","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2024 International Joint Conference on Neural Networks (IJCNN)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[{"id":"https://openalex.org/F4320335787","display_name":"Fundamental Research Funds for the Central Universities","ror":null}],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":42,"referenced_works":["https://openalex.org/W1976174404","https://openalex.org/W2165382777","https://openalex.org/W2768409085","https://openalex.org/W2890431379","https://openalex.org/W2945102109","https://openalex.org/W3168867926","https://openalex.org/W3200079259","https://openalex.org/W3208581766","https://openalex.org/W4221143046","https://openalex.org/W4226278401","https://openalex.org/W4281483047","https://openalex.org/W4292779060","https://openalex.org/W4303441863","https://openalex.org/W4309953112","https://openalex.org/W4317553041","https://openalex.org/W4322718191","https://openalex.org/W4365205411","https://openalex.org/W4375869868","https://openalex.org/W4382202695","https://openalex.org/W4384615768","https://openalex.org/W4385567149","https://openalex.org/W4386185625","https://openalex.org/W4389520779","https://openalex.org/W4390023570","https://openalex.org/W4396571402","https://openalex.org/W6745921949","https://openalex.org/W6778883912","https://openalex.org/W6796581206","https://openalex.org/W6803081274","https://openalex.org/W6809646742","https://openalex.org/W6810738896","https://openalex.org/W6837989031","https://openalex.org/W6846120675","https://openalex.org/W6846874006","https://openalex.org/W6849274154","https://openalex.org/W6850625674","https://openalex.org/W6850656743","https://openalex.org/W6851560035","https://openalex.org/W6851928915","https://openalex.org/W6852852302","https://openalex.org/W6855328780","https://openalex.org/W6855970221"],"related_works":["https://openalex.org/W2383619981","https://openalex.org/W4390861444","https://openalex.org/W4206687279","https://openalex.org/W4400335725","https://openalex.org/W4386768611","https://openalex.org/W4316658535","https://openalex.org/W2990338989","https://openalex.org/W2340883001","https://openalex.org/W2536316411","https://openalex.org/W2557197178"],"abstract_inverted_index":{"Text-to-SQL":[0,37],"is":[1,73],"a":[2,17,32,50,69,111,147,162],"fundamental":[3],"natural":[4,12],"language":[5,13,26,185],"processing":[6],"(NLP)":[7],"task":[8],"that":[9,189],"involves":[10],"translating":[11],"queries":[14,145],"related":[15],"to":[16,74,91,171,194],"specified":[18],"relational":[19],"database":[20],"into":[21,146],"SQL":[22,82,103,144,173],"queries.":[23,104,152,174],"Recently,":[24],"large":[25,51,184],"models":[27,186],"(LLMs)":[28],"have":[29,187],"emerged":[30],"as":[31,56,128],"crucial":[33],"paradigm":[34],"in":[35,61,100,155,196],"the":[36,92,120,134,156,168,178],"task.":[38],"Despite":[39],"their":[40],"success,":[41],"current":[42],"methods":[43],"heavily":[44],"depend":[45],"on":[46,177],"closed-source":[47],"LLMs":[48,77],"with":[49,78,133],"number":[52],"of":[53,96,137,149],"parameters,":[54],"such":[55],"ChatGPT":[57],"and":[58,65],"GPT4,":[59],"resulting":[60],"significant":[62],"API":[63],"costs":[64],"privacy":[66],"concerns.":[67],"Therefore,":[68],"more":[70],"cost-effective":[71],"strategy":[72,87],"fine-tune":[75],"open-source":[76,97,183],"smaller":[79],"parameters":[80],"for":[81,116],"generation.":[83],"However,":[84],"this":[85,107],"alternative":[86],"faces":[88],"challenges":[89],"due":[90],"weaker":[93],"reasoning":[94],"capabilities":[95],"LLMs,":[98],"particularly":[99],"generating":[101],"complex":[102,143],"To":[105],"address":[106],"issue,":[108],"we":[109,124,166],"propose":[110],"Chain-of-Programs":[112],"(COP)":[113],"prompting":[114,170],"framework":[115],"Text-to-SQL.":[117],"Different":[118],"from":[119],"conventional":[121],"Chain-of-Thoughts":[122],"(COT),":[123],"utilize":[125],"Pandas":[126,151],"code":[127],"an":[129],"intermediate":[130],"representation":[131],"aligned":[132],"step-wise":[135],"nature":[136],"human":[138],"thinking.":[139],"This":[140],"decomposition":[141],"transforms":[142],"series":[148],"simple":[150],"Each":[153],"step":[154],"COP":[157,169],"can":[158],"be":[159],"validated":[160],"using":[161,181],"Python":[163],"interpreter.":[164],"Finally,":[165],"use":[167],"generate":[172],"Experiments":[175],"conducted":[176],"Spider":[179],"dataset":[180],"two":[182],"demonstrated":[188],"our":[190],"performances":[191],"are":[192],"comparable":[193],"GPT4":[195],"zero-shot":[197],"scenario.":[198]},"counts_by_year":[],"updated_date":"2025-12-27T23:08:20.325037","created_date":"2025-10-10T00:00:00"}