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: h050b17845c8247b8
Venue: VLDB
Year: 2007
Pagerank: 9.6583009e-05
Overall Rank: 1,779 | 88.05%
DOI: 10.14778/1329682.1329689

Incoming Non-self Citations Over Time

Authors

1. Jingren Zhou (Microsoft)
2. Per-Ake Larson (Microsoft)
3. Hicham G. Elmongui (Alexandria University; Purdue University)

BibTeX Citation

@article{zhou_vldb07,
        title = {{Lazy Maintenance of Materialized Views}},
        author = {Zhou, Jingren and Larson, Per-Ake and Elmongui, Hicham G.},
        journal = {PVLDB},
        series = {{VLDB} '07},
        pages = {231--242},
        doi = {10.14778/1329682.1329689},
        url = {https://doi.org/10.14778/1329682.1329689},
        year = {2007}
}

Incoming Citations (Sorted by Pagerank)

Showing 23 of 23 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
408	DBToaster: Higher-order Delta Processing for Dynamic, Frequently Fresh Views	2012	VLDB	0.00018900199
1,701	Feeding Frenzy: Selectively Materializing Users' Event Feeds	2010	SIGMOD	9.8371359e-05
1,947	Scalable Atomic Visibility with RAMP Transactions	2014	SIGMOD	9.3241479e-05
3,019	Asynchronous View Maintenance for VLSD Databases	2009	SIGMOD	7.7461391e-05
4,503	Incremental View Maintenance over Array Data	2017	SIGMOD	6.5734419e-05
5,637	MaSM: Efficient Online Updates in Data Warehouses	2011	SIGMOD	6.0569403e-05
5,718	Indexing in an Actor-Oriented Database	2017	CIDR	6.0190316e-05
6,622	Everything is a Transaction: Unifying Logical Concurrency Control and Physical Data Structure Maintenance in Database Management Systems	2021	CIDR	5.7307819e-05
6,796	Intermittent Query Processing	2019	VLDB	5.6803529e-05
6,814	CrocodileDB: Efficient Database Execution through Intelligent Deferment	2020	CIDR	5.6735614e-05
7,542	Foreign Keys Open the Door for Faster Incremental View Maintenance	2023	SIGMOD	5.4986181e-05
7,722	Resource-efficient Shared Query Execution via Exploiting Time Slackness	2021	SIGMOD	5.467573e-05
7,771	DBToaster: Agile Views in a Dynamic Data Management System	2011	CIDR	5.4553987e-05
7,839	ExDRa: Exploratory Data Science on Federated Raw Data	2021	SIGMOD	5.4432099e-05
8,131	Thrifty Query Execution via Incrementability	2020	SIGMOD	5.3936608e-05
8,213	Scaling a Declarative Cluster Manager Architecture with Query Optimization Techniques	2023	VLDB	5.3770961e-05
8,560	Efficient Incrementialization of Correlated Nested Aggregate Queries using Relative Partial Aggregate Indexes (RPAI)	2022	SIGMOD	5.3142933e-05
9,148	In-depth Analysis of Continuous Subgraph Matching in a Common Delta Query Compilation Framework	2024	SIGMOD	5.2189946e-05
9,226	Streaming Democratized: Ease Across the Latency Spectrum with Delayed View Semantics and Snowflake Dynamic Tables	2025	SIGMOD	5.2056825e-05
10,169	Transactional Panorama: A Conceptual Framework for User Perception in Analytical Visual Interfaces	2023	VLDB	5.0682654e-05
10,268	Keep Your Distributed Data Warehouse Consistent at a Minimal Cost	2023	SIGMOD	5.0491419e-05
11,382	Streaming View: An Efficient Data Processing Engine for Modern Real-time Data Warehouse of Alibaba Cloud	2025	VLDB	4.9793485e-05
12,071	Towards Scalable UDTFs in Noria	2020	SIGMOD	4.9793485e-05

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
19	A Critique of ANSI SQL Isolation Levels	1995	SIGMOD	0.00058781151
39	Efficiently Updating Materialized Views	1986	SIGMOD	0.00046602544
62	Maintaining Views Incrementally	1993	SIGMOD	0.00039045511
388	Incremental Maintenance of Views with Duplicates	1995	SIGMOD	0.00019350381
398	View Maintenance in a Warehousing Environment	1995	SIGMOD	0.00019152162
553	Optimizing Queries Using Materialized Views: A Practical, Scalable Solution	2001	SIGMOD	0.0001652591
648	Materialized Views In Oracle	1998	VLDB	0.00015151422
901	Maintenance of Data Cubes and Summary Tables in a Warehouse	1997	SIGMOD	0.00013185553
1,054	Answering Complex SQL Queries Using Automatic Summary Tables	2000	SIGMOD	0.00012269068
1,131	Efficient Exploitation of Similar Subexpressions for Query Processing	2007	SIGMOD	0.0001189909
1,150	Algorithms for Deferred View Maintenance	1996	SIGMOD	0.00011809311
1,753	On-Line Warehouse View Maintenance	1997	SIGMOD	9.7248839e-05
2,741	Efficient View Maintenance at Data Warehouses	1997	SIGMOD	8.0688837e-05
2,761	How To Roll a Join: Asynchronous Incremental View Maintenance	2000	SIGMOD	8.0473806e-05
8,143	Query Processing for SQL Updates	2004	SIGMOD	5.3912745e-05
8,621	Maintenance of Cube Automatic Summary Tables	2000	SIGMOD	5.3012918e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	1,879	Incremental Maintenance for Materialized Views over Semistructured Data	1998	VLDB
2	553	Optimizing Queries Using Materialized Views: A Practical, Scalable Solution	2001	SIGMOD
3	1,822	Adapting Materialized Views after Redefinitions	1995	SIGMOD
4	744	Materialized View Maintenance and Integrity Constraint Checking: Trading Space for Time	1996	SIGMOD
5	6,524	Analytical Modeling of Materialized View Maintenance	1988	PODS
6	380	Maintenance Of Views	1984	SIGMOD
7	1,150	Algorithms for Deferred View Maintenance	1996	SIGMOD
8	723	A Performance Analysis of View Materialization Strategies	1987	SIGMOD
9	923	Materialized View Selection and Maintenance Using Multi-Query Optimization	2001	SIGMOD
10	39	Efficiently Updating Materialized Views	1986	SIGMOD