Open Access Open Access  Restricted Access Subscription or Fee Access

Query Extraction using Natural Language Processing

Ashish Tamrakar, Deepty Dubey

Abstract


Motivating change has come in Natural language processing (NLP) has seen in both research direction and methodology in the past several years. Improved work in computational linguistics tended to focus on purely symbolic methods. Now various work is shifting toward hybrid methods that combine new empirical corpus-based methods, including the use of probabilistic and information theoretic techniques, with traditional symbolic methods. Need of Natural Language Query Processing is for an English sentence to be interpreted by the computer and appropriate action taken. Question answering to any databases in natural language is a very convenient and easy method of data access, especially for casual users who do not understand complicated database query languages such as SQL So this paper proposes the architecture for translating English Query into SQL using Semantic Grammar.

Keywords


NLP (Natural Language Processing), AI (Artificial Intelligence), Morphology, Phonetic Rules, Syntactic, Semantic.

Full Text:

PDF

References


Huangi,Guiang Zangi, Phillip C-Y Sheu “A Natural Language database Interface based on probabilistic context free grammar”, IEEE International workshop on Semantic Computing and Systems 2008

Akama, S. (Ed.) Logic, language and computation, Kulwer Academic publishers, pp. 7-11, 1997.

ELF Software CO. Natural-Language Database Interfaces from ELF Software Co, cited November 1999, available from Internet: http://hometown.aol.com/elfsoft/

Hendrix, G.G., Sacerdoti, E.D., Sagalowicz, D., Slocum, J.

“Developing a natural language interface to complex data”, in ACM Transactions on database systems, 3(2), pp. 105- 147, 1978.

Joseph, S.W., Aleliunas, R. “A knowledge-based subsystem for a natural language interface to a database that predicts and explains query failures”, in IEEE CH, pp. 80-87, 1991.

Mitrovic, A. A knowledge-based teaching system for SQL, University of Canterbury, 1998. Moore, J.D. “Discourse generation for instructional applications: making computer tutors more like humans”, in Proceedings AI-ED, pp.36-42, 1995.

Suh, K.S., Perkins, W.C., “The effects of a system echo in a restricted natural language database interface for novice users”, in IEEE System sciences, 4, pp. 594-599, 1994.

Whenhua, W., Dilts, D.M. “Integrating diverse CIM data bases: the role of natural language interface”, in IEEE Transactions on systems, man, and cybernetics, 22(6), pp. 1331-1347, 1992.

Dan Klein, Christopher D. Manning: Corpus-Based Induction of Syntactic Structure: Models of Dependency and Constituency. ACL 2004: 478-485.

In-Su Kang, Jae-Hak J. Bae, Jong-Hyeok Lee “Database Semantics Representation for Natural Language Access.” Department of Computer Science and Engineering, Electrical and Computer Engineering Division Pohang University of Science and Technology (POSTECH) and Advanced Information Technology Research Center (AITrc), 2002.

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.

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.

Linguistic Technology. English Wizard – Dictionary Administrator's Guide. Linguistic Technology Corp., Littleton, MA, USA, 1997.

Dan Klein, Christopher D. Manning: Corpus-Based Induction of Syntactic Structure: Models of Dependency and Constituency. ACL 2004: 478-485.

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.

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.

Marie-Catherine de Marneffe, Bill MacCartney, and Christopher D. Manning. Generating Typed Dependency Parses from Phrase Structure Parses. In LREC 2006.


Refbacks

  • There are currently no refbacks.


Creative Commons License
This work is licensed under a Creative Commons Attribution 3.0 License.