Physical Data Warehouse Design

  • Alejandro Vaisman
  • Esteban Zimányi
Part of the Data-Centric Systems and Applications book series (DCSA)


The physical design of data warehouses is crucial to ensure adequate query response time. There are typically three common techniques for improving performance in data warehouse systems: materialized views, indexing, and partitioning. A materialized view is a view that is physically stored in a database, which enhances query performance by precalculating costly operations such as joins and aggregations. With respect to indexing, traditional techniques used in OLTP systems are not appropriate for multidimensional data. Thus, alternative indexing mechanisms are used in data warehouses, typically bitmap and join indexes. Finally, partitioning or fragmentation divides the contents of a relation into several files, typically based on a range of values of an attribute.


Data Warehouse Data Cube Analysis Service Query Performance Measure Group 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Springer-Verlag Berlin Heidelberg 2014

Authors and Affiliations

  • Alejandro Vaisman
    • 1
  • Esteban Zimányi
    • 2
  1. 1.Instituto Tecnológico de Buenos AiresBuenos AiresArgentina
  2. 2.Université Libre de BruxellesBrusselsBelgium

Personalised recommendations