Sciweavers

ER
2004
Springer

Data Mapping Diagrams for Data Warehouse Design with UML

13 years 9 months ago
Data Mapping Diagrams for Data Warehouse Design with UML
Abstract. In Data Warehouse (DW) scenarios, ETL (Extraction, Transformation, Loading) processes are responsible for the extraction of data from heterogeneous operational data sources, their transformation (conversion, cleaning, normalization, etc.) and their loading into the DW. In this paper, we present a framework for the design of the DW back-stage (and the respective ETL processes) based on the key observation that this task fundamentally involves dealing with the specificities of information at very low levels of granularity including transformation rules at the attribute level. Specifically, we present a disciplined framework for the modeling of the relationships between sources and targets in different levels of granularity (including coarse mappings at the database and table levels to detailed inter-attribute mappings at the attribute level). In order to accomplish this goal, we extend UML (Unified Modeling Language) to model attributes as first-class citizens. In our atte...
Sergio Luján-Mora, Panos Vassiliadis, Juan
Added 01 Jul 2010
Updated 01 Jul 2010
Type Conference
Year 2004
Where ER
Authors Sergio Luján-Mora, Panos Vassiliadis, Juan Trujillo
Comments (0)