Structuring Natural Language to Query Language: A Review

Authors

  • B. Nethravathi Department of Information Science and Engineering, JSS Academy of Technical Education, Bangalore, India https://orcid.org/0000-0003-0340-7888
  • G. Amitha Department of Information Science and Engineering, JSS Academy of Technical Education, Bangalore, India
  • A. Saruka Department of Information Science and Engineering, JSS Academy of Technical Education, Bangalore, India
  • T. P. Bharath Department of Information Science and Engineering, JSS Academy of Technical Education, Bangalore, India
  • S. Suyagya Department of Information Science and Engineering, JSS Academy of Technical Education, Bangalore, India
Volume: 10 | Issue: 6 | Pages: 6521-6525 | December 2020 | https://doi.org/10.48084/etasr.3873

Abstract

SQL (Structured Query Language) is a structured language for specialized purposes used to communicate with the data stored in a database management system. It uses dynamic and sophisticated query commands for processing and controlling data in a database, which can become an obstacle for users with no previous experience. In order to address this constraint, we have analyzed the existing models in Natural Language Processing, which convert a native-language query into an SQL query. Thus, any novice user can use the SQL program and eliminate the need to generate any complex queries. This work is a detailed survey of the existing literature.

Keywords:

Structured Query Language, Natural Language Processing, Query

Downloads

Download data is not yet available.

References

D. Saha, A. Floratou, K. Sankaranarayanan, U. F. Minhas, A. R. Mittal, and F. Özcan, "ATHENA: an ontology-driven system for natural language querying over relational data stores," Proceedings of the VLDB Endowment, vol. 9, no. 12, pp. 1209-1220, Aug. 2016. DOI: https://doi.org/10.14778/2994509.2994536

F. Brad, R. C. A. Iacob, I. A. Hosu, and T. Rebedea, "Dataset for a Neural Natural Language Interface for Databases (NNLIDB)," in Proceedings of the Eighth International Joint Conference on Natural Language Processing (Volume 1: Long Papers), Taipei, Taiwan, Nov. 2017, pp. 906-914, Accessed: Nov. 28, 2020. [Online]. Available: https://www.aclweb.org/anthology/I17-1091.

L. Blunschi, C. Jossen, D. Kossman, M. Mori, and K. Stockinger, "SODA: Generating SQL for Business Users," arXiv:1207.0134 [cs], Jun. 2012, Accessed: Nov. 28, 2020. [Online]. Available: http://arxiv.org/abs/1207.0134.

G. Bhalotia, A. Hulgeri, C. Nakhe, S. Chakrabarti, and S. Sudarshan, "Keyword searching and browsing in databases using BANKS," in Proceedings 18th International Conference on Data Engineering, San Jose, CA, USA, Feb. 2002, pp. 431-440.

A.-M. Popescu, O. Etzioni, and H. Kautz, "Towards a theory of natural language interfaces to databases," in Proceedings of the 8th international conference on Intelligent user interfaces, New York, NY, USA, Jan. 2003, pp. 149-157. DOI: https://doi.org/10.1145/604045.604120

F. Basik et al., "DBPal: A Learned NL-Interface for Databases," in Proceedings of the 2018 International Conference on Management of Data, New York, NY, USA, May 2018, pp. 1765-1768. DOI: https://doi.org/10.1145/3183713.3193562

X. Xu, C. Liu, and D. Song, "SQLNet: Generating Structured Queries From Natural Language Without Reinforcement Learning," arXiv:1711.04436 [cs], Nov. 2017, Accessed: Nov. 28, 2020. [Online]. Available: http://arxiv.org/abs/1711.04436.

J. Berant, A. Chou, R. Frostig, and P. Liang, "Semantic Parsing on Freebase from Question-Answer Pairs," in Proceedings of the 2013 Conference on Empirical Methods in Natural Language Processing, Seattle, Washington, USA, Oct. 2013, pp. 1533-1544.

A. Kate, S. Kamble, A. Bodkhe, and M. Joshi, "Conversion of Natural Language Query to SQL Query," in 2018 Second International Conference on Electronics, Communication and Aerospace Technology (ICECA), Coimbatore, India, Mar. 2018, pp. 488-491. DOI: https://doi.org/10.1109/ICECA.2018.8474639

R. Kumar and M. Dua, "Translating controlled natural language query into SQL query using pattern matching technique," in International Conference for Convergence for Technology-2014, Pune, India, Apr. 2014, pp. 1-5. DOI: https://doi.org/10.1109/I2CT.2014.7092161

A. Iftikhar, E. Iftikhar, and M. K. Mehmood, "Domain specific query generation from natural language text," in 2016 Sixth International Conference on Innovative Computing Technology (INTECH), Dublin, Ireland, Aug. 2016, pp. 502-506. DOI: https://doi.org/10.1109/INTECH.2016.7845105

