Authors: Il-Yeol Song, Juan Trujillo, Sergio Luján-Mora
Tags: 2005, conceptual modeling
The multidimensional (MD) modeling, which is the foundation of data warehouses (DWs), MD databases, and On-Line Analytical Processing (OLAP) applications, is based on several properties different from those in traditional databasemodeling. In the past few years, there have been some proposals, providing their own formal and graphical notations, forrepresenting the main MD properties at the conceptual level. However, unfortunately none of them has been accepted as astandard for conceptual MD modeling.In this paper, we present an extension of the Unified Modeling Language (UML) using a UML profile. This profile isdefined by a set of stereotypes, constraints and tagged values to elegantly represent main MD properties at the conceptuallevel. We make use of the Object Constraint Language (OCL) to specify the constraints attached to the defined stereotypes,thereby avoiding an arbitrary use of these stereotypes. We have based our proposal in UML for two main reasons:(i) UML is a well known standard modeling language known by most database designers, thereby designers can avoidlearning a new notation, and (ii) UML can be easily extended so that it can be tailored for a specific domain with concretepeculiarities such as the multidimensional modeling for data warehouses. Moreover, our proposal is Model Driven Archi-tecture (MDA) compliant and we use the Query View Transformation (QVT) approach for an automatic generation of theimplementation in a target platform. Throughout the paper, we will describe how to easily accomplish the MD modeling ofDWs at the conceptual level. Finally, we show how to use our extension in Rational Rose for MD modeling.Read the full paper here: https://reader.elsevier.com/reader/sd/pii/S0169023X0500176X?token=E78005AC0FC1FB4A38CBDA6F7E78E97DFFAF08AF6E30C490D0172978D8F6CC491C22C28DAF7BF4A2E08ED5E2AB513913
