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
Información del item - Informació de l'item - Item information
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:
Files in This Item:
File Description SizeFormat 
ThumbnailLujan-Mora_etal_2006_DataKnowledgeEng_preprint.pdfPreprint (acceso abierto)1,45 MBAdobe PDFOpen Preview
ThumbnailLujan-Mora_etal_2006_DataKnowledgeEng_final.pdfVersión final (acceso restringido)3,21 MBAdobe PDFOpen    Request a copy

Items in RUA are protected by copyright, with all rights reserved, unless otherwise indicated.