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: hbeabff33904975df
Venue: VLDB
Year: 2003
Pagerank: 5.3930626e-05
Overall Rank: 8,134 | 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,321	Generalized Scale Independence Through Incremental Precomputation	2013	SIGMOD	6.6660222e-05
13,057	Transaction support for indexed summary views	2004	SIGMOD	4.9793485e-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
221	ARIES/KVL: A Key-Value Locking Method for Concurrency Control of Multiaction Transactions Operating on B-Tree Indexes	1990	VLDB	0.00024274803
566	On Computing Correlated Aggregates Over Continual Data Streams	2001	SIGMOD	0.00016295476
983	ARIES/IM: An Efficient and High Concurrency Index Management Method Using Write-Ahead Logging	1992	SIGMOD	0.00012706526
1,526	Key Range Locking Strategies for Improved Concurrency	1993	VLDB	0.0001035143
2,263	Concurrency and Recovery in Generalized Search Trees	1997	SIGMOD	8.7304715e-05
4,682	Concurrency on High-Traffic Data Elements	1982	PODS	6.4720546e-05
5,237	Commit LSN: A Novel and Simple Method for Reducing Locking and Latching in Transaction Processing Systems	1990	VLDB	6.2170143e-05

Semantically Similar Papers

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