Transaction support for indexed summary views

Summary: Maintains materialized views in transactions for up-to-date results and serializable semantics. Adopts escrow locking with MVCC and snapshot transactions to minimize contention, enabling bulk loads and online index maintenance with recovery. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 3591
Venue: SIGMOD
Year: 2004
Pagerank: 5.093636e-05
Overall Rank: 12,767 | 12.41%
DOI: 10.1145/1007568.1007606

Incoming Non-self Citations Over Time

No non-self incoming citations found for this paper in this database.

Authors

1. Goetz Graefe (Microsoft)
2. Michael Zwilling (Microsoft)

BibTeX Citation

@inproceedings{graefe_sigmod04,
        title = {{Transaction support for indexed summary views}},
        author = {Graefe, Goetz and Zwilling, Michael},
        series = {{SIGMOD} '04},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/1007568.1007606},
        url = {https://dl.acm.org/doi/10.1145/1007568.1007606},
        year = {2004}
}

Incoming Citations (Sorted by Pagerank)

Showing 0 of 0 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank

Outgoing Citations (Sorted by Pagerank)

Showing 11 of 11 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.00058720861
924	Algorithms for Creating Indexes for Very Large Tables Without Quiescing Updates	1992	SIGMOD	0.00013185068
1,361	Updating Derived Relations: Detecting Irrelevant and Autonomously Computable Updates	1986	VLDB	0.00011037801
1,501	Key Range Locking Strategies for Improved Concurrency	1993	VLDB	0.00010559899
2,064	Incremental Maintenance for Non-Distributive Aggregate Functions	2002	VLDB	9.2383582e-05
2,193	Architectural Issues of Transaction Management in Multi-Layered Systems	1984	VLDB	8.973733e-05
2,738	Utilization of B-trees with Inserts, Deletes and Modifies	1989	PODS	8.1875737e-05
3,348	Multi-Level Recovery	1990	PODS	7.4945952e-05
3,680	MLR: A Recovery Method for Multi-level Systems	1992	SIGMOD	7.2042508e-05
5,119	Commit LSN: A Novel and Simple Method for Reducing Locking and Latching in Transaction Processing Systems	1990	VLDB	6.3577506e-05
7,970	Locking Protocols for Materialized Aggregate Join Views	2003	VLDB	5.516316e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	2,729	On-the-Fly, Incremental, Consistent Reading of Entire Databases	1985	VLDB
2	2,614	Locking Key Ranges with Unbundled Transaction Services	2009	VLDB
3	903	An Empirical Evaluation of In-Memory Multi-Version Concurrency Control	2017	VLDB
4	5,903	Concurrency Control for Adaptive Indexing	2012	VLDB
5	7,681	Efficient Concurrency Control in Multidimensional Access Methods	1999	SIGMOD
6	233	Fast Serializable Multi-Version Concurrency Control for Main-Memory Database Systems	2015	SIGMOD
7	6,751	An Almost-Serial Protocol for Transaction Execution in Main-Memory Database Systems	2002	VLDB
8	172	High-Performance Concurrency Control Mechanisms for Main-Memory Databases	2012	VLDB
9	4,218	Reducing Database Locking Contention Through Multi-version Concurrency	2014	VLDB
10	7,970	Locking Protocols for Materialized Aggregate Join Views	2003	VLDB