Applying UML for Modeling the Physical Design of Data Warehouses

Applying UML for Modeling the Physical Design of Data Warehouses

Sergio Luján-Mora (Universidad de Alicante, Spain) and Juan Trujillo (Universidad de Alicante, Spain)
DOI: 10.4018/978-1-59904-289-3.ch003
OnDemand PDF Download:
$37.50

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.

Complete Chapter List

Search this Book:
Reset
Table of Contents
Chapter 1
Mauri Leppänen
This chapter presents an ISD ontology, which aims to provide an integrated conceptualization of ISD through anchoring it upon a contextual approach.... Sample PDF
Towards an Ontology for Information Systems Development—A Contextual Approach
$37.50
Chapter 2
Raimundas Matulevicius, Patrick Heymans, Andreas L. Opdahl
Goal modeling is emerging as a central requirements engineering (RE) technique. Unfortunately, current goal-oriented languages are not interoperable... Sample PDF
Ontological Analysis of KAOS using Separation of References
$37.50
Chapter 3
Sergio Luján-Mora, Juan Trujillo
In previous work, we have shown how to use unified modeling language (UML) as the primary representation mechanism to model conceptual design... Sample PDF
Applying UML for Modeling the Physical Design of Data Warehouses
$37.50
Chapter 4
Wil M.P. van der Aalst, Mariska Netjes, Hajo A. Reijers
Business process management (BPM) systems provide a broad range of facilities to enact and manage operational business processes. Ideally, these... Sample PDF
Supporting the Full BPM Life-Cycle Using Process Mining and Intelligent Redesign
$37.50
Chapter 5
Pedro Nuno San-Bento Furtado
Some businesses generate giga or even terabytes of historical data that can be organized and analyzed for better decision making. This poses issues... Sample PDF
Efficient Placement and Processing in Shared-Nothing Data Warehouses
$37.50
Chapter 6
Colleen Cunningham, Il-Yeol Song
Customer relationship management (CRM) is a strategy that integrates concepts of knowledge management, data mining, and data warehousing in order to... Sample PDF
Factors Affecting Design Decisions for Customer Relationship Management Data Warehouses
$37.50
Chapter 7
Xuepeng Yin, Torben Bach Pedersen
In today’s OLAP systems, physically integrating fast-changing data, for example, stock quotes, into a cube is complex and time-consuming. This data... Sample PDF
Effective Processing of XML-Extended OLAP Queries Based on a Physical Algebra
$37.50
Chapter 8
Keng Siau, John Erickson, Lih Yunn Lee
An on-going and major problem faced by information systems developers and business users alike is reaching a clear and consensual understanding of... Sample PDF
Is There a Difference Between the Theoretical and Practical Complexity of UML?
$37.50
Chapter 9
Jeretta Horn Nord, G. Daryl Nord, Hongjiang Xu, Elizabeth S. Myrin
This chapter presents results from a large-scale survey of Australian CPA members regarding data quality. The research investigates and reports... Sample PDF
Data Quality: An Assessment
$37.50
Chapter 10
Nenad Jukic, Svetlozar Nestorov, Susan V. Vrbsky, Allen Parrish
In this chapter, we extend the multi-level secure (MLS) data model to include nonkey related cover stories so that key attributes can have different... Sample PDF
Cover Stories for Key Attributes—Expanded Database Access Control
$37.50
About the Contributors