Towards Multidimensional Requirement Design

  • Estella Annoni
  • Franck Ravat
  • Olivier Teste
  • Gilles Zurfluh
Part of the Lecture Notes in Computer Science book series (LNCS, volume 4081)


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.


Data Warehouse Conceptual Schema Requirement Analysis Tabular Representation User Vision 
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.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Bruckner, R., List, B., Schiefer, J.: Developping requirements for data warehouse systems with use cases. AMCIS (1999)Google Scholar
  2. 2.
    Kimball, R.: The data warehouse toolkit: practical techniques for building dimensional data warehouses. John Wiley & Sons, Inc., New York (1996)Google Scholar
  3. 3.
    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)Google Scholar
  4. 4.
    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)CrossRefGoogle Scholar
  5. 5.
    Luján-Mora, S., Trujillo, J.: A comprehensive method for data warehouse design. In: DMDW (2003)Google Scholar
  6. 6.
    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)Google Scholar
  7. 7.
    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)CrossRefGoogle Scholar
  8. 8.
    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)CrossRefGoogle Scholar
  9. 9.
    Vassiliadis, P., Simitsis, A., Skiadopoulos, S.: Conceptual modeling for etl processes. In: Theodoratos, D. (ed.) DOLAP, pp. 14–21. ACM Press, New York (2002)Google Scholar
  10. 10.
    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),
  11. 11.
    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)Google Scholar
  12. 12.
    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)CrossRefGoogle Scholar
  13. 13.
    Pedersen, T.B., Jensen, C.S.: Multidimensional data modeling for complex data. In: ICDE, pp. 336–345. IEEE Computer Society Press, Los Alamitos (1999)Google Scholar
  14. 14.
    Annoni, E.: ebipad: Outil de developpement des systemes d’information decisionnels. Technical Report IRIT/RR-2006-12-FR (2006)Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2006

Authors and Affiliations

  • Estella Annoni
    • 1
  • Franck Ravat
    • 1
  • Olivier Teste
    • 1
  • Gilles Zurfluh
    • 1
  1. 1.IRIT-SIG Institute (UMR 5505)University of Paul SabatierTOULOUSE

Personalised recommendations