Abstract
Writing Online Analytical Processing (OLAP) queries for data warehouses is a complex and skill requiring task especially for the novel users. The situation becomes more critical when a low skilled person wants to access or analyze his business data from a data warehouse. These scenarios require more expertise and skills in terms of understanding and writing the accurate and functional queries. However, these complex tasks can be simplified by providing an easy interface to the users. In order to resolve all such issues, automated software tool is needed, which facilitates both users and software engineers. In this paper we present a novel approach with name QueGen (Query Generator) that generates OLAP queries based on the specification provided in natural English language. Users need to write the requirements in simple English in a few statements. After a semantic analysis and mapping of associated information, QueGen generates the intended OLAP queries that can be executed directly on data warehouses. An experimental study has been conducted to analyze the performance and accuracy of proposed tool.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Inmon, W.H.: Building the Data Warehouse. John Wiley (1992)
Allen, J.: Natural Language Understanding. Benjamin- Cummings Publishing Company, New York (1994)
Biber, D., Conrad, S., Reppen, R.: Corpus Linguistics: Investigating Language Structure and Use. Cambridge Univ. Press, Cambridge (1998)
DeHaan, D., Toman, D., Consens, M.P., Ozsu, T.: A Comprehensive XQuery to SQL Translation using Dynamic Interval Encoding. In: SIGMOD (2003)
Kuchmann-Beauger, N., Aufaure, M.-A.: A Natural Language Interface for Data Warehouse Question Answering. In: Muñoz, R., Montoyo, A., Métais, E. (eds.) NLDB 2011. LNCS, vol. 6716, pp. 201–208. Springer, Heidelberg (2011)
Object Management Group. Semantics of Business vocabulary and Rules (SBVR) Standard v.1.0. Object Management Group (2008), http://www.omg.org/spec/SBVR/1.0/
Thompson, C.A., Mooney, R.J., Tang, L.R.: Learning to parse natural language database queries into logical form. In: Workshop on Automata Induction, Grammatical Inference and Language Acquisition (1997)
Zelle, J.M., Mooney, R.J.: Learning semantic grammars with constructive inductive logic programming. In: Proceedings of the 11th National Conference on Artificial Intelligence, pp. 817–822. AAAI Press/MIT Press, Washington, D.C (1993)
Losee, R.M.: Learning syntactic rules and tags with genetic algorithms for information retrieval and filtering: An empirical basis for grammatical rules. Information Processing and Management 32(2), 185–197 (1996a)
Manning, C.D., Schutze, H.: Foundations of Statistical Natural Language Processing. MIT Press, Cambridge (1999)
Partee, B.H., ter Meulen, A., Wall, R.E.: Mathematical Methods in Linguistics. Kluwer, Dordrecht (1990)
Manning, C.D.: Part-of-Speech Tagging from 97% to 100%: Is It Time for Some Linguistics? In: Gelbukh, A.F. (ed.) CICLing 2011, Part I. LNCS, vol. 6608, pp. 171–189. Springer, Heidelberg (2011)
Cer, D., Marneffe, M.C., Jurafsky, D., Manning, C.D.: Parsing to Stanford Dependencies: Trade-offs between speed and accuracy. In: Proceedings of LREC 2010 (2010)
Bajwa, I.S., Mumtaz, S., Naveed, M.S.: Database Interfacing using Natural Language Processing. European Journal of Scientific Research 20(4), 844–851 (2008)
Bajwa, I.S., Mumtaz, S., Samad, A.: Object Oriented Software Modeling using NLP Based Knowledge Extraction. European Journal of Scientific Research 32(3), 613–619 (2009)
Bajwa, I.S., Lee, M.G., Bordbar, B. Translating Natural Language Constraints to OCL. Journal of King Saud University - Computer and Information Sciences 24(2) (June 2012)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2012 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Naeem, M.A., Ullah, S., Bajwa, I.S. (2012). Interacting with Data Warehouse by Using a Natural Language Interface. In: Bouma, G., Ittoo, A., Métais, E., Wortmann, H. (eds) Natural Language Processing and Information Systems. NLDB 2012. Lecture Notes in Computer Science, vol 7337. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-31178-9_50
Download citation
DOI: https://doi.org/10.1007/978-3-642-31178-9_50
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-31177-2
Online ISBN: 978-3-642-31178-9
eBook Packages: Computer ScienceComputer Science (R0)