Model-Based Architecture for Building Natural Language Interface to Oracle Database
 |
International Journal of Recent Engineering Science (IJRES) |  |
| © 2015 by IJRES Journal | ||
| Volume-2 Issue-2 |
||
| Year of Publication : 2015 | ||
| Authors : S. Aquter Babu, Dr. C. Lokanatha Reddy |
||
| DOI : 10.14445/23497157/IJRES-V2I2P102 |
How to Cite?
S. Aquter Babu, Dr. C. Lokanatha Reddy, "Model-Based Architecture for Building Natural Language Interface to Oracle Database," International Journal of Recent Engineering Science, vol. 2, no. 2, pp. 6-13, 2015. Crossref, https://doi.org/10.14445/23497157/IJRES-V2I2P102
Abstract
Structured Query Language (SQL) is a very standard interface since many years to retrieve information from a database. But, to use SQL to formulate query, one should know the syntax of SQL and Database Schema. However, not everybody is able to write such queries in SQL, especially those who lack computer background. To override the complexity of SQL, and to facilitate easy retrieval of information from database, Natural Language Interfaces to Databases (NLIDBs) have been developed. A Natural Language Interface to Database (NLIDB) allows the user to retrieve information from the database by submitting questions in a natural language such as English. Many Natural Language Interface to a Database (NLIDB) systems were developed since 1960’s with different architectures such as Pattern-Matching architecture, Syntaxbased architecture, Semantic Grammar architecture and Intermediate Representation Languages (IRL) architecture. Developing a NLIDB with one of these architectures requires more effort and time. This has motivated us to propose a novel architecture called Model-based Architecture that can be used to develop a Natural Language Interface to Oracle Database (NLIOD) with less effort and time. This paper presents the Modelbased Architecture for NLIOD.
Keywords
database, database management system (DBMS), Structured Query Language (SQL), natural language interface, architecture, models, extensibility, portability.
Reference
[1] W.A. Woods, R.M. Kaplan, and B.N. Webber. The Lunar Sciences Natural Language Information System: Final Report. BBN Report 2378, Bolt Beranek and Newman Inc., Cambridge, Massachusetts, 1972.
[2] E.F. Codd. Seven Steps to RENDEZVOUS with the Casual User. In J. Kimbie and K. Koffeman, editors, Data Base Management. North-Holland Publishers, 1974.
[3] D.L. Waltz. An English Language Question Answering System for a Large Relational Database. Communications of the ACM, 21(7):526–539, July 1978.
[4] R.J.H. Scha. Philips Question Answering System PHILIQA1. In SIGART Newsletter, no.61. ACM, New York, February 1977.
[5] G. Hendrix, E. Sacerdoti, D. Sagalowicz, and J. Slocum. Developing a Natural Language Interface to Complex Data. ACM Transactions on Database Systems, 3(2):105– 147, 1978.
[6] I. Androutsopoulos, G.D. Ritchie, and P. Thanisch, "Natural Language Interfaces to Databases - An Introduction". Natural Language Engineering, 1(1): 29-81, Cambridge University Press, 1995.
[7] B.J. Grosz, D.E. Appelt, P.A. Martin, and F.C.N. Pereira. TEAM: An Experiment in the Design of Transportable Natural-Language Interfaces. Artificial Intelligence, 32:173–243, 1987.
[8] B.H. Thompson and F.B. Thompson. ASK is Transportable in Half a Dozen Ways. ACM Transactions on Office Information Systems, 3(2):185–203, April 1985.
[9] P. Resnik. Access to Multiple Underlying Systems in JANUS. BBN report 7142, Bolt Beranek and Newman Inc., Cambridge, Massachusetts, September 1989.
[10] C.D Hafner and K. Godden. Portability of Syntax and Semantics in Datalog. ACM Transactions on Office Information Systems, 3(2):141–164, April 1985.
[11] M. Templeton and J. Burger. Problems in Natural Language Interface to DBMS with Examples from EUFID. In Proceedings of the 1st Conference on Applied Natural Language Processing, Santa Monica, California, pages 3–16, 1983.
[12] Ana-Maria Popescu, Alex Armanasu, Oren Etzioni, David Ko, and Alexander Yates, Modern Natural Language Interfaces to Databases: Composing Statistical Parsin with Semantic Tractability, COLING (2004)
[13] Yunyao Li, Huahai Yang, and H.V. Jagadish, NALIX: An Interactive Natural Language Interface for querying XML , SIGMOD, 2005