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

Article:Natural Language Interface to Database using Semantic Matching

by Neelu Nihalani, Dr. Mahesh Motwani, Dr. Sanjay Silakari
International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
Volume 31 - Number 11
Year of Publication: 2011
Authors: Neelu Nihalani, Dr. Mahesh Motwani, Dr. Sanjay Silakari
10.5120/3942-5552

Neelu Nihalani, Dr. Mahesh Motwani, Dr. Sanjay Silakari . Article:Natural Language Interface to Database using Semantic Matching. International Journal of Computer Applications. 31, 11 ( October 2011), 29-34. DOI=10.5120/3942-5552

@article{ 10.5120/3942-5552,
author = { Neelu Nihalani, Dr. Mahesh Motwani, Dr. Sanjay Silakari },
title = { Article:Natural Language Interface to Database using Semantic Matching },
journal = { International Journal of Computer Applications },
issue_date = { October 2011 },
volume = { 31 },
number = { 11 },
month = { October },
year = { 2011 },
issn = { 0975-8887 },
pages = { 29-34 },
numpages = {9},
url = { https://ijcaonline.org/archives/volume31/number11/3942-5552/ },
doi = { 10.5120/3942-5552 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Journal Article
%1 2024-02-06T20:17:55.064435+05:30
%A Neelu Nihalani
%A Dr. Mahesh Motwani
%A Dr. Sanjay Silakari
%T Article:Natural Language Interface to Database using Semantic Matching
%J International Journal of Computer Applications
%@ 0975-8887
%V 31
%N 11
%P 29-34
%D 2011
%I Foundation of Computer Science (FCS), NY, USA
Abstract

Information is playing an important role in our lives. One of the major sources of information is databases. Databases and database technology are having major impact on the growing use of computers. In order to retrieve information from a database, one needs to formulate a query in such way that the computer will understand and produce the desired output. The Structured Query Language (SQL) norms are been pursued in almost all languages for relational database systems. However, not everybody is able to write SQL queries as they may not be aware of the structure of the database. So there is a need for non-expert users to query relational databases in their natural language instead of working with the values of the attributes. The idea of using natural language instead of SQL, has promoted the development of Natural Language Interface to Database systems (NLIDB). The need of NLIDB is increasing day by day as more and more people access information through web browsers, PDA’s and cell phones. In this paper we introduce an intelligent interface for database. We prove that our NLIDB is guaranteed to map a natural language query to the corresponding SQL query. We have tested our system on Northwind database and show that our NLIDB compares favourably with MS English Query product.

References
  1. Androutsopoulos, G.D. Ritchie, and P. Thanisch, Natural Language Interfaces to Databases - An introduction, Journal of Natural Language Engineering 1 Part 1 (1995), 29–81.
  2. Raymond J. Mooney, Learning Language from Perceptual Context:A Challenge Problem for AI, American Association for Artificial Intelligence (2006).
  3. VILIB Virtual Library (1999), www.islp.uni-koeln.de/aktuell/vilib/
  4. Chae, J., Lee, S.: Frame-based Decomposition Method for Korean Language Query Processing. Computer Processing of Oriental Languages (1998)
  5. Popescu, A.:Modern Natural Language Interfaces to Databases: Composing Statistical Parsing with Semantic Tractability, University of Washington (2004)
  6. Waltz, D.: An English Language Question Answering System for a Large Relational Database. Communications of the ACM (1978)
  7. Microsoft TechNet., chapter 32- English Query Best Practices (2008), www.microsoft.com/technet/prodtechnol/sql/2000/reskit/part9/c3261.mspx?mfr=true
  8. Popescu, A., Etzioni, O., Kautz, H.: Towards a Theory of Natural Language Interfaces to Databases. In: Proc. IUI-2003, Miami, USA (2003)
  9. ELF Software, ELF Software Documentation Series (2002), www.elfsoft.com/help/accelf/Overview.htm
  10. SQL-HAL, www.csse.monash.edu.au/hons/projects/2000/ Supun.Ruwanpura/
  11. Androutsopoulus, I., Ritchie, G., Thanish, P.: MASQUE/SQL, An Efficient and Portables Language Query Interface for Relational Databases, Department of Artificial Intelligence, University of Edinburgh (1993)
  12. Minock, M.: A STEP Towards Realizing Codd’s Vision of Rendezvous with the Casual User.In: Proc. 33rd International Conference on Very Large Databases (VLDB-2007), Demonstration Session, Vienna, Austria (2007)
  13. Minock, M.: Natural Language Access to Relational Databases through STEP. Technical report, Department of Computer Science, Umea University (2004)
  14. Bagnasco, C., Bresciani, P., Magnini, B., Strapparava, C.: Natural Language Interpretation for Public Administrations Database Querying in the TAMIC Demonstrator. In: The Proc. Second InternationalWorkshop on Applications of Natural Language to Information Systems (1996)
  15. Chu, W., Yang, H., Chiang, K., Minock, M., Chow, G., Larson, C.: Cobase – A Scalable and Extensible Cooperative Information System. Journal of Intelligent Information System 6,253–259 (1996)
  16. Alshawi, H., Carter, D., Crouch, R., Pulman, S.: CLARE: A Contextual Reasoning and Cooperative Response Framework for the Core Language Engine. Technical report CRC-028(1994)
  17. Binot, J., Debille, L., Sedlock, D., Vandecapelle, B.: Natural Language Interfaces: A New Philosophy, SunExpert, Magazine (1991)
  18. Boldasov, M., Sokolova, G.E.: QGen – Generation Module for the Register Restricted In-BASE System. In: Computational Linguistics and Intelligent Text Processing, 4th International Conference, vol. 2588, pp. 465–476 (2003)
  19. Microsoft English Query Tutorials available with standard installation in SQL SERVER 7.0 or higher
Index Terms

Computer Science
Information Sciences

Keywords

Databases Database Management System (DBMS) Structured Query Language (SQL) Natural Language Interface for Databases (NLIDB)