How to Cut Data Cube Processing Time by 60% with Deduplication Optimization

This article explains how to dramatically reduce the cost of deduplication‑Cube calculations in large‑scale data pipelines by replacing costly data‑expansion steps with a UID‑level tagging approach, detailing the scenario, common methods, performance analysis, a new solution, implementation steps, and experimental results.

Big DataSQL Optimizationdata cube

0 likes · 15 min read

How to Cut Data Cube Processing Time by 60% with Deduplication Optimization

JD Tech

Jan 4, 2023 · Big Data

Implementing Data Cubes in Hive Using WITH CUBE, GROUPING SETS, and WITH ROLLUP

This article demonstrates how to build multi‑dimensional data cubes on JD's big‑data platform using Hive, comparing UNION ALL with the more concise WITH CUBE, GROUPING SETS, and WITH ROLLUP functions, and discusses practical pitfalls and optimization tips.

Big DataGrouping SetsRollup

0 likes · 10 min read

Implementing Data Cubes in Hive Using WITH CUBE, GROUPING SETS, and WITH ROLLUP

Big Data Technology & Architecture

Jan 2, 2020 · Databases

Comprehensive Overview of Data Warehousing, ETL, OLAP, and Data Cube Operations

This article provides a thorough introduction to data warehousing, covering warehouse creation, the ETL process, OLAP/BI tools, data cube concepts, common OLAP operations, and the three main OLAP architectural models (MOLAP, ROLAP, HOLAP).

ETLOLAPdata cube

0 likes · 12 min read

Comprehensive Overview of Data Warehousing, ETL, OLAP, and Data Cube Operations