Tagged articles

slowly changing dimension

5 articles · Page 1 of 1

Jun 16, 2026 · Databases

A Systematic Overview of Data Warehouse and Data Mart Modeling Techniques

This article systematically explains data warehouse modeling, covering ER, relational, and dimensional modeling, introduces star, snowflake, and constellation schemas, walks through a retail sales example, discusses fact attributes, slowly changing dimensions, and compares normalized, dimensional, and independent data‑mart approaches.

data warehousedimensional modelingfact constellation

0 likes · 16 min read

A Systematic Overview of Data Warehouse and Data Mart Modeling Techniques

Ma Wei Says

Mar 16, 2025 · Databases

Mastering Slowly Changing Dimensions: Which SCD Strategy Fits Your Data Warehouse?

This article explains the concept of Slowly Changing Dimensions (SCD) in data warehouses, compares six common SCD handling methods—including SCD0, SCD1, SCD2, SCD3, combined SCD2+SCD3, and historical tables—and guides you on selecting the most suitable approach for your business needs.

ETLSCD Typesdata warehouse

0 likes · 9 min read

Mastering Slowly Changing Dimensions: Which SCD Strategy Fits Your Data Warehouse?

Ma Wei Says

Feb 28, 2025 · Databases

Mastering Dimension Tables: Natural vs Surrogate Keys and Handling Slowly Changing Dimensions

This article explains the role of dimension tables in data warehouses, compares natural and surrogate keys, and details three strategies—overwrite, insert new rows, and add new attributes—for managing slowly changing dimensions, including full‑snapshot tables.

Dimension TableSurrogate Keydata warehouse

0 likes · 8 min read

Mastering Dimension Tables: Natural vs Surrogate Keys and Handling Slowly Changing Dimensions

Big Data Technology & Architecture

Dec 28, 2020 · Big Data

Implementing Historical Slowly Changing Dimension (Chain) Tables with PL/pgSQL

This article explains the concept of historical chain (slowly changing dimension) tables in data warehousing, demonstrates how to create source and target tables, provides a PL/pgSQL stored procedure to handle inserts, updates, and deletions, and shows step‑by‑step testing with sample SQL scripts.

Big DataPL/pgSQLSQL

0 likes · 10 min read

Implementing Historical Slowly Changing Dimension (Chain) Tables with PL/pgSQL

Big Data Technology & Architecture

Jul 30, 2020 · Databases

Dimensional Modeling Techniques for Data Warehouses: Star, Snowflake, and Constellation Schemas

This article explains data‑warehouse dimensional modeling, covering the basic concepts of dimension and fact tables, the three main schema patterns—star, snowflake, and constellation—along with their advantages, implementation steps, and handling of slowly changing dimensions.

Constellation Schemadimensional modelingslowly changing dimension

0 likes · 14 min read