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

Authors: N. D. Karande, G. A. Patil

Abstract:

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.

Keywords: Natural language database interface, representation converter, syntactic and semantic knowledge

Digital Object Identifier (DOI): doi.org/10.5281/zenodo.1329799

References:

[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.