eprintid: 3663
rev_number: 8
eprint_status: archive
userid: 290
dir: disk0/00/00/36/63
datestamp: 2019-11-28 11:23:55
lastmod: 2019-11-28 11:23:55
status_changed: 2019-11-28 11:23:55
type: conference_item
metadata_visibility: show
creators_name: Vuong, Thi Hai Yen
creators_name: Nguyen, Thi Thu Trang
creators_name: Tran, Nhu Thuat
creators_name: Nguyen, Le Minh
creators_name: Phan, Xuan Hieu
creators_id: yenvth_57@vnu.edu.vn
creators_id: thuattn@vnu.edu.vn
creators_id: hieupx@vnu.edu.vn
title: Learning to Transform Vietnamese Natural Language Queries into SQL Commands
ispublished: pub
subjects: IT
divisions: fac_fit
abstract: In the field of data management, users traditionally manipulates their data using structured query language (SQL). However, this method requires an understanding of relational database, data schema, and SQL syntax as well as the way it works. Database manipulation using natural language, therefore, is much more convenient since any normal user can interact with their data without a background of database and SQL. This is, however, really tough because transforming natural language commands into SQL queries is a challenging task in natural language processing and understanding. In this paper, we propose a novel two–phase approach to automatically analyzing and converting natural language queries into the corresponding SQL forms. In our approach, the first phase is component segmenta- tion which identifies primary clauses in SQL such as SELECT, FROM, WHERE, ORDER BY, etc. The second phase is slot– filling that helps extract sub–components for each primary clause such as SELECT column(s), SELECT aggregation operation, etc. We carefully conducted an empirical evaluation for our method using conditional random fields (CRFs) on a medium– sized corpus of natural language queries in Vietnamese, and have achieved promising results with an average accuracy of more than 90%.
date: 2019-10-24
date_type: published
full_text_status: none
pres_type: paper
event_title: The 11th International Conference on Knowledge and Systems Engineering (KSE 2019)
event_location: Da Nang, Vietnam
event_dates: October 24-26, 2019
event_type: conference
refereed: TRUE
citation:   Vuong, Thi Hai Yen and Nguyen, Thi Thu Trang and Tran, Nhu Thuat and Nguyen, Le Minh and Phan, Xuan Hieu  (2019) Learning to Transform Vietnamese Natural Language Queries into SQL Commands.  In: The 11th International Conference on Knowledge and Systems Engineering (KSE 2019), October 24-26, 2019, Da Nang, Vietnam.