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
3278
Venue
SIGMOD
Year
2001
Pagerank
0.00013917776
Overall Rank
1,112 | 92.27%
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.00031066222
1,476 Efficient Exploitation of Similar Subexpressions for Query Processing 2007 SIGMOD 0.00011779092
1,646 Caravan: Provisioning for What-If Analysis 2013 CIDR 0.00011036992
2,693 An Architecture for Recycling Intermediates in a Column-store 2009 SIGMOD 8.2883398e-05
3,312 Multiple Query Optimization on the D-Wave 2X Adiabatic Quantum Computer 2016 VLDB 7.2388261e-05
3,594 Continuous Sampling for Online Aggregation Over Multiple Queries 2010 SIGMOD 6.9381343e-05
4,007 Scalable Pattern Sharing on Event Streams 2016 SIGMOD 6.5397067e-05
4,455 Generalized Scale Independence Through Incremental Precomputation 2013 SIGMOD 6.171182e-05
4,574 Incremental View Maintenance over Array Data 2017 SIGMOD 6.0738556e-05
5,771 Graph-Aware, Workload-Adaptive SPARQL Query Caching 2015 SIGMOD 5.3325981e-05
5,924 HMAB: Self-Driving Hierarchy of Bandits for Integrated Physical Database Design Tuning 2023 VLDB 5.2719183e-05
6,607 Balancing Performance and Data Freshness in Web Database Servers 2003 VLDB 4.9962123e-05
6,753 State-Slice: New Paradigm of Multi-query Optimization of Window-based Stream Queries 2006 VLDB 4.9387235e-05
6,815 Near-Optimal Algorithms for Shared Filter Evaluation in Data Stream Systems 2008 SIGMOD 4.9177481e-05
6,968 Utilizing IDs to Accelerate Incremental View Maintenance 2015 SIGMOD 4.8801295e-05
7,407 Intermittent Query Processing 2019 VLDB 4.7373205e-05
7,615 Qunits: queried units for database search 2009 CIDR 4.6946145e-05
7,689 ROBUS: Fair Cache Allocation for Data-parallel Workloads 2017 SIGMOD 4.6765769e-05
7,805 Scaling a Declarative Cluster Manager Architecture with Query Optimization Techniques 2023 VLDB 4.6462265e-05
8,295 View Selection over Knowledge Graphs in Triple Stores 2021 VLDB 4.5435639e-05
9,444 Online Optimization and Fair Costing for Dynamic Data Sharing in a Cloud Data Market 2014 SIGMOD 4.3408772e-05
9,851 Adaptive Schema Databases 2017 CIDR 4.2721228e-05
9,964 Classifier Construction Under Budget Constraints 2022 SIGMOD 4.2269436e-05
10,116 Stochastic Submodular Data Forgetting 2026 SIGMOD 4.1945683e-05
10,503 Self-Enhancing Video Data Management System for Compositional Events with Large Language Models 2025 SIGMOD 4.1945683e-05
10,761 SIEVE: Effective Filtered Vector Search with Collection of Indexes 2025 VLDB 4.1945683e-05
11,595 Minimization of Classifier Construction Cost for Search Queries 2020 SIGMOD 4.1945683e-05
11,657 An Efficient Index for RDF Query Containment 2019 SIGMOD 4.1945683e-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.0011708144
55 Efficiently Updating Materialized Views 1986 SIGMOD 0.00065762967
158 Automated Selection of Materialized Views and Indexes for SQL Databases 2000 VLDB 0.00040071492
179 Efficient and Extensible Algorithms for Multi Query Optimization 2000 SIGMOD 0.00037672155
481 Incremental Maintenance of Views with Duplicates 1995 SIGMOD 0.00022167223
779 Materialized View Maintenance and Integrity Constraint Checking: Trading Space for Time 1996 SIGMOD 0.00016786961
Previous Page 1 / 1 Next

Semantically Similar Papers

Overall Rank Paper Year Venue Pagerank
5,480 Multiple-View Self-Maintenance in Data Warehousing Environments 1997 VLDB 5.484741e-05
4,082 On the Content of Materialized Aggregate Views 2000 PODS 6.4639136e-05
2,022 Lazy Maintenance of Materialized Views 2007 VLDB 9.754634e-05
1,617 Adapting Materialized Views after Redefinitions 1995 SIGMOD 0.00011119837
6,301 Analytical Modeling of Materialized View Maintenance 1988 PODS 5.1219348e-05
55 Efficiently Updating Materialized Views 1986 SIGMOD 0.00065762967
653 A Performance Analysis of View Materialization Strategies 1987 SIGMOD 0.00018626606
779 Materialized View Maintenance and Integrity Constraint Checking: Trading Space for Time 1996 SIGMOD 0.00016786961
1,911 Algorithms for Materialized View Design in Data Warehousing Environment 1997 VLDB 0.00010120234
731 Optimizing Queries Using Materialized Views: A Practical, Scalable Solution 2001 SIGMOD 0.00017468889