A Naive approach: Translation of Natural Language to Structured Query Language

Jyotirmayee Rautaray; Pranati Mishra

doi:10.4108/eetsis.4344

Authors

Jyotirmayee Rautaray Odisha University of Technology and Research
Pranati Mishra Odisha University of Technology and Research

DOI:

https://doi.org/10.4108/eetsis.4344

Keywords:

Natural language query, Natural language processing, Natural language generation, SQL query, Syntactic analysis, Semantic analysis, Data dictionary, Natural language information database

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.

References

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.

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.

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.

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.

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.

Ion Androutsopoulos, Graeme D Ritchie, and Peter Thanisch.” Natural language interfaces to databases-an introduction.” Natural language engineering, 1(1):29-81, 1995.

Josephine E Petralba. “An extracted database content from wordnet for natural language processing and word games.” In 2014 International Conference on Asian Language Pro- cessing (IALP), pages 199-202. IEEE, 2014.

Kovács, László. "SQL generation for natural language interface." Journal of Computer Science and Control Systems 2, no. 18 (2009): 19-22.

Kumar, Sachin, Ashish Kumar, Pinaki Mitra, and Girish Sundaram. "System and methods for converting speech to SQL." arXiv preprint arXiv:1308.3106 (2013).

Manasamithra, P., and H. C. Vijayalakshmi. "NLP for Information Retrieval using B Trees." International Journal of Computer Applications 975: 8887.

Mathur, Amrita, Atmiya Fadia, Bhagyashri Lokhande, Sagar Malaviya, and Seaman Mu- nis. "Database access for non-technical users using nlp and voice recognition."4

Nikita Mandhan, Aishwarya Ahuja, Komal Jain, and HD Gadade.” Q&a on database using nlp.”

Prasun Kanti Ghosh, Saparja Dey, and Subhabrata Sengupta. “Automatic sql query for- mation from natural language query”. International Journal of Computer Applications, 975:8887, 2014.

Rashid Ahmad, 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, page p53, 2009.

Rohit Agrawal, Amogh Chakkarwar, Prateek Choudhary, Usha A Jogalekar, and Deepa H Kulkarni. “Dbiqs an intelligent system for querying and mining databases using nlp”. In 2014 International Conference on Information Systems and Computer Networks (ISCON), pages 39-44. IEEE, 2014.

Rukshan Alexander, Prashanthi Rukshan, and Sinnathamby Mahesan. “Natural language web interface for database (nlwidb)”. arXiv preprint arXiv:1308.3830, 2013.

Ruslan Posevkin and Igor Bessmertny. “Translation of natural language queries to struc- tured data sources.” In 2015 9th International Conference on Application of Information and Communication Technologies (AICT), pages 57-59. IEEE, 2015.

Saravjeet Kaur and Rashmeet Singh Bali. “Sql generation and execution from natural lan- guage processing”. International Journal of Computing & Business Research ISSN (Online), pages 2229-6166, 2012.

Satwik Kolhe and Nitish Muley. “Natural language processing based sql query generation for retrieval of data from temporal/non-temporal database.”

Singh, Garima, and Arun Solanki. "An algorithm to transform natural language into SQL queries for relational databases." Selforganizology 3, no. 3 (2016): 100-116.

Sontakke, Abhijeet R., and Amit Pimpalkar. "A Review Paper on Hindi Language Graph- ical User Interface to Relational Database using NLP." International Journal of Advanced Research in Computer Engineering & Technology (IJARCET) 3, no. 10 (2014).

Rautaray, Jyotirmayee, Asutosh Hota, and Sai Sankar Gochhayat. "A shallow parser-based Hindi to Odia machine translation system." In Computational Intelligence in Data Mining: Proceedings of the International Conference on CIDM 2017, pp. 51-62. Springer Singapore, 2019.