{"id":"https://openalex.org/W4283159195","doi":"https://doi.org/10.1145/3511095.3531282","title":"Exploring the Feasibility of Crowd-Powered Decomposition of Complex User Questions in Text-to-SQL Tasks","display_name":"Exploring the Feasibility of Crowd-Powered Decomposition of Complex User Questions in Text-to-SQL Tasks","publication_year":2022,"publication_date":"2022-06-20","ids":{"openalex":"https://openalex.org/W4283159195","doi":"https://doi.org/10.1145/3511095.3531282"},"language":"en","primary_location":{"id":"doi:10.1145/3511095.3531282","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3511095.3531282","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3511095.3531282","source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 33rd ACM Conference on Hypertext and Social Media","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://dl.acm.org/doi/pdf/10.1145/3511095.3531282","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5090642445","display_name":"Sara Salimzadeh","orcid":"https://orcid.org/0000-0001-8734-951X"},"institutions":[{"id":"https://openalex.org/I98358874","display_name":"Delft University of Technology","ror":"https://ror.org/02e2c7k09","country_code":"NL","type":"education","lineage":["https://openalex.org/I98358874"]}],"countries":["NL"],"is_corresponding":true,"raw_author_name":"Sara Salimzadeh","raw_affiliation_strings":["Delft University of Technology, Netherlands"],"affiliations":[{"raw_affiliation_string":"Delft University of Technology, Netherlands","institution_ids":["https://openalex.org/I98358874"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5038081564","display_name":"Ujwal Gadiraju","orcid":"https://orcid.org/0000-0002-6189-6539"},"institutions":[{"id":"https://openalex.org/I98358874","display_name":"Delft University of Technology","ror":"https://ror.org/02e2c7k09","country_code":"NL","type":"education","lineage":["https://openalex.org/I98358874"]}],"countries":["NL"],"is_corresponding":false,"raw_author_name":"Ujwal Gadiraju","raw_affiliation_strings":["Delft University of Technology, Netherlands"],"affiliations":[{"raw_affiliation_string":"Delft University of Technology, Netherlands","institution_ids":["https://openalex.org/I98358874"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5084915697","display_name":"Claudia Hauff","orcid":"https://orcid.org/0000-0001-9879-6470"},"institutions":[{"id":"https://openalex.org/I98358874","display_name":"Delft University of Technology","ror":"https://ror.org/02e2c7k09","country_code":"NL","type":"education","lineage":["https://openalex.org/I98358874"]}],"countries":["NL"],"is_corresponding":false,"raw_author_name":"Claudia Hauff","raw_affiliation_strings":["Delft University of Technology, Netherlands"],"affiliations":[{"raw_affiliation_string":"Delft University of Technology, Netherlands","institution_ids":["https://openalex.org/I98358874"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5090401584","display_name":"Arie van Deursen","orcid":"https://orcid.org/0000-0003-4850-3312"},"institutions":[{"id":"https://openalex.org/I98358874","display_name":"Delft University of Technology","ror":"https://ror.org/02e2c7k09","country_code":"NL","type":"education","lineage":["https://openalex.org/I98358874"]}],"countries":["NL"],"is_corresponding":false,"raw_author_name":"Arie van Deursen","raw_affiliation_strings":["Delft University of Technology, Netherlands"],"affiliations":[{"raw_affiliation_string":"Delft University of Technology, Netherlands","institution_ids":["https://openalex.org/I98358874"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5090642445"],"corresponding_institution_ids":["https://openalex.org/I98358874"],"apc_list":null,"apc_paid":null,"fwci":0.6316,"has_fulltext":true,"cited_by_count":3,"citation_normalized_percentile":{"value":0.75367319,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":96},"biblio":{"volume":null,"issue":null,"first_page":"154","last_page":"165"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11704","display_name":"Mobile Crowdsensing and Crowdsourcing","score":0.9998000264167786,"subfield":{"id":"https://openalex.org/subfields/1706","display_name":"Computer Science Applications"},"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/T11704","display_name":"Mobile Crowdsensing and Crowdsourcing","score":0.9998000264167786,"subfield":{"id":"https://openalex.org/subfields/1706","display_name":"Computer Science Applications"},"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/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/T10028","display_name":"Topic Modeling","score":0.9861000180244446,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8782644867897034},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.8512855768203735},{"id":"https://openalex.org/keywords/data-definition-language","display_name":"Data definition language","score":0.6420571208000183},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.5678188800811768},{"id":"https://openalex.org/keywords/sql/psm","display_name":"SQL/PSM","score":0.5441043376922607},{"id":"https://openalex.org/keywords/stored-procedure","display_name":"Stored procedure","score":0.4762049913406372},{"id":"https://openalex.org/keywords/language-integrated-query","display_name":"Language Integrated Query","score":0.4467929005622864},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.41772955656051636},{"id":"https://openalex.org/keywords/data-transformation-services","display_name":"Data Transformation Services","score":0.41392824053764343},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.39774560928344727},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.3855384588241577},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.34855765104293823},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.335163414478302},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.10093405842781067},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.07373389601707458}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8782644867897034},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.8512855768203735},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.6420571208000183},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.5678188800811768},{"id":"https://openalex.org/C167544706","wikidata":"https://www.wikidata.org/wiki/Q360842","display_name":"SQL/PSM","level":5,"score":0.5441043376922607},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.4762049913406372},{"id":"https://openalex.org/C179531526","wikidata":"https://www.wikidata.org/wiki/Q595637","display_name":"Language Integrated Query","level":5,"score":0.4467929005622864},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.41772955656051636},{"id":"https://openalex.org/C141589383","wikidata":"https://www.wikidata.org/wiki/Q644775","display_name":"Data Transformation Services","level":5,"score":0.41392824053764343},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.39774560928344727},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.3855384588241577},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.34855765104293823},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.335163414478302},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.10093405842781067},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.07373389601707458}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/3511095.3531282","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3511095.3531282","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3511095.3531282","source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 33rd ACM Conference on Hypertext and Social Media","raw_type":"proceedings-article"},{"id":"pmh:oai:tudelft.nl:uuid:966a5972-ca66-414a-9556-a2031a5582a2","is_oa":true,"landing_page_url":"http://resolver.tudelft.nl/uuid:966a5972-ca66-414a-9556-a2031a5582a2","pdf_url":null,"source":{"id":"https://openalex.org/S4306400906","display_name":"Research Repository (Delft University of Technology)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I98358874","host_organization_name":"Delft University of Technology","host_organization_lineage":["https://openalex.org/I98358874"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"conference paper"}],"best_oa_location":{"id":"doi:10.1145/3511095.3531282","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3511095.3531282","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3511095.3531282","source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 33rd ACM Conference on Hypertext and Social Media","raw_type":"proceedings-article"},"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/4","score":0.699999988079071,"display_name":"Quality Education"}],"awards":[],"funders":[],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4283159195.pdf","grobid_xml":"https://content.openalex.org/works/W4283159195.grobid-xml"},"referenced_works_count":71,"referenced_works":["https://openalex.org/W203668661","https://openalex.org/W1971218560","https://openalex.org/W1975466917","https://openalex.org/W2018528547","https://openalex.org/W2023822028","https://openalex.org/W2023996190","https://openalex.org/W2036001619","https://openalex.org/W2043794661","https://openalex.org/W2047237057","https://openalex.org/W2049318239","https://openalex.org/W2056584528","https://openalex.org/W2073068515","https://openalex.org/W2081118310","https://openalex.org/W2104438030","https://openalex.org/W2116705992","https://openalex.org/W2127008633","https://openalex.org/W2142327972","https://openalex.org/W2145618437","https://openalex.org/W2154268919","https://openalex.org/W2161002933","https://openalex.org/W2163031058","https://openalex.org/W2164155814","https://openalex.org/W2171913066","https://openalex.org/W2251784184","https://openalex.org/W2269738476","https://openalex.org/W2327765591","https://openalex.org/W2605214337","https://openalex.org/W2734958999","https://openalex.org/W2745934983","https://openalex.org/W2757361303","https://openalex.org/W2762513422","https://openalex.org/W2769041395","https://openalex.org/W2798663534","https://openalex.org/W2890431379","https://openalex.org/W2891691255","https://openalex.org/W2945102109","https://openalex.org/W2952032096","https://openalex.org/W2959716049","https://openalex.org/W2962713807","https://openalex.org/W2963207291","https://openalex.org/W2963357517","https://openalex.org/W2963477458","https://openalex.org/W2963675284","https://openalex.org/W2963794306","https://openalex.org/W2964271186","https://openalex.org/W2970002529","https://openalex.org/W2970172141","https://openalex.org/W2970442801","https://openalex.org/W2970744399","https://openalex.org/W2971126690","https://openalex.org/W2971323043","https://openalex.org/W2978891579","https://openalex.org/W3009312460","https://openalex.org/W3015937477","https://openalex.org/W3034835156","https://openalex.org/W3103291908","https://openalex.org/W3103611182","https://openalex.org/W3104003456","https://openalex.org/W3104055253","https://openalex.org/W3104196282","https://openalex.org/W3170014162","https://openalex.org/W3170698273","https://openalex.org/W3170721718","https://openalex.org/W3175013773","https://openalex.org/W3175488485","https://openalex.org/W3176057191","https://openalex.org/W3200079259","https://openalex.org/W3212896246","https://openalex.org/W4239019441","https://openalex.org/W4287816933","https://openalex.org/W4292341621"],"related_works":["https://openalex.org/W2750425440","https://openalex.org/W638381921","https://openalex.org/W2912795851","https://openalex.org/W2898367493","https://openalex.org/W2512476881","https://openalex.org/W2240099544","https://openalex.org/W619366292","https://openalex.org/W2168095336","https://openalex.org/W2917505743","https://openalex.org/W2738342198"],"abstract_inverted_index":{"Natural":[0],"Language":[1,21],"Interfaces":[2],"to":[3,23,61,74,78,123,152,185,196,211,227,233],"Databases":[4],"(NLIDB),":[5],"also":[6,58],"known":[7],"as":[8,120],"Text-to-SQL":[9,192,247],"models,":[10],"enable":[11],"users":[12],"with":[13,115,163],"different":[14],"levels":[15],"of":[16,45,49,105,127,135,180,189],"knowledge":[17],"in":[18,66,89,140,161,207],"Structured":[19],"Query":[20],"(SQL)":[22],"access":[24],"relational":[25],"databases":[26,50,65],"without":[27],"any":[28],"programming":[29],"effort.":[30],"By":[31],"translating":[32],"natural":[33,67,76],"languages":[34,77],"into":[35,110],"SQL":[36,54,79,129,155,164,204],"query,":[37],"not":[38],"only":[39],"do":[40],"NLIDBs":[41,71,151],"minimize":[42],"the":[43,47,103,125,133,209,229],"burden":[44],"memorizing":[46],"schema":[48],"and":[51,92],"writing":[52],"complex":[53,96,107,128,137,181,242],"queries,":[55,156],"but":[56],"they":[57,81],"allow":[59],"non-experts":[60],"acquire":[62],"information":[63],"from":[64,86,194],"languages.":[68],"However,":[69],"existing":[70,150,191],"largely":[72],"fail":[73],"translate":[75],"when":[80],"are":[82],"complex,":[83],"preventing":[84],"them":[85],"being":[87],"deployed":[88],"real-world":[90],"scenarios":[91],"generalizing":[93],"across":[94],"unseen":[95],"databases.":[97],"In":[98],"this":[99],"paper,":[100],"we":[101,175],"explored":[102],"feasibility":[104,134],"decomposing":[106,136],"user":[108,138,182,243],"questions":[109,139,183],"multiple":[111],"sub-questions":[112],"\u2014":[113,119],"each":[114,144],"a":[116,121,141,224],"reduced":[117],"complexity":[118],"means":[122],"circumvent":[124],"problem":[126],"generation.":[130],"We":[131],"investigated":[132],"manner":[142],"that":[143,177,219,238],"sub-question":[145],"is":[146],"simple":[147],"enough":[148],"for":[149],"generate":[153],"correct":[154],"using":[157],"non-expert":[158],"crowd":[159],"workers":[160],"juxtaposition":[162],"experts.":[165],"Through":[166],"an":[167,171,186,190],"empirical":[168],"study":[169],"on":[170],"NLIDB":[172],"benchmark":[173],"dataset,":[174],"found":[176],"crowd-powered":[178,220],"decomposition":[179,202,221],"led":[184],"accuracy":[187,199,210,214],"boost":[188],"pipeline":[193],"30%":[195],"59%":[197],"(96%":[198],"boost).":[200,215],"Similarly,":[201],"by":[203],"experts":[205],"resulted":[206],"boosting":[208],"76%":[212],"(153%":[213],"Our":[216],"findings":[217],"suggest":[218],"can":[222,239],"be":[223],"scalable":[225],"alternative":[226],"producing":[228],"training":[230],"data":[231],"necessary":[232],"build":[234],"machine":[235],"learning":[236],"models":[237],"automatically":[240],"decompose":[241],"questions,":[244],"thereby":[245],"improving":[246],"pipelines.":[248]},"counts_by_year":[{"year":2025,"cited_by_count":2},{"year":2023,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}