BestHub
Sign in
Tagged articles

star schema

13 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
Apr 1, 2026 · Big Data

Fact vs. Dimension Tables: All You Need to Know

This article explains the fundamental differences between fact tables and dimension tables in a data warehouse, covering their core contents, key characteristics, design best‑practices, types, how they interrelate, and maintenance tips for reliable analytics.

Data ModelingData WarehouseDimension Table
0 likes · 11 min read
Fact vs. Dimension Tables: All You Need to Know
Data Integration and Governance
Data Integration and Governance
Mar 12, 2026 · Big Data

7 Core Data Warehouse Modeling Methods You Must Master

The article explains why traditional transactional databases hinder analytics, introduces seven essential data‑warehouse modeling techniques—3NF, Kimball star schema, snowflake, wide table, Data Vault 2.0, activity model, and entity‑centric modeling—detailing their advantages, drawbacks, and how to choose among them based on analysis needs, data volume, usability, flexibility, and performance.

Data VaultData WarehouseModeling
0 likes · 12 min read
7 Core Data Warehouse Modeling Methods You Must Master
Smart Sea Tide
Smart Sea Tide
Dec 18, 2025 · Databases

ClickHouse Performance Test on a 600‑Million‑Row Table

This article records a ClickHouse performance benchmark on a single‑node 20.8.11.17 deployment with a 600 million‑row star‑schema table, detailing server specs, data compression, and the execution time, rows processed, and result size of multiple analytical queries, highlighting first‑run latency of about 8 seconds and sub‑second speeds on repeated runs.

ClickHouseLarge DatasetSQL
0 likes · 10 min read
ClickHouse Performance Test on a 600‑Million‑Row Table
Smart Sea Tide
Smart Sea Tide
Sep 12, 2025 · Fundamentals

Practical Data Modeling Patterns for Data Warehousing

The article explains why a well‑designed data model is essential for data‑warehouse performance and reliability, then walks through three core modeling patterns—flat tables, master/detail, and dimensional (star) schemas—illustrating each with concrete Power BI examples, step‑by‑step design stages, and trade‑offs such as many‑to‑many relationships and bidirectional filters.

Data ModelingData WarehousePower BI
0 likes · 11 min read
Practical Data Modeling Patterns for Data Warehousing
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
JavaEdge
JavaEdge
Jun 21, 2022 · Databases

Why OLTP and OLAP Differ: Understanding Data Warehouses and Star Schemas

This article explains the fundamental differences between transactional (OLTP) and analytical (OLAP) database workloads, describes how data warehouses isolate analytical queries, and introduces star and snowflake schema designs for efficient reporting and business intelligence.

Data WarehouseOLTPolap
0 likes · 9 min read
Why OLTP and OLAP Differ: Understanding Data Warehouses and Star Schemas
IT Architects Alliance
IT Architects Alliance
Aug 14, 2021 · Big Data

An Introduction to Dimensional Modeling in Data Warehousing

This article provides a comprehensive overview of data warehouse concepts, compares classic warehouse models, explains dimensional modeling fundamentals such as fact and dimension tables, demonstrates a practical e‑commerce scenario with schema design and SQL query examples, and discusses real‑world trade‑offs.

Big DataETLSQL
0 likes · 9 min read
An Introduction to Dimensional Modeling in Data Warehousing
Architect
Architect
Dec 22, 2020 · Big Data

Dimensional Modeling in Data Warehousing: Concepts, Theory, and Practical Example

This article explains data warehouse fundamentals, reviews classic warehouse models such as ER, dimensional, Data Vault and Anchor, then dives deep into dimensional modeling concepts, star and snowflake schemas, and demonstrates a practical e‑commerce scenario with SQL examples and trade‑offs.

Big DataData WarehouseETL
0 likes · 11 min read
Dimensional Modeling in Data Warehousing: Concepts, Theory, and Practical Example
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