Database Paper Browser

Back to papers

Materialized View Selection and Maintenance Using Multi-Query Optimization

Summary: Multi-query optimization for MV maintenance exploits cross-view subexpressions to share work via transient and permanent materialization. A unified framework jointly selects exprs/idxs and maintenance plans across views, delivering major maintenance-time savings. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
3279
Venue
SIGMOD
Year
2001
Pagerank
0.00013902997
Overall Rank
1,110 | 92.29%
DOI
-

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 28 of 28 citing papers.

Rank Citing Paper Year Venue Pagerank
244 Continuously Adaptive Continuous Queries over Streams 2002 SIGMOD 0.00031037999
1,475 Efficient Exploitation of Similar Subexpressions for Query Processing 2007 SIGMOD 0.00011765071
1,646 Caravan: Provisioning for What-If Analysis 2013 CIDR 0.00011026644
2,695 An Architecture for Recycling Intermediates in a Column-store 2009 SIGMOD 8.2827669e-05
3,314 Multiple Query Optimization on the D-Wave 2X Adiabatic Quantum Computer 2016 VLDB 7.2318547e-05
3,596 Continuous Sampling for Online Aggregation Over Multiple Queries 2010 SIGMOD 6.9342283e-05
4,012 Scalable Pattern Sharing on Event Streams 2016 SIGMOD 6.5338454e-05
4,457 Generalized Scale Independence Through Incremental Precomputation 2013 SIGMOD 6.1636855e-05
4,573 Incremental View Maintenance over Array Data 2017 SIGMOD 6.0680332e-05
5,778 Graph-Aware, Workload-Adaptive SPARQL Query Caching 2015 SIGMOD 5.3274776e-05
5,925 HMAB: Self-Driving Hierarchy of Bandits for Integrated Physical Database Design Tuning 2023 VLDB 5.2669029e-05
6,607 Balancing Performance and Data Freshness in Web Database Servers 2003 VLDB 4.9913878e-05
6,813 Near-Optimal Algorithms for Shared Filter Evaluation in Data Stream Systems 2008 SIGMOD 4.9135157e-05
6,871 State-Slice: New Paradigm of Multi-query Optimization of Window-based Stream Queries 2006 VLDB 4.8966771e-05
6,966 Utilizing IDs to Accelerate Incremental View Maintenance 2015 SIGMOD 4.8754926e-05
7,397 Intermittent Query Processing 2019 VLDB 4.7367491e-05
7,616 Qunits: queried units for database search 2009 CIDR 4.6901111e-05
7,690 ROBUS: Fair Cache Allocation for Data-parallel Workloads 2017 SIGMOD 4.6723821e-05
7,807 Scaling a Declarative Cluster Manager Architecture with Query Optimization Techniques 2023 VLDB 4.6417687e-05
8,288 View Selection over Knowledge Graphs in Triple Stores 2021 VLDB 4.5392079e-05
9,450 Online Optimization and Fair Costing for Dynamic Data Sharing in a Cloud Data Market 2014 SIGMOD 4.3367172e-05
9,851 Adaptive Schema Databases 2017 CIDR 4.2680295e-05
9,963 Classifier Construction Under Budget Constraints 2022 SIGMOD 4.2229209e-05
10,116 Stochastic Submodular Data Forgetting 2026 SIGMOD 4.1905499e-05
10,512 Self-Enhancing Video Data Management System for Compositional Events with Large Language Models 2025 SIGMOD 4.1905499e-05
10,767 SIEVE: Effective Filtered Vector Search with Collection of Indexes 2025 VLDB 4.1905499e-05
11,599 Minimization of Classifier Construction Cost for Search Queries 2020 SIGMOD 4.1905499e-05
11,662 An Efficient Index for RDF Query Containment 2019 SIGMOD 4.1905499e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 6 of 6 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.0011695087
55 Efficiently Updating Materialized Views 1986 SIGMOD 0.00065687017
160 Automated Selection of Materialized Views and Indexes for SQL Databases 2000 VLDB 0.00040053897
179 Efficient and Extensible Algorithms for Multi Query Optimization 2000 SIGMOD 0.00037637319
482 Incremental Maintenance of Views with Duplicates 1995 SIGMOD 0.00022145976
775 Materialized View Maintenance and Integrity Constraint Checking: Trading Space for Time 1996 SIGMOD 0.00016775051
Previous Page 1 / 1 Next

Semantically Similar Papers

Overall Rank Paper Year Venue Pagerank
5,484 Multiple-View Self-Maintenance in Data Warehousing Environments 1997 VLDB 5.4826436e-05
4,084 On the Content of Materialized Aggregate Views 2000 PODS 6.4581296e-05
2,026 Lazy Maintenance of Materialized Views 2007 VLDB 9.7466372e-05
1,620 Adapting Materialized Views after Redefinitions 1995 SIGMOD 0.00011112989
6,304 Analytical Modeling of Materialized View Maintenance 1988 PODS 5.1160893e-05
55 Efficiently Updating Materialized Views 1986 SIGMOD 0.00065687017
658 A Performance Analysis of View Materialization Strategies 1987 SIGMOD 0.00018566555
775 Materialized View Maintenance and Integrity Constraint Checking: Trading Space for Time 1996 SIGMOD 0.00016775051
1,911 Algorithms for Materialized View Design in Data Warehousing Environment 1997 VLDB 0.00010117173
728 Optimizing Queries Using Materialized Views: A Practical, Scalable Solution 2001 SIGMOD 0.00017459654