C. Baik, H. V. Jagadish, and Y. Li, "Bridging the Semantic Gap with SQL Query Logs in Natural Language Interfaces to Databases," 2019 IEEE 35th International Conference on Data Engineering (ICDE), pp. 374-385, Apr. 2019. DOI: https://doi.org/10.1109/ICDE.2019.00041

N. Yaghmazadeh, Y. Wang, I. Dillig, and T. Dillig, "SQLizer: query synthesis from natural language," Proceedings of the ACM on Programming Languages, vol. 1, no. OOPSLA, p. 63:1-63:26, Oct. 2017. DOI: https://doi.org/10.1145/3133887

L. Dong and M. Lapata, "Language to Logical Form with Neural Attention," arXiv:1601.01280 [cs], Jun. 2016, Accessed: Nov. 28, 2020. [Online]. Available: http://arxiv.org/abs/1601.01280.

R. Ge and R. Mooney, "A Statistical Semantic Parser that Integrates Syntax and Semantics," in Proceedings of the Ninth Conference on Computational Natural Language Learning (CoNLL-2005), Ann Arbor, Michigan, Jun. 2005, pp. 9-16, Accessed: Nov. 28, 2020. [Online]. Available: https://www.aclweb.org/anthology/W05-0602. DOI: https://doi.org/10.3115/1706543.1706546

D. Shah and D. Vanusha, "Optimizing Natural Language Interface for Relational Database," International Journal of Engineering and Advanced Technology, vol. 8, no. 4, pp. 131-135, Apr. 2019.

C. Sun, "A Natural Language Interface for Querying Graph Databases," M.S. thesis, Massachusetts Institute of Technology, 2018.

H. Bais, M. Machkour, and L. Koutti, "A Model of a Generic Natural Language Interface for Querying Database," International Journal of Intelligent Systems and Applications, vol. 8, no. 2, pp. 35-44, Feb. 2016. DOI: https://doi.org/10.5815/ijisa.2016.02.05

J.-H. Tao, J. Huang, Y. Li, Z. Lian, and M.-Y. Niu, "Semi-supervised Ladder Networks for Speech Emotion Recognition," International Journal of Automation and Computing, vol. 16, no. 4, pp. 437-448, Aug. 2019. DOI: https://doi.org/10.1007/s11633-019-1175-x

B.-T. Zhang, X.-P. Wang, Y. Shen, and T. Lei, "Dual-modal Physiological Feature Fusion-based Sleep Recognition Using CFS and RF Algorithm," International Journal of Automation and Computing, vol. 16, no. 3, pp. 286-296, Jun. 2019. DOI: https://doi.org/10.1007/s11633-019-1171-1

N. R. Nayak, P. K. Dash, and R. Bisoi, "A Hybrid Time Frequency Response and Fuzzy Decision Tree for Non-stationary Signal Analysis and Pattern Recognition," International Journal of Automation and Computing, vol. 16, no. 3, pp. 398-412, Jun. 2019. DOI: https://doi.org/10.1007/s11633-018-1113-3

H. Sasaki, S. Yamamoto, A. Agchbayar, and Ν. Nkhbayasgalan, "Extracting Problem Linkages to Improve Knowledge Exchange between Science and Technology Domains using an Attention-based Language Model," Engineering, Technology & Applied Science Research, vol. 10, no. 4, pp. 5903-5913, Aug. 2020. DOI: https://doi.org/10.48084/etasr.3598

S. Khalid and S. Wu, "Supporting Scholarly Search by Query Expansion and Citation Analysis," Engineering, Technology & Applied Science Research, vol. 10, no. 4, pp. 6102-6108, Aug. 2020. DOI: https://doi.org/10.48084/etasr.3655

M. Alsuwaiket, A. H. Blasi, and K. Altarawneh, "Refining Student Marks based on Enrolled Modules' Assessment Methods using Data Mining Techniques," Engineering, Technology & Applied Science Research, vol. 10, no. 1, pp. 5205-5210, Feb. 2020. DOI: https://doi.org/10.48084/etasr.3284

S. R. Basha and J. K. Rani, "A Comparative Approach of Dimensionality Reduction Techniques in Text Classification," Engineering, Technology & Applied Science Research, vol. 9, no. 6, pp. 4974-4979, Dec. 2019. DOI: https://doi.org/10.48084/etasr.3146

Downloads

How to Cite

[1]
Nethravathi, B., Amitha, G., Saruka, A., Bharath , T.P. and Suyagya, S. 2020. Structuring Natural Language to Query Language: A Review. Engineering, Technology & Applied Science Research. 10, 6 (Dec. 2020), 6521–6525. DOI:https://doi.org/10.48084/etasr.3873.

Metrics

Abstract Views: 1170
PDF Downloads: 989

Metrics Information