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

Alka Malik; Rahul Rishi

Research 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 - Issue 4

Published: April 2015

Authors: Alka Malik, Rahul Rishi

10.5120/20325-2444

PDF

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 },
                        year    = { 2015 },
                        volume  = { 116 },
                        number  = { 4 },
                        pages   = { 29-34 },
                        doi     = { 10.5120/20325-2444 },
                        publisher = { Foundation of Computer Science (FCS), NY, USA }
                        }

                        %0 Journal Article
                        %D 2015
                        %A Alka Malik
                        %A Rahul Rishi
                        %T A Domain and Language Construct based Mapping to Convert Natural Language Query to SQL%T 
                        %J International Journal of Computer Applications
                        %V 116
                        %N 4
                        %P 29-34
                        %R 10.5120/20325-2444
                        %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

D. J. P. H. N. P. Axita Shah, "NLKBIDB- Natural Language and Keyword Based Interface to Database", in IEEE, 2013.
Vesper Owei," Natural Language Query Filtration in the Conceptual Query Language",1997 IEEE.
Kunar S Vaisla & Ashish Kumar, "Natural Language Interface to Database: Development Techniques", Elixir Comp. Sci. & Engg. , 2013.
A. Kaur and P. Bhatiya, "Punjabi Language Interface to Database", M. Tech dissertation, Department of CSED, Thapar Universirty, 2010.
D. D & Ashish Tamrakar, "Query Optimization using Natural Language Processing", Int. J. Tech, Vol. 1, Issue 2, 2011.
D. M. M. D. S. S. Neelu Nihalani, "Natural Language Interface for Database: A Brief Review", IJCSI, Vol. 8, Issue 2, 2011.
Y. S. Hu Li, "A Word Net Based Natural Language Interface to Relational Database", in IEEE, Wuhan, China, 2010
D. S. S. D. M. M. Neelu Nihalani, "An Intelligent Interface for Relational Databases", IJSSST, vol. 11, No. 1.
N. J. M. Porforio p. Filipe, "Database and Natural Language Interfaces", Portugal, 2000
George A. Miller, "WordNet: A Lexical Database for English", communication of the ACM, Vol. 38, No. 11, 1995
WordNet WordNet, http:/wordnet. princeton. edu/
The Stanford Parser: A statistical Parser. http://nlp. stanford. edu. /software/lex-parser. shtml
Link Parser Grammar link- http://www. link. cs. cmu. edu/link/submit-sentence-4. html
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.
Y. S. Hu Li, "A Word Net Based Natural Language Interface to Relational Database", in IEEE, Wuhan, China, 2010
en. wikipedia. org/wiki/Natural_language_processing.
S. B. P. T. D. H. D. T. Nguyen, "A Vietnamese Natural Language Interface to Database ", in IEEE, china, 2002.
S. C. D. Sanjay Agrwal, "DBXplorer:A system for keyword base search over relational database," in IEEE, 2002.
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

No index terms available.

Keywords

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