TY  - JOUR
T1  - A CNN-based Column Prediction Model for Generating SQL Queries using Natural Language
AU  - Jeong, Yoonki 
AU  - Kim, Dongmin 
AU  - Lee, Jongwuk 
JO  - Journal of KIISE, JOK
PY  - 2019
DA  - 2019/1/14
DO  - 10.5626/JOK.2019.46.2.202
KW  - RDBMS
KW  - natural language processing
KW  - convolutional neural networks
AB  - To retrieve massive data using relational database management system (RDBMS), it is important to understanding of table schemas and SQL grammar. To address this issue, many studies have recently been carried out to generate an SQL query from a natural language question. However, the existing works suffer mostly from predicting columns at where clause and the accuracy is greatly reduced when there are multiple columns to be predicted. In this paper, we propose a convolutional neural network model with column attention mechanism that effectively extracts the latent representation of input question which helps column prediction of the model. The experiment shows that our model outperforms the accuracy of the existing model (SQLNet) by 6%.