Extracting Sql Query Using Natural Language Processing
Nandhini S1, B.Viruthika2, Almas Saba3, Suman Sangeeta Das4
1Ms.Nandhini.S, Assistant Professor, Department of CSE, SRMIST, Ramapuram Campus, Chennai (Tamil Nadu), India.
2B.Viruthika, Department of CSE, SRMIST, Ramapuram Campus, Chennai (Tamil Nadu), India.
3Almas Saba, Department of CSE, SRMIST, Ramapuram Campus, Chennai (Tamil Nadu), India.
4Suman Sangeeta Das, Department of CSE, SRMIST, Ramapuram Campus, Chennai (Tamil Nadu), India.
Manuscript received on 18 April 2019 | Revised Manuscript received on 25 April 2019 | Manuscript published on 30 April 2019 | PP: 1544-1548 | Volume-8 Issue-4, April 2019 | Retrieval Number: D6647048419/19©BEIESP
Open Access | Ethics and Policies | Cite | Mendeley | Indexing and Abstracting
© The Authors. Blue Eyes Intelligence Engineering and Sciences Publication (BEIESP). This is an open access article under the CC-BY-NC-ND license (http://creativecommons.org/licenses/by-nc-nd/4.0/)
Abstract: The basic idea is to obtain SQL query from Natural Language Query efficiently. Structured query language is the most used tool for managing data in the relational database system. Most users are not familiar with SQL which is problematic for managing and retrieving data. A model has been proposed to find a solution to the problem. This helps people who are new and inexperienced in using SQL. The speech in Hindi language is taken as input and is converted into text. This is further translated into SQL query using word mapping technique. Finally, the output is obtained from the result using database.
Keywords: Natural Language Processing, Structured Query Language, Speech to Text, Lexical Analysis, Syntactic and Semantic Analysis, Python, Data Dictionary.
Scope of the Article: Natural Language Processing