The week's pick
Reseach Article
Article:Natural Language Interface to Database using Semantic Matching
| 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
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
- 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.
- Raymond J. Mooney, Learning Language from Perceptual Context:A Challenge Problem for AI, American Association for Artificial Intelligence (2006).
- VILIB Virtual Library (1999), www.islp.uni-koeln.de/aktuell/vilib/
- Chae, J., Lee, S.: Frame-based Decomposition Method for Korean Language Query Processing. Computer Processing of Oriental Languages (1998)
- Popescu, A.:Modern Natural Language Interfaces to Databases: Composing Statistical Parsing with Semantic Tractability, University of Washington (2004)
- Waltz, D.: An English Language Question Answering System for a Large Relational Database. Communications of the ACM (1978)
- Microsoft TechNet., chapter 32- English Query Best Practices (2008), www.microsoft.com/technet/prodtechnol/sql/2000/reskit/part9/c3261.mspx?mfr=true
- Popescu, A., Etzioni, O., Kautz, H.: Towards a Theory of Natural Language Interfaces to Databases. In: Proc. IUI-2003, Miami, USA (2003)
- ELF Software, ELF Software Documentation Series (2002), www.elfsoft.com/help/accelf/Overview.htm
- SQL-HAL, www.csse.monash.edu.au/hons/projects/2000/ Supun.Ruwanpura/
- 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)
- 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)
- Minock, M.: Natural Language Access to Relational Databases through STEP. Technical report, Department of Computer Science, Umea University (2004)
- 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)
- 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)
- 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)
- Binot, J., Debille, L., Sedlock, D., Vandecapelle, B.: Natural Language Interfaces: A New Philosophy, SunExpert, Magazine (1991)
- 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)
- Microsoft English Query Tutorials available with standard installation in SQL SERVER 7.0 or higher
Index Terms
Keywords