BestHub
Sign in
Tagged articles
30 articles
Page 1 of 1
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
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
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 WarehouseETLdata modeling
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.

OLAPdata engineeringdimensional modeling
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
政采云技术
政采云技术
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 WarehouseDatabase design
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 WarehouseDatabase design
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 Warehousedata modeling
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.

Slowly Changing DimensionStar Schemaconstellation schema
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 PlatformData Warehouse
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