Abstract
Data warehouses (DW) main objective is to facilitating decision- making. Thus their development has to take into account DW project actor requirements. While much recent research has been focused on the design of multidimensional conceptual models, only few works were done to develop models and tools to analyze them. Despite specificities (OLAP, historicization, ...) of these requirements, most of the previous works used an E/R or UML schemas which do not allow designers to represent these specific principles. A main property of DW is that they are derived from existing data sources. Therefore, Extraction-Transformation-Loading (ETL) processes from these sources to the DW are very useful to define a reliable DW.
In this paper, we fill this gap by showing how to systematically derive a conceptual schema of actors requirements using a rule-based mechanism. We provide a conceptual model which tries to be close to user vision of data by extending an object-oriented multidimensional model. Hence, in the early step of DW engineering, designers can formalize actors requirements about information and ETL processes at the same time to make easier understandability, confrontation and validation by all DW actors.
This is a preview of subscription content, log in via an institution to check access.
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
References
Bruckner, R., List, B., Schiefer, J.: Developping requirements for data warehouse systems with use cases. AMCIS (1999)
Kimball, R.: The data warehouse toolkit: practical techniques for building dimensional data warehouses. John Wiley & Sons, Inc., New York (1996)
Annoni, E., Ravat, F., Teste, O., Zurfluh, G.: Les systèmes d’informations décisionnels: une approche d’analyse et de conception à base de patrons. revue RSTI srie ISI, Méthodes Avancées de Développement des SI 10(6) (2005)
Golfarelli, M., Rizzi, S.: Methodological framework for data warehouse design. In: DOLAP 1998, ACM First International Workshop on Data Warehousing and OLAP, Proceedings, Bethesda, Maryland, USA, November 7, 1998, pp. 3–9. ACM, New York (1998)
Luján-Mora, S., Trujillo, J.: A comprehensive method for data warehouse design. In: DMDW (2003)
Abelló, A., Samos, J., Saltor, F.: Yam2 (yet another multidimensional model): An extension of uml. In: Nascimento, M.A., Özsu, M.T., Zaïane, O.R. (eds.) IDEAS, pp. 172–181. IEEE Computer Society Press, Los Alamitos (2002)
Bonifati, A., Cattaneo, F., Ceri, S., Fuggetta, A., Paraboschi, S.: Designing data marts for data warehouses. ACM Trans. Softw. Eng. Methodol. 10(4), 452–483 (2001)
Giorgini, P., Rizzi, S., Garzetti, M.: Goal-oriented requirement analysis for data warehouse design. In: Song, I.Y., Trujillo, J. (eds.) DOLAP, pp. 47–56. ACM Press, New York (2005)
Vassiliadis, P., Simitsis, A., Skiadopoulos, S.: Conceptual modeling for etl processes. In: Theodoratos, D. (ed.) DOLAP, pp. 14–21. ACM Press, New York (2002)
Bouzeghoub, M., Fabret, F., Matulovic-Broqué, M.: Modeling the data warehouse refreshment process as a workflow application. In: Gatziu, S., Jeusfeld, M.A., Staudt, M., Vassiliou, Y. (eds.) DMDW. CEUR Workshop Proceedings, vol. 19, p. 6 (1999), CEUR-WS.org
Luján-Mora, S., Trujillo, J., Song, I.Y.: Extending the uml for multidimensional modeling. In: Jézéquel, J.-M., Hussmann, H., Cook, S. (eds.) UML 2002. LNCS, vol. 2460, pp. 290–304. Springer, Heidelberg (2002)
Luján-Mora, S., Vassiliadis, P., Trujillo, J.: Data mapping diagrams for data warehouse design with uml. In: Atzeni, P., Chu, W., Lu, H., Zhou, S., Ling, T.-W. (eds.) ER 2004. LNCS, vol. 3288, pp. 191–204. Springer, Heidelberg (2004)
Pedersen, T.B., Jensen, C.S.: Multidimensional data modeling for complex data. In: ICDE, pp. 336–345. IEEE Computer Society Press, Los Alamitos (1999)
Annoni, E.: ebipad: Outil de developpement des systemes d’information decisionnels. Technical Report IRIT/RR-2006-12-FR (2006)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2006 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Annoni, E., Ravat, F., Teste, O., Zurfluh, G. (2006). Towards Multidimensional Requirement Design. In: Tjoa, A.M., Trujillo, J. (eds) Data Warehousing and Knowledge Discovery. DaWaK 2006. Lecture Notes in Computer Science, vol 4081. Springer, Berlin, Heidelberg. https://doi.org/10.1007/11823728_8
Download citation
DOI: https://doi.org/10.1007/11823728_8
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-37736-8
Online ISBN: 978-3-540-37737-5
eBook Packages: Computer ScienceComputer Science (R0)