{"id":"https://openalex.org/W2963993485","doi":"https://doi.org/10.24963/ijcai.2018/553","title":"An Encoder-Decoder Framework Translating Natural Language to Database Queries","display_name":"An Encoder-Decoder Framework Translating Natural Language to Database Queries","publication_year":2018,"publication_date":"2018-07-01","ids":{"openalex":"https://openalex.org/W2963993485","doi":"https://doi.org/10.24963/ijcai.2018/553","mag":"2963993485"},"language":"en","primary_location":{"id":"doi:10.24963/ijcai.2018/553","is_oa":true,"landing_page_url":"https://doi.org/10.24963/ijcai.2018/553","pdf_url":"https://www.ijcai.org/proceedings/2018/0553.pdf","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the Twenty-Seventh International Joint Conference on Artificial Intelligence","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://www.ijcai.org/proceedings/2018/0553.pdf","any_repository_has_fulltext":null},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5076948208","display_name":"Ruichu Cai","orcid":"https://orcid.org/0000-0001-8972-167X"},"institutions":[{"id":"https://openalex.org/I139024713","display_name":"Guangdong University of Technology","ror":"https://ror.org/04azbjn80","country_code":"CN","type":"education","lineage":["https://openalex.org/I139024713"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Ruichu Cai","raw_affiliation_strings":["Faculty of Computer, Guangdong University of Technology, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Faculty of Computer, Guangdong University of Technology, China","institution_ids":["https://openalex.org/I139024713"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5034536387","display_name":"Boyan Xu","orcid":"https://orcid.org/0000-0003-1327-4740"},"institutions":[{"id":"https://openalex.org/I139024713","display_name":"Guangdong University of Technology","ror":"https://ror.org/04azbjn80","country_code":"CN","type":"education","lineage":["https://openalex.org/I139024713"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Boyan Xu","raw_affiliation_strings":["Faculty of Computer, Guangdong University of Technology, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Faculty of Computer, Guangdong University of Technology, China","institution_ids":["https://openalex.org/I139024713"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100633293","display_name":"Zhenjie Zhang","orcid":"https://orcid.org/0000-0003-1079-8784"},"institutions":[{"id":"https://openalex.org/I168639165","display_name":"Singapore Institute of Technology","ror":"https://ror.org/01v2c2791","country_code":"SG","type":"education","lineage":["https://openalex.org/I168639165"]}],"countries":["SG"],"is_corresponding":false,"raw_author_name":"Zhenjie Zhang","raw_affiliation_strings":["Singapore R&D, Yitu Technology Ltd"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Singapore R&D, Yitu Technology Ltd","institution_ids":["https://openalex.org/I168639165"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101767360","display_name":"Xiaoyan Yang","orcid":"https://orcid.org/0000-0001-8546-3589"},"institutions":[{"id":"https://openalex.org/I168639165","display_name":"Singapore Institute of Technology","ror":"https://ror.org/01v2c2791","country_code":"SG","type":"education","lineage":["https://openalex.org/I168639165"]}],"countries":["SG"],"is_corresponding":false,"raw_author_name":"Xiaoyan Yang","raw_affiliation_strings":["Singapore R&D, Yitu Technology Ltd"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Singapore R&D, Yitu Technology Ltd","institution_ids":["https://openalex.org/I168639165"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100406497","display_name":"Zijian Li","orcid":"https://orcid.org/0000-0002-3964-3789"},"institutions":[{"id":"https://openalex.org/I139024713","display_name":"Guangdong University of Technology","ror":"https://ror.org/04azbjn80","country_code":"CN","type":"education","lineage":["https://openalex.org/I139024713"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Zijian Li","raw_affiliation_strings":["Faculty of Computer, Guangdong University of Technology, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Faculty of Computer, Guangdong University of Technology, China","institution_ids":["https://openalex.org/I139024713"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5036326490","display_name":"Zhihao Liang","orcid":"https://orcid.org/0000-0003-0485-9376"},"institutions":[{"id":"https://openalex.org/I139024713","display_name":"Guangdong University of Technology","ror":"https://ror.org/04azbjn80","country_code":"CN","type":"education","lineage":["https://openalex.org/I139024713"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Zhihao Liang","raw_affiliation_strings":["Faculty of Computer, Guangdong University of Technology, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Faculty of Computer, Guangdong University of Technology, China","institution_ids":["https://openalex.org/I139024713"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":6,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":4.0549,"has_fulltext":false,"cited_by_count":51,"citation_normalized_percentile":{"value":0.95132484,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":94,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"3977","last_page":"3983"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10181","display_name":"Natural Language Processing Techniques","score":0.9998999834060669,"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.9998999834060669,"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.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/T10215","display_name":"Semantic Web and Ontologies","score":0.9948999881744385,"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.9086916446685791},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7595075368881226},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.6686728000640869},{"id":"https://openalex.org/keywords/natural-language-processing","display_name":"Natural language processing","score":0.5970805287361145},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.5118042826652527},{"id":"https://openalex.org/keywords/natural-language","display_name":"Natural language","score":0.4960270822048187},{"id":"https://openalex.org/keywords/machine-translation","display_name":"Machine translation","score":0.4822429120540619},{"id":"https://openalex.org/keywords/convolutional-neural-network","display_name":"Convolutional neural network","score":0.46886900067329407},{"id":"https://openalex.org/keywords/compiler","display_name":"Compiler","score":0.4667739272117615},{"id":"https://openalex.org/keywords/semantics","display_name":"Semantics (computer science)","score":0.4503001272678375},{"id":"https://openalex.org/keywords/grammar","display_name":"Grammar","score":0.4220598042011261},{"id":"https://openalex.org/keywords/deep-learning","display_name":"Deep learning","score":0.41136878728866577}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.9086916446685791},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7595075368881226},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.6686728000640869},{"id":"https://openalex.org/C204321447","wikidata":"https://www.wikidata.org/wiki/Q30642","display_name":"Natural language processing","level":1,"score":0.5970805287361145},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.5118042826652527},{"id":"https://openalex.org/C195324797","wikidata":"https://www.wikidata.org/wiki/Q33742","display_name":"Natural language","level":2,"score":0.4960270822048187},{"id":"https://openalex.org/C203005215","wikidata":"https://www.wikidata.org/wiki/Q79798","display_name":"Machine translation","level":2,"score":0.4822429120540619},{"id":"https://openalex.org/C81363708","wikidata":"https://www.wikidata.org/wiki/Q17084460","display_name":"Convolutional neural network","level":2,"score":0.46886900067329407},{"id":"https://openalex.org/C169590947","wikidata":"https://www.wikidata.org/wiki/Q47506","display_name":"Compiler","level":2,"score":0.4667739272117615},{"id":"https://openalex.org/C184337299","wikidata":"https://www.wikidata.org/wiki/Q1437428","display_name":"Semantics (computer science)","level":2,"score":0.4503001272678375},{"id":"https://openalex.org/C26022165","wikidata":"https://www.wikidata.org/wiki/Q8091","display_name":"Grammar","level":2,"score":0.4220598042011261},{"id":"https://openalex.org/C108583219","wikidata":"https://www.wikidata.org/wiki/Q197536","display_name":"Deep learning","level":2,"score":0.41136878728866577},{"id":"https://openalex.org/C41895202","wikidata":"https://www.wikidata.org/wiki/Q8162","display_name":"Linguistics","level":1,"score":0.0},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.24963/ijcai.2018/553","is_oa":true,"landing_page_url":"https://doi.org/10.24963/ijcai.2018/553","pdf_url":"https://www.ijcai.org/proceedings/2018/0553.pdf","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the Twenty-Seventh International Joint Conference on Artificial Intelligence","raw_type":"proceedings-article"}],"best_oa_location":{"id":"doi:10.24963/ijcai.2018/553","is_oa":true,"landing_page_url":"https://doi.org/10.24963/ijcai.2018/553","pdf_url":"https://www.ijcai.org/proceedings/2018/0553.pdf","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the Twenty-Seventh International Joint Conference on Artificial Intelligence","raw_type":"proceedings-article"},"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/4","score":0.7099999785423279,"display_name":"Quality Education"}],"awards":[{"id":"https://openalex.org/G3555622924","display_name":"\u9762\u5411\u591a\u89c6\u89d2\u591a\u6807\u7b7e\u6570\u636e\u7684\u652f\u6301\u5f20\u91cf\u673a\u5206\u7c7b\u7b97\u6cd5\u7814\u7a76","funder_award_id":"61472089","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G4314879914","display_name":null,"funder_award_id":"2014A030308008","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G5437744706","display_name":null,"funder_award_id":"2015B010131015","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G5813347349","display_name":null,"funder_award_id":"2014A030306004, 2014A030308008","funder_id":"https://openalex.org/F4320321921","funder_display_name":"Natural Science Foundation of Guangdong Province"},{"id":"https://openalex.org/G7243720383","display_name":null,"funder_award_id":"U1501254","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G7393361838","display_name":null,"funder_award_id":"2014A030306004","funder_id":"https://openalex.org/F4320321921","funder_display_name":"Natural Science Foundation of Guangdong Province"},{"id":"https://openalex.org/G8982061459","display_name":null,"funder_award_id":"2014A030308008","funder_id":"https://openalex.org/F4320321921","funder_display_name":"Natural Science Foundation of Guangdong Province"}],"funders":[{"id":"https://openalex.org/F4320312066","display_name":"Advanced Digital Sciences Center","ror":"https://ror.org/01xaqx887"},{"id":"https://openalex.org/F4320321001","display_name":"National Natural Science Foundation of China","ror":"https://ror.org/01h0zpd94"},{"id":"https://openalex.org/F4320321921","display_name":"Natural Science Foundation of Guangdong Province","ror":null}],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2963993485.pdf","grobid_xml":"https://content.openalex.org/works/W2963993485.grobid-xml"},"referenced_works_count":23,"referenced_works":["https://openalex.org/W1975258157","https://openalex.org/W2130942839","https://openalex.org/W2147880316","https://openalex.org/W2157331557","https://openalex.org/W2250701144","https://openalex.org/W2269738476","https://openalex.org/W2307268612","https://openalex.org/W2525778437","https://openalex.org/W2546950329","https://openalex.org/W2613904329","https://openalex.org/W2962728167","https://openalex.org/W2963372003","https://openalex.org/W2963655793","https://openalex.org/W2963794306","https://openalex.org/W2963991316","https://openalex.org/W2964186869","https://openalex.org/W2964224049","https://openalex.org/W2964271186","https://openalex.org/W4236265809","https://openalex.org/W4246375690","https://openalex.org/W4294170691","https://openalex.org/W4295017198","https://openalex.org/W4299674251"],"related_works":["https://openalex.org/W4240253816","https://openalex.org/W3096456556","https://openalex.org/W2169584677","https://openalex.org/W2979513934","https://openalex.org/W4232954277","https://openalex.org/W2020341030","https://openalex.org/W2749133591","https://openalex.org/W2367473450","https://openalex.org/W23346600","https://openalex.org/W2159231020"],"abstract_inverted_index":{"Machine":[0],"translation":[1,37,85],"is":[2,87],"going":[3],"through":[4],"a":[5,32,98,103,173],"radical":[6],"revolution,":[7],"driven":[8],"by":[9,172],"the":[10,61,71,77,84,91,114,120,135,150],"explosive":[11],"development":[12],"of":[13,64,76,94,105,122,143],"deep":[14],"learning":[15],"techniques":[16,133],"using":[17],"Convolutional":[18],"Neural":[19,24],"Network":[20,25],"(CNN)":[21],"and":[22,58,73,148,163],"Recurrent":[23],"(RNN).":[26],"In":[27],"this":[28],"paper,":[29],"we":[30],"consider":[31],"special":[33],"case":[34],"in":[35,145],"machine":[36],"problems,":[38],"targeting":[39],"to":[40],"convert":[41],"natural":[42,146],"language":[43,147],"into":[44,113,119],"Structured":[45],"Query":[46],"Language":[47],"(SQL)":[48],"for":[49,130],"data":[50],"retrieval":[51],"over":[52],"relational":[53],"database.":[54],"Although":[55],"generic":[56],"CNN":[57],"RNN":[59],"learn":[60],"grammar":[62,92,154],"structure":[63],"SQL":[65,153],"when":[66,83],"trained":[67],"with":[68,90,102],"sufficient":[69],"samples,":[70],"accuracy":[72],"training":[74],"efficiency":[75],"model":[78,86],"could":[79],"be":[80],"dramatically":[81],"improved,":[82],"deeply":[88],"integrated":[89],"rules":[93],"SQL.":[95],"We":[96],"present":[97],"new":[99,106,109],"encoder-decoder":[100],"framework,":[101],"suite":[104],"approaches,":[107],"including":[108],"semantic":[110],"features":[111],"fed":[112],"encoder,":[115],"grammar-aware":[116],"states":[117],"injected":[118],"memory":[121],"decoder,":[123],"as":[124,126],"well":[125],"recursive":[127],"state":[128],"management":[129],"sub-queries.":[131],"These":[132],"help":[134],"neural":[136],"network":[137],"better":[138],"focus":[139],"on":[140,152,159],"understanding":[141],"semantics":[142],"operations":[144],"save":[149],"efforts":[151],"learning.":[155],"The":[156],"empirical":[157],"evaluation":[158],"real":[160],"world":[161],"database":[162],"queries":[164],"show":[165],"that":[166],"our":[167],"approach":[168],"outperform":[169],"state-of-the-art":[170],"solution":[171],"significant":[174],"margin.":[175]},"counts_by_year":[{"year":2026,"cited_by_count":3},{"year":2025,"cited_by_count":6},{"year":2024,"cited_by_count":2},{"year":2023,"cited_by_count":10},{"year":2022,"cited_by_count":6},{"year":2021,"cited_by_count":7},{"year":2020,"cited_by_count":8},{"year":2019,"cited_by_count":7},{"year":2018,"cited_by_count":2}],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}