{"id":"https://openalex.org/W2890671347","doi":"https://doi.org/10.18653/v1/d18-1197","title":"What It Takes to Achieve 100% Condition Accuracy on WikiSQL","display_name":"What It Takes to Achieve 100% Condition Accuracy on WikiSQL","publication_year":2018,"publication_date":"2018-01-01","ids":{"openalex":"https://openalex.org/W2890671347","doi":"https://doi.org/10.18653/v1/d18-1197","mag":"2890671347"},"language":"en","primary_location":{"id":"doi:10.18653/v1/d18-1197","is_oa":true,"landing_page_url":"https://doi.org/10.18653/v1/d18-1197","pdf_url":"https://www.aclweb.org/anthology/D18-1197.pdf","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 2018 Conference on Empirical Methods in Natural Language Processing","raw_type":"proceedings-article"},"type":"conference-paper","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://www.aclweb.org/anthology/D18-1197.pdf","any_repository_has_fulltext":null},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5048500970","display_name":"Semih Yavuz","orcid":null},"institutions":[{"id":"https://openalex.org/I154570441","display_name":"University of California, Santa Barbara","ror":"https://ror.org/02t274463","country_code":"US","type":"education","lineage":["https://openalex.org/I154570441"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Semih Yavuz","raw_affiliation_strings":["Department of Computer Science, University of California, Santa Barbara"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Computer Science, University of California, Santa Barbara","institution_ids":["https://openalex.org/I154570441"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5048764935","display_name":"\u0130zzeddin G\u00fcr","orcid":null},"institutions":[{"id":"https://openalex.org/I154570441","display_name":"University of California, Santa Barbara","ror":"https://ror.org/02t274463","country_code":"US","type":"education","lineage":["https://openalex.org/I154570441"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Izzeddin Gur","raw_affiliation_strings":["Department of Computer Science, University of California, Santa Barbara"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Computer Science, University of California, Santa Barbara","institution_ids":["https://openalex.org/I154570441"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5075435632","display_name":"Yu Su","orcid":"https://orcid.org/0000-0003-4306-0161"},"institutions":[{"id":"https://openalex.org/I154570441","display_name":"University of California, Santa Barbara","ror":"https://ror.org/02t274463","country_code":"US","type":"education","lineage":["https://openalex.org/I154570441"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Yu Su","raw_affiliation_strings":["Department of Computer Science, University of California, Santa Barbara"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Computer Science, University of California, Santa Barbara","institution_ids":["https://openalex.org/I154570441"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5047709762","display_name":"Xifeng Yan","orcid":"https://orcid.org/0009-0000-6508-4792"},"institutions":[{"id":"https://openalex.org/I154570441","display_name":"University of California, Santa Barbara","ror":"https://ror.org/02t274463","country_code":"US","type":"education","lineage":["https://openalex.org/I154570441"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Xifeng Yan","raw_affiliation_strings":["Department of Computer Science, University of California, Santa Barbara"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Computer Science, University of California, Santa Barbara","institution_ids":["https://openalex.org/I154570441"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I154570441"],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":true,"cited_by_count":29,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"1702","last_page":"1711"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10181","display_name":"Natural Language Processing Techniques","score":0.9990000128746033,"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.9990000128746033,"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.9988999962806702,"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.9671000242233276,"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.8804508447647095},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.6795343160629272},{"id":"https://openalex.org/keywords/focus","display_name":"Focus (optics)","score":0.5938308238983154},{"id":"https://openalex.org/keywords/simplicity","display_name":"Simplicity","score":0.5665019750595093},{"id":"https://openalex.org/keywords/scope","display_name":"Scope (computer science)","score":0.5661007761955261},{"id":"https://openalex.org/keywords/simple","display_name":"Simple (philosophy)","score":0.518034040927887},{"id":"https://openalex.org/keywords/ask-price","display_name":"Ask price","score":0.49109816551208496},{"id":"https://openalex.org/keywords/natural-language","display_name":"Natural language","score":0.4186114966869354},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.40235015749931335},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.33475613594055176},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.28644928336143494},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.2686132490634918},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.26395943760871887}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8804508447647095},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6795343160629272},{"id":"https://openalex.org/C192209626","wikidata":"https://www.wikidata.org/wiki/Q190909","display_name":"Focus (optics)","level":2,"score":0.5938308238983154},{"id":"https://openalex.org/C2776372474","wikidata":"https://www.wikidata.org/wiki/Q508291","display_name":"Simplicity","level":2,"score":0.5665019750595093},{"id":"https://openalex.org/C2778012447","wikidata":"https://www.wikidata.org/wiki/Q1034415","display_name":"Scope (computer science)","level":2,"score":0.5661007761955261},{"id":"https://openalex.org/C2780586882","wikidata":"https://www.wikidata.org/wiki/Q7520643","display_name":"Simple (philosophy)","level":2,"score":0.518034040927887},{"id":"https://openalex.org/C90329073","wikidata":"https://www.wikidata.org/wiki/Q914232","display_name":"Ask price","level":2,"score":0.49109816551208496},{"id":"https://openalex.org/C195324797","wikidata":"https://www.wikidata.org/wiki/Q33742","display_name":"Natural language","level":2,"score":0.4186114966869354},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.40235015749931335},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.33475613594055176},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.28644928336143494},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.2686132490634918},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.26395943760871887},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0},{"id":"https://openalex.org/C136264566","wikidata":"https://www.wikidata.org/wiki/Q159810","display_name":"Economy","level":1,"score":0.0},{"id":"https://openalex.org/C111472728","wikidata":"https://www.wikidata.org/wiki/Q9471","display_name":"Epistemology","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/C120665830","wikidata":"https://www.wikidata.org/wiki/Q14620","display_name":"Optics","level":1,"score":0.0},{"id":"https://openalex.org/C121332964","wikidata":"https://www.wikidata.org/wiki/Q413","display_name":"Physics","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.18653/v1/d18-1197","is_oa":true,"landing_page_url":"https://doi.org/10.18653/v1/d18-1197","pdf_url":"https://www.aclweb.org/anthology/D18-1197.pdf","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 2018 Conference on Empirical Methods in Natural Language Processing","raw_type":"proceedings-article"}],"best_oa_location":{"id":"doi:10.18653/v1/d18-1197","is_oa":true,"landing_page_url":"https://doi.org/10.18653/v1/d18-1197","pdf_url":"https://www.aclweb.org/anthology/D18-1197.pdf","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 2018 Conference on Empirical Methods in Natural Language Processing","raw_type":"proceedings-article"},"sustainable_development_goals":[{"score":0.5400000214576721,"id":"https://metadata.un.org/sdg/4","display_name":"Quality Education"}],"awards":[{"id":"https://openalex.org/G6383328962","display_name":"III: Small: Knowledge Graph Query Processing and Benchmarking","funder_award_id":"1528175","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"}],"funders":[{"id":"https://openalex.org/F4320306076","display_name":"National Science Foundation","ror":"https://ror.org/021nxhr62"},{"id":"https://openalex.org/F4320338295","display_name":"Army Research Laboratory","ror":"https://ror.org/011hc8f90"}],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2890671347.pdf","grobid_xml":"https://content.openalex.org/works/W2890671347.grobid-xml"},"referenced_works_count":34,"referenced_works":["https://openalex.org/W580074167","https://openalex.org/W1496189301","https://openalex.org/W1507020546","https://openalex.org/W1522301498","https://openalex.org/W2107618763","https://openalex.org/W2111742432","https://openalex.org/W2145618437","https://openalex.org/W2154268919","https://openalex.org/W2163274265","https://openalex.org/W2250539671","https://openalex.org/W2251079237","https://openalex.org/W2252136820","https://openalex.org/W2342096063","https://openalex.org/W2402144811","https://openalex.org/W2512994153","https://openalex.org/W2561148973","https://openalex.org/W2566402689","https://openalex.org/W2751448157","https://openalex.org/W2768409085","https://openalex.org/W2796167946","https://openalex.org/W2798753108","https://openalex.org/W2888128175","https://openalex.org/W2953384591","https://openalex.org/W2962713807","https://openalex.org/W2962942784","https://openalex.org/W2963207291","https://openalex.org/W2963794306","https://openalex.org/W2963899988","https://openalex.org/W2964121744","https://openalex.org/W2964271186","https://openalex.org/W3159064672","https://openalex.org/W4246375690","https://openalex.org/W4299674251","https://openalex.org/W4301674784"],"related_works":["https://openalex.org/W2368019753","https://openalex.org/W2333930193","https://openalex.org/W2737356002","https://openalex.org/W2246241526","https://openalex.org/W4301122218","https://openalex.org/W2374150061","https://openalex.org/W2081340182","https://openalex.org/W2369703001","https://openalex.org/W2372323577","https://openalex.org/W2159231020"],"abstract_inverted_index":{"WikiSQL":[0,152],"is":[1,54,70],"a":[2],"newly":[3],"released":[4],"dataset":[5],"for":[6,59,75],"studying":[7],"the":[8,40,71,92,100,113,123,134,151],"natural":[9],"language":[10],"sequence":[11],"to":[12,84,120,132,146],"SQL":[13,17],"translation":[14,124],"problem.":[15],"The":[16,105],"queries":[18],"in":[19,103,118],"Wik-iSQL":[20],"are":[21],"simple:":[22],"Each":[23],"involves":[24],"one":[25],"relation":[26],"and":[27,79],"does":[28,81],"not":[29],"have":[30],"any":[31],"join":[32],"operation.":[33],"Despite":[34],"of":[35,39,94],"its":[36],"simplicity,":[37],"none":[38],"publicly":[41],"reported":[42],"structured":[43],"query":[44],"generation":[45],"models":[46],"can":[47,143],"achieve":[48,85],"an":[49],"accuracy":[50,72,87,149],"beyond":[51],"62%,":[52],"which":[53],"still":[55,73],"far":[56],"from":[57],"enough":[58],"practical":[60],"use.":[61],"In":[62],"this":[63],"paper,":[64],"we":[65,97,115],"ask":[66],"two":[67],"questions,":[68],"\"Why":[69],"low":[74],"such":[76],"simple":[77],"queries?\"":[78],"\"What":[80],"it":[82],"take":[83],"100%":[86],"on":[88,99,138,150],"WikiSQL?\"":[89],"To":[90],"limit":[91],"scope":[93],"our":[95],"study,":[96],"focus":[98],"WHERE":[101],"clause":[102],"SQL.":[104],"answers":[106],"will":[107,127],"help":[108],"us":[109],"gain":[110],"insights":[111],"about":[112],"directions":[114],"should":[116],"explore":[117],"order":[119],"further":[121],"improve":[122],"accuracy.":[125],"We":[126],"then":[128],"investigate":[129],"alternative":[130],"solutions":[131],"realize":[133],"potential":[135],"ceiling":[136],"performance":[137],"WikiSQL.":[139],"Our":[140],"proposed":[141],"solution":[142],"reach":[144],"up":[145],"88.6%":[147],"condition":[148],"dataset.":[153]},"counts_by_year":[{"year":2026,"cited_by_count":2},{"year":2025,"cited_by_count":2},{"year":2023,"cited_by_count":3},{"year":2022,"cited_by_count":3},{"year":2021,"cited_by_count":6},{"year":2020,"cited_by_count":7},{"year":2019,"cited_by_count":6}],"updated_date":"2026-07-14T23:27:15.235271","created_date":"2025-10-10T00:00:00"}