Dimension Modeling

DataFunSummit

Mar 12, 2024 · Big Data

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

This article analyzes why data engineers face endless data‑retrieval requests, identifies common missteps in data‑construction such as demand‑driven development, lack of modeling and OLAP concepts, and proposes a dimension‑model‑based data warehouse with OLAP reporting, tooling, and knowledge‑empowerment to break the cycle.

Dimension ModelingOLAPbig data

0 likes · 13 min read

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

58 Tech

Apr 26, 2022 · Information Security

Design and Architecture of a Full‑Chain Data Warehouse for Information Security

The article presents a comprehensive design of an end‑to‑end data warehouse for information‑security governance, detailing background motivations, multi‑layer data architecture, dimension modeling, bus‑matrix mapping, real‑time (lambda/kappa) processing, data‑dictionary integration, and future directions toward unified streaming‑batch solutions.

Dimension ModelingReal-time Processingbig data

0 likes · 16 min read

Design and Architecture of a Full‑Chain Data Warehouse for Information Security

DataFunSummit

Apr 6, 2022 · Big Data

Real-time Dimension Modeling with Flink SQL: Challenges and Solutions

This article presents a JD.com case study on applying Flink SQL for real‑time dimension modeling, detailing two complex streaming scenarios—full‑join of multiple streams and full‑group aggregation—along with the associated challenges of historical data handling, state management, and performance optimization, and proposes component‑based architectural solutions.

Dimension ModelingFlinkSQL

0 likes · 14 min read

Real-time Dimension Modeling with Flink SQL: Challenges and Solutions

DataFunTalk

Mar 24, 2022 · Big Data

Real‑time Dimension Modeling with Flink SQL: Problems, Challenges, and Solutions

This article presents a JD.com BI engineer's case study on applying Flink SQL to real‑time dimension modeling, detailing two complex streaming scenarios, the technical difficulties of handling historical data and performance, and a component‑based solution architecture with future roadmap considerations.

Dimension ModelingFlinkSQL

0 likes · 13 min read

Real‑time Dimension Modeling with Flink SQL: Problems, Challenges, and Solutions

Fulu Network R&D Team

Jul 19, 2021 · Databases

Ubiquitous Data: From Analysis to Data Warehousing and Dimension Modeling with Tableau and MaxCompute

This article explains how data-driven decision making evolves from simple Excel and Python analysis to robust data warehouses, introduces star‑schema dimension modeling, and demonstrates practical integration of Alibaba Cloud MaxCompute with Tableau for interactive OLAP‑style analytics.

Data WarehousingDimension ModelingMaxCompute

0 likes · 7 min read

Ubiquitous Data: From Analysis to Data Warehousing and Dimension Modeling with Tableau and MaxCompute