Abstract
Multidimensional modeling is nowadays recognized to best reflect the decision makers’ analytical view on data. In this paper, we address some modeling features that we believe existing multidimensional models do not fully cover, such as considering real life entities that are meant to be analyzed as complex objects, allowing for simple and complex measures, treating facts and dimension members equally and observing hierarchies within and between complex entities. We propose a layered multidimensional model based on the concept of complex object which encapsulates data and structure complexity and eases the creation and manipulation of complex data cubes. We need to define our model at three layers. The first layer class diagram describes complex objects and captures the hierarchical organization of their attributes. The second layer package of classes describes the multidimensional model as a set of complex objects that are connected by relationships and some of which are organized in hierarchies. The third layer package of packages describes complex cubes which are derived from the multidimensional model. We show the benefits and feasibility of our proposals through their implementation in a real-life case study.
Chapter PDF
Similar content being viewed by others
References
Abelló, A., Samos, J., Saltor, F.: A framework for the classification and description of multidimensional data models. In: Mayr, H.C., Lazanský, J., Quirchmayr, G., Vogel, P. (eds.) DEXA 2001. LNCS, vol. 2113, pp. 668–677. Springer, Heidelberg (2001)
Abelló, A., Samos, J., Saltor, F.: Understanding analysis dimensions in a multidimensional object-oriented model. In: Proceedings of the 3rd Intl. Workshop on Design and Management of Data Warehouses, DMDW 2001, Interlaken, Switzerland, June 4, p. 4 (2001)
Abelló, A., Samos, J., Saltor, F.: Yam2: a multidimensional conceptual model extending uml. Inf. Syst. 31(6), 541–567 (2006)
Blaschka, M., Sapia, C., Höfling, G., Dinter, B.: Finding your way through multidimensional data models. In: DEXA Workshop, pp. 198–203 (1998)
Boukraâ, D., Boussaid, O., Bentayeb, F., Zegour, D.E.: Modèle multidimensionnel d’objets complexes. du modèle d’objets aux cubes d’objets complexes. Ingénierie des Systèmes d’Information 16(6), 41–65 (2011)
Chaudhuri, S., Dayal, U.: An overview of data warehousing and olap technology. SIGMOD Record 26(1), 65–74 (1997)
Kimball, R.: The Data Warehouse Toolkit: Practical Techniques for Building Dimensional Data Warehouses. John Wiley (1996)
Pérez, M.A., Clemente, P.J.: 12th Workshop for PhD Students in Object-Oriented Systems. In: Hernández, J., Moreira, A. (eds.) ECOOP-WS 2002. LNCS, vol. 2548, pp. 44–54. Springer, Heidelberg (2002)
Luján-Mora, S., Trujillo, J., Song, I.-Y.: Multidimensional modeling with UML package diagrams. In: Spaccapietra, S., March, S.T., Kambayashi, Y. (eds.) ER 2002. LNCS, vol. 2503, pp. 199–213. Springer, Heidelberg (2002)
Nassis, V., Rajugan, R., Dillon, T.S., Rahayu, J.W.J.: Conceptual design of XML document warehouses. In: Kambayashi, Y., Mohania, M., Wöß, W. (eds.) DaWaK 2004. LNCS, vol. 3181, pp. 1–14. Springer, Heidelberg (2004)
Pedersen, T.B., Jensen, C.S.: Multidimensional data modeling for complex data. In: Proceedings of the 15th International Conference on Data Engineering, Sydney, Austrialia, March 23-26, pp. 336–345. IEEE Computer Society (1999)
Ravat, F., Teste, O., Tournier, R., Zurfluh, G.: Algebraic and graphic languages for olap manipulations. International Journal of Data Warehousing and Mining 4(1), 17–46 (2008)
Torlone, R.: Conceptual multidimensional models. In: Multidimensional Databases, pp. 69–90. IGI Publishing, Hershey (2003)
Trujillo, J.: The gold model: An oo multidimensional data model for multidimensional databases. In: Yu, H.-J., Demeyer, S. (eds.) ECOOP 1999 Workshops. LNCS, vol. 1743, pp. 24–30. Springer, Heidelberg (1999)
Trujillo, J., Palomar, M.: An object-oriented approach to multidimensional database conceptual modeling. In: ACM First International Workshop on Data Warehousing and OLAP (DOLAP 1998), Bethesda, Maryland, USA, pp. 16–21. ACM (1998)
Trujillo, J., Palomar, M.S., Gómez, J.: Applying object-oriented conceptual modeling techniques to the design of multidimensional databases and OLAP applications. In: Lu, H., Zhou, A. (eds.) WAIM 2000. LNCS, vol. 1846, pp. 83–94. Springer, Heidelberg (2000)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2013 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Boukraâ, D., Boussaïd, O., Bentayeb, F., Zegour, DE. (2013). A Layered Multidimensional Model of Complex Objects. In: Salinesi, C., Norrie, M.C., Pastor, Ó. (eds) Advanced Information Systems Engineering. CAiSE 2013. Lecture Notes in Computer Science, vol 7908. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-38709-8_32
Download citation
DOI: https://doi.org/10.1007/978-3-642-38709-8_32
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-38708-1
Online ISBN: 978-3-642-38709-8
eBook Packages: Computer ScienceComputer Science (R0)