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 2007:

Clave: CL  Ref: DDISD'07 Sergio Luján-Mora, Juan Trujillo. Applying UML for Modeling the Physical Design of Data Warehouses. In K. Siau (Ed.), Contemporany Issues in Database Design and Information Systems Development, p. 55-99 (chapter 3), Hershey, PA: IGI Publishing. ISBN: 978-159904289-3. https://doi.org/10.4018/978-1-59904-289-3.ch003 In previous work, we have shown how to use UML (Unified Modeling Language) as the primary representation mechanism to model conceptual design, logical design, modeling of ETL (Extraction, Transformation, Loading) processes, and defining OLAP (On-Line Analytical Processing) requirements of data warehouses (DW). Continuing our work on using UML throughout the DW development lifecycle, in this book chapter we present our modeling techniques of physical design of DW using component diagrams and deployment diagrams of UML. Our approach allows the DW designer to anticipate important physical design decisions that may reduce the overall development time of a DW such as replicating dimension tables, vertical and horizontal partitioning of a fact table, and the use of particular servers for certain ETL processes. We illustrate our techniques with a case study.