Page 33 - DCAP606_BUSINESS_INTELLIGENCE

Business Intelligence Sartaj Singh, Lovely Professional University

Notes Unit 3: Dimensional Data Warehouse

CONTENTS
Objectives
Introduction

3.1 Dimensional Model
3.2 Facts Table
3.2.1 Types of Measure

3.2.2 Types of Fact Table
3.3 Dimension Tables
3.4 Surrogate Keys and Alternative Table Structure
3.4.1 Advantages of Surrogate Keys
3.4.2 Disadvantages of Surrogate Keys

3.4.3 Alternative Tables used in Data Warehousing
3.5 Multidimensional OLAP
3.5.1 MOLAP

3.5.2 ROLAP
3.5.3 HOLAP
3.6 Summary
3.7 Keywords
3.8 Review Questions

3.9 Further Readings

Objectives

After studying this unit, you will be able to:

Describe about Dimensional Model
Construct Facts Table
Demonstrate Dimension Tables
Discuss about Surrogate Keys and Alternative Table Structure

Explain Multidimensional OLAP
Introduction

Dimensions are a common way of analysing data. Dimension model comprises of a fact table
and numerous dimensional tables and is used for assessing summarized data. Dimensional data
modelling is the preferred modelling technique in a BI environment. Knowing the basics of data
warehousing and dimensions helps you design a better data warehouse that fits your reporting

28 LOVELY PROFESSIONAL UNIVERSITY