BestHub
Sign in
Tagged articles

Dimension Table

5 articles · Page 1 of 1
Data Integration and Governance
Data Integration and Governance
Jun 25, 2026 · Fundamentals

Why Is Data Modeling So Hard? Master These 7 Essential Concepts

Data modeling isn’t about creating more tables; the real challenge lies in translating business logic, relationships, and metric definitions into a stable structure, which requires mastering seven key concepts—business objects, granularity, entity relationships, fact and dimension tables, metric definitions, model layering, and data lineage and quality.

Dimension TableFact Tablebusiness objects
0 likes · 14 min read
Why Is Data Modeling So Hard? Master These 7 Essential Concepts
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.

AnalyticsDimension TableETL
0 likes · 11 min read
Fact vs. Dimension Tables: All You Need to Know
Big Data Technology & Architecture
Big Data Technology & Architecture
Oct 29, 2021 · Big Data

Dimension Table Join Strategies in Apache Flink: Preload, Distributed Cache, Hot Storage, Broadcast, and Temporal Table Function

The article explains various dimension‑table join approaches in Apache Flink, including preloading tables into memory, using distributed cache, leveraging hot storage with async I/O, broadcasting state, and temporal table function joins, and compares their trade‑offs for different data volumes and update frequencies.

Dimension TableFlinkStreaming
0 likes · 10 min read
Dimension Table Join Strategies in Apache Flink: Preload, Distributed Cache, Hot Storage, Broadcast, and Temporal Table Function
Beike Product & Technology
Beike Product & Technology
Jun 12, 2020 · Big Data

Design and Implementation of SQL on Streaming (SQL 1.0 → SQL 2.0) in a Real‑Time Computing Platform

This article describes the evolution of a real‑time computing platform from SQL 1.0 built on Spark Structured Streaming to SQL 2.0 powered by Flink‑SQL, covering dynamic tables, continuous queries, dimension‑table joins, cache optimization, DDL extensions, platformization, operational challenges and future roadmap.

Data EngineeringDimension TableFlink
0 likes · 19 min read
Design and Implementation of SQL on Streaming (SQL 1.0 → SQL 2.0) in a Real‑Time Computing Platform