CPU-Aware Automatic Materialized View Refresh

We present a CPU-aware automatic materialized view refresh system that monitors system resources in real-time and adaptively throttles refresh operations to prevent production workload impact. Our system combines staleness-based triggering, configurable CPU limits, and graceful degradation under load to maintain view freshness while respecting resource constraints. This approach addresses a widely recognized pain point in database systems where materialized view refreshes consume unbounded CPU and impact application performance.

Authors

Publication Details

Journal
Zenodo (CERN European Organization for Nuclear Research)
Published
2026-03-27
DOI
https://doi.org/10.5281/zenodo.19243692
Primary Topic
Distributed systems and fault tolerance
Type
article
Field-Weighted Citation Impact
0.00
Controls
|||
ALL TIME
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
article

CPU-Aware Automatic Materialized View Refresh

Daniel Moya Vaca
Zenodo (CERN European Organization for Nuclear Research)
Distributed systems and fault tolerance
article

CPU-Aware Automatic Materialized View Refresh

Daniel Moya Vaca
article en

Abstract

We present a CPU-aware automatic materialized view refresh system that monitors system resources in real-time and adaptively throttles refresh operations to prevent production workload impact. Our system combines staleness-based triggering, configurable CPU limits, and graceful degradation under load to maintain view freshness while respecting resource constraints. This approach addresses a widely recognized pain point in database systems where materialized view refreshes consume unbounded CPU and impact application performance.

Zenodo (CERN European Organization for Nuclear Research)
Openalex Percentile: Top 5%
Distributed systems and fault tolerance
DOIOpen Access PDFOpenAlex
AI Navigator

Ask Laika to Summarize, Analyze, and Connect papers live on the map.

Summarize Papers & Methodologies

Extract key findings, datasets, and comparative methods across publications.

Benchmark Rankings & Visual Analytics

Rank top research institutions, authors, funders, topics, and journals by Field-Weighted Citation Impact (FWCI) and paper volume with instant charts.

Connect Distant Disciplines

Bridge topological clusters on the map to find hidden collaborative intersections.

CPU-Aware Automatic Materialized View Refresh — Daniel Moya Vaca · Zenodo (CERN European Organization for Nuclear Research) (2026) | TGRS Research Map | TGRS