BestHub
Sign in
Tagged articles

snowflake schema

8 articles · Page 1 of 1
Smart Sea Tide
Smart Sea Tide
Aug 31, 2026 · Big Data

B2B vs B2C Data Development: Core Differences in Metrics, Modeling & Team Structure

A data developer with two years each in B2C and B2B e-commerce compares how user focus, metric priorities, team structures, and data warehouse modeling differ between consumer-facing and enterprise-facing products, illustrating with concrete project examples like APP health dashboards and lead allocation systems.

B2B data developmentB2C data developmentETL
0 likes · 17 min read
B2B vs B2C Data Development: Core Differences in Metrics, Modeling & Team Structure
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 VaultER Model
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.

Dimension TableER ModelFact Table
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 SchemaETLdatabase design
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