Abstract
In strategic decision-making, the decision maker needs to exploit the strategic information provided by decision support systems (DSS) and the strategic external information emanating from the enterprise business environment. The data warehouse (DW) is the main component of a data-driven DSS. In the field of DW design, many approaches exist but ignore external information and focus only on internal information coming from the operational sources. The existing approaches do not provide any instrument to take into account external information. In this paper, our objective is to introduce two models that will be employed in our approach: the requirement model and the environment model. These models are the basis of our DW design approach that supports external information. To evaluate the requirement model, we will illustrate with an example how to obtain external information useful for decision-making.
Chapter PDF
Similar content being viewed by others
References
Kimball, R., Ross, M.: The data warehouse lifecycle toolkit. John Wiley & Sons (2002)
Inmon, W.H.: Building the data warehouse. John wiley & sons (1996)
Golfarelli, M., Maio, D., Rizzi, S.: The dimensional fact model: a conceptual model for data warehouses. International Journal of Cooperative Information Systems 7, 215–247 (1998)
Hüsemann, B., Lechtenbörger, J., Vossen, G.: Conceptual data warehouse design. Universität Münster. Angewandte Mathematik und Informatik (2000)
Winter, R., Strauch, B.: A method for demand-driven information requirements analysis in data warehousing projects. In: Proceedings of the 36th Annual Hawaii International Conference on System Sciences, p. 9. IEEE (2003)
Boukrara, A., Chalal, R.: Specification of useful information for the strategic decision support: risks-based approach. International Journal of Decision Sciences, Risk and Management 4, 276–293 (2012)
Böhnlein, M., Ulbrich-vom Ende, A.: Business process oriented development of data warehouse structures. In: Data Warehousing, pp. 3–21. Springer (2000)
Bonifati, A., Cattaneo, F., Ceri, S., Fuggetta, A., Paraboschi, S.: Designing data marts for data warehouses. ACM Transactions on Software Engineering and Methodology 10, 452–483 (2001)
Bruckner, R., List, B., Scheifer, J.: Developing requirements for data warehouse systems with use cases. In: AMCIS Proceedings, p. 66 (2001)
Schiefer, J., List, B., Bruckner, R.: A holistic approach for managing requirements of data warehouse systems. In: AMCIS Proceedings, p. 13 (2002)
Paim, F.R.S., de Castro, J.F.B.: DWARF: An approach for requirements definition and management of data warehouse systems. In: Proceedings of 11th IEEE International Requirements Engineering Conference, pp. 75–84. IEEE (2003)
Gam, I., Salinesi, C.: A requirement-driven approach for designing data warehouses. In: Proceedings of Requirements Engineering: Foundation for Software Quality (REFSQ) (2006)
Prakash, N., Gosain, A.: An approach to engineering the requirements of data warehouses. Requirements Engineering 13, 49–72 (2008)
Giorgini, P., Rizzi, S., Garzetti, M.: GRAnD: A goal-oriented approach to requirement analysis in data warehouses. Decision Support Systems 45, 4–21 (2008)
Mazón, J.-N., Pardillo, J., Trujillo, J.: A model-driven goal-oriented requirement engineering approach for data warehouses. In: Hainaut, J.-L., et al. (eds.) ER Workshops 2007. LNCS, vol. 4802, pp. 255–264. Springer, Heidelberg (2007)
Bresciani, P., Perini, A., Giorgini, P., Giunchiglia, F., Mylopoulos, J.: Tropos: An agent-oriented software development methodology. Autonomous Agents and Multi-Agent Systems 8, 203–236 (2004)
Yu, E.S.-K.: Modelling strategic relationships for process reengineering. University of Toronto (1995)
Luján-Mora, S., Trujillo, J., Song, I.-Y.: A UML profile for multidimensional modeling in data warehouses. Data & Knowledge Engineering 59, 725–769 (2006)
Cravero Leal, A., Mazón, J.N., Trujillo, J.: A business-oriented approach to data warehouse development. Ingeniería e Investigación 33, 59–65 (2013)
Maté, A., Trujillo, J., Eric, S.: Aligning Data Warehouse Requirements with Business Goals. In: iStar, pp. 67–72 (2013)
Barone, D., Yu, E., Won, J., Jiang, L., Mylopoulos, J.: Enterprise modeling for business intelligence. In: van Bommel, P., Hoppenbrouwers, S., Overbeek, S., Proper, E., Barjis, J. (eds.) PoEM 2010. LNBIP, vol. 68, pp. 31–45. Springer, Heidelberg (2010)
Horkoff, J., Barone, D., Jiang, L., Yu, E., Amyot, D., Borgida, A., Mylopoulos, J.: Strategic business modeling: representation and reasoning. Softw. Syst. Model. 13, 1015–1041 (2014)
Golfarelli, M.: From User Requirements to Conceptual Design in Data Warehouse Design. In: Data Warehousing Design and Advanced Engineering Applications: Methods for Complex Construction (2010)
Porter, M.E.: Competitive Strategy: Techniques for Analyzing Industries and Companies. Free Press (1980)
Chalal, R., Boukrara, A., Saddok, M., Guiri, S.: A model for the aquisition of competitor information for strategic decision support. In: ISKO-France (2013)
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2015 IFIP International Federation for Information Processing
About this paper
Cite this paper
Chouder, M.L., Chalal, R., Setra, W. (2015). Requirement Analysis in Data Warehouses to Support External Information. In: Amine, A., Bellatreche, L., Elberrichi, Z., Neuhold, E., Wrembel, R. (eds) Computer Science and Its Applications. CIIA 2015. IFIP Advances in Information and Communication Technology, vol 456. Springer, Cham. https://doi.org/10.1007/978-3-319-19578-0_20
Download citation
DOI: https://doi.org/10.1007/978-3-319-19578-0_20
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-19577-3
Online ISBN: 978-3-319-19578-0
eBook Packages: Computer ScienceComputer Science (R0)