BestHub
Sign in
Tagged articles

dimensional modeling

43 articles · Page 1 of 1
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 24, 2026 · Fundamentals

Four Core Data Modeling Techniques Every Engineer Should Know

The article explains why solid data modeling is essential, then walks through four widely used techniques—normalization, dimensional modeling, Data Vault, and graph modeling—detailing their principles, typical use cases, advantages, and trade‑offs, and shows how they fit into layered data‑warehouse architectures.

Data ModelingData VaultData Warehouse
0 likes · 10 min read
Four Core Data Modeling Techniques Every Engineer Should Know
Data Integration and Governance
Data Integration and Governance
Mar 23, 2026 · Big Data

Offline vs Real‑Time Data Warehouse: Full Architecture Comparison

The article explains the fundamental differences between offline and real‑time data warehouses, covering their core logic, layered designs, dimensional modeling, typical architectures such as Lambda, Kappa and stream‑batch hybrid, and provides guidance on selecting the appropriate solution based on latency, team expertise, cost and workload characteristics.

Data WarehouseKappa ArchitectureLambda Architecture
0 likes · 13 min read
Offline vs Real‑Time Data Warehouse: Full Architecture Comparison
Big Data Tech Team
Big Data Tech Team
Jan 25, 2026 · Databases

Unlocking Data Consistency: The Essential Guide to Data Modeling Stages

This article explains why many enterprises suffer from mismatched "Customer ID" fields, clarifies the distinction between data modeling (the process) and a data model (the result), and walks through conceptual, logical, and physical modeling as well as three common modeling approaches—normative, dimensional, and entity—highlighting their purposes, steps, and trade‑offs.

Database Designconceptual modelingdimensional modeling
0 likes · 12 min read
Unlocking Data Consistency: The Essential Guide to Data Modeling Stages
Data Integration and Governance
Data Integration and Governance
Jan 16, 2026 · Big Data

Understanding Data Warehouses: Differences from Databases and How to Get Started

The article explains why scattered, unprepared data hampers analysis, defines data warehouses versus traditional databases, outlines the three‑layer architecture (ODS/Staging, DWD, DWS/ADS), details the ETL process, introduces dimensional modeling, and discusses metadata, data‑quality management, and emerging cloud‑native and real‑time trends.

Cloud Data WarehouseData WarehouseETL
0 likes · 9 min read
Understanding Data Warehouses: Differences from Databases and How to Get Started
Smart Sea Tide
Smart Sea Tide
Jan 9, 2026 · Databases

How to Build a Layered Data Warehouse Architecture

The article outlines the essential principles and step‑by‑step design of a three‑layer data warehouse—source (ODS), historical, and data‑model layers—covering data consistency, universality, storage strategies, usability, and security to help architects construct reliable analytical platforms.

Data ConsistencyData WarehouseODS
0 likes · 9 min read
How to Build a Layered Data Warehouse Architecture
Smart Sea Tide
Smart Sea Tide
Jan 6, 2026 · Databases

Practical Guide to Building the DWD Layer in a Data Warehouse

This article walks through the DWD (Data Warehouse Detail) layer design, explaining its purpose, the four-step modeling process, and detailed implementations of transactional, periodic snapshot, and cumulative snapshot fact tables with Hive SQL examples and schema definitions.

DWDData WarehouseFact Table
0 likes · 15 min read
Practical Guide to Building the DWD Layer in a Data Warehouse
Data Integration and Governance
Data Integration and Governance
Dec 5, 2025 · Fundamentals

Finally, a Clear Explanation of Data Modeling

The article explains why inconsistent field definitions across systems stem from a lack of a unified data model, defines data modeling versus data model, outlines the three modeling stages, compares three common modeling approaches—normative, dimensional, and entity—and shows how proper modeling supports data governance, ETL, and analytics.

Data GovernanceData ModelingData Warehouse
0 likes · 12 min read
Finally, a Clear Explanation of Data Modeling
Smart Sea Tide
Smart Sea Tide
Nov 28, 2025 · Big Data

A Comprehensive Panorama of Data Modeling for Big Data Systems

The article explains why structured data modeling is essential for large‑scale systems, compares OLTP and OLAP approaches, details ER, dimensional, Data Vault and Anchor methodologies, and walks through Alibaba's multi‑stage data‑modeling practice, including OneData implementation, dimension design, fact‑table types, and aggregation strategies.

