relation: https://eprints.uet.vnu.edu.vn/eprints/id/eprint/3663/
title: Learning to Transform Vietnamese Natural Language Queries into SQL Commands
creator: Vuong, Thi Hai Yen
creator: Nguyen, Thi Thu Trang
creator: Tran, Nhu Thuat
creator: Nguyen, Le Minh
creator: Phan, Xuan Hieu
subject: Information Technology (IT)
description: 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
type: Conference or Workshop Item
type: PeerReviewed
identifier:   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.