NL2SQL: Natural Language to SQL Query Translator

2021 ◽  
pp. 267-278
Author(s):  
T. J. Revanth ◽  
K. Venkat Sai ◽  
R. Ramya ◽  
Renusree Chava ◽  
V. Sushma ◽  
...  
Keyword(s):  
Author(s):  
Kiran Raj R

Today, everyone has a personal device to access the web. Every user tries to access the knowledge that they require through internet. Most of the knowledge is within the sort of a database. A user with limited knowledge of database will have difficulty in accessing the data in the database. Hence, there’s a requirement for a system that permits the users to access the knowledge within the database. The proposed method is to develop a system where the input be a natural language and receive an SQL query which is used to access the database and retrieve the information with ease. Tokenization, parts-of-speech tagging, lemmatization, parsing and mapping are the steps involved in the process. The project proposed would give a view of using of Natural Language Processing (NLP) and mapping the query in accordance with regular expression in English language to SQL.


2017 ◽  
Author(s):  
Nandan Sukthankar ◽  
Sanket Maharnawar ◽  
Pranay Deshmukh ◽  
Yashodhara Haribhakta ◽  
Vibhavari Kamble

2018 ◽  
Vol 7 (3) ◽  
pp. 01-11 ◽  
Author(s):  
Amit Pagrut ◽  
Ishant Pakmode ◽  
Shambhoo Kariya ◽  
Vibhavari Kamble ◽  
Yashodhara Haribhakta

2020 ◽  
Vol 32 ◽  
pp. 01007
Author(s):  
Rachana Dubey ◽  
Tejal Kawale ◽  
Twisha Choudhary ◽  
Vaibhav Narawade

In our everyday lives we require information to accomplish daily tasks. Database is one of the most important sources of information. Database systems have been widely used in data storage and retrieval. However, to extract information from databases, we need to have some knowledge of database languages like SQL. But SQL has predefined structures and format, so it is hard for the non-expert users to formulate the desired query. To override this complexity, we have turned to natural language to retrieve information from database, which can be an ideal channel between a non-technical user and the application. But the application cannot understand natural language so an interface is required. This interface is capable of converting the user’s natural language query to an equivalent database language query. In this paper, we address the system architecture for translating a Hindi sentence in the form of an audio to an equivalent SQL query. The users don’t need to learn any formal query language; hence it’s easy to use for common people.


2013 ◽  
Vol 765-767 ◽  
pp. 1684-1688
Author(s):  
Xiao Na Ma ◽  
Bo Wei Li ◽  
Lin Wang

In order to make the users who didnt study the computer-related major can find the useful information in their familiar manner, it becomes a hot research topic to search in an interactive way using Chinese natural language. But because the complexity of Chinese, how to build of a formal model of natural language is always a difficult research problem. In this paper, by analysis the query sentence type in SQL based on the special database, we bring forward the rules and the context irrespective grammars of the restrictive Chinese that resolves the difficult comprehension problem in natural language processing. And aiming at the comprehension processing, we give the detailed arithmetic describing that can translate a natural language query of the restrictive Chinese to SQL.


Sign in / Sign up

Export Citation Format

Share Document