BestHub
Sign in
Tagged articles

snowflake schema

7 articles · Page 1 of 1
Data Integration and Governance
Data Integration and Governance
Aug 5, 2026 · Databases

8 Essential Data Modeling Techniques Every Data Engineer Should Know

The article explains why data modeling is the bridge between business processes and analytical applications, breaks down eight common modeling methods—including ER, 3NF, dimensional, star, snowflake, wide‑table, Data Vault, and subject‑oriented models—detailing their purposes, strengths, trade‑offs, and how they fit into a layered data‑warehouse architecture.

Data ModelingData VaultData Warehouse
0 likes · 16 min read
8 Essential Data Modeling Techniques Every Data Engineer Should Know
Smart Sea Tide
Smart Sea Tide
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
Smart Sea Tide
Smart Sea Tide
Jun 15, 2026 · Databases

Key Data Warehouse Concepts Every Interviewee Should Know

The article explains what a data warehouse is, why it is built for decision support, compares ER and dimensional modeling, and details core concepts such as dimensions, facts, slowly changing dimensions, fact table types, and star versus snowflake schemas, highlighting practical trade‑offs.

Data WarehouseDimension TableER Model
0 likes · 12 min read
Key Data Warehouse Concepts Every Interviewee Should Know
Data Integration and Governance
Data Integration and Governance
Mar 3, 2026 · Databases

Star, Snowflake, or Constellation Schema? Pros, Cons, and How to Choose

The article explains the structure, advantages, and disadvantages of star, snowflake, and constellation data‑warehouse schemas, shares real‑world experiences, and provides practical criteria—performance, team skill, and business scope—to help practitioners select the most suitable model or combine them effectively.

Constellation SchemaDatabase DesignETL
0 likes · 9 min read
Star, Snowflake, or Constellation Schema? Pros, Cons, and How to Choose
Liulishuo Tech Team
Liulishuo Tech Team
Mar 31, 2023 · Big Data

Understanding and Experimenting with the Data Warehouse Toolbox: Dimensional Modeling

This article explains the concepts, key characteristics, terminology, and practical steps of dimensional modeling—including star and snowflake schemas—and demonstrates how to apply the methodology to a real‑world sales analysis scenario, while also discussing common challenges in building star‑schema models.

Big DataData Warehousedimensional modeling
0 likes · 13 min read
Understanding and Experimenting with the Data Warehouse Toolbox: Dimensional Modeling
Big Data Technology & Architecture
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
Dimensional Modeling Techniques for Data Warehouses: Star, Snowflake, and Constellation Schemas