Efficient View Maintenance at Data Warehouses

Summary: SWEEP and Nested SWEEP for incremental view maintenance in warehouses with multiple distributed sources. Local compensation enables concurrent updates with no quiescence and linear messaging; Nested SWEEP maintains strong consistency for composite updates. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: h2b0e6e793614cca9
Venue: SIGMOD
Year: 1997
Pagerank: 8.0688837e-05
Overall Rank: 2,741 | 81.58%
DOI: 10.1145/253260.253355

Incoming Non-self Citations Over Time

Authors

1. D. Agrawal (University of California Santa Barbara)
2. A. El Abbadi (University of California Santa Barbara)
3. A. Singh (University of California Santa Barbara)
4. T. Yurek (University of California Santa Barbara)

BibTeX Citation

@inproceedings{agrawal_sigmod97,
        title = {{Efficient View Maintenance at Data Warehouses}},
        author = {Agrawal, D. and Abbadi, A. El and Singh, A. and Yurek, T.},
        series = {{SIGMOD} '97},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/253260.253355},
        url = {https://dl.acm.org/doi/10.1145/253260.253355},
        year = {1997}
}

Incoming Citations (Sorted by Pagerank)

Showing 14 of 14 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
1,622	Mesa: Geo-Replicated, Near Real-Time, Scalable Data Warehousing	2014	VLDB	0.00010051462
1,701	Feeding Frenzy: Selectively Materializing Users' Event Feeds	2010	SIGMOD	9.8371359e-05
1,779	Lazy Maintenance of Materialized Views	2007	VLDB	9.6583009e-05
3,019	Asynchronous View Maintenance for VLSD Databases	2009	SIGMOD	7.7461391e-05
3,073	Pushing Data-Induced Predicates Through Joins in Big-Data Clusters	2020	VLDB	7.6777283e-05
3,128	How to Win a Hot Dog Eating Contest: Distributed Incremental View Maintenance with Batch Updates	2016	SIGMOD	7.6151967e-05
5,240	View Invalidation for Dynamic Content Caching in Multitiered Architectures	2002	VLDB	6.215518e-05
5,839	Shrinking the Warehouse Update Window	1999	SIGMOD	5.9746195e-05
8,320	Evolvable View Environment (EVE): Non-Equivalent View Maintenance under Schema Changes	1999	SIGMOD	5.3546275e-05
8,386	Ajax-based Report Pages as Incrementally Rendered Views	2010	SIGMOD	5.3417391e-05
9,575	A Step Toward Deep Online Aggregation	2023	SIGMOD	5.1571823e-05
9,775	Online Optimization and Fair Costing for Dynamic Data Sharing in a Cloud Data Market	2014	SIGMOD	5.1317143e-05
10,268	Keep Your Distributed Data Warehouse Consistent at a Minimal Cost	2023	SIGMOD	5.0491419e-05
12,920	K-Relevance: A Spectrum of Relevance for Data Sources Impacting a Query	2007	SIGMOD	4.9793485e-05

Outgoing Citations (Sorted by Pagerank)

Showing 9 of 9 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
39	Efficiently Updating Materialized Views	1986	SIGMOD	0.00046602544
62	Maintaining Views Incrementally	1993	SIGMOD	0.00039045511
246	Deriving Production Rules for Incremental View Maintenance	1991	VLDB	0.00023212582
380	Maintenance Of Views	1984	SIGMOD	0.00019511838
388	Incremental Maintenance of Views with Duplicates	1995	SIGMOD	0.00019350381
398	View Maintenance in a Warehousing Environment	1995	SIGMOD	0.00019152162
1,150	Algorithms for Deferred View Maintenance	1996	SIGMOD	0.00011809311
2,962	A Framework for Supporting Data Integration Using the Materialized and Virtual Approaches	1996	SIGMOD	7.8061777e-05
3,185	Language Constructs for Programming Active Databases	1991	VLDB	7.556677e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	1,089	Incremental Maintenance of Externally Materialized Views	1996	VLDB
2	2,801	Supporting Multiple View Maintenance Policies	1997	SIGMOD
3	6,759	Performance Issues in Incremental Warehouse Maintenance	2000	VLDB
4	923	Materialized View Selection and Maintenance Using Multi-Query Optimization	2001	SIGMOD
5	5,839	Shrinking the Warehouse Update Window	1999	SIGMOD
6	10,268	Keep Your Distributed Data Warehouse Consistent at a Minimal Cost	2023	SIGMOD
7	1,753	On-Line Warehouse View Maintenance	1997	SIGMOD
8	1,150	Algorithms for Deferred View Maintenance	1996	SIGMOD
9	398	View Maintenance in a Warehousing Environment	1995	SIGMOD
10	5,888	Multiple-View Self-Maintenance in Data Warehousing Environments	1997	VLDB