BestHub
Sign in
Tagged articles
21 articles
Page 1 of 1
Big Data Technology & Architecture
Big Data Technology & Architecture
Sep 10, 2025 · Databases

When to Use Materialized Views in Production: Benefits, Types, and Pitfalls

This article explains what materialized views are, outlines their advantages such as query acceleration, lightweight ETL, and lake‑warehouse integration, classifies them by sync mode, table count, and refresh strategy, and highlights their limitations and best‑practice recommendations for production use.

Data WarehousingDatabase PerformanceETL
0 likes · 6 min read
When to Use Materialized Views in Production: Benefits, Types, and Pitfalls
DeWu Technology
DeWu Technology
Aug 28, 2023 · Operations

Real-time Data Warehouse Business-Side Chaos Engineering Practice

The article describes how a real‑time data warehouse supporting ad‑delivery metrics adopts both technical and business‑side chaos‑engineering, using red‑blue team drills to inject faults, monitor indicator anomalies, and refine response procedures, thereby enhancing early risk detection, system resilience, and overall data stability for the advertising platform.

Data QualityData WarehousingOps
0 likes · 16 min read
Real-time Data Warehouse Business-Side Chaos Engineering Practice
Huawei Cloud Developer Alliance
Huawei Cloud Developer Alliance
Aug 4, 2023 · Databases

How GaussDB(DWS) HStore Tables Enable Real‑Time Ingestion and Lightning‑Fast Queries

Discover how GaussDB(DWS) HStore tables combine columnar storage with Delta capabilities to support high‑concurrency real‑time data ingestion, upsert operations, and ultra‑fast analytical queries, while offering full ACID consistency, strong compression, and practical configuration tips for developers.

ColumnarData WarehousingDatabase Storage
0 likes · 8 min read
How GaussDB(DWS) HStore Tables Enable Real‑Time Ingestion and Lightning‑Fast Queries
21CTO
21CTO
Jun 20, 2023 · Fundamentals

ETL vs ELT: Which Data Integration Method Wins for Your Business?

ETL extracts, transforms, then loads data, while ELT extracts, loads, and transforms later, each offering distinct advantages; the article compares their processes, key differences, and factors such as data volume, complexity, latency, and cost to help businesses choose the optimal integration approach.

Data IntegrationData WarehousingELT
0 likes · 12 min read
ETL vs ELT: Which Data Integration Method Wins for Your Business?
Architects Research Society
Architects Research Society
Jun 20, 2023 · Databases

Understanding the Differences Between OLAP and OLTP Systems

OLAP (Online Analytical Processing) and OLTP (Online Transaction Processing) are two distinct data processing systems—OLAP optimized for complex, multidimensional analysis and business intelligence, while OLTP handles high‑volume, real‑time transactional workloads—each serving different purposes, and often used together to drive data‑driven decision making.

Data WarehousingOLAPOLTP
0 likes · 10 min read
Understanding the Differences Between OLAP and OLTP Systems
DataFunSummit
DataFunSummit
Dec 29, 2022 · Big Data

Technical Q&A on Wide Tables, Tracking Parameters, and Data Validation in Data Warehousing

The article presents a technical Q&A covering the challenges of wide tables and historical data retrieval, the recommendation to separate public and private tracking parameters, methods for validating tracking data using automated rules and manual checks, and announces DataFun's 5‑year anniversary series on big data and AI.

Data Warehousingdata validationtracking parameters
0 likes · 3 min read
Technical Q&A on Wide Tables, Tracking Parameters, and Data Validation in Data Warehousing
DataFunSummit
DataFunSummit
Sep 10, 2022 · Big Data

Application of Multi‑Dimensional Analysis in NetEase Cloud Music's Social Innovation Business

The talk explains how NetEase Cloud Music leverages multi‑dimensional analysis across its social innovation apps, detailing business background, use‑case scenarios, technology choices, data‑platform architecture, and future plans to enable self‑service analytics and improve data efficiency.

