Logical Data Warehouse Design
- 5.1k Downloads
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).
KeywordsData Warehouse Dimension Table Data Cube Analysis Service Fact Table
Unable to display preview. Download preview PDF.