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

Summary: Benchmarks MV query acceleration end to end—enumeration, budgeted selection, and optimizer rewriting—across academic, open-source, and commercial systems. A modular, cross-engine protocol exposes strong stage interactions, recurring rewrite regressions, and highly variable realized savings. (summarized by gpt-5.6-luna on Aug 28 2026)

Paper ID: haa5fe051ccb01b17
Venue: VLDB
Year: 2026
Pagerank: 4.9769913e-05
Overall Rank: 10,905 | 26.71%
DOI: 10.14778/3836663.3836724
PDF: Download (CC BY-NC-ND 4.0)

Incoming Non-self Citations Over Time

No non-self incoming citations found for this paper in this database.

Authors

1. Xinjie Hu (Simon Fraser University)
2. Zhengjie Miao (Simon Fraser University)

BibTeX Citation

@article{hu_vldb26,
        title = {{Benchmarking the Full Pipeline of Materialized-View-Based Query Rewriting}},
        author = {Hu, Xinjie and Miao, Zhengjie},
        journal = {PVLDB},
        series = {{VLDB} '26},
        volume = {19},
        number = {11},
        pages = {3772--3785},
        doi = {10.14778/3836663.3836724},
        url = {https://doi.org/10.14778/3836663.3836724},
        year = {2026}
}

Incoming Citations (Sorted by Pagerank)

Showing 0 of 0 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank

Outgoing Citations (Sorted by Pagerank)

Showing 25 of 25 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank	Cited Paper	Year	Venue	Pagerank
11	Implementing Data Cubes Efficiently	1996	SIGMOD	0.00071056708
15	How Good Are Query Optimizers, Really?	2016	VLDB	0.00061067652
72	Answering Queries Using Views (Extended Abstract)	1995	PODS	0.0003753293
85	Learned Cardinalities: Estimating Correlated Joins with Deep Learning	2019	CIDR	0.00035876108
88	Automated Selection of Materialized Views and Indexes for SQL Databases	2000	VLDB	0.00035340164
117	Querying Heterogeneous Information Sources Using Source Descriptions	1996	VLDB	0.00031616101
129	Efficient and Extensible Algorithms for Multi Query Optimization	2000	SIGMOD	0.00030395767
202	Aggregate-Query Processing in Data Warehousing Environments	1995	VLDB	0.0002523837
379	Apache Calcite: A Foundational Framework for Optimized Query Processing Over Heterogeneous Data Sources	2018	SIGMOD	0.00019507406
553	Optimizing Queries Using Materialized Views: A Practical, Scalable Solution	2001	SIGMOD	0.00016518678
577	The GMAP: A Versatile Tool for Physical Data Independence	1994	VLDB	0.00016111779
649	Materialized Views In Oracle	1998	VLDB	0.00015144459
923	Materialized View Selection and Maintenance Using Multi-Query Optimization	2001	SIGMOD	0.00013059066
981	Cardinality Estimation in DBMS: A Comprehensive Benchmark Evaluation	2022	VLDB	0.00012713454
1,107	Range Queries in OLAP Data Cubes	1997	SIGMOD	0.00011988445
1,132	Efficient Exploitation of Similar Subexpressions for Query Processing	2007	SIGMOD	0.00011893781
1,549	Data Warehouse Configuration	1997	VLDB	0.00010287654
1,706	Algorithms for Materialized View Design in Data Warehousing Environment	1997	VLDB	9.8256789e-05
1,747	Selecting Subexpressions to Materialize at Datacenter Scale	2018	VLDB	9.7303647e-05
2,225	Shared Workload Optimization	2014	VLDB	8.8062552e-05
2,292	Querying Aggregate Data	1999	PODS	8.6850643e-05
3,544	Computation Reuse in Analytics Job Service at Microsoft	2018	SIGMOD	7.2108612e-05
4,007	Automated Generation of Materialized Views in Oracle	2020	VLDB	6.8561069e-05
9,532	UniView: A Unified Autonomous Materialized View Management System for Various Databases	2024	VLDB	5.1648692e-05
9,556	Athena: An Effective Learning-based Framework for Query Optimizer Performance Improvement	2025	SIGMOD	5.1580326e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	7,269	Query Evaluation using Overlapping Views: Completeness and Efficiency	2006	SIGMOD
2	5,238	Implementation Strategies for Views over Property Graphs	2024	SIGMOD
3	8,568	Materialized View Selection for XQuery Workloads	2012	SIGMOD
4	4,232	On the Content of Materialized Aggregate Views	2000	PODS
5	1,054	Answering Complex SQL Queries Using Automatic Summary Tables	2000	SIGMOD
6	6,227	Scalable Query Rewriting: A Graph-Based Approach	2011	SIGMOD
7	567	Answering Queries with Aggregation Using Views	1996	VLDB
8	4,096	Optimizing Refresh of a Set of Materialized Views	2005	VLDB
9	923	Materialized View Selection and Maintenance Using Multi-Query Optimization	2001	SIGMOD
10	553	Optimizing Queries Using Materialized Views: A Practical, Scalable Solution	2001	SIGMOD