Download

Download Full Text (3.1 MB)

Course

Datawarehouse

Description

This presentation, "Slowly Changing Dimensions and Fast Changing Facts - The Story of the Traditional Data Warehouse," explores how to generate actionable insights from organizational performance data. It begins by discussing the challenges of generating insights directly from existing databases and introduces the concept of data cubes for efficient aggregate storage. The core of the presentation focuses on dimensional modeling, particularly the Star Schema, as a solution for analytical processing needs that cannot be met by transactional systems. It details the characteristics of fast-changing fact tables (long, lean, numeric) and slowly changing dimension tables (descriptive, wide, containing strings and numbers). The presentation then delves into various Slowly Changing Dimension (SCD) types (Type 0, 1, 2, 3, 4, 5, and 6), explaining how each handles changes in dimensional data to preserve or overwrite historical information. Key considerations for designing star schemas, such as the number of dimensions and the granularity of facts, are also addressed.

More details: https://events.vtools.ieee.org/m/363162

Video Recording: https://ieeetv.ieee.org/video/slowly-changing-dimensions-and-fast-changing-facts-the-story-of-the-traditional-data-warehouse

Publication Date

Summer 6-2-2023

Document Type

Article

Keywords

Data Warehouse, Data Modeling, Star Schema, Fact Table, Dimension Table, Slowly Changing Dimensions, SCD Type 1, SCD Type 2, SCD Type 3, Data Cube, OLAP, Business Intelligence

Disciplines

Computational Engineering | Computer Engineering | Engineering

Creative Commons License

Creative Commons License
This work is licensed under a Creative Commons Attribution-No Derivative Works 4.0 License.

Slowly changing dimensions and fast changing facts - the story of the traditional data warehouse

Share

COinS