Support System for creating SQL Queries using Natural Language
Mumuksha Pant, Vinayak Mishra, B.Jothi · Journal of Emerging Technologies and Innovative Research · 2020
Nowadays, all the people have their own personal devices that are connected to the web. Each one of these people try to get the knowledge that they need via the internet. Much of the knowledge is within some sort of database. A person that needs to retrieve the data via a database and has very little or no knowledge about the database languages faces a problematic scenario. Therefore, there is requirement for a means and a system that permits the average person to access natural language within a table. This paper looks to make a system like the one mentioned using NLP by giving natural language question as input and outputting SQL query, to access the related info via a Vehicle database table with no difficulty. The various steps that are there during these processes are lemmatization, tokenization, parts of speech tagging, chunking and mapping the values. The dataset being used to implement the proposed system has a group of structured natural questions on car details. This research would be an overall view of the usage of Natural Language Processing (NLP) and use of regular expressions to map the query in English to SQL.