@article{M1B172863, title = "A CNN-based Column Prediction Model for Generating SQL Queries using Natural Language", journal = "Journal of KIISE, JOK", year = "2019", issn = "2383-630X", doi = "10.5626/JOK.2019.46.2.202", author = "Yoonki Jeong,Dongmin Kim,Jongwuk Lee", keywords = "RDBMS,natural language processing,convolutional neural networks", abstract = "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%." }