VNU-UET Repository

Learning to Transform Vietnamese Natural Language Queries into SQL Commands

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.

Full text not available from this repository.


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%.

Item Type: Conference or Workshop Item (Paper)
Subjects: Information Technology (IT)
Divisions: Faculty of Information Technology (FIT)
Depositing User: A/Prof. Xuan Hieu Phan
Date Deposited: 28 Nov 2019 11:23
Last Modified: 28 Nov 2019 11:23

Actions (login required)

View Item View Item