A UML based approach for modeling ETL processes in data warehouses

J Trujillo, S Luján-Mora - International Conference on Conceptual …, 2003 - Springer
Data warehouses (DWs) are complex computer systems whose main goal is to facilitate the
decision making process of knowledge workers. ETL (Extraction-Transformation-Loading) …

A UML profile for multidimensional modeling in data warehouses

S Luján-Mora, J Trujillo, IY Song - Data & knowledge engineering, 2006 - Elsevier
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 …

An MDA approach for the development of data warehouses

JN Mazón, J Trujillo - Decision Support Systems, 2008 - Elsevier
Different modeling approaches have been proposed to overcome every design pitfall of
different data warehouse (DW) components. However, most of them offer partial solutions …

YAM2: a multidimensional conceptual model extending UML

A Abelló, J Samos, F Saltor - Information Systems, 2006 - Elsevier
This paper presents a multidimensional conceptual Object-Oriented model for Data
Warehousing and OLAP tools, its structures, integrity constraints and query operations. It has …

Data mapping diagrams for data warehouse design with UML

S Luján-Mora, P Vassiliadis, J Trujillo - Conceptual Modeling–ER 2004 …, 2004 - Springer
Abstract In Data Warehouse (DW) scenarios, ETL (Extraction, Transformation, Loading)
processes are responsible for the extraction of data from heterogeneous operational data …

A systematic review on the definition of UML profiles

J Pardillo - Model Driven Engineering Languages and Systems …, 2010 - Springer
This article reports a systematic review on the definition of UML profiles in the research
literature. Several exploratory statistical analyses have been performed in order to …

Metrics for data warehouse conceptual models understandability

M Serrano, J Trujillo, C Calero, M Piattini - Information and Software …, 2007 - Elsevier
Due to the principal role of Data warehouses (DW) in making strategy decisions, data
warehouse quality is crucial for organizations. Therefore, we should use methods, models …

[PDF][PDF] Designing data warehouses: from business requirement analysis to multidimensional modeling

JN Mazón, J Trujillo, M Serrano, M Piattini - Rebnita, 2005 - academia.edu
Most of the data warehouse projects still fail because the final data warehouse does not
properly meet business goals. Designers start a data warehouse project with the conceptual …

Access control and audit model for the multidimensional modeling of data warehouses

E Fernández-Medina, J Trujillo, R Villarroel… - Decision Support …, 2006 - Elsevier
Due to the sensitive data contained in Data Warehouses (DW), it is essential to specify
security measures from the early stages of the DW design and enforce them. Traditional …

Developing secure data warehouses with a UML extension

E Fernández-Medina, J Trujillo, R Villarroel… - Information Systems, 2007 - Elsevier
Data Warehouses (DWs), Multidimensional (MD) Databases, and On-Line Analytical
Processing Applications are used as a very powerful mechanism for discovering crucial …