Abstract
OLAP systems remain difficult to develop for two primary reasons. The first reason is that the REQ analysis step is typically overlooked [1]. The second reason is that, even when attention is accorded to this step, REQ are described from a too technical perspective for decision makers to understand and validate [2]. However, the lack of user involvement in the specification can easily lead to the failure of the project. To ensure the involvement of decision makers in REQ specification, two solutions are offered: non technical notations for OLAP REQ expression (cf., tabular format [3]) and approaches to assist decision makers in identifying their REQ (cf., goal-driven approaches with either a graphical notation [1] or SQL scenarios [4], reuse of MultiDimensional (MD) patterns representing generic OLAP REQ [5]). Despite the assistance they offer, the proposed REQ notations and specification approaches presume that the decision makers are familiar with the MD concepts and their relationships.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsReferences
Giorgini, P., Rizzi, S., Garzetti, M.: GRAnd: A goal-oriented approach to requirement analysis in data warehouses. Decision Support Systems 45(1), 4–21 (2007)
List, B., Scheifer, J., Tjoa, A.M.: Process-oriented requirement analysis supporting the data warehouse design process a use case driven approach. In: Ibrahim, M., Küng, J., Revell, N. (eds.) DEXA 2000. LNCS, vol. 1873, pp. 593–603. Springer, Heidelberg (2000)
Feki, J., Nabli, A., Ben-Abdallah, H., Gargouri, F.: An Automatic Data Warehouse Conceptual Design Approach. In: Encyclopedia of Data Warehousing and Mining, 2nd edn., John Wang edn. (2008) ISBN: 978-1-60566-010-3
Prakash, N., Gosain, A.: An approach to engineering the requirements of data warehouses. Journal of Requirements Eng (RE) 13(1), 49–72 (2008)
Ben-Abdallah, H., Feki, J., Ben Abdallah, M.: A Multidimensional Pattern based Approach for the Design of Data Marts. In: Advances in Data Warehousing and Mining Series, IGI Global. David Taniar edn., vol. 3, pp. 172–192 (2009) ISBN: 978-1-60566-232-9
Bargui, F., Feki, J., Ben-Abdallah, H.: A natural language approach for data mart schema design. In: Proc. of 9th Int. Arabic Conference on Information Technology (ACIT), Hammamet-Tunisia, December 16-18 (2008)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2010 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Bargui, F., Ben-Abdallah, H., Feki, J. (2010). A Hybrid Approach for Data Mart Schema Design from NL-OLAP Requirements. In: Horacek, H., Métais, E., Muñoz, R., Wolska, M. (eds) Natural Language Processing and Information Systems. NLDB 2009. Lecture Notes in Computer Science, vol 5723. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-12550-8_26
Download citation
DOI: https://doi.org/10.1007/978-3-642-12550-8_26
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-12549-2
Online ISBN: 978-3-642-12550-8
eBook Packages: Computer ScienceComputer Science (R0)