Locking Protocols for Materialized Aggregate Join Views

Summary: Extends high-concurrency locking techniques to materialized aggregate join views for transactional maintenance. Demonstrates effectiveness despite indices on the view and highlights limitations of generic concurrency control. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 9199
Venue: VLDB
Year: 2003
Pagerank: 5.516316e-05
Overall Rank: 7,970 | 45.32%
DOI: 10.1016/B978-012722442-8/50059-8

Incoming Non-self Citations Over Time

Authors

1. Gang Luo (University of Wisconsin)
2. Jeffrey F. Naughton (University of Wisconsin)
3. Curt J. Ellmann (NCR Advance Development Lab)
4. Michael W. Watzke (NCR Advance Development Lab)

BibTeX Citation

@article{luo_vldb03,
        title = {{Locking Protocols for Materialized Aggregate Join Views}},
        author = {Luo, Gang and Naughton, Jeffrey F. and Ellmann, Curt J. and Watzke, Michael W.},
        journal = {PVLDB},
        series = {{VLDB} '03},
        doi = {10.1016/B978-012722442-8/50059-8},
        url = {https://doi.org/10.1016/B978-012722442-8/50059-8},
        year = {2003}
}

Incoming Citations (Sorted by Pagerank)

Showing 2 of 2 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
4,250	Generalized Scale Independence Through Incremental Precomputation	2013	SIGMOD	6.8031294e-05
12,767	Transaction support for indexed summary views	2004	SIGMOD	5.093636e-05

Outgoing Citations (Sorted by Pagerank)

Showing 7 of 7 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
214	ARIES/KVL: A Key-Value Locking Method for Concurrency Control of Multiaction Transactions Operating on B-Tree Indexes	1990	VLDB	0.00024680756
551	On Computing Correlated Aggregates Over Continual Data Streams	2001	SIGMOD	0.00016635191
958	ARIES/IM: An Efficient and High Concurrency Index Management Method Using Write-Ahead Logging	1992	SIGMOD	0.00012956148
1,501	Key Range Locking Strategies for Improved Concurrency	1993	VLDB	0.00010559899
2,227	Concurrency and Recovery in Generalized Search Trees	1997	SIGMOD	8.9111106e-05
4,580	Concurrency on High-Traffic Data Elements	1982	PODS	6.6202221e-05
5,119	Commit LSN: A Novel and Simple Method for Reducing Locking and Latching in Transaction Processing Systems	1990	VLDB	6.3577506e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	1,420	Lightweight Locking for Main Memory Database Systems	2013	VLDB
2	14,478	Concurrency Control in Graph Protocols by Using Edge Locks	1984	PODS
3	1,750	Lazy Maintenance of Materialized Views	2007	VLDB
4	172	High-Performance Concurrency Control Mechanisms for Main-Memory Databases	2012	VLDB
5	233	Fast Serializable Multi-Version Concurrency Control for Main-Memory Database Systems	2015	SIGMOD
6	2,725	How To Roll a Join: Asynchronous Incremental View Maintenance	2000	SIGMOD
7	929	Materialized View Selection and Maintenance Using Multi-Query Optimization	2001	SIGMOD
8	7,253	Compatibility And Commutativity In Non-Two-Phase Locking Protocols	1982	PODS
9	2,523	Multidatabase Update Issues	1988	SIGMOD
10	12,767	Transaction support for indexed summary views	2004	SIGMOD