{"id":"https://openalex.org/W3046744391","doi":"https://doi.org/10.14778/3401960.3401970","title":"Natural language to SQL","display_name":"Natural language to SQL","publication_year":2020,"publication_date":"2020-06-01","ids":{"openalex":"https://openalex.org/W3046744391","doi":"https://doi.org/10.14778/3401960.3401970","mag":"3046744391"},"language":"en","primary_location":{"is_oa":false,"landing_page_url":"https://doi.org/10.14778/3401960.3401970","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_indexed_in_scopus":true,"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":null,"is_accepted":false,"is_published":false},"type":"article","type_crossref":"journal-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/A5101856648","display_name":"Hyeonji Kim","orcid":"https://orcid.org/0000-0002-6923-6113"},"institutions":[{"id":"https://openalex.org/I2799891827","display_name":"Korea Post","ror":"https://ror.org/00p45d091","country_code":"KR","type":"government","lineage":["https://openalex.org/I2799891827","https://openalex.org/I2801339556","https://openalex.org/I4387152098"]},{"id":"https://openalex.org/I123900574","display_name":"Pohang University of Science and Technology","ror":"https://ror.org/04xysgw12","country_code":"KR","type":"funder","lineage":["https://openalex.org/I123900574"]}],"countries":["KR"],"is_corresponding":false,"raw_author_name":"Hyeonji Kim","raw_affiliation_strings":["POSTECH, Korea"],"affiliations":[{"raw_affiliation_string":"POSTECH, Korea","institution_ids":["https://openalex.org/I2799891827","https://openalex.org/I123900574"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5052953840","display_name":"Byeong-Hoon So","orcid":null},"institutions":[{"id":"https://openalex.org/I123900574","display_name":"Pohang University of Science and Technology","ror":"https://ror.org/04xysgw12","country_code":"KR","type":"funder","lineage":["https://openalex.org/I123900574"]},{"id":"https://openalex.org/I2799891827","display_name":"Korea Post","ror":"https://ror.org/00p45d091","country_code":"KR","type":"government","lineage":["https://openalex.org/I2799891827","https://openalex.org/I2801339556","https://openalex.org/I4387152098"]}],"countries":["KR"],"is_corresponding":false,"raw_author_name":"Byeong-Hoon So","raw_affiliation_strings":["POSTECH, Korea"],"affiliations":[{"raw_affiliation_string":"POSTECH, Korea","institution_ids":["https://openalex.org/I123900574","https://openalex.org/I2799891827"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5035744252","display_name":"Wook-Shin Han","orcid":"https://orcid.org/0000-0001-9206-9563"},"institutions":[{"id":"https://openalex.org/I2799891827","display_name":"Korea Post","ror":"https://ror.org/00p45d091","country_code":"KR","type":"government","lineage":["https://openalex.org/I2799891827","https://openalex.org/I2801339556","https://openalex.org/I4387152098"]},{"id":"https://openalex.org/I123900574","display_name":"Pohang University of Science and Technology","ror":"https://ror.org/04xysgw12","country_code":"KR","type":"funder","lineage":["https://openalex.org/I123900574"]}],"countries":["KR"],"is_corresponding":false,"raw_author_name":"Wook-Shin Han","raw_affiliation_strings":["POSTECH, Korea"],"affiliations":[{"raw_affiliation_string":"POSTECH, Korea","institution_ids":["https://openalex.org/I2799891827","https://openalex.org/I123900574"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5081157085","display_name":"Hongrae Lee","orcid":null},"institutions":[{"id":"https://openalex.org/I1291425158","display_name":"Google (United States)","ror":"https://ror.org/00njsd438","country_code":"US","type":"funder","lineage":["https://openalex.org/I1291425158","https://openalex.org/I4210128969"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Hongrae Lee","raw_affiliation_strings":["Google"],"affiliations":[{"raw_affiliation_string":"Google","institution_ids":["https://openalex.org/I1291425158"]}]}],"institution_assertions":[],"countries_distinct_count":2,"institutions_distinct_count":3,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":6.14,"has_fulltext":false,"cited_by_count":74,"citation_normalized_percentile":{"value":0.999974,"is_in_top_1_percent":true,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":98,"max":99},"biblio":{"volume":"13","issue":"10","first_page":"1737","last_page":"1750"},"is_retracted":false,"is_paratext":false,"primary_topic":{"id":"https://openalex.org/T10028","display_name":"Topic Modeling","score":0.997,"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/T10028","display_name":"Topic Modeling","score":0.997,"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/T10181","display_name":"Natural Language Processing Techniques","score":0.994,"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/T10260","display_name":"Software Engineering Research","score":0.9815,"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/benchmark","display_name":"Benchmark (surveying)","score":0.4823396}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.84894466},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.4947023},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.48262104},{"id":"https://openalex.org/C185798385","wikidata":"https://www.wikidata.org/wiki/Q1161707","display_name":"Benchmark (surveying)","level":2,"score":0.4823396},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.4704244},{"id":"https://openalex.org/C2779343474","wikidata":"https://www.wikidata.org/wiki/Q3109175","display_name":"Context (archaeology)","level":2,"score":0.43875045},{"id":"https://openalex.org/C58642233","wikidata":"https://www.wikidata.org/wiki/Q8269924","display_name":"Taxonomy (biology)","level":2,"score":0.4138942},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.402144},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.22359666},{"id":"https://openalex.org/C151730666","wikidata":"https://www.wikidata.org/wiki/Q7205","display_name":"Paleontology","level":1,"score":0.0},{"id":"https://openalex.org/C59822182","wikidata":"https://www.wikidata.org/wiki/Q441","display_name":"Botany","level":1,"score":0.0},{"id":"https://openalex.org/C38652104","wikidata":"https://www.wikidata.org/wiki/Q3510521","display_name":"Computer security","level":1,"score":0.0},{"id":"https://openalex.org/C13280743","wikidata":"https://www.wikidata.org/wiki/Q131089","display_name":"Geodesy","level":1,"score":0.0},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0},{"id":"https://openalex.org/C205649164","wikidata":"https://www.wikidata.org/wiki/Q1071","display_name":"Geography","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"is_oa":false,"landing_page_url":"https://doi.org/10.14778/3401960.3401970","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_indexed_in_scopus":true,"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":null,"is_accepted":false,"is_published":false}],"best_oa_location":null,"sustainable_development_goals":[],"grants":[],"datasets":[],"versions":[],"referenced_works_count":61,"referenced_works":["https://openalex.org/W1885389775","https://openalex.org/W2016589492","https://openalex.org/W2047237057","https://openalex.org/W2081580037","https://openalex.org/W2091671846","https://openalex.org/W2101964891","https://openalex.org/W2107878631","https://openalex.org/W2111742432","https://openalex.org/W2153710242","https://openalex.org/W2154268919","https://openalex.org/W2159934185","https://openalex.org/W2163274265","https://openalex.org/W2164155814","https://openalex.org/W2165382777","https://openalex.org/W2250701144","https://openalex.org/W2251044566","https://openalex.org/W2269738476","https://openalex.org/W2333611780","https://openalex.org/W2507756961","https://openalex.org/W2511108736","https://openalex.org/W2536574992","https://openalex.org/W2584709123","https://openalex.org/W2597655663","https://openalex.org/W2605887895","https://openalex.org/W2610301736","https://openalex.org/W2611818442","https://openalex.org/W2740841986","https://openalex.org/W2751448157","https://openalex.org/W2762513422","https://openalex.org/W2768409085","https://openalex.org/W2773790959","https://openalex.org/W2791666059","https://openalex.org/W2798315459","https://openalex.org/W2798663534","https://openalex.org/W2798753108","https://openalex.org/W2799042489","https://openalex.org/W2890431379","https://openalex.org/W2891691255","https://openalex.org/W2914913241","https://openalex.org/W2945102109","https://openalex.org/W2945290078","https://openalex.org/W2950133940","https://openalex.org/W2950706223","https://openalex.org/W2950898568","https://openalex.org/W2951775809","https://openalex.org/W2952032096","https://openalex.org/W2952380375","https://openalex.org/W2952466824","https://openalex.org/W2962713807","https://openalex.org/W2962728167","https://openalex.org/W2963617989","https://openalex.org/W2963866663","https://openalex.org/W2963899988","https://openalex.org/W2964078224","https://openalex.org/W2964142859","https://openalex.org/W2964271186","https://openalex.org/W2964308564","https://openalex.org/W3104055253","https://openalex.org/W3105251181","https://openalex.org/W4236265809","https://openalex.org/W4301356317"],"related_works":["https://openalex.org/W972276598","https://openalex.org/W4321353415","https://openalex.org/W4246352526","https://openalex.org/W2745001401","https://openalex.org/W2378211422","https://openalex.org/W2130974462","https://openalex.org/W2121910908","https://openalex.org/W2087343574","https://openalex.org/W2086519370","https://openalex.org/W2028665553"],"abstract_inverted_index":{"Translating":[0],"natural":[1],"language":[2],"to":[3,46],"SQL":[4],"(NL2SQL)":[5],"has":[6],"received":[7],"extensive":[8,122,169],"attention":[9],"lately,":[10],"especially":[11],"with":[12],"the":[13,22,74,97,162,200],"recent":[14,131,149],"success":[15],"of":[16,25,34,81,99,113,130,148,155,161],"deep":[17],"learning":[18],"technologies.":[19],"However,":[20],"despite":[21],"large":[23],"number":[24],"studies,":[26],"we":[27,120],"do":[28,93],"not":[29,94],"have":[30,63],"a":[31,79,110,137,145,153,174],"thorough":[32],"understanding":[33],"how":[35,42],"good":[36],"existing":[37],"techniques":[38,132],"really":[39],"are":[40,56,70,84,89],"and":[41,67,92,116,141,164,189],"much":[43],"is":[44,52],"applicable":[45],"real-world":[47],"situations.":[48],"A":[49],"key":[50],"difficulty":[51],"that":[53,69,199],"different":[54,59],"studies":[55],"based":[57],"on":[58],"datasets,":[60],"which":[61],"often":[62],"their":[64],"own":[65],"limitations":[66],"assumptions":[68,160],"implicitly":[71],"hidden":[72],"in":[73,105,205],"context":[75],"or":[76],"datasets.":[77],"Moreover,":[78],"couple":[80],"evaluation":[82],"metrics":[83],"commonly":[85],"employed":[86],"but":[87],"they":[88],"rather":[90],"simplistic":[91],"properly":[95],"depict":[96],"accuracy":[98],"results,":[100],"as":[101,186],"will":[102],"be":[103,203],"shown":[104],"our":[106,125],"experiments.":[107,170],"To":[108],"provide":[109,144,173],"holistic":[111],"view":[112],"NL2SQL":[114,150],"technologies":[115,184],"access":[117],"current":[118],"advancements,":[119],"perform":[121],"experiments":[123],"under":[124],"unified":[126],"framework":[127],"using":[128,180],"eleven":[129],"over":[133],"10+":[134],"benchmarks":[135],"including":[136],"new":[138],"benchmark":[139],"(WTQ)":[140],"TPC-H.":[142],"We":[143,157,171,192],"comprehensive":[146],"survey":[147],"methods,":[151],"introducing":[152],"taxonomy":[154],"them.":[156],"reveal":[158],"major":[159],"methods":[163],"classify":[165],"translation":[166,201],"errors":[167],"through":[168],"also":[172],"practical":[175],"tool":[176],"for":[177],"validation":[178],"by":[179],"existing,":[181],"mature":[182],"database":[183,190],"such":[185],"query":[187],"rewrite":[188],"testing.":[191],"then":[193],"suggest":[194],"future":[195],"research":[196],"directions":[197],"so":[198],"can":[202],"used":[204],"practice.":[206]},"abstract_inverted_index_v3":null,"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W3046744391","counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":21},{"year":2023,"cited_by_count":21},{"year":2022,"cited_by_count":10},{"year":2021,"cited_by_count":18},{"year":2020,"cited_by_count":3}],"updated_date":"2025-03-18T21:11:33.962026","created_date":"2020-08-07"}