Abstract
The development of a data warehouse has been traditionally guided by an in-depth analysis of the underlying operational data sources, thus overlooking an explicit development phase in which information requirements of decision makers are addressed. This scenario has prompted that the deployed data warehouse often fails in delivering the expected support of the decision making process. To overcome this problem, we propose to use the i* modeling framework and the model driven architecture (MDA) in order to describe (i) how to model goals and information requirements for data warehouses, and (ii) how to derive a conceptual multidimensional model that provides the required information to support the decision making process.
This work has been partially supported by the METASIGN (TIN2004-00779) project and by the FPU grants AP2005-1360 and AP2006-00332 from the Spanish Ministry of Education and Science, and by the DADS (PBC-05-012-2) project from the Castilla-La Mancha Ministry of Education and Science (Spain).
Access provided by Autonomous University of Puebla. Download to read the full chapter text
Chapter PDF
Similar content being viewed by others
Keywords
- Business Process
- Data Warehouse
- Information Requirement
- Model Drive Architecture
- Model Drive Architecture
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.
References
Kimball, R., Ross, M.: The Data Warehouse Toolkit. Wiley & Sons, Chichester (2002)
Inmon, W.: Building the Data Warehouse. Wiley & Sons, Chichester (2002)
Schiefer, J., List, B., Bruckner, R.: A holistic approach for managing requirements of data warehouse systems. In: Americas Conf. on Information Systems, pp. 77–87 (2002)
Winter, R., Strauch, B.: A method for demand-driven information requirements analysis in data warehousing projects. In: HICSS (2003)
Prakash, N., Singh, Y., Gosain, A.: Informational scenarios for data warehouse requirements elicitation. In: Atzeni, P., Chu, W., Lu, H., Zhou, S., Ling, T.-W. (eds.) ER 2004. LNCS, vol. 3288, pp. 205–216. Springer, Heidelberg (2004)
Rizzi, S., Abelló, A., Lechtenbörger, J., Trujillo, J.: Research in data warehouse modeling and design: dead or alive? In: DOLAP, pp. 3–10 (2006)
OMG: Unified Modeling Language Specification 2.0, http://www.omg.org/cgi-bin/doc?formal/05-07-04
Yu, E.: Modelling Strategic Relationships for Process Reenginering. PhD thesis, University of Toronto, Canada (1995)
Yu, E.: Towards modeling and reasoning support for early-phase requirements engineering. In: RE 1997, pp. 226–235 (1997)
Mazón, J.N., Trujillo, J., Serrano, M., Piattini, M.: Designing data warehouses: from business requirement analysis to multidimensional modeling. In: REBNITA (2005)
Chenoweth, T., Corral, K., Demirkan, H.: Seven key interventions for data warehouse success. Commun. ACM 49(1), 114–119 (2006)
Gam, I., Salinesi, C.: A requirement-driven approach for designing data warehouses. In: REFSQ (2006)
OMG: MDA Guide 1.0.1, http://www.omg.org/cgi-bin/doc?omg/03-06-01
Mazón, J.N., Trujillo, J.: An MDA approach for the development of data warehouses. Decision Support Systems doi:10.1016/j.dss.2006.12.003
OMG: MOF 2.0 Query/View/Transformation, http://www.omg.org/cgi-bin/doc?ptc/2005-11-01
Paim, F.R.S., Castro, J.: DWARF: An approach for requirements definition and management of data warehouse systems. In: RE 2003, pp. 75–84 (2003)
Giorgini, P., Rizzi, S., Garzetti, M.: Goal-oriented requirement analysis for data warehouse design. In: DOLAP 2005, pp. 47–56 (2005)
Stefanov, V., List, B.: Business metadata for the datawarehouse - weaving enterprise goals and multidimensional models. In: EDOC 2006 Workshops (2006)
Romero, O., Abelló, A.: Multidimensional design by examples. In: Tjoa, A.M., Trujillo, J. (eds.) DaWaK 2006. LNCS, vol. 4081, pp. 85–94. Springer, Heidelberg (2006)
van Lamsweerde, A.: Goal-oriented requirements enginering: A roundtrip from research to practice. In: RE 2004, pp. 4–7 (2004)
Luján-Mora, S., Trujillo, J., Song, I.Y.: A UML profile for multidimensional modeling in data warehouses. Data Knowl. Eng. 59(3), 725–769 (2006)
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 2007 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Mazón, JN., Pardillo, J., Trujillo, J. (2007). A Model-Driven Goal-Oriented Requirement Engineering Approach for Data Warehouses. In: Hainaut, JL., et al. Advances in Conceptual Modeling – Foundations and Applications. ER 2007. Lecture Notes in Computer Science, vol 4802. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-76292-8_31
Download citation
DOI: https://doi.org/10.1007/978-3-540-76292-8_31
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-76291-1
Online ISBN: 978-3-540-76292-8
eBook Packages: Computer ScienceComputer Science (R0)