{"id":"https://openalex.org/W4381326864","doi":"https://doi.org/10.1145/3589292","title":"Few-shot Text-to-SQL Translation using Structure and Content Prompt Learning","display_name":"Few-shot Text-to-SQL Translation using Structure and Content Prompt Learning","publication_year":2023,"publication_date":"2023-06-13","ids":{"openalex":"https://openalex.org/W4381326864","doi":"https://doi.org/10.1145/3589292"},"language":"en","primary_location":{"id":"doi:10.1145/3589292","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3589292","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":true,"oa_status":"green","oa_url":"https://dspace.mit.edu/bitstream/1721.1/151087/1/3589292.pdf","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5030726587","display_name":"Zihui Gu","orcid":"https://orcid.org/0000-0002-9413-2068"},"institutions":[{"id":"https://openalex.org/I78988378","display_name":"Renmin University of China","ror":"https://ror.org/041pakw92","country_code":"CN","type":"education","lineage":["https://openalex.org/I78988378"]}],"countries":["CN"],"is_corresponding":true,"raw_author_name":"Zihui Gu","raw_affiliation_strings":["Renmin University of China, Beijing, China"],"affiliations":[{"raw_affiliation_string":"Renmin University of China, Beijing, China","institution_ids":["https://openalex.org/I78988378"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100739546","display_name":"Ju Fan","orcid":"https://orcid.org/0000-0003-4729-9903"},"institutions":[{"id":"https://openalex.org/I78988378","display_name":"Renmin University of China","ror":"https://ror.org/041pakw92","country_code":"CN","type":"education","lineage":["https://openalex.org/I78988378"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Ju Fan","raw_affiliation_strings":["Renmin University of China, Beijing, China"],"affiliations":[{"raw_affiliation_string":"Renmin University of China, Beijing, China","institution_ids":["https://openalex.org/I78988378"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101824160","display_name":"Nan Tang","orcid":"https://orcid.org/0000-0003-2832-0295"},"institutions":[{"id":"https://openalex.org/I889458895","display_name":"University of Hong Kong","ror":"https://ror.org/02zhqgq86","country_code":"HK","type":"education","lineage":["https://openalex.org/I889458895"]}],"countries":["HK"],"is_corresponding":false,"raw_author_name":"Nan Tang","raw_affiliation_strings":["QCRI & HKUST (GZ), Doha, Qatar"],"affiliations":[{"raw_affiliation_string":"QCRI & HKUST (GZ), Doha, Qatar","institution_ids":["https://openalex.org/I889458895"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5049926126","display_name":"Lei Cao","orcid":"https://orcid.org/0000-0001-9909-8607"},"institutions":[{"id":"https://openalex.org/I138006243","display_name":"University of Arizona","ror":"https://ror.org/03m2x1q45","country_code":"US","type":"education","lineage":["https://openalex.org/I138006243"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Lei Cao","raw_affiliation_strings":["MIT CSAIL & University of Arizona, Boston, MA, USA"],"affiliations":[{"raw_affiliation_string":"MIT CSAIL & University of Arizona, Boston, MA, USA","institution_ids":["https://openalex.org/I138006243"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5103264516","display_name":"Bowen Jia","orcid":"https://orcid.org/0000-0003-3905-2521"},"institutions":[{"id":"https://openalex.org/I78988378","display_name":"Renmin University of China","ror":"https://ror.org/041pakw92","country_code":"CN","type":"education","lineage":["https://openalex.org/I78988378"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Bowen Jia","raw_affiliation_strings":["Renmin University of China, Beijing, China"],"affiliations":[{"raw_affiliation_string":"Renmin University of China, Beijing, China","institution_ids":["https://openalex.org/I78988378"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5037742794","display_name":"Samuel Madden","orcid":null},"institutions":[{"id":"https://openalex.org/I4210110987","display_name":"IIT@MIT","ror":"https://ror.org/01wp8zh54","country_code":"US","type":"facility","lineage":["https://openalex.org/I30771326","https://openalex.org/I4210110987"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Sam Madden","raw_affiliation_strings":["MIT CSAIL, Boston, MA, USA"],"affiliations":[{"raw_affiliation_string":"MIT CSAIL, Boston, MA, USA","institution_ids":["https://openalex.org/I4210110987"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5008721449","display_name":"Xiaoyong Du","orcid":"https://orcid.org/0000-0002-5757-9135"},"institutions":[{"id":"https://openalex.org/I78988378","display_name":"Renmin University of China","ror":"https://ror.org/041pakw92","country_code":"CN","type":"education","lineage":["https://openalex.org/I78988378"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Xiaoyong Du","raw_affiliation_strings":["Renmin University of China, Beijing, China"],"affiliations":[{"raw_affiliation_string":"Renmin University of China, Beijing, China","institution_ids":["https://openalex.org/I78988378"]}]}],"institutions":[],"countries_distinct_count":3,"institutions_distinct_count":7,"corresponding_author_ids":["https://openalex.org/A5030726587"],"corresponding_institution_ids":["https://openalex.org/I78988378"],"apc_list":null,"apc_paid":null,"fwci":8.6825,"has_fulltext":true,"cited_by_count":50,"citation_normalized_percentile":{"value":0.98333535,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":96,"max":100},"biblio":{"volume":"1","issue":"2","first_page":"1","last_page":"28"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10181","display_name":"Natural Language Processing Techniques","score":0.9997000098228455,"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.9997000098228455,"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.9995999932289124,"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.9911999702453613,"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.8716846704483032},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7815068960189819},{"id":"https://openalex.org/keywords/identifier","display_name":"Identifier","score":0.5525991320610046},{"id":"https://openalex.org/keywords/stored-procedure","display_name":"Stored procedure","score":0.5259820818901062},{"id":"https://openalex.org/keywords/task","display_name":"Task (project management)","score":0.5023798942565918},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.4581517279148102},{"id":"https://openalex.org/keywords/natural-language-processing","display_name":"Natural language processing","score":0.4419531226158142},{"id":"https://openalex.org/keywords/data-definition-language","display_name":"Data definition language","score":0.4360966384410858},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.43439358472824097},{"id":"https://openalex.org/keywords/table","display_name":"Table (database)","score":0.4248954653739929},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.32980644702911377},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.3145526945590973},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.2626364231109619},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.07493025064468384}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8716846704483032},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7815068960189819},{"id":"https://openalex.org/C154504017","wikidata":"https://www.wikidata.org/wiki/Q853614","display_name":"Identifier","level":2,"score":0.5525991320610046},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.5259820818901062},{"id":"https://openalex.org/C2780451532","wikidata":"https://www.wikidata.org/wiki/Q759676","display_name":"Task (project management)","level":2,"score":0.5023798942565918},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.4581517279148102},{"id":"https://openalex.org/C204321447","wikidata":"https://www.wikidata.org/wiki/Q30642","display_name":"Natural language processing","level":1,"score":0.4419531226158142},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.4360966384410858},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.43439358472824097},{"id":"https://openalex.org/C45235069","wikidata":"https://www.wikidata.org/wiki/Q278425","display_name":"Table (database)","level":2,"score":0.4248954653739929},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.32980644702911377},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.3145526945590973},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.2626364231109619},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.07493025064468384},{"id":"https://openalex.org/C187736073","wikidata":"https://www.wikidata.org/wiki/Q2920921","display_name":"Management","level":1,"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/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/3589292","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3589292","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"},{"id":"pmh:oai:dspace.mit.edu:1721.1/151087","is_oa":true,"landing_page_url":"https://hdl.handle.net/1721.1/151087","pdf_url":"https://dspace.mit.edu/bitstream/1721.1/151087/1/3589292.pdf","source":{"id":"https://openalex.org/S4306400425","display_name":"DSpace@MIT (Massachusetts Institute of Technology)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I63966007","host_organization_name":"Massachusetts Institute of Technology","host_organization_lineage":["https://openalex.org/I63966007"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by-nc","license_id":"https://openalex.org/licenses/cc-by-nc","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Association for Computing Machinery","raw_type":"http://purl.org/eprint/type/JournalArticle"}],"best_oa_location":{"id":"pmh:oai:dspace.mit.edu:1721.1/151087","is_oa":true,"landing_page_url":"https://hdl.handle.net/1721.1/151087","pdf_url":"https://dspace.mit.edu/bitstream/1721.1/151087/1/3589292.pdf","source":{"id":"https://openalex.org/S4306400425","display_name":"DSpace@MIT (Massachusetts Institute of Technology)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I63966007","host_organization_name":"Massachusetts Institute of Technology","host_organization_lineage":["https://openalex.org/I63966007"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by-nc","license_id":"https://openalex.org/licenses/cc-by-nc","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Association for Computing Machinery","raw_type":"http://purl.org/eprint/type/JournalArticle"},"sustainable_development_goals":[{"display_name":"No poverty","score":0.4300000071525574,"id":"https://metadata.un.org/sdg/1"}],"awards":[],"funders":[],"has_content":{"pdf":true,"grobid_xml":false},"content_urls":{"pdf":"https://content.openalex.org/works/W4381326864.pdf"},"referenced_works_count":23,"referenced_works":["https://openalex.org/W2560674852","https://openalex.org/W2890431379","https://openalex.org/W2963620441","https://openalex.org/W2970442801","https://openalex.org/W2971105107","https://openalex.org/W3034835156","https://openalex.org/W3034999214","https://openalex.org/W3035331128","https://openalex.org/W3044438666","https://openalex.org/W3116342879","https://openalex.org/W3153427360","https://openalex.org/W3156012351","https://openalex.org/W3172642864","https://openalex.org/W3173274550","https://openalex.org/W3173964589","https://openalex.org/W3174726724","https://openalex.org/W3174770825","https://openalex.org/W3175488485","https://openalex.org/W3198571508","https://openalex.org/W3205950290","https://openalex.org/W3214600982","https://openalex.org/W4205123042","https://openalex.org/W4205991051"],"related_works":["https://openalex.org/W650213220","https://openalex.org/W2340883001","https://openalex.org/W1980548249","https://openalex.org/W1592149428","https://openalex.org/W2974218799","https://openalex.org/W151494989","https://openalex.org/W20807724","https://openalex.org/W2373982268","https://openalex.org/W2385056678","https://openalex.org/W2486394024"],"abstract_inverted_index":{"A":[0],"common":[1],"problem":[2],"with":[3,28,104,128,211],"adopting":[4],"Text-to-SQL":[5,25,54,58,214],"translation":[6,59],"in":[7,123,177,227],"database":[8],"systems":[9],"is":[10,16,69],"poor":[11],"generalization.":[12],"Specifically,":[13],"when":[14],"there":[15],"limited":[17],"training":[18,243,249],"data":[19],"on":[20,33,233,260],"new":[21],"datasets,":[22],"existing":[23],"few-shot":[24,53,229],"techniques,":[26],"even":[27],"carefully":[29],"designed":[30],"textual":[31,160],"prompts":[32],"pre-trained":[34],"language":[35],"models":[36],"(PLMs),":[37],"tend":[38],"to":[39,50,71,84,119,171,187,199,203],"be":[40,72],"ineffective.":[41],"In":[42,180,231],"this":[43],"paper,":[44],"we":[45,182],"present":[46],"a":[47,82,117,145],"divide-and-conquer":[48],"framework":[49],"better":[51,172],"support":[52],"translation,":[55],"which":[56],"divides":[57],"into":[60],"two":[61],"stages":[62],"(or":[63],"sub-tasks),":[64],"such":[65,92,100,134,162],"that":[66,149,163,222],"each":[67],"sub-task":[68],"simpler":[70],"tackled.":[73],"The":[74,109],"first":[75],"stage,":[76,80,111,115],"called":[77,112],"the":[78,113,121,124,164,189,201,217,228,234,247,253],"structure":[79,88,127,196],"steers":[81],"PLM":[83,118],"generate":[85],"an":[86],"SQL":[87,90,98,126,132,193],"(including":[89,131],"commands":[91],"as":[93,101,135],"SELECT,":[94],"FROM,":[95],"WHERE":[96],"and":[97,140,153,195],"operators":[99],"<\",":[102],"?>\")":[103],"placeholders":[105,122],"for":[106,175],"missing":[107],"identifiers.":[108],"second":[110],"content":[114],"guides":[116],"populate":[120],"generated":[125,192],"concrete":[129],"values":[130],"identifies":[133],"table":[136],"names,":[137,139],"column":[138],"constant":[141],"values).":[142],"We":[143],"propose":[144],"hybrid":[146,165],"prompt":[147,166],"strategy":[148],"combines":[150],"learnable":[151],"vectors":[152,155],"fixed":[154],"(i.e.,":[156],"word":[157],"embeddings":[158],"of":[159,191,219,246],"prompts),":[161],"can":[167],"learn":[168],"contextual":[169],"information":[170],"guide":[173],"PLMs":[174],"prediction":[176],"both":[178],"stages.":[179],"addition,":[181],"design":[183],"keyword":[184],"constrained":[185],"decoding":[186,198],"ensure":[188],"validity":[190],"structures,":[194],"guided":[197],"guarantee":[200],"model":[202],"fill":[204],"correct":[205],"content.":[206],"Extensive":[207],"experiments,":[208],"by":[209,257],"comparing":[210],"ten":[212],"state-of-the-art":[213],"solutions":[215],"at":[216],"time":[218],"writing,":[220],"show":[221],"SC-Prompt":[223,251],"significantly":[224],"outperforms":[225,252],"them":[226],"scenario.":[230],"particular,":[232],"widely-adopted":[235],"Spider":[236],"dataset,":[237],"given":[238],"less":[239],"than":[240],"500":[241],"labeled":[242],"examples":[244],"(5%":[245],"official":[248],"set),":[250],"previous":[254],"SOTA":[255],"methods":[256],"around":[258],"5%":[259],"accuracy.":[261]},"counts_by_year":[{"year":2026,"cited_by_count":3},{"year":2025,"cited_by_count":24},{"year":2024,"cited_by_count":20},{"year":2023,"cited_by_count":3}],"updated_date":"2026-04-05T17:49:38.594831","created_date":"2025-10-10T00:00:00"}