Tagged articles
dimensional modeling
43 articles · Page 1 of 1
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

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

The article breaks down dimensional modeling for data warehouses, detailing the star, snowflake, and constellation schemas, their structures, pros and cons, ideal business scenarios, and guidance on selecting the right model to support reliable analytics and AI initiatives.
BIConstellation Schemadimensional modeling
0 likes · 16 min read

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 VaultETL
0 likes · 10 min read

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.
Kappa architectureLambda architectureLayered Architecture
0 likes · 13 min read

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

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 WarehouseETLOLAP
0 likes · 9 min read

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 ConsistencyLayered ArchitectureODS
0 likes · 9 min read

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.
DWDFact TableHive
0 likes · 15 min read

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 ModelingETLdata governance
0 likes · 12 min read

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.
AlibabaData ModelingOneData
0 likes · 54 min read

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.
Database Designconceptual modelingdata governance
0 likes · 12 min read

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.
AirflowETLMySQL
0 likes · 12 min read

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 IntelligenceETLInmon
0 likes · 48 min read

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 ModelingPower BIdata warehouse
0 likes · 11 min read

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.
ETLFact Tabledata warehouse
0 likes · 15 min read

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.
Database Designdata governancedimensional modeling
0 likes · 12 min read

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

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 ModelingETLdata warehouse
0 likes · 11 min read

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.
Lambda architecturedata governancedata warehouse
0 likes · 13 min read

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

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 EngineeringOLAPdimensional modeling
0 likes · 12 min read

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.
Multi-dimensional Analysisbig datadata warehouse
0 likes · 3 min read

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


政采云技术Mar 9, 2023 · Fundamentals
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.
Data ModelingDatabase DesignETL
0 likes · 12 min read


政采云技术Mar 7, 2023 · Databases
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.
Data ModelingDatabase DesignETL
0 likes · 14 min read

This article explains the purpose and benefits of data‑warehouse layering, outlines the four ETL steps, describes each architectural layer from ODS to ADS, presents modeling principles, naming conventions, and includes sample DDL to illustrate how layered design improves data quality, reuse, and operational efficiency.
ETLLayered Architecturebig data
0 likes · 36 min read

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.
Fact TableKimballbig data
0 likes · 16 min read

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

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.
Data Vaultbig datadata warehouse
0 likes · 15 min read

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

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

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.
ETLbig datadata warehouse
0 likes · 63 min read

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.
ETLSQLbig data
0 likes · 9 min read

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.
DataWorksMaxComputeSQL
0 likes · 32 min read

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.
ETLSQLbig data
0 likes · 11 min read

This article provides an extensive introduction to data warehouses, covering their origins, development, definition, advantages, components, comparisons with databases, ODS and data marts, architectural approaches, modeling techniques, and dimensional modeling processes for enterprise‑level analytics.
ETLInmonKimball
0 likes · 47 min read

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

This article describes the design and implementation of a data warehouse, covering storage engine choices, dimensional modeling techniques, ETL processes using Python scripts, and workflow management with Apache Airflow to address data integration, scalability, and maintenance challenges.
AirflowETLMySQL
0 likes · 11 min read

This article explains the historical background of databases and data warehouses, outlines why data warehouses are essential for modern enterprises, and provides a step‑by‑step guide to building a data warehouse using Kimball’s dimensional modeling approach.
ETLKimballdimensional modeling
0 likes · 8 min read

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.
ETLdata warehousedimensional modeling
0 likes · 17 min read

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.
architecturebig datadata platform
0 likes · 6 min read


ITPUBMar 9, 2017 · Databases
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.
SQL Serverdata warehousedimensional modeling
0 likes · 7 min read
