{"id":"https://openalex.org/W2992316751","doi":"https://doi.org/10.1109/kse.2019.8919393","title":"Learning to Transform Vietnamese Natural Language Queries into SQL Commands","display_name":"Learning to Transform Vietnamese Natural Language Queries into SQL Commands","publication_year":2019,"publication_date":"2019-10-01","ids":{"openalex":"https://openalex.org/W2992316751","doi":"https://doi.org/10.1109/kse.2019.8919393","mag":"2992316751"},"language":"en","primary_location":{"id":"doi:10.1109/kse.2019.8919393","is_oa":false,"landing_page_url":"https://doi.org/10.1109/kse.2019.8919393","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2019 11th International Conference on Knowledge and Systems Engineering (KSE)","raw_type":"proceedings-article"},"type":"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/A5081773521","display_name":"Thi-Hai-Yen Vuong","orcid":"https://orcid.org/0000-0002-8019-7178"},"institutions":[{"id":"https://openalex.org/I177233841","display_name":"Vietnam National University, Hanoi","ror":"https://ror.org/02jmfj006","country_code":"VN","type":"education","lineage":["https://openalex.org/I177233841"]}],"countries":["VN"],"is_corresponding":true,"raw_author_name":"Thi-Hai-Yen Vuong","raw_affiliation_strings":["University of Engineering & Technology, Vietnam National University, Hanoi, Vietnam"],"affiliations":[{"raw_affiliation_string":"University of Engineering & Technology, Vietnam National University, Hanoi, Vietnam","institution_ids":["https://openalex.org/I177233841"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5082539218","display_name":"Thi-Thu-Trang Nguyen","orcid":null},"institutions":[{"id":"https://openalex.org/I177233841","display_name":"Vietnam National University, Hanoi","ror":"https://ror.org/02jmfj006","country_code":"VN","type":"education","lineage":["https://openalex.org/I177233841"]}],"countries":["VN"],"is_corresponding":false,"raw_author_name":"Thi-Thu-Trang Nguyen","raw_affiliation_strings":["University of Engineering & Technology, Vietnam National University, Hanoi, Vietnam"],"affiliations":[{"raw_affiliation_string":"University of Engineering & Technology, Vietnam National University, Hanoi, Vietnam","institution_ids":["https://openalex.org/I177233841"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5027096970","display_name":"Nhu-Thuat Tran","orcid":"https://orcid.org/0000-0001-5496-6749"},"institutions":[{"id":"https://openalex.org/I177233841","display_name":"Vietnam National University, Hanoi","ror":"https://ror.org/02jmfj006","country_code":"VN","type":"education","lineage":["https://openalex.org/I177233841"]}],"countries":["VN"],"is_corresponding":false,"raw_author_name":"Nhu-Thuat Tran","raw_affiliation_strings":["University of Engineering & Technology, Vietnam National University, Hanoi, Vietnam"],"affiliations":[{"raw_affiliation_string":"University of Engineering & Technology, Vietnam National University, Hanoi, Vietnam","institution_ids":["https://openalex.org/I177233841"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5077641909","display_name":"Le-Minh Nguyen","orcid":"https://orcid.org/0000-0002-2265-1010"},"institutions":[{"id":"https://openalex.org/I177233841","display_name":"Vietnam National University, Hanoi","ror":"https://ror.org/02jmfj006","country_code":"VN","type":"education","lineage":["https://openalex.org/I177233841"]}],"countries":["VN"],"is_corresponding":false,"raw_author_name":"Le-Minh Nguyen","raw_affiliation_strings":["University of Engineering & Technology, Vietnam National University, Hanoi, Vietnam"],"affiliations":[{"raw_affiliation_string":"University of Engineering & Technology, Vietnam National University, Hanoi, Vietnam","institution_ids":["https://openalex.org/I177233841"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5012773199","display_name":"Xuan-Hieu Phan","orcid":"https://orcid.org/0000-0002-7640-9190"},"institutions":[{"id":"https://openalex.org/I177233841","display_name":"Vietnam National University, Hanoi","ror":"https://ror.org/02jmfj006","country_code":"VN","type":"education","lineage":["https://openalex.org/I177233841"]}],"countries":["VN"],"is_corresponding":false,"raw_author_name":"Xuan-Hieu Phan","raw_affiliation_strings":["University of Engineering & Technology, Vietnam National University, Hanoi, Vietnam"],"affiliations":[{"raw_affiliation_string":"University of Engineering & Technology, Vietnam National University, Hanoi, Vietnam","institution_ids":["https://openalex.org/I177233841"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5081773521"],"corresponding_institution_ids":["https://openalex.org/I177233841"],"apc_list":null,"apc_paid":null,"fwci":0.28,"has_fulltext":false,"cited_by_count":5,"citation_normalized_percentile":{"value":0.66999872,"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":"1","last_page":"5"},"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.9994999766349792,"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/T11550","display_name":"Text and Document Classification Technologies","score":0.9872999787330627,"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.8959545493125916},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7651667594909668},{"id":"https://openalex.org/keywords/data-definition-language","display_name":"Data definition language","score":0.7059230208396912},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.6447560787200928},{"id":"https://openalex.org/keywords/stored-procedure","display_name":"Stored procedure","score":0.5581659078598022},{"id":"https://openalex.org/keywords/natural-language","display_name":"Natural language","score":0.5266692042350769},{"id":"https://openalex.org/keywords/natural-language-processing","display_name":"Natural language processing","score":0.5245205163955688},{"id":"https://openalex.org/keywords/data-control-language","display_name":"Data control language","score":0.4683235287666321},{"id":"https://openalex.org/keywords/language-integrated-query","display_name":"Language Integrated Query","score":0.4388953447341919},{"id":"https://openalex.org/keywords/data-manipulation-language","display_name":"Data manipulation language","score":0.4346574544906616},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.43371373414993286},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.4230212867259979},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.41594380140304565},{"id":"https://openalex.org/keywords/pl/sql","display_name":"PL/SQL","score":0.4105859398841858},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.4073909521102905},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.3178582787513733},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.08845189213752747}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8959545493125916},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7651667594909668},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.7059230208396912},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.6447560787200928},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.5581659078598022},{"id":"https://openalex.org/C195324797","wikidata":"https://www.wikidata.org/wiki/Q33742","display_name":"Natural language","level":2,"score":0.5266692042350769},{"id":"https://openalex.org/C204321447","wikidata":"https://www.wikidata.org/wiki/Q30642","display_name":"Natural language processing","level":1,"score":0.5245205163955688},{"id":"https://openalex.org/C32977378","wikidata":"https://www.wikidata.org/wiki/Q604737","display_name":"Data control language","level":5,"score":0.4683235287666321},{"id":"https://openalex.org/C179531526","wikidata":"https://www.wikidata.org/wiki/Q595637","display_name":"Language Integrated Query","level":5,"score":0.4388953447341919},{"id":"https://openalex.org/C56288433","wikidata":"https://www.wikidata.org/wiki/Q58673","display_name":"Data manipulation language","level":2,"score":0.4346574544906616},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.43371373414993286},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.4230212867259979},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.41594380140304565},{"id":"https://openalex.org/C32145003","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"PL/SQL","level":5,"score":0.4105859398841858},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.4073909521102905},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3178582787513733},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.08845189213752747},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/kse.2019.8919393","is_oa":false,"landing_page_url":"https://doi.org/10.1109/kse.2019.8919393","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2019 11th International Conference on Knowledge and Systems Engineering (KSE)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.75,"display_name":"Quality Education","id":"https://metadata.un.org/sdg/4"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":24,"referenced_works":["https://openalex.org/W1494362579","https://openalex.org/W1976174404","https://openalex.org/W2007321142","https://openalex.org/W2101964891","https://openalex.org/W2147880316","https://openalex.org/W2154268919","https://openalex.org/W2250701144","https://openalex.org/W2611818442","https://openalex.org/W2626990892","https://openalex.org/W2751448157","https://openalex.org/W2762513422","https://openalex.org/W2768409085","https://openalex.org/W2941519458","https://openalex.org/W2962713807","https://openalex.org/W2963794306","https://openalex.org/W2963899988","https://openalex.org/W2964271186","https://openalex.org/W4239510810","https://openalex.org/W4299674251","https://openalex.org/W6682082992","https://openalex.org/W6691843663","https://openalex.org/W6730791392","https://openalex.org/W6743367031","https://openalex.org/W6745921949"],"related_works":["https://openalex.org/W4386768611","https://openalex.org/W1890845846","https://openalex.org/W633210651","https://openalex.org/W154011653","https://openalex.org/W2750425440","https://openalex.org/W621362137","https://openalex.org/W106036922","https://openalex.org/W218121808","https://openalex.org/W1003534662","https://openalex.org/W4362499450"],"abstract_inverted_index":{"In":[0,86,108],"the":[1,33,104,111],"field":[2],"of":[3,22,59,171,186],"data":[4,10,25,55],"management,":[5],"users":[6],"traditionally":[7],"manipulates":[8],"their":[9,54],"using":[11,39,162],"structured":[12],"query":[13],"language":[14,71,82,101,173],"(SQL).":[15],"However,":[16],"this":[17,87],"method":[18,161],"requires":[19],"an":[20,156,183],"understanding":[21],"relational":[23],"database,":[24],"schema,":[26],"and":[27,61,84,98,177],"SQL":[28,74,106,122],"syntax":[29],"as":[30,32,124,146],"well":[31],"way":[34],"it":[35],"works.":[36],"Database":[37],"manipulation":[38],"natural":[40,70,81,100,172],"language,":[41],"therefore,":[42],"is":[43,76,114,134],"much":[44],"more":[45,187],"convenient":[46],"since":[47],"any":[48],"normal":[49],"user":[50],"can":[51],"interact":[52],"with":[53,182],"without":[56],"a":[57,77,91,168],"background":[58],"database":[60],"SQL.":[62],"This":[63],"is,":[64],"however,":[65],"really":[66],"tough":[67],"because":[68],"transforming":[69],"commands":[72],"into":[73,103],"queries":[75,102,174],"challenging":[78],"task":[79],"in":[80,121,175],"processing":[83],"understanding.":[85],"paper,":[88],"we":[89],"propose":[90],"novel":[92],"two-phase":[93],"approach":[94],"to":[95],"automatically":[96],"analyzing":[97],"converting":[99],"corresponding":[105],"forms.":[107],"our":[109,160],"approach,":[110],"first":[112],"phase":[113,133],"component":[115],"segmentation":[116],"which":[117],"identifies":[118],"primary":[119,143],"clauses":[120],"such":[123,145],"SELECT,":[125],"FROM,":[126],"WHERE,":[127],"ORDER":[128],"BY,":[129],"etc.":[130,152],"The":[131],"second":[132],"slot-":[135],"filling":[136],"that":[137],"helps":[138],"extract":[139],"sub-components":[140],"for":[141,159],"each":[142],"clause":[144],"SELECT":[147,149],"column(s),":[148],"aggregation":[150],"operation,":[151],"We":[153],"carefully":[154],"conducted":[155],"empirical":[157],"evaluation":[158],"conditional":[163],"random":[164],"fields":[165],"(CRFs)":[166],"on":[167],"medium-sized":[169],"corpus":[170],"Vietnamese,":[176],"have":[178],"achieved":[179],"promising":[180],"results":[181],"average":[184],"accuracy":[185],"than":[188],"90%.":[189]},"counts_by_year":[{"year":2024,"cited_by_count":2},{"year":2023,"cited_by_count":1},{"year":2021,"cited_by_count":1},{"year":2020,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}