Author:
Rautaray Jyotirmayee,Mishra Pranati
Abstract
A database is a major source of information which plays an important role in our life. Information retrieval from the database requires formulating a querythatisunderstandablebythecomputerinordertoproducedesiredoutput. Generally, databases work with structured query language (SQL). But a naive user usually unfamiliar with the structured query language as well as structure of the table in the database. Hence, it becomes very difficult for the naïve-user to collect the desired information. This paper provides a solution to this problem and it enables users to retrieve information through natural language, such as English language. Being able to access information from the database by using natural language bridges the man-machine gap. Tokenization, lexical analysis, syntactic analysis, semantic analysis, and other complex stages are all involved in converting a natural language query into a SQL query. The purpose of this paper is to translate natural language queries into Structure Query Language queries, allowing non-technical people to get connected to databases and to gather the required information.
Publisher
European Alliance for Innovation n.o.
Subject
Information Systems and Management,Computer Networks and Communications,Computer Science Applications,Hardware and Architecture,Information Systems,Software
Reference22 articles.
1. Abhilasha Kate, Satish Kamble, Aishwarya Bodkhe, and Mrunal Joshi. “Conversion of natural language query to sql query”. In 2018 Second International Conference on Elec- tronics, Communication and Aerospace Technology (ICECA), pages 488-491. IEEE, 2018.
2. Ahmad, Rashid, Mohammad Abid Khan, and Rahman Ali. "Efficient transformation of a natural language query to SQL for Urdu." In Proceedings of the Conference on Language & Technology, p. p53. 2009.
3. AJ Shaikh and VL Kolhe. “Framework for web content mining using semantic search and natural language queries”. In 2013 IEEE International Conference on Computational Intel- ligence and Computing Research, pages 1-5. IEEE, 2013.
4. Catherine Finegan-Dollak, Jonathan K Kummerfeld, Li Zhang, Karthik Ramanathan, Sesh Sadasivam, Rui Zhang, and Dragomir Radev. “Improving text-to-sql evaluation methodol- ogy.” arXiv preprint arXiv:1806.09029, 2018.
5. Chalermpol Tapsai. “Information processing and retrieval from csv file by natural lan- guage.” In 2018 IEEE 3rd International Conference on Communication and Information Systems (ICCIS), pages 212-216. IEEE, 2018.