AlibabaBig DataData Modeling
0 likes · 54 min read
A Comprehensive Panorama of Data Modeling for Big Data Systems
Big Data Tech Team
Big Data Tech Team
Oct 29, 2025 · Fundamentals

Why Unified Data Modeling Matters: From Conceptual Design to Physical Implementation

The article explains how inconsistent "customer ID" fields across systems stem from a lack of unified data models, defines the difference between data modeling and data models, outlines three modeling stages, and compares three major modeling approaches—normative, dimensional, and entity—highlighting their purposes, processes, and trade‑offs.

Data GovernanceDatabase Designconceptual modeling
0 likes · 12 min read
Why Unified Data Modeling Matters: From Conceptual Design to Physical Implementation
Smart Sea Tide
Smart Sea Tide
Oct 17, 2025 · Big Data

Building a Data Warehouse for the Data Processing Layer

The article outlines the problems of early data services, proposes a two‑step data warehouse solution—abstracting a data model and extracting, cleaning, and storing data from MySQL, MongoDB, and Elasticsearch—then details storage selection, dimensional modeling, incremental ETL, and Airflow workflow management.

AirflowBig DataData Warehouse
0 likes · 12 min read
Building a Data Warehouse for the Data Processing Layer
Smart Sea Tide
Smart Sea Tide
Sep 29, 2025 · Databases

Data Warehouse Architecture and Construction Methodology

The article explains why scattered, heterogeneous enterprise data requires a unified, subject‑oriented data warehouse, outlines its historical evolution, compares Inmon and Kimball architectures, describes the core components and modeling stages, and details dimensional modeling techniques and best practices.

Business IntelligenceData IntegrationData Warehouse
0 likes · 48 min read
Data Warehouse Architecture and Construction Methodology
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
Architect's Guide
Architect's Guide
Jun 14, 2025 · Big Data

Mastering Data Warehouse Design: From Fact Tables to Dimensional Modeling

This article explains the core components of a data warehouse ecosystem, distinguishes fact and dimension tables, outlines synchronization strategies, introduces star, snowflake, and constellation schemas, and details the layered architecture from ODS to data marts for effective big‑data analytics.

Data WarehouseETLFact Table
0 likes · 15 min read
Mastering Data Warehouse Design: From Fact Tables to Dimensional Modeling
Big Data Tech Team
Big Data Tech Team
May 19, 2025 · Fundamentals

Why Unified Data Modeling Matters: From Concepts to Physical Design

The article explains why establishing a unified data model is essential, differentiates data modeling from data models, outlines three modeling stages, compares normative, dimensional, and entity modeling methods, and provides practical steps and diagrams to help organizations build robust, business‑driven data architectures.

Data GovernanceDatabase Designdimensional modeling
0 likes · 12 min read
Why Unified Data Modeling Matters: From Concepts to Physical Design
Ma Wei Says
Ma Wei Says
Feb 26, 2025 · Databases

Understanding Fact Tables: Types, Granularity, and Design Best Practices

This article explains fact tables in data warehousing, covering their definition, granularity, additive classifications, null handling, consistency rules, and the various types such as transaction, snapshot, cumulative, fact‑less, and aggregate tables, along with design trade‑offs and ETL considerations.

BIETLdimensional modeling
0 likes · 17 min read
Understanding Fact Tables: Types, Granularity, and Design Best Practices
Alibaba Cloud Developer
Alibaba Cloud Developer
Sep 3, 2024 · Big Data

Mastering Data Modeling: From Raw Data to Insightful Warehouses

This article walks through the fundamentals of data modeling, explaining what data is, the DIKW framework, why modeling matters, and detailing the end‑to‑end process from conceptual design through logical and physical layers, including DIM, DWD, DWS, and ADM tables with practical tips and naming conventions.

Data ModelingData WarehouseETL
0 likes · 11 min read
Mastering Data Modeling: From Raw Data to Insightful Warehouses
Data Thinking Notes
Data Thinking Notes
Aug 15, 2024 · Big Data

How to Build a Scalable Data Warehouse: Theory, Architecture, and Best Practices

This article outlines practical approaches to data warehouse construction, covering dimensional modeling, layered architecture, capability development, real‑time and batch processing with technologies like Hive, Spark, Flink, Iceberg, and discusses governance, security, and future trends toward data value and real‑time metrics.

