Structuring Natural Language to Query Language: A Review

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 5 articles. 订阅此论文施引文献 订阅此论文施引文献,注册后可以免费订阅5篇论文的施引文献,订阅后可以查看论文全部施引文献

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

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

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

4. Sustainable manufacturing in the fourth industrial revolution: A big data application proposal in the textile industry;Journal of Industrial Engineering and Management;2022-10-10

5. A grammar analysis model for a video query language SVQL;Xibei Gongye Daxue Xuebao/Journal of Northwestern Polytechnical University;2022-10

同舟云学术

1.学者识别学者识别

2.学术分析学术分析

3.人才评估人才评估

"同舟云学术"是以全球学者为主线,采集、加工和组织学术论文而形成的新型学术文献查询和分析系统,可以对全球学者进行文献检索和人才价值评估。用户可以通过关注某些学科领域的顶尖人物而持续追踪该领域的学科进展和研究前沿。经过近期的数据扩容,当前同舟云学术共收录了国内外主流学术期刊6万余种,收集的期刊论文及会议论文总量共计约1.5亿篇,并以每天添加12000余篇中外论文的速度递增。我们也可以为用户提供个性化、定制化的学者数据。欢迎来电咨询!咨询电话:010-8811{复制后删除}0370

www.globalauthorid.com

TOP

Copyright © 2019-2024 北京同舟云网络信息技术有限公司
京公网安备11010802033243号  京ICP备18003416号-3