Dimension hierarchies design from UML : generalizations and aggregations - Archive ouverte HAL
Communication Dans Un Congrès Année : 2001

Dimension hierarchies design from UML : generalizations and aggregations

Résumé

Data for decision-making applications are based on dimensions, such as time, customer, and product. These dimensions are naturally related by hierarchies. Hierarchies are crucial to multidimensional modeling. Defining hierarchies using star or snowflake schemas can be misleading, since they are not explicitly well-modeled. However, deriving them from conceptual UML or ER schemas is a non-trivial task since they have no direct equivalent in conceptual models. This paper focuses on the definition of multidimensional hierarchies. We present and illustrate rules for defining multidimensional hierarchies from UML schemas, especially based on aggregation and generalization hierarchies. The definition of hierarchies is part of a data warehouse design method based on the three usual modeling levels : conceptual, logical, and physical. The conceptual schema is based on the UML notation. The logical schema is represented using a unified pivot multidimensional model. The physical schema depends on the target ROLAP or MOLAP tool.

Dates et versions

hal-01124879 , version 1 (06-03-2015)

Identifiants

Citer

Jacky Akoka, Isabelle Comyn-Wattiau, Nicolas Prat. Dimension hierarchies design from UML : generalizations and aggregations. ER 2001 : International Conference on Conceptual Modeling, Nov 2001, Yokohama, Japan. pp.442-455, ⟨10.1007/3-540-45581-7_33⟩. ⟨hal-01124879⟩
100 Consultations
0 Téléchargements

Altmetric

Partager

More