Structuring Natural Language to Query Language: A Review-Reference-Cited by-同舟云学术

Structuring Natural Language to Query Language: A Review

Published:2020-12-20 Issue:6 Volume:10 Page:6521-6525
ISSN:1792-8036
Container-title:Engineering, Technology & Applied Science Research
language:
Short-container-title:Eng. Technol. Appl. Sci. Res.

Author:

Nethravathi B.^ORCID,Amitha G.,Saruka A.,Bharath T. P.,Suyagya S.

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.

Publisher

Engineering, Technology & Applied Science Research

Reference25 articles.

1. [1] 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.

2. [2] 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.

3. [3] 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.

4. [4] 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.

5. [5] 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.

Cited by 7 articles. 订阅此论文施引文献订阅此论文施引文献，注册后可以免费订阅5篇论文的施引文献，订阅后可以查看论文全部施引文献

1. Utilizing Ant Colony Optimization for Result Merging in Federated Search;Engineering, Technology & Applied Science Research;2024-08-02

2. Word Sense Disambiguation applied to Assamese-Hindi Bilingual Statistical Machine Translation;Engineering, Technology & Applied Science Research;2024-02-08

3. Enabling Context-based AI in Chatbots for conveying Personalized Interdisciplinary Knowledge to Users;Engineering, Technology & Applied Science Research;2023-12-05

4. An Efficient Methodology for Detecting the Vertical Movement of Structures;Engineering, Technology & Applied Science Research;2023-02-01

5. Identification of Harmful animal detection using Image Processing Technique;2022 Fourth International Conference on Cognitive Computing and Information Processing (CCIP);2022-12-23