Benchmarking the Full Pipeline of Materialized-View-Based Query Rewriting
Proceedings of the VLDB Endowment · 01.07.2026 · 19 (11) · 3772-3785
DOI: 10.14778/3836663.3836724 ↗Kurz gefasst
Fachartikel in der Zeitschrift Proceedings of the VLDB Endowment, online erschienen am 04.09.2026. Verfasst von Xinjie Hu und 1 weiteren Autor:innen. Die Arbeit wurde bisher 1-mal zitiert (Crossref) und nennt 55 Literaturangaben.
Abstract (Originalsprache)
Materialized views (MVs) accelerate OLAP and data-warehouse workloads by precomputing reusable subexpressions, but practical MV-based query acceleration is a multi-stage pipeline: candidate enumeration, view selection under storage budgets, and query rewriting inside the optimizer. Existing evaluations typically study only parts of this pipeline and within a single system, leaving end-to-end trade-offs and cross-system behavior unclear. In this paper, we benchmark MV-based query rewriting by jointly evaluating enumeration, selection, and rewriting with a modular evaluation framework and by using controlled ablations. We also introduce a cross-engine protocol allowing us to compare systems that expose only execution plans by contrasting native optimizer-level rewriting with portable SQL rewriting baselines when available. Across representative academic methods and modern open-source and commercial systems, we find strong interaction effects across stages and large variability in MV usage and realized savings. We identify recurring failure modes that explain performance regressions after rewriting. Our results highlight which pipeline stages most often limit performance and provide evidence to guide future MV enumeration, selection, and rewriting designs.
Zitieren
APA
Hu, X., & Miao, Z. (2026). Benchmarking the Full Pipeline of Materialized-View-Based Query Rewriting. Proceedings of the VLDB Endowment, 19(11), 3772-3785. https://doi.org/10.14778/3836663.3836724
Vancouver
Hu X, Miao Z. Benchmarking the Full Pipeline of Materialized-View-Based Query Rewriting. Proceedings of the VLDB Endowment. 2026;19(11):3772-3785. doi:10.14778/3836663.3836724
BibTeX
@article{Hu2026,
author = {Hu, Xinjie and Miao, Zhengjie},
title = {Benchmarking the Full Pipeline of Materialized-View-Based Query Rewriting},
journal = {Proceedings of the VLDB Endowment},
year = {2026},
volume = {19},
number = {11},
pages = {3772--3785},
doi = {10.14778/3836663.3836724}
}
EUVIMED