Ver todos los resumenes/See all abstracts

Ver todas las publicaciones (sin resumenes)/See all publications (without abstracts)

Claves:

URL     Documento / Document     Presentación / Slides

Año/Year 2004:

Clave: CI  Ref: ER'04 Sergio Luján-Mora, Panos Vassiliadis, Juan Trujillo. Data Mapping Diagrams for Data Warehouse Design with UML. 23rd International Conference on Conceptual Modeling (ER 2004), p. 191-204: Lecture Notes in Computer Science 3288, Shanghai (China), November 8-12 2004. https://doi.org/10.1007/978-3-540-30464-7_16 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 attempt to provide complementary views of the design artifacts in different levels of detail, our framework is based on a principled approach in the usage of UML packages, to allow zooming in and out the design of a scenario.