This paper is published in Volume-5, Issue-3, 2019
Area
Natural Language Processing
Author
Ankita Makker, Gaurav Nayak
Org/Univ
PDPM Indian Institute of Information Technology, Design and Manufacturing, Jabalpur, Madhya Pradesh, India
Pub. Date
23 May, 2019
Paper ID
V5I3-1525
Publisher
Keywords
Natural Language Processing (NLP), SQL, Semantic similarity, context, Named entity recognition, Dependency graphs

Citationsacebook

IEEE
Ankita Makker, Gaurav Nayak. Natural language to SQL, International Journal of Advance Research, Ideas and Innovations in Technology, www.IJARIIT.com.

APA
Ankita Makker, Gaurav Nayak (2019). Natural language to SQL. International Journal of Advance Research, Ideas and Innovations in Technology, 5(3) www.IJARIIT.com.

MLA
Ankita Makker, Gaurav Nayak. "Natural language to SQL." International Journal of Advance Research, Ideas and Innovations in Technology 5.3 (2019). www.IJARIIT.com.

Abstract

In this research, an intelligent system is designed for the users to access the database using natural language. It accepts natural language input and then converts it into an SQL query. Using query language for dealing with databases has always been a professional and complex problem. The system currently handles single sentence natural language inputs and concentrates on MySQL database system. The system accommodates aggregate functions, multiple conditions in WHERE clause, join operations, advanced clauses like ORDER BY, GROUP BY and HAVING. The natural language statement goes through various stages of Natural Language Processing like morphological, lexical, syntactic and semantic analysis resulting in SQL query formation. Intelligent Interface is the need of database applications to enhance efficient interaction between user and DBMS. The research focuses on making the system more dynamic.Improvements have been introduced to the system by incorporating preprocessing of text, named entity recognition, building hierarchical relations, semantic similarity and negation handling using dependency graphs.