A Model-Driven Approach for Enforcing Summarizability in Multidimensional Modeling

  • Jose-Norberto Mazón
  • Jens Lechtenbörger
  • Juan Trujillo
Part of the Lecture Notes in Computer Science book series (LNCS, volume 6999)


The development of a data warehouse system is based on a conceptual multidimensional model, which provides a high level of abstraction in the accurate and expressive description of real-world situations. Once this model has been designed, the corresponding logical representation must be obtained as the basis of the implementation of the data warehouse according to one specific technology. However, there is a semantic gap between the dimension hierarchies modeled in a conceptual multidimensional model and its implementation. This gap particularly complicates a suitable treatment of summarizability issues, which may in turn lead to erroneous results from business intelligence tools. Therefore, it is crucial not only to capture adequate dimension hierarchies in the conceptual multidimensional model of the data warehouse, but also to correctly transform these multidimensional structures in a summarizability-compliant representation. A model-driven normalization process is therefore defined in this paper to address this summarizability-aware transformation of the dimension hierarchies in rich conceptual models.


Source Model Base Class Data Warehouse Target Model Fact Class 
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.
    Bodart, F., Patel, A., Sim, M., Weber, R.: Should optional properties be used in conceptual modelling? a theory and three empirical tests. Info. Sys. Research 12(4), 384–405 (2001)CrossRefGoogle Scholar
  2. 2.
    Lechtenbörger, J., Vossen, G.: Multidimensional normal forms for data warehouse design. Inf. Syst. 28(5), 415–434 (2003)CrossRefzbMATHGoogle Scholar
  3. 3.
    Lehner, W., Albrecht, J., Wedekind, H.: Normal forms for multidimensional databases. In: Rafanelli, M., Jarke, M. (eds.) SSDBM, pp. 63–72. IEEE Computer Society, Los Alamitos (1998)Google Scholar
  4. 4.
    Lenz, H.J., Shoshani, A.: Summarizability in OLAP and statistical data bases. In: Ioannidis, Y.E., Hansen, D.M. (eds.) SSDBM, pp. 132–143. IEEE Computer Society, Los Alamitos (1997)Google Scholar
  5. 5.
    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)CrossRefGoogle Scholar
  6. 6.
    Malinowski, E., Zimányi, E.: Hierarchies in a multidimensional model: From conceptual modeling to logical representation. Data Knowl. Eng. 59(2), 348–377 (2006)CrossRefGoogle Scholar
  7. 7.
    Malinowski, E., Zimányi, E.: Advanced data warehouse design: From conventional to spatial and temporal applications. Springer, Heidelberg (2008)zbMATHGoogle Scholar
  8. 8.
    Mazón, J.N., Lechtenbörger, J., Trujillo, J.: Solving summarizability problems in fact-dimension relationships for multidimensional models. In: Song, I.Y., Abelló, A. (eds.) DOLAP, pp. 57–64. ACM, New York (2008)CrossRefGoogle Scholar
  9. 9.
    Mazón, J.N., Lechtenbörger, J., Trujillo, J.: A survey on summarizability issues in multidimensional modeling. Data Knowl. Eng. 68(12), 1452–1469 (2009)CrossRefGoogle Scholar
  10. 10.
    Pedersen, T.B., Jensen, C.S., Dyreson, C.E.: Extending practical pre-aggregation in on-line analytical processing. In: VLDB, pp. 663–674 (1999)Google Scholar
  11. 11.
    Pedersen, T.B., Jensen, C.S., Dyreson, C.E.: A foundation for capturing and querying complex multidimensional data. Inf. Syst. 26(5), 383–423 (2001)CrossRefzbMATHGoogle Scholar
  12. 12.
    Rafanelli, M., Shoshani, A.: STORM: A statistical object representation model. In: Michalewicz, Z. (ed.) SSDBM 1990. LNCS, vol. 420, pp. 14–29. Springer, Heidelberg (1990)CrossRefGoogle Scholar
  13. 13.
    Rizzi, S., Abelló, A., Lechtenbörger, J., Trujillo, J.: Research in data warehouse modeling and design: dead or alive? In: Song, I.Y., Vassiliadis, P. (eds.) DOLAP, pp. 3–10. ACM, New York (2006)Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2011

Authors and Affiliations

  • Jose-Norberto Mazón
    • 1
  • Jens Lechtenbörger
    • 2
  • Juan Trujillo
    • 1
  1. 1.Lucentia, Dept. of Software and Computing SystemsUniversity of AlicanteSpain
  2. 2.Dept. of Information SystemsUniversity of MünsterGermany

Personalised recommendations