Database Paper Browser

Back to papers

Lazy Maintenance of Materialized Views

Summary: Proposes lazy maintenance of materialized views to defer upkeep until query references the view, lowering update cost. Techniques: cross-trans batching, condensing multiple row updates, and row versioning; prototype shows faster updates and lower cost. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
9579
Venue
VLDB
Year
2007
Pagerank
9.7466372e-05
Overall Rank
2,026 | 85.93%
DOI
-

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 23 of 23 citing papers.

Rank Citing Paper Year Venue Pagerank
585 DBToaster: Higher-order Delta Processing for Dynamic, Frequently Fresh Views 2012 VLDB 0.00019682634
1,139 Feeding Frenzy: Selectively Materializing Users' Event Feeds 2010 SIGMOD 0.0001371195
2,276 Scalable Atomic Visibility with RAMP Transactions 2014 SIGMOD 9.1320955e-05
3,095 Asynchronous View Maintenance for VLSD Databases 2009 SIGMOD 7.5775325e-05
4,573 Incremental View Maintenance over Array Data 2017 SIGMOD 6.0680332e-05
5,848 MaSM: Efficient Online Updates in Data Warehouses 2011 SIGMOD 5.3023051e-05
5,948 Indexing in an Actor-Oriented Database 2017 CIDR 5.2575489e-05
6,986 CrocodileDB: Efficient Database Execution through Intelligent Deferment 2020 CIDR 4.8672517e-05
7,140 Everything is a Transaction: Unifying Logical Concurrency Control and Physical Data Structure Maintenance in Database Management Systems 2021 CIDR 4.8153926e-05
7,397 Intermittent Query Processing 2019 VLDB 4.7367491e-05
7,699 Resource-efficient Shared Query Execution via Exploiting Time Slackness 2021 SIGMOD 4.6696504e-05
7,702 ExDRa: Exploratory Data Science on Federated Raw Data 2021 SIGMOD 4.6689015e-05
7,807 Scaling a Declarative Cluster Manager Architecture with Query Optimization Techniques 2023 VLDB 4.6417687e-05
7,880 DBToaster: Agile Views in a Dynamic Data Management System 2011 CIDR 4.6250755e-05
8,049 Thrifty Query Execution via Incrementability 2020 SIGMOD 4.5939412e-05
8,182 Foreign Keys Open the Door for Faster Incremental View Maintenance 2023 SIGMOD 4.5616384e-05
8,610 Efficient Incrementialization of Correlated Nested Aggregate Queries using Relative Partial Aggregate Indexes (RPAI) 2022 SIGMOD 4.480988e-05
9,375 In-depth Analysis of Continuous Subgraph Matching in a Common Delta Query Compilation Framework 2024 SIGMOD 4.3452177e-05
9,827 Transactional Panorama: A Conceptual Framework for User Perception in Analytical Visual Interfaces 2023 VLDB 4.2710095e-05
9,907 Keep Your Distributed Data Warehouse Consistent at a Minimal Cost 2023 SIGMOD 4.2536148e-05
10,427 Streaming Democratized: Ease Across the Latency Spectrum with Delayed View Semantics and Snowflake Dynamic Tables 2025 SIGMOD 4.1905499e-05
10,794 Streaming View: An Efficient Data Processing Engine for Modern Real-time Data Warehouse of Alibaba Cloud 2025 VLDB 4.1905499e-05
11,577 Towards Scalable UDTFs in Noria 2020 SIGMOD 4.1905499e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 16 of 16 cited papers.

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

Rank Cited Paper Year Venue Pagerank
23 A Critique of ANSI SQL Isolation Levels 1995 SIGMOD 0.00083899338
55 Efficiently Updating Materialized Views 1986 SIGMOD 0.00065687017
97 Maintaining Views Incrementally 1993 SIGMOD 0.00050863077
402 View Maintenance in a Warehousing Environment 1995 SIGMOD 0.00024179174
470 Materialized Views In Oracle 1998 VLDB 0.00022386815
482 Incremental Maintenance of Views with Duplicates 1995 SIGMOD 0.00022145976
728 Optimizing Queries Using Materialized Views: A Practical, Scalable Solution 2001 SIGMOD 0.00017459654
963 Maintenance of Data Cubes and Summary Tables in a Warehouse 1997 SIGMOD 0.00014975448
1,059 Answering Complex SQL Queries Using Automatic Summary Tables 2000 SIGMOD 0.00014370009
1,428 Algorithms for Deferred View Maintenance 1996 SIGMOD 0.00012030912
1,475 Efficient Exploitation of Similar Subexpressions for Query Processing 2007 SIGMOD 0.00011765071
1,745 On-Line Warehouse View Maintenance 1997 SIGMOD 0.0001069303
2,300 Efficient View Maintenance at Data Warehouses 1997 SIGMOD 9.0703913e-05
3,038 How To Roll a Join: Asynchronous Incremental View Maintenance 2000 SIGMOD 7.6712282e-05
7,788 Query Processing for SQL Updates 2004 SIGMOD 4.6465948e-05
8,169 Maintenance of Cube Automatic Summary Tables 2000 SIGMOD 4.5662628e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

Overall Rank Paper Year Venue Pagerank
1,663 Incremental Maintenance for Materialized Views over Semistructured Data 1998 VLDB 0.00010961643
728 Optimizing Queries Using Materialized Views: A Practical, Scalable Solution 2001 SIGMOD 0.00017459654
1,620 Adapting Materialized Views after Redefinitions 1995 SIGMOD 0.00011112989
775 Materialized View Maintenance and Integrity Constraint Checking: Trading Space for Time 1996 SIGMOD 0.00016775051
6,304 Analytical Modeling of Materialized View Maintenance 1988 PODS 5.1160893e-05
261 Maintenance Of Views 1984 SIGMOD 0.00029976111
1,428 Algorithms for Deferred View Maintenance 1996 SIGMOD 0.00012030912
658 A Performance Analysis of View Materialization Strategies 1987 SIGMOD 0.00018566555
1,110 Materialized View Selection and Maintenance Using Multi-Query Optimization 2001 SIGMOD 0.00013902997
55 Efficiently Updating Materialized Views 1986 SIGMOD 0.00065687017