We apologize for a recent technical issue with our email system, which temporarily affected account activations. Accounts have now been activated. Authors may proceed with paper submissions. PhDFocusTM
CFP last date
20 November 2024
Call for Paper
December Edition
IJCA solicits high quality original research papers for the upcoming December edition of the journal. The last date of research paper submission is 20 November 2024

Submit your paper
Know more
Reseach Article

Automatic SQL Query Formation from Natural Language Query

Published on October 2014 by Prasun Kanti Ghosh, Saparja Dey, Subhabrata Sengupta
International Conference on Microelectronics, Circuits and Systems
Foundation of Computer Science USA
MICRO - Number 1
October 2014
Authors: Prasun Kanti Ghosh, Saparja Dey, Subhabrata Sengupta
014f3d22-57ff-46d9-bf43-e9cce3723798

Prasun Kanti Ghosh, Saparja Dey, Subhabrata Sengupta . Automatic SQL Query Formation from Natural Language Query. International Conference on Microelectronics, Circuits and Systems. MICRO, 1 (October 2014), 1-5.

@article{
author = { Prasun Kanti Ghosh, Saparja Dey, Subhabrata Sengupta },
title = { Automatic SQL Query Formation from Natural Language Query },
journal = { International Conference on Microelectronics, Circuits and Systems },
issue_date = { October 2014 },
volume = { MICRO },
number = { 1 },
month = { October },
year = { 2014 },
issn = 0975-8887,
pages = { 1-5 },
numpages = 5,
url = { /proceedings/micro/number1/18306-1802/ },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Proceeding Article
%1 International Conference on Microelectronics, Circuits and Systems
%A Prasun Kanti Ghosh
%A Saparja Dey
%A Subhabrata Sengupta
%T Automatic SQL Query Formation from Natural Language Query
%J International Conference on Microelectronics, Circuits and Systems
%@ 0975-8887
%V MICRO
%N 1
%P 1-5
%D 2014
%I International Journal of Computer Applications
Abstract

Natural language processing is a field of computer science concerned with the interactions between computers and human (natural) languages. It is becoming one of the most active areas in the interaction between human and computer. These include spoken language systems that integrate speech and natural language. It is an interdisciplinary research area at the border between linguistics and artificial intelligence, aiming at developing computer programs capable of human-like activities like understanding or producing texts or speech in a natural language, such as English or conversion of natural language in text or speech form to languages like SQL. The most important applications of natural language processing include information retrieval and information organization, machine translation. The goal of NLP is to enable communication between people and computers without resorting to memorization of complex commands and procedures.

References
  1. Huangi,Guiang Zangi, Phillip C-Y Sheu "A Natural Language database Interface based on probabilistic context free grammar", IEEE International workshop on Semantic Computing and Systems 2008
  2. A. M. Riad, El-Minir, H. K. , ElSoud, M. A. , Sabbeh. PSSE: An Architecture for a Personalized Semantic Search Engine. International Journal on Advances in Information Sciences and Service Sciences Volume 2, Number 1, March 2010, pp. 102 - 112J.
  3. Myungjin Lee, Wooju Kim, Sangun Park. Semantic Association-Based Search and Visualization Method on the Semantic Web Portal. International Journal of Computer Networks & Communications (IJCNC), Vol. 2, No. 1, January 2010, pp. 140 – 152.
  4. Nguyen Tuan Dang, and Do Thi Thanh Tuyen. Natural Language Question Answering Model Applied To Document Retrieval System. World Academy of Science, Engineering and Technology 51 2009, pp. 36 – 39
  5. William B. Cavnar, John M. Trenkle. 1994 N-Gram-Based Text Categorization. Proceedings of SDAIR-94, 3rd Annual Symposium on Document Analysis and Information Retrieval, pp. 161—175
  6. Hendrix, G. G. , Sacerdoti, E. D. , Sagalowicz, D. , Slocum, J. "Developing a natural language interface to complex data", in ACM Transactions on database systems,1978,pp. 105-147.
  7. A. Jebaraj Ratnakumar 2005 An Implementation of Web Personalization Using Web Mining Techniques. Journal of Theoretical and Applied Information Technology, 2005, pp. 68–73
  8. Gauri Rao, Chanchal Agarwal, Snehal Chaudhry, Nikita Kulkarni, Dr. S. H. Patil (IJCSE) International Journal on Computer Science and Engineering Vol. 02, No. 02, 2010, 219-223
  9. Gauri Rao, Chanchal Agarwal, Snehal Chaudhry, Nikita Kulkarni, Dr. S. H. Patil (IJCSE) International Journal on Computer Science and Engineering Vol. 02, No. 02, 2010, 219-223
  10. Enikuomehin A. O, Okwufulueze D. O ,An Algorithm for Solving Natural Language Query Execution Problems on Relational Databases by in (IJACSA)International Journal of Advanced Computer Sciemce and Applications, Vol. 3, no. 10, 2012
  11. Sachin Kumar,Ashish Kumar, Dr. Pinaki Mitra, Girish Sundaram (ERCICA) Emerging Research in Computing, Information, Communication and Applications pp:291-298, in proceedings of International Conference. , 2013.
  12. Weizenbaum, Joseph (January 1966), "ELIZA—A Computer Program For the Study of Natural Language Communication Between Man And Machine", Communications of the ACM 9 (1): 36–45, doi:10. 1145/365153. 365168.
  13. Terry Winograd, "Procedures as a Representation for Data in a Computer Program for Understanding Natural Language", MIT AI Technical Report 235, February 1971
Index Terms

Computer Science
Information Sciences

Keywords

Natural Language Query Speech-to-text Log File Data Dictionary Speech Recognition