Logical Data Warehouse Design

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


Conceptual models are useful to design database applications since they favor the communication between the stakeholders in a project. However, conceptual models must be translated into logical ones for their implementation on a database management system. In this chapter, we study how the conceptual multidimensional model studied in the previous chapter can be represented in the relational model. We start in Sect. 5.1 by describing the three logical models for data warehouses, namely, relational OLAP (ROLAP), multidimensional OLAP (MOLAP), and hybrid OLAP (HOLAP).


Data Warehouse Dimension Table Data Cube Analysis Service Fact Table 
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