A CNN-based Column Prediction Model for Generating SQL Queries using Natural Language 


Vol. 46,  No. 2, pp. 202-207, Feb.  2019
10.5626/JOK.2019.46.2.202


PDF

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


  Statistics
Cumulative Counts from November, 2022
Multiple requests among the same browser session are counted as one view. If you mouse over a chart, the values of data points will be shown.


  Cite this article

[IEEE Style]

Y. Jeong, D. Kim, J. Lee, "A CNN-based Column Prediction Model for Generating SQL Queries using Natural Language," Journal of KIISE, JOK, vol. 46, no. 2, pp. 202-207, 2019. DOI: 10.5626/JOK.2019.46.2.202.


[ACM Style]

Yoonki Jeong, Dongmin Kim, and Jongwuk Lee. 2019. A CNN-based Column Prediction Model for Generating SQL Queries using Natural Language. Journal of KIISE, JOK, 46, 2, (2019), 202-207. DOI: 10.5626/JOK.2019.46.2.202.


[KCI Style]

정윤기, 김동민, 이종욱, "자연어를 활용한 SQL문 생성을 위한 합성곱 신경망 기반 칼럼 예측 모델," 한국정보과학회 논문지, 제46권, 제2호, 202~207쪽, 2019. DOI: 10.5626/JOK.2019.46.2.202.


[Endnote/Zotero/Mendeley (RIS)]  Download


[BibTeX]  Download



Search




Journal of KIISE

  • ISSN : 2383-630X(Print)
  • ISSN : 2383-6296(Electronic)
  • KCI Accredited Journal

Editorial Office

  • Tel. +82-2-588-9240
  • Fax. +82-2-521-1352
  • E-mail. chwoo@kiise.or.kr