IJSTR

International Journal of Scientific & Technology Research

Home About Us Scope Editorial Board Blog/Latest News Contact Us
0.2
2019CiteScore
 
10th percentile
Powered by  Scopus
Scopus coverage:
Nov 2018 to May 2020

CALL FOR PAPERS
AUTHORS
DOWNLOADS
CONTACT

IJSTR >> Volume 8 - Issue 10, October 2019 Edition



International Journal of Scientific & Technology Research  
International Journal of Scientific & Technology Research

Website: http://www.ijstr.org

ISSN 2277-8616



Providing Natural Language Interface To Database Using Artificial Intelligence

[Full Text]

 

AUTHOR(S)

Anil Kumar H M, Ashwin Ram Kumar, Harshitha P, Mahadevaswamy, Sachin D N

 

KEYWORDS

Database, Natural Language, Natural Language Processing, Tokenization, Stop word filtering, Structured Query Language (SQL), Artificial Intelligence.

 

ABSTRACT

In today's world, the maximum number of operations are executed using a system involving data storage in the database. Non-programmers also try to access the information stored in the database. So it is a challenging task to make the system support search interface to access the information without even knowing the syntax of database language. This paper represents a method in which the user can give input in natural language (currently English) and retrieve the desired information in the same language by generating a query on the database in SQL language. If any interpretation error occurs, we provide a natural query recommendation framework (in the future) to make it easier for the users.

 

REFERENCES

[1] Khurana, Priyanka, Mittar Vishav and Ruchika Yadav. “Computation of User-based Query using Natural Language processing.” International Journal of Computer Applications 55.11 (2012).
[2] Satav, Akshay G., et al. “A proposed natural language query processing system.” International Journal of Science and Applied Information Technology 3.2 (2014).
[3] Patel, Jaina, and Jay Dave. "A Survey: Natural Language Interface to Databases." International Journal of Advanced Engineering and Research Development (IJAERD) (2015).
[4] Ashwath M, Balapradeep K N, Savitha C K. “A simplified model of natural language interface for querying database.” International Research Journal of Engineering and Technology (IRJET).
[5] Anil M Bhardgale, Sanhita R Gavas, Meghana M Patil, Pinki, R Goyal (2013). “Natural Language to SQL conversion system” IJCSEITR, 3(2), 161-166.
[6] Garima Singh, Arun Solanki, “An algorithm to transform natural language into SQL queries for relational Databases,” IAEES September 2016.
[7] Prashant Gupta, Aman Goswamy, Sahil Koul and Kashinath Sartape, “IQS-Intelligent Querying System using Natural Language Processing,” in International Conference on Electronics, Communication and Aerospace Technology, 2017.
[8] Ikshu Bhalla and Archit Gupta. “Generating SQL from Natural Language.” Stanford Publications, 2017, web.stanford.edu/class/cs224n/reports/6907018.pdf
[9] NAVID YAGHMAZADEH, et al. “SQLizer: Query Synthesis from Natural Language.” University of Texas, Oct. 2017, www.cs.utexas.edu/~ypwang/pubs/oopsla17.pdf
[10] K Javubar Sathick, and A Jaya. "Natural Language to SQL Generation for Semantic Knowledge Extraction in Social Web Sources." Indian Journal of Science and Technology, Jan. 2015.