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: 3027
Venue: SIGMOD
Year: 1997
Pagerank: 8.2491468e-05
Overall Rank: 2,692 | 81.54%
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,606	Mesa: Geo-Replicated, Near Real-Time, Scalable Data Warehousing	2014	VLDB	0.00010228576
1,676	Feeding Frenzy: Selectively Materializing Users' Event Feeds	2010	SIGMOD	0.00010034449
1,750	Lazy Maintenance of Materialized Views	2007	VLDB	9.8392477e-05
2,966	Asynchronous View Maintenance for VLSD Databases	2009	SIGMOD	7.9152992e-05
3,087	How to Win a Hot Dog Eating Contest: Distributed Incremental View Maintenance with Batch Updates	2016	SIGMOD	7.7702906e-05
3,137	Pushing Data-Induced Predicates Through Joins in Big-Data Clusters	2020	VLDB	7.7204167e-05
5,117	View Invalidation for Dynamic Content Caching in Multitiered Architectures	2002	VLDB	6.3581741e-05
5,728	Shrinking the Warehouse Update Window	1999	SIGMOD	6.1073148e-05
8,151	Evolvable View Environment (EVE): Non-Equivalent View Maintenance under Schema Changes	1999	SIGMOD	5.4773351e-05
8,219	Ajax-based Report Pages as Incrementally Rendered Views	2010	SIGMOD	5.4642154e-05
9,392	A Step Toward Deep Online Aggregation	2023	SIGMOD	5.2755515e-05
9,598	Online Optimization and Fair Costing for Dynamic Data Sharing in a Cloud Data Market	2014	SIGMOD	5.2494989e-05
10,063	Keep Your Distributed Data Warehouse Consistent at a Minimal Cost	2023	SIGMOD	5.1650158e-05
12,630	K-Relevance: A Spectrum of Relevance for Data Sources Impacting a Query	2007	SIGMOD	5.093636e-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.00047309646
61	Maintaining Views Incrementally	1993	SIGMOD	0.00039026867
258	Deriving Production Rules for Incremental View Maintenance	1991	VLDB	0.00023131981
373	Maintenance Of Views	1984	SIGMOD	0.00019797816
375	Incremental Maintenance of Views with Duplicates	1995	SIGMOD	0.00019681204
391	View Maintenance in a Warehousing Environment	1995	SIGMOD	0.00019370653
1,133	Algorithms for Deferred View Maintenance	1996	SIGMOD	0.00012039326
2,901	A Framework for Supporting Data Integration Using the Materialized and Virtual Approaches	1996	SIGMOD	7.9774387e-05
3,130	Language Constructs for Programming Active Databases	1991	VLDB	7.7250012e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	1,091	Incremental Maintenance of Externally Materialized Views	1996	VLDB
2	2,771	Supporting Multiple View Maintenance Policies	1997	SIGMOD
3	6,648	Performance Issues in Incremental Warehouse Maintenance	2000	VLDB
4	929	Materialized View Selection and Maintenance Using Multi-Query Optimization	2001	SIGMOD
5	5,728	Shrinking the Warehouse Update Window	1999	SIGMOD
6	10,063	Keep Your Distributed Data Warehouse Consistent at a Minimal Cost	2023	SIGMOD
7	1,715	On-Line Warehouse View Maintenance	1997	SIGMOD
8	1,133	Algorithms for Deferred View Maintenance	1996	SIGMOD
9	391	View Maintenance in a Warehousing Environment	1995	SIGMOD
10	5,779	Multiple-View Self-Maintenance in Data Warehousing Environments	1997	VLDB