EUVIMEDEUVIMED entdecken
Crossref

Benchmarking the Full Pipeline of Materialized-View-Based Query Rewriting

Xinjie Hu, Zhengjie Miao

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.

AbstractBibliografische AngabenZitierenVerwandte Studien

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}
}
Kostenlos starten →