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

Submit your paper
Know more
Reseach Article

A Domain and Language Construct based Mapping to Convert Natural Language Query to SQL

by Alka Malik, Rahul Rishi
International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
Volume 116 - Number 4
Year of Publication: 2015
Authors: Alka Malik, Rahul Rishi
10.5120/20325-2444

Alka Malik, Rahul Rishi . A Domain and Language Construct based Mapping to Convert Natural Language Query to SQL. International Journal of Computer Applications. 116, 4 ( April 2015), 29-34. DOI=10.5120/20325-2444

@article{ 10.5120/20325-2444,
author = { Alka Malik, Rahul Rishi },
title = { A Domain and Language Construct based Mapping to Convert Natural Language Query to SQL },
journal = { International Journal of Computer Applications },
issue_date = { April 2015 },
volume = { 116 },
number = { 4 },
month = { April },
year = { 2015 },
issn = { 0975-8887 },
pages = { 29-34 },
numpages = {9},
url = { https://ijcaonline.org/archives/volume116/number4/20325-2444/ },
doi = { 10.5120/20325-2444 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Journal Article
%1 2024-02-06T22:56:08.653144+05:30
%A Alka Malik
%A Rahul Rishi
%T A Domain and Language Construct based Mapping to Convert Natural Language Query to SQL
%J International Journal of Computer Applications
%@ 0975-8887
%V 116
%N 4
%P 29-34
%D 2015
%I Foundation of Computer Science (FCS), NY, USA
Abstract

Database management systems (DBMS) have been widely used for storing and retrieving data. However, databases are often hard to use since their interface is quite rigid in cooperating with users. End user is required to issue SQL query to retrieve information from the database. Thus, a user cannot interact directly because of lack of knowledge about the SQL query form, thus is restricted to available application options. To provide the direct access of user on dataset, some unstructured query processor is required. The present work is an interface that will convert the unstructured text query to structured SQL query. It is an intelligent interface formation between the user and the dataset and defined in three main stages namely Descriptive Database Construction, Unstructured Query Filtration and Mapping Stage. The system provide the robustness in terms to handle the broader range of user queries and is be implemented in java environment on Enterprise Employee Database.

References
  1. D. J. P. H. N. P. Axita Shah, "NLKBIDB- Natural Language and Keyword Based Interface to Database", in IEEE, 2013.
  2. Vesper Owei," Natural Language Query Filtration in the Conceptual Query Language",1997 IEEE.
  3. Kunar S Vaisla & Ashish Kumar, "Natural Language Interface to Database: Development Techniques", Elixir Comp. Sci. & Engg. , 2013.
  4. A. Kaur and P. Bhatiya, "Punjabi Language Interface to Database", M. Tech dissertation, Department of CSED, Thapar Universirty, 2010.
  5. D. D & Ashish Tamrakar, "Query Optimization using Natural Language Processing", Int. J. Tech, Vol. 1, Issue 2, 2011.
  6. D. M. M. D. S. S. Neelu Nihalani, "Natural Language Interface for Database: A Brief Review", IJCSI, Vol. 8, Issue 2, 2011.
  7. Y. S. Hu Li, "A Word Net Based Natural Language Interface to Relational Database", in IEEE, Wuhan, China, 2010
  8. D. S. S. V. K. N. S. Alok Parlikar, "NQML: Natural Query Markup Language", NLP - KE '05, 0-7803-9361-9/05©2005 IEEE
  9. D. S. S. D. M. M. Neelu Nihalani, "An Intelligent Interface for Relational Databases", IJSSST, vol. 11, No. 1.
  10. N. J. M. Porforio p. Filipe, "Database and Natural Language Interfaces", Portugal, 2000
  11. George A. Miller, "WordNet: A Lexical Database for English", communication of the ACM, Vol. 38, No. 11, 1995
  12. WordNet WordNet, http:/wordnet. princeton. edu/
  13. The Stanford Parser: A statistical Parser. http://nlp. stanford. edu. /software/lex-parser. shtml
  14. Link Parser Grammar link- http://www. link. cs. cmu. edu/link/submit-sentence-4. html
  15. Z. S. Z. A. A. A. I. S. E. -F. Faraj A. EI-Mouadib, "Gneric Interactive Natural Language Interface to Databases (GINLIDB)," International journal of computer, vol. 3, no. 3, 2009.
  16. Y. S. Hu Li, "A Word Net Based Natural Language Interface to Relational Database", in IEEE, Wuhan, China, 2010
  17. en. wikipedia. org/wiki/Natural_language_processing.
  18. S. B. P. T. D. H. D. T. Nguyen, "A Vietnamese Natural Language Interface to Database ", in IEEE, china, 2002.
  19. S. C. D. Sanjay Agrwal, "DBXplorer:A system for keyword base search over relational database," in IEEE, 2002.
  20. z. j. y. D. Shang wank, "NUITS: A novel user interface for efficient Keyword search over database," in citeseer, China, 2006.
Index Terms

Computer Science
Information Sciences

Keywords

Natural Language Interface to Database (NLIDB) Keyword based Interface to Database (KBIDB) Structured Query Language (SQL).