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...

• Type: Conference
• Year: 2004
• Where: ER
• Authors: Sergio Luján-Mora, Panos Vassiliadis, Juan Trujillo
• Keywords: Attribute Level, Different Levels, ER 2004, Heterogeneous Operational Data