PUBLICACIONES
Ver todos los resumenes/See all abstracts
Ver todas las publicaciones (sin resumenes)/See all publications (without abstracts) Claves:
BL | Blog | CI | Congreso internacional / International conference | CL | Capítulo de libro / Book chapter | CN | Congreso nacional / National conference | II | Informe interno / Internal report | LI | Libro / Book | RV | Revista / Journal |
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. | |
|