Info

Syllabus

Introduction

  • OLTP vs OLAP
  • Why a RDBMS is not suitable for Analytical Queries
    • Important conceptual notions
    • Data cube
    • Dimensions
    • Hierarchy
  • Data Explosion Problem


Important database notions:

  • ER Modelling
  • Translation to the relational model
  • Dependencies: Functional and foreign key dependencies

Dimensional Modeling

  • Dimensional Modeling
  • Roll-up lattice

Logical Modelling

  • Special aggregation cases
  • Additive and non-additive measures
  • Star and snowflake schemas
  • Logical design
  • Dealing with changing dimensions
  • Slowly Changing Dimensions
    • Type I, II, and II
    • Rapidly changing dimensions
    • Mini dimension
  • Specific dimension types
    • Junk dimension
    • Outriggers
    • Degenerate dimension

Physical level

  • View materialization
  • Indexing
    • Bitmap index, Projection index, Join index, Bitmap-join index
    • Indexing dimension and fact tables
  • Partitioning


ETL

  • Data warehouse architectures
  • ETL
Share your opinion