Data GovernanceData WarehouseIceberg
0 likes · 13 min read
How to Build a Scalable Data Warehouse: Theory, Architecture, and Best Practices
DataFunTalk
DataFunTalk
Aug 8, 2024 · Big Data

Building a User Profile Data Warehouse at 58.com: Architecture, Modeling, and Practices

This article details the design and implementation of a user‑profile data warehouse at 58.com, covering data‑warehouse fundamentals, user‑profile tag generation, layered architecture, dimensional modeling choices, ETL migration from Hive to Spark, data‑quality safeguards, and the resulting scale of tables, metrics and tags.

ETLdimensional modelinguser profiling
0 likes · 20 min read
Building a User Profile Data Warehouse at 58.com: Architecture, Modeling, and Practices
DataFunTalk
DataFunTalk
Aug 6, 2024 · Fundamentals

Solving Massive Data Retrieval Demands: From Problem Causes to OLAP Multidimensional Reporting Solutions

This article analyzes why data engineers face endless data‑extraction requests, identifies common missteps in data‑construction practices, and proposes a comprehensive solution based on dimensional modeling, OLAP multidimensional reporting, self‑service tools, and knowledge empowerment to dramatically improve efficiency and scalability.

Data Engineeringdimensional modelingolap
0 likes · 12 min read
Solving Massive Data Retrieval Demands: From Problem Causes to OLAP Multidimensional Reporting Solutions
DataFunSummit
DataFunSummit
Oct 16, 2023 · Big Data

Elegant Dimensional Modeling and Multi‑Dimensional Analysis Design Practice

In this presentation, Qiu Shengchang shares his 13‑year experience designing elegant data‑warehouse architectures, detailing a highly generic dimensional model, extreme partitioned tables, and a universal multi‑dimensional analysis framework that enables rapid, comprehensive reporting on massive datasets.

Big DataData WarehouseMulti-dimensional Analysis
0 likes · 3 min read
Elegant Dimensional Modeling and Multi‑Dimensional Analysis Design Practice
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
政采云技术
政采云技术
Mar 9, 2023 · Fundamentals

Redesigning Data Warehouse Models: When and How to Use Dimensional Modeling

This article explains the concept of data models, why warehouse models need reconstruction, compares normative and dimensional modeling approaches, and provides a step‑by‑step guide—including information gathering, design, and implementation—to build efficient, maintainable data warehouse architectures.

Big DataData ModelingData Warehouse
0 likes · 12 min read
Redesigning Data Warehouse Models: When and How to Use Dimensional Modeling
政采云技术
政采云技术
Mar 7, 2023 · Databases

Data Warehouse Modeling: Concepts, Methods, and Implementation

This article explains what data models are, why model refactoring is necessary, compares normalized and dimensional data warehouse modeling approaches, and details a three‑step implementation process—including information research, model design, and model deployment—while highlighting best‑practice naming conventions and practical examples.

Big DataData ModelingData Warehouse
0 likes · 14 min read
Data Warehouse Modeling: Concepts, Methods, and Implementation
Data Thinking Notes
Data Thinking Notes
Nov 23, 2022 · Big Data

Mastering Fact Table Design: From Basics to Advanced Strategies

This comprehensive guide explains the fundamentals, design rules, and various types of fact tables—including transaction, snapshot, and aggregate tables—while detailing Kimball's four-step modeling process, grain declaration, handling of additive measures, and practical examples for effective data warehouse implementation.

Big DataData WarehouseFact Table
0 likes · 16 min read
Mastering Fact Table Design: From Basics to Advanced Strategies
Data Thinking Notes
Data Thinking Notes
Nov 21, 2022 · Big Data

Mastering Big Data Modeling: From ER and Dimensional to Data Vault and Alibaba’s OneData

This comprehensive guide explains why data modeling is essential for big‑data systems, compares relational and OLAP approaches, details ER, dimensional, Data Vault and Anchor methodologies, and walks through Alibaba’s multi‑stage data‑model practice, integration framework, dimension design, fact‑table strategies and aggregation techniques.

AlibabaData ModelingData Warehouse
0 likes · 57 min read
Mastering Big Data Modeling: From ER and Dimensional to Data Vault and Alibaba’s OneData
dbaplus Community
dbaplus Community
Oct 24, 2022 · Big Data

Mastering Data Warehouse Modeling: From ER to Data Vault

