Work

CPU-Aware Automatic Materialized View Refresh

Year: 2026

Type: article

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.

Source: Zenodo (CERN European Organization for Nuclear Research)

DOI: 10.5281/zenodo.19243692

Author: Moya Vaca, Daniel

Language: English

Topic: Advanced Database Systems and Queries

Subfield: Computer Networks and Communications

Field: Computer Science

Domain: Physical Sciences

Open Access status: green

OpenAlex ID: W7141582046

FWCI:

Cites:

Cited by:

Related to: