Skip to Main content Skip to Navigation
Conference papers

From UML to ROLAP multidimensional databases using a pivot model

Abstract : Effective data warehouse design requires a conceptual modeling phase. This paper describes a data warehouse design method based on the conceptual, logical and physical levels. The conceptual phase creates an UML model. To this end, UML is enriched with multidimensional concepts. The logical phase maps the enriched UML model into a multidimensional one. The physical phase maps the multidimensional model into a database schema, depending on the target ROLAP or MOLAP tool. Our method consists in (1) the metamodels used at each design step, including the unified multidimensional metamodel (2) a set of transformations defined on the concepts of these metamodels, facilitating the design process. We present the metamodels and transformations, and illustrate the formal specification of the transformations with OMG’s Object Constraint Language (OCL). We apply our method to a case study and compare it to the state-of-the-art.
Document type :
Conference papers
Complete list of metadata

https://hal.archives-ouvertes.fr/hal-01124886
Contributor : Laboratoire Cedric Connect in order to contact the contributor
Submitted on : Friday, March 6, 2015 - 10:51:32 AM
Last modification on : Tuesday, October 12, 2021 - 2:48:04 PM

Identifiers

  • HAL Id : hal-01124886, version 1

Citation

Nicolas Prat, Jacky Akoka. From UML to ROLAP multidimensional databases using a pivot model. BDA 2002 : 18èmes Journées Bases de Données Avancées, Oct 2002, Evry, France. pp.24. ⟨hal-01124886⟩

Share

Metrics

Record views

73