This article explains what a data warehouse is, why modeling it matters, and compares four major modeling approaches—ER, dimensional, Data Vault, and Anchor—detailing their structures, steps, advantages, and typical use cases, while also offering guidance on selecting tools and designing models.

Big DataData VaultData Warehouse
0 likes · 15 min read
Mastering Data Warehouse Modeling: From ER to Data Vault
Big Data Technology & Architecture
Big Data Technology & Architecture
Oct 24, 2022 · Big Data

Comprehensive Guide to Big Data Modeling and Data Warehouse Design

This article provides an in‑depth overview of big‑data modeling concepts, covering why data modeling is essential, relational versus analytical systems, common warehouse modeling methodologies, Alibaba's practical implementations, dimension design techniques, and detailed fact‑table design principles for modern data platforms.

ETLdimensional modeling
0 likes · 50 min read
Comprehensive Guide to Big Data Modeling and Data Warehouse Design
DataFunSummit
DataFunSummit
Mar 2, 2022 · Databases

Industrial Data Analysis: Choosing Between Normalized and Dimensional Data Warehouse Modeling

The article examines industrial data analysis and compares normalized (entity‑relationship) modeling with dimensional (star/snowflake) modeling for data warehouses, highlighting their strengths, weaknesses, and selection criteria based on an enterprise's data‑intelligence maturity and project goals.

dimensional modelingindustrial datanormalized modeling
0 likes · 16 min read
Industrial Data Analysis: Choosing Between Normalized and Dimensional Data Warehouse Modeling
dbaplus Community
dbaplus Community
Feb 15, 2022 · Big Data

Mastering Data Warehouse Architecture: Concepts, Modeling Techniques, and Real‑Time Strategies

This comprehensive guide explains data warehouse fundamentals, architecture layers, modeling methods such as dimensional and entity modeling, metadata management, and the transition from offline to real‑time processing with Lambda and Kappa architectures, providing practical steps, best practices, and key terminology for building robust analytical platforms.

Big DataData WarehouseETL
0 likes · 63 min read
Mastering Data Warehouse Architecture: Concepts, Modeling Techniques, and Real‑Time Strategies
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
Sohu Tech Products
Sohu Tech Products
Apr 7, 2021 · Big Data

Data Warehouse Architecture and Modeling with Alibaba MaxCompute and DataWorks

This tutorial explains how to select a technical architecture, design a three‑layer data warehouse (ODS, CDM, ADS), model tables and dimensions, choose storage strategies, handle slowly changing dimensions, synchronize data with DataWorks, and implement dimensional modeling and fact tables using Alibaba MaxCompute for big‑data analytics.

Big DataData WarehouseDataWorks
0 likes · 32 min read
Data Warehouse Architecture and Modeling with Alibaba MaxCompute and DataWorks
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
Architecture Digest
Architecture Digest
Dec 26, 2019 · Databases

Data Warehouse Fundamentals, Modeling Techniques, and the Evolution of Maoyan’s Warehouse

This article explains the origins and challenges of scattered enterprise data, defines the data warehouse concept, details its four core characteristics, compares entity, normalization, and dimensional modeling methods, and illustrates Maoyan’s three‑stage data‑warehouse evolution with practical examples and diagrams.

Data WarehouseETLModeling
0 likes · 17 min read
Data Warehouse Fundamentals, Modeling Techniques, and the Evolution of Maoyan’s Warehouse
Product Technology Team
Product Technology Team
Dec 11, 2019 · Big Data

How a Data Middle Platform Transforms Business: Design, Architecture, and Modeling Insights

This article explains what a data middle platform is, why it matters, its core components—including storage, compute, IDE, workflow, API services, and data asset management—and details the layered architecture of ODS, DWD, DWT, DIM, and DWA, as well as dimensional modeling using Kimball’s methodology.

Big DataData Warehousearchitecture
0 likes · 6 min read
How a Data Middle Platform Transforms Business: Design, Architecture, and Modeling Insights
ITPUB
ITPUB
Mar 9, 2017 · Databases

How to Optimize Data Warehouse Indexes for Faster Queries

This article explains practical strategies for indexing dimension and fact tables in a data warehouse, covering when to use clustered versus non‑clustered indexes, how to handle surrogate and business keys, partition considerations, and tips for evolving index designs as data grows.

Data WarehouseSQL Serverdimensional modeling
0 likes · 7 min read
How to Optimize Data Warehouse Indexes for Faster Queries