Natural Language Database Interface for Selection of Data Using Grammar and Parsing

Databases have become ubiquitous. Almost all IT applications are storing into and retrieving information from databases. Retrieving information from the database requires knowledge of technical languages such as Structured Query Language (SQL). However majority of the users who interact with the databases do not have a technical background and are intimidated by the idea of using languages such as SQL. This has led to the development of a few Natural Language Database Interfaces (NLDBIs). A NLDBI allows the user to query the database in a natural language. This paper highlights on architecture of new NLDBI system, its implementation and discusses on results obtained. In most of the typical NLDBI systems the natural language statement is converted into an internal representation based on the syntactic and semantic knowledge of the natural language. This representation is then converted into queries using a representation converter. A natural language query is translated to an equivalent SQL query after processing through various stages. The work has been experimented on primitive database queries with certain constraints.

• N. D. Karande
• G. A. Patil

• Natural language database interface
• representation converter
• syntactic and semantic knowledge

[1] In-Su Kang, Jae-Hak J. Bae, Jong-Hyeok Lee "Database Semantics
Representation for Natural Language Access." Department of Com
Computer Science and Engineering, Electrical and Computer
Engineering Division Pohang University of Science and Technology
(POSTECH) and Advanced Information Technology Research Center
(AITrc), 2002.
[2] Woods, W., Kaplan, R. "Lunar rocks in natural English: Explorations in
natural language question answering." Linguistic Structures
Processing. In Fundamental Studies in Computer Science, 5:521-569,
1977.
[3] Androutsopoulos, I., Richie, G.D., Thanisch, P. "Natural Language
Interface to Database - An Introduction." Journal of Natural Language
Engineering, Cambridge University Press. 1(1), 29-81, 1995.
[4] Linguistic Technology. English Wizard - Dictionary Administrator's
Guide. Linguistic Technology Corp., Littleton, MA, USA, 1997.
[5] Dan Klein, Christopher D. Manning: Corpus-Based Induction of
Syntactic Structure: Models of Dependency and Constituency. ACL
2004: 478-485.
[6] M-C.de Marneffe, B. MacCartney, and C. D. Manning. "Generating
Typed Dependency Parses from Phrase Structure Parses." In Proceedings
of the IEEE /ACL 2006 Workshop on Spoken Language
Technology. The Stanford Natural Language Processing Group. 2006.
[7] Dan Klein and Christopher D. Manning. 2003. Fast Exact Inference
with a Factored Model for Natural Language Parsing. In Advances in
Neural Information Processing Systems 15 (NIPS 2002), Cambridge,
MA: MIT Press, pp. 3-10.
[8] Marie-Catherine de Marneffe, Bill MacCartney, and Christopher D.
Manning. Generating Typed Dependency Parses from Phrase Structure
Parses. In LREC 2006.