A UML profile for multidimensional modeling in data warehouses
Please use this identifier to cite or link to this item:
http://hdl.handle.net/10045/105188
Title: | A UML profile for multidimensional modeling in data warehouses |
---|---|
Authors: | Luján-Mora, Sergio | Trujillo, Juan | Song, Il-Yeol |
Research Group/s: | Advanced deveLopment and empIrical research on Software (ALISoft) | Lucentia |
Center, Department or Service: | Universidad de Alicante. Departamento de Lenguajes y Sistemas Informáticos |
Keywords: | UML | Multidimensional modeling | Data warehouses | UML extension | UML profile |
Knowledge Area: | Lenguajes y Sistemas Informáticos |
Issue Date: | Dec-2006 |
Publisher: | Elsevier |
Citation: | Data & Knowledge Engineering. 2006, 59(3): 725-769. doi:10.1016/j.datak.2005.11.004 |
Abstract: | 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 database modeling. In the past few years, there have been some proposals, providing their own formal and graphical notations, for representing the main MD properties at the conceptual level. However, unfortunately none of them has been accepted as a standard for conceptual MD modeling. In this paper, we present an extension of the Unified Modeling Language (UML) using a UML profile. This profile is defined by a set of stereotypes, constraints and tagged values to elegantly represent main MD properties at the conceptual level. 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 avoid learning a new notation, and (ii) UML can be easily extended so that it can be tailored for a specific domain with concrete peculiarities such as the multidimensional modeling for data warehouses. Moreover, our proposal is Model Driven Architecture (MDA) compliant and we use the Query View Transformation (QVT) approach for an automatic generation of the implementation in a target platform. Throughout the paper, we will describe how to easily accomplish the MD modeling of DWs at the conceptual level. Finally, we show how to use our extension in Rational Rose for MD modeling. |
Sponsor: | This work has been partially supported by the METASIGN project (TIN2004-00779) from the Spanish Ministry of Education and Science, by the DADASMECA project (GV05/220) from the Regional Government of Valencia, and by the MESSENGER (PCC-03-003-1) and DADS (PBC-05-012-2) projects from the Regional Science and Technology Ministry of Castilla-La Mancha (Spain). |
URI: | http://hdl.handle.net/10045/105188 |
ISSN: | 0169-023X (Print) | 1872-6933 (Online) |
DOI: | 10.1016/j.datak.2005.11.004 |
Language: | eng |
Type: | info:eu-repo/semantics/article |
Rights: | © 2005 Elsevier B.V. |
Peer Review: | si |
Publisher version: | https://doi.org/10.1016/j.datak.2005.11.004 |
Appears in Collections: | INV - LUCENTIA - Artículos de Revistas INV - ALISoft - Artículos de Revistas |
Files in This Item:
File | Description | Size | Format | |
---|---|---|---|---|
Lujan-Mora_etal_2006_DataKnowledgeEng_preprint.pdf | Preprint (acceso abierto) | 1,45 MB | Adobe PDF | Open Preview |
Lujan-Mora_etal_2006_DataKnowledgeEng_final.pdf | Versión final (acceso restringido) | 3,21 MB | Adobe PDF | Open Request a copy |
Items in RUA are protected by copyright, with all rights reserved, unless otherwise indicated.