Open Access   Article Go Back

Natural Language Query Processing for Relational Database using EFFCN Algorithm

B.Sujatha 1 , S.Vishwanadha Raju2

Section:Research Paper, Product Type: Journal Paper
Volume-4 , Issue-2 , Page no. 49-53, Feb-2016

Online published on Feb 29, 2016

Copyright © B.Sujatha , S.Vishwanadha Raju . This is an open access article distributed under the Creative Commons Attribution License, which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.

View this paper at   Google Scholar | DPI Digital Library

XML View
PDF Download

How to Cite this Paper

  • IEEE Citation
  • MLA Citation
  • APA Citation
  • BibTex Citation
  • RIS Citation

IEEE Style Citation: B.Sujatha , S.Vishwanadha Raju, “Natural Language Query Processing for Relational Database using EFFCN Algorithm,” International Journal of Computer Sciences and Engineering, Vol.4, Issue.2, pp.49-53, 2016.

MLA Style Citation: B.Sujatha , S.Vishwanadha Raju "Natural Language Query Processing for Relational Database using EFFCN Algorithm." International Journal of Computer Sciences and Engineering 4.2 (2016): 49-53.

APA Style Citation: B.Sujatha , S.Vishwanadha Raju, (2016). Natural Language Query Processing for Relational Database using EFFCN Algorithm. International Journal of Computer Sciences and Engineering, 4(2), 49-53.

BibTex Style Citation:
@article{Raju_2016,
author = {B.Sujatha , S.Vishwanadha Raju},
title = {Natural Language Query Processing for Relational Database using EFFCN Algorithm},
journal = {International Journal of Computer Sciences and Engineering},
issue_date = {2 2016},
volume = {4},
Issue = {2},
month = {2},
year = {2016},
issn = {2347-2693},
pages = {49-53},
url = {https://www.ijcseonline.org/full_paper_view.php?paper_id=793},
publisher = {IJCSE, Indore, INDIA},
}

RIS Style Citation:
TY - JOUR
UR - https://www.ijcseonline.org/full_paper_view.php?paper_id=793
TI - Natural Language Query Processing for Relational Database using EFFCN Algorithm
T2 - International Journal of Computer Sciences and Engineering
AU - B.Sujatha , S.Vishwanadha Raju
PY - 2016
DA - 2016/02/29
PB - IJCSE, Indore, INDIA
SP - 49-53
IS - 2
VL - 4
SN - 2347-2693
ER -

VIEWS PDF XML
1716 1617 downloads 1578 downloads
  
  
           

Abstract

This paper addresses the procedure to develope an interface to natural language database that is efficient and flexible to handle unrestricted natural language and interpret the request appropriately called as EFFCN, stands for EFFiciently Compliant Natural language interface to database. The Experimental set up is created by developing a database named as CPVBase. The database holds the tables instituted with the sample records of Customer, Product, Vendor and Invoice data. The database tables have foreign key references to the other tables epitomizing a relation database management system. This paper explains about various technical segments of the implementation of the EFFCN algorithm. The working procedure of the algorithm for the natural language statement transformation into SQL query is depicted. The EFFCN algorithm's precision and recall measures for the score of relevancy is obtained with the success rate of 84%. The PR curve shows the variation of precision and recall measures tested on discrete set of input queries.

Key-Words / Index Term

Natural Language Query, First Order Logic, Structured Query, Precision, Recall, F1-measureNatural Language Query, First Order Logic, Structured Query, Precision, Recall, F1-measure

References

[1] Mrs. Neelu Nihalani, Dr. Sanjay Silakari and Dr. Mahesh Motwani, “Natural Language Interface for Database: A Brief Review”, IJCSI International Journal of Computer Science Issues, vol. 8, no. 2, pp. 600-608, Mar. 2011.
[2] T. Johnson, “Natural Language Computing-The Commercial Applications”, The Knowledge Engineering Review, vol. 1, no. 3, pp. 11-23, 1984.
[3] Androutsopoulos, G.D. Ritchie and P. Thanisch, “Natural Language Interface to Databases-An Introduction”, Department of Computer Science, University of Edinburgh, King‟s Buildings, Mayfield Road, Edinburgh EH9 3JZ, Scotland, U.K. , Mar. 1995.
[4] W.A. Woods, R.M. Kaplan and B.N. Webber, “The Lunar Sciences Natural Language Information System: Final Report”, BBN Report 2378, Bolt Beranek and Newman Inc., Cambridge, Massachusetts, 1972.
[5] C.R. Perrault and B.J. Grosz, “Natural Language Interfaces”, Exploring Artificial Intelligence, Morgan Kaufmann Publishers Inc., San Mateo, California, 1988, pp. 133-172.
[6] G. Hendrix, E. Sacerdoti, D. Sagalowicz, and J. Slocum, “Developing a Natural Language Interface to Complex Data”, ACM Transactions on Database Systems, pp. 105-147, 1978.
[7] W. Woods, “An experimental parsing system for transition network grammars in Natural Language Processing”, Algorithmic Press, New York, USA, 1973.
[8] L.R.Harris,“Experience with INTELLECT: Artificial Intelligence Technology Transfer”, The AI Magazine, pp. 43-50, 1984.
[9] Faraj A. El-Mouadib, Zakaria S. Zubi, Ahmed A. Almagrous and Irdess S. El-Feghi, “Generic Interactive Natural Language Interface to Databases (GINLIDB)”, International Journal of Computers, vol. 3, no. 3, 2009.
[10] “START Natural Language Question Answering system Online.
[11] M. Joshi, R. A. Akerkar, “Algorithms to improve performance of Natural Language Interface”, International Journal of Computer Science & Applications, vol. 5, no. 2, pp. 52-68, 2008.
[12] Seymour Knowles and Tanja Mitrovic, “A Natural Language Interface For SQL-Tutor”, Nov. 5, 1999.
[13] D.L. Waltz, “An English Language Question Answering System for a Large Relational Database”, Communications of the ACM, pp. 526-539, 1978.