CFP last date
20 May 2024
Call for Paper
June Edition
IJCA solicits high quality original research papers for the upcoming June edition of the journal. The last date of research paper submission is 20 May 2024

Submit your paper
Know more
The week's pick
Responsive image
Enhancing Privacy Preservation: Multi-Attribute Protection with P-Sensitive K-Anonymity

Twinkle Patel Kiran Amin
Random Articles
Reseach Article

Information Retrieval using Natural Language Interfaces

by M. Sreenivasulu
journal cover thumbnail

International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
Volume 92 - Number 12
Year of Publication: 2014
Authors: M. Sreenivasulu
10.5120/16064-5375

M. Sreenivasulu . Information Retrieval using Natural Language Interfaces. International Journal of Computer Applications. 92, 12 ( April 2014), 34-37. DOI=10.5120/16064-5375

@article{ 10.5120/16064-5375,
author = { M. Sreenivasulu },
title = { Information Retrieval using Natural Language Interfaces },
journal = { International Journal of Computer Applications },
issue_date = { April 2014 },
volume = { 92 },
number = { 12 },
month = { April },
year = { 2014 },
issn = { 0975-8887 },
pages = { 34-37 },
numpages = {9},
url = { https://ijcaonline.org/archives/volume92/number12/16064-5375/ },
doi = { 10.5120/16064-5375 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Journal Article
%1 2024-02-06T22:14:10.065318+05:30
%A M. Sreenivasulu
%T Information Retrieval using Natural Language Interfaces
%J International Journal of Computer Applications
%@ 0975-8887
%V 92
%N 12
%P 34-37
%D 2014
%I Foundation of Computer Science (FCS), NY, USA
Abstract

In Database Management System (DBMS) is collection of interrelated data and set of programs to access and modify the data. In Relational DBMS (RDBMS), data is organized inform of tables. In order to retrieve information from the database, the end user requires the knowledge of database query language such as Structured Query Language (SQL). However, not every user is able to write SQL queries as they may not aware of structure of the database and they needs to learn SQL. So, there is a need for non-expert user to query relational databases in their natural language such as English. In this paper, we propose s Natural language Interfaces to Relational Databases (NLIRDB) to access the data in easier manner. The end user can submit the request in natural language. The query in natural language is then translated into equivalent SQL statement and finally SQL statement will be executed to extract desired information from the database. The proposed method allows non-expert user to access information from database.

References
  1. Harjit Singh, "Providing Inferential Capability to Natural Language Database Interface", IJECSE, Vol. 1, N0. 3, pp. 1634 – 1639, 2012.
  2. Mrs. Neelu Nihalani, Dr. Sanjay Silakari, Dr. Mahesh Motwani, "Natural language Interface for Database: A Brief review", IJCSI International Journal of Computer Science Issues, Vol. 8, Issue 2, pp. 600-608, March 2011.
  3. Mrs. Neelu Nihalani, Dr. Sanjay Silakari, Dr. Mahesh Motwani, "An Intelligent Interface for relational databases", IJSSST, Vol. 11, No. 1. pp 29-34, Jan 2010.
  4. Lappoon R. Tang, "Using machine learning approach for natural language interfaces for databases: Application of advanced techniques in inductive logic programming", Journal of Computer Science, Informatics and Electrical Engineering, vol 2, Issue 1, 2008.
  5. Alfred V. Aho, Monica S. Lam, Ravi Sethi, and Jeffrey D. Ullman, "Compilers: Principles, Techniques, and Tools", Pearson Education, 2006.
  6. Silberschatz, Korth, "Data base System Concepts", McGraw hill, V edition, 2006.
  7. Raghurama Krishnan, Johannes Gehrke, "Data base Management Systems", TATA McGraw Hill, 3rd Edition, 2010.
  8. Herbert Schildt, "JAVA 2 The Complete Reference", Osborne/McGraw-Hill, 4th Edition, 2001.
  9. A. A. Puntambekar, "Web Technologies", Technical Publications, 2009.
Index Terms

Computer Science
Information Sciences

Keywords

Database Query Generator Morphological Analyzer NLIRDB Query Executor SQL.

Powered by PhDFocusTM