Modeling the Physical Design of Data Warehouses from a UML Specification

S. Luján-Mora and J. Trujillo (Spain)


data warehouses, configuration, deployment, component, UML, physical design


A Data Warehouse (DW) is a complex information system mainly used to support strategy decisions. During the last few years, several approaches have been proposed to model different aspects of a DW. However, few efforts have been dedicated to the modeling of the physical design (i.e. the physical structures that will host data together with their corresponding implementations) of a DW from the early stages of a DW project. In this paper, we present a pro posal for the modeling of the physical design of DWs by using the component diagrams and deployment diagrams of UML. With these diagrams, we can anticipate impor tant physical design decisions that may shorten the overall development time of a DW such as replicating dimension tables, vertical and horizontal partitioning of a fact table, the use of particular servers for certain ETL processes and so on. The approach presented in this paper complements our previous works for the conceptual and logical design of DWs, and therefore, to the best of our knowledge we pro vide the first global proposal, based on the Unified Model ing Language (UML), that allows us to cover all main de sign phases of DWs, from the conceptual modeling phase until the final implementation.

Important Links:

Go Back