Welcome to the InfoSci Platform
Applying UML for Modeling the Physical Design of Data Warehouses

Applying UML for Modeling the Physical Design of Data Warehouses

Sergio Luján-Mora, Juan Trujillo
Copyright: © 2007 |Pages: 45
ISBN13: 9781599042893|ISBN10: 1599042894|ISBN13 Softcover: 9781616927707|EISBN13: 9781599042916
DOI: 10.4018/978-1-59904-289-3.ch003
Cite Chapter Cite Chapter

MLA

Luján-Mora, Sergio, and Juan Trujillo. "Applying UML for Modeling the Physical Design of Data Warehouses." Contemporary Issues in Database Design and Information Systems Development, edited by Keng Siau, IGI Global, 2007, pp. 55-99. https://doi.org/10.4018/978-1-59904-289-3.ch003

APA

Luján-Mora, S. & Trujillo, J. (2007). Applying UML for Modeling the Physical Design of Data Warehouses. In K. Siau (Ed.), Contemporary Issues in Database Design and Information Systems Development (pp. 55-99). IGI Global. https://doi.org/10.4018/978-1-59904-289-3.ch003

Chicago

Luján-Mora, Sergio, and Juan Trujillo. "Applying UML for Modeling the Physical Design of Data Warehouses." In Contemporary Issues in Database Design and Information Systems Development, edited by Keng Siau, 55-99. Hershey, PA: IGI Global, 2007. https://doi.org/10.4018/978-1-59904-289-3.ch003

Export Reference

Mendeley
Favorite

Abstract

In previous work, we have shown how to use unified modeling language (UML) as the primary representation mechanism to model conceptual design, logical design, modeling of extraction, transformation, loading (ETL) processes, and defining online analytical processing (OLAP) requirements of data warehouses (DW). Continuing our work on using UML throughout the DW development lifecycle, in this 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.

Request Access

You do not own this content. Please login to recommend this title to your institution's librarian or purchase it from the IGI Global bookstore.