Data WarehousingMulti-dimensional Analysiscloud music
0 likes · 12 min read
Application of Multi‑Dimensional Analysis in NetEase Cloud Music's Social Innovation Business
Architects Research Society
Architects Research Society
Mar 27, 2022 · Databases

What Is OLAP? An Overview of Online Analytical Processing and Its Types

This article explains OLAP as a core data‑warehouse component that enables fast, multidimensional analysis for business intelligence, describes the structure of OLAP cubes, outlines basic operations such as drill‑down, roll‑up, slice‑and‑dice and pivot, compares MOLAP, ROLAP and HOLAP, and discusses OLAP’s relationship with OLTP and cloud architectures.

Data WarehousingHOLAPMOLAP
0 likes · 12 min read
What Is OLAP? An Overview of Online Analytical Processing and Its Types
Programmer DD
Programmer DD
Nov 27, 2020 · Databases

Why TiDB Is Revolutionizing Distributed Databases: Architecture, Use Cases, and HTAP

TiDB, an open‑source distributed relational database, separates compute and storage, offers MySQL compatibility, supports both OLTP and OLAP workloads, and provides HTAP capabilities, with real‑world use cases ranging from MySQL sharding to full replacement, data warehousing, and serving as a modular component.

Data WarehousingHTAPMySQL compatibility
0 likes · 8 min read
Why TiDB Is Revolutionizing Distributed Databases: Architecture, Use Cases, and HTAP
Big Data Technology & Architecture
Big Data Technology & Architecture
Aug 29, 2019 · Databases

Differences Between OLTP and OLAP: Characteristics, Resource Requirements, and Use Cases

The article explains the two main types of data processing—OLTP for real‑time transactional workloads and OLAP for analytical data‑warehousing tasks—detailing their distinct characteristics, resource demands, typical features, major vendor products, and a five‑point comparison of their design and usage.

Data WarehousingOLAPOLTP
0 likes · 6 min read
Differences Between OLTP and OLAP: Characteristics, Resource Requirements, and Use Cases
StarRing Big Data Open Lab
StarRing Big Data Open Lab
Aug 18, 2017 · Big Data

Cut OLAP Cube Storage Explosions: Proven Dimensionality Reduction Tricks with Rubik

This article explains why raw OLAP Cubes consume exponential storage, then details six practical dimensionality‑reduction methods—Aggregation Group, Mandatory Dimension, Joint Dimension, Derived Dimension, Hierarchy Dimension, and Partial Cube—showing how each can dramatically shrink materialized tables while preserving query performance.

Cube OptimizationData WarehousingOLAP
0 likes · 10 min read
Cut OLAP Cube Storage Explosions: Proven Dimensionality Reduction Tricks with Rubik
Architects' Tech Alliance
Architects' Tech Alliance
Nov 19, 2016 · Databases

An Overview of Greenplum Database Architecture and Core Components

Greenplum is an open‑source, massively parallel processing (MPP) database built on PostgreSQL, offering ANSI‑SQL compliance, distributed ACID transactions, linear scalability, polymorphic storage, advanced optimizers, and extensive ecosystem integrations, making it suitable for large‑scale data warehousing, analytics, and big‑data workloads.

Data WarehousingGreenplumMPP
0 likes · 15 min read
An Overview of Greenplum Database Architecture and Core Components
ITPUB
ITPUB
Aug 18, 2016 · Databases

Cut Oracle Data Extraction from 20 Hours to 1 Hour: Proven DBA Tuning Tricks

An experienced DBA shares a real-world case of optimizing a nightly Oracle reporting pipeline, detailing how partitioned tables, truncate operations, table compression, disabling logging, and parallel execution reduced a 20‑hour data extraction to under one hour, and compiles community‑sourced tuning tips for large‑scale data warehouses.

Data WarehousingOracleSQL Optimization
0 likes · 14 min read
Cut Oracle Data Extraction from 20 Hours to 1 Hour: Proven DBA Tuning Tricks