Abstract
Business Intelligence (BI) systems help organisations to monitor the fulfillment of business goals by means of tracking various Key Performance Indicators (KPIs). Data Warehouses (DWs) supply data to compute KPIs and therefore, are an important component of any BI system. While designing a DW to monitor KPIs, the following two important questions arise: (1) What data should be stored in a DW to measure a KPI, and (2) how the data should be modelled in a DW? We present a model-based Requirement Engineering (RE) framework to answer these questions. Our proposal consists of two major modelling components, namely, the context modelling component which is used to represent why and which data is required, and data modelling component which is used to model data as a multidimensional model.
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
References
Bonifati, A., Cattaneo, F.: Designing data marts for data warehouses. ACM Trans. Softw. Eng. Methodol. 10(4), 452–483 (2001)
Chowdhary, P., Mihaila, G., Lei, H.: Model driven data warehousing for business performance management. In: Proceedings of the IEEE International Conference on e-Business, Engineering, pp. 483–487 (2006)
Frendi, M., Salinesi, C.: Requirements engineering for data warehousing. In Proceedings of Workshop on RE: Foundation for Software Quality, pp. 75–82 (2003)
Gallardo, J., Giacaman, G., Meneses, C., Marbán, Ó.: Framework for decisional business and requirements modeling in data mining projects. In: Corchado, E., Yin, H. (eds.) IDEAL 2009. LNCS, vol. 5788, pp. 268–275. Springer, Heidelberg (2009). https://doi.org/10.1007/978-3-642-04394-9_33
Giorgini, C., Jazayeri, M., Mandrioli, D.: GRAnD: a goal-oriented approach to requirement analysis in data warehouses. Decis. Support Syst. 45(1), 4–21 (2008)
Horkoff, J., Barone, D., Jiang, L., Yu, E., Amyot, D., Borgida, A., Mylopoulos, J.: Strategic business modeling: representation and reasoning. Softw. Syst. Model. 13(3), 1015–1041 (2014)
Kimball, R.: The Data Warehouse Lifecycle Toolkit: Expert Methods for Designing, Developing, and Deploying Data Warehouses. Wiley, New York (1998)
Kimball, R., Ross, M.: The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling. Wiley, New York (2011)
Malinowski, E., Zimányi, E.: Requirements specification and conceptual modeling for spatial data warehouses. In: Meersman, R., Tari, Z., Herrero, P. (eds.) OTM 2006. LNCS, vol. 4278, pp. 1616–1625. Springer, Heidelberg (2006). https://doi.org/10.1007/11915072_68
Maté, A., Trujillo, J., Mylopoulos, J.: Conceptualizing and specifying key performance indicators in business strategy models. In: Proceedings of the Conference on the Center for Advanced Studies on Collaborative Research, pp. 102–115. IBM Corp. (2012)
Mazón, J., Trujillo, J., Lechtenbörger, J.: Reconciling requirement-driven data warehouses with data sources via multidimensional normal forms. Data Knowl. Eng. 63(3), 725–751 (2007)
Nasiri, A., Wrembel, R., Zimányi, E.: Model-based requirements engineering for data warehouses: From multidimensional modelling to KPI monitoring. In: Jeusfeld, M., Karlapalem, K. (eds.) Proceedings of International Workshop on Conceptual Modeling. LNCS, vol. 9382, pp. 198–209. Springer, Cham (2015). https://doi.org/10.1007/978-3-319-25747-1_20
Nasiri, A., Zimányi, E., Wrembel, R.: Requirements engineering for data warehouses. In: Proceedings of the Conference on Journes francophones sur les Entrepts de Donnes et l’Analyse en ligne, EDA, pp. 49–64 (2015)
Pardillo, J., Mazón, J., Trujillo, J.: Extending OCL for OLAP querying on conceptual MD models of DWs. Inf. Sci. 180(5), 584–601 (2010)
Vaisman, I., Zimányi, E.: DW Systems: Design and Implementation. Springer, Heidelberg (2014)
Winter, R., Strauch, B.: Information requirements engineering for data warehouse systems. In: ACM Symposium on Applied, Computing, pp. 1359–1365 (2004)
Yu, E.: Towards modelling and reasoning support for early-phase requirements engineering. In: Proceedings of IEEE International Conference on Requirements Engineering, pp. 226–235 (1997)
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2017 Springer International Publishing AG
About this paper
Cite this paper
Nasiri, A., Ahmed, W., Wrembel, R., Zimányi, E. (2017). Requirements Engineering for Data Warehouses (RE4DW): From Strategic Goals to Multidimensional Model. In: de Cesare, S., Frank, U. (eds) Advances in Conceptual Modeling. ER 2017. Lecture Notes in Computer Science(), vol 10651. Springer, Cham. https://doi.org/10.1007/978-3-319-70625-2_13
Download citation
DOI: https://doi.org/10.1007/978-3-319-70625-2_13
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-70624-5
Online ISBN: 978-3-319-70625-2
eBook Packages: Computer ScienceComputer Science (R0)