A Performance Analysis of View Materialization Strategies

Summary: Compares query modification, immediate maintenance, and deferred maintenance for views across three structures: select/projection, join, and aggregate. Best method depends on data layout, view definition, and workload. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: h8435ccb3d44bcada
Venue: SIGMOD
Year: 1987
Pagerank: 0.00014436222
Overall Rank: 724 | 95.15%
DOI: 10.1145/38713.38759

Incoming Non-self Citations Over Time

Authors

1. Eric N. Hanson (University of California Berkeley)

BibTeX Citation

@inproceedings{hanson_sigmod87,
        title = {{A Performance Analysis of View Materialization Strategies}},
        author = {Hanson, Eric N.},
        series = {{SIGMOD} '87},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/38713.38759},
        url = {https://dl.acm.org/doi/10.1145/38713.38759},
        year = {1987}
}

Incoming Citations (Sorted by Pagerank)

Showing 20 of 20 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
293	Efficient Management of Transitive Relationships in Large Data and Knowledge Bases	1989	SIGMOD	0.00021884281
400	View Maintenance in a Warehousing Environment	1995	SIGMOD	0.00019089369
401	Query Caching and Optimization in Distributed Mediator Systems	1996	SIGMOD	0.00019080589
904	Maintenance of Data Cubes and Summary Tables in a Warehouse	1997	SIGMOD	0.00013138723
1,150	Algorithms for Deferred View Maintenance	1996	SIGMOD	0.00011766641
1,525	Performance Enhancement Through Replication in an Object-Oriented DBMS	1989	SIGMOD	0.0001032939
1,890	Incremental Maintenance for Materialized Views over Semistructured Data	1998	VLDB	9.4085684e-05
2,809	Supporting Multiple View Maintenance Policies	1997	SIGMOD	7.9616655e-05
2,902	Improving Performance in Replicated Databases through Relaxed Coherency	1995	VLDB	7.8775353e-05
3,115	Applying Update Streams in a Soft Real-Time Database System	1995	SIGMOD	7.6167845e-05
3,411	Orca: Scalable Temporal Graph Neural Network Training with Theoretical Guarantees	2023	SIGMOD	7.3074792e-05
3,640	Efficient Maintenance of Materialized Mediated Views (Extended Abstract)	1995	SIGMOD	7.1242859e-05
4,845	Processing Queries Against Database Procedures: A Performance Analysis	1988	SIGMOD	6.3717336e-05
5,266	View Invalidation for Dynamic Content Caching in Multitiered Architectures	2002	VLDB	6.1920335e-05
6,540	Analytical Modeling of Materialized View Maintenance	1988	PODS	5.7351561e-05
7,147	Intra-Transaction Parallelism in the Mapping of an Object Model to a Relational Multi-Processor System	1996	VLDB	5.580601e-05
7,550	Foreign Keys Open the Door for Faster Incremental View Maintenance	2023	SIGMOD	5.4809422e-05
8,418	Data Management for Large Rule Systems	1991	VLDB	5.3200866e-05
13,445	Function Materialization in Object Bases	1991	SIGMOD	4.9605343e-05
13,499	Temporal Relationships in Databases	1988	VLDB	4.9605343e-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
1	Access Path Selection in a Relational Database Management System	1979	SIGMOD	0.0023948467
39	Efficiently Updating Materialized Views	1986	SIGMOD	0.00046445099
59	Differential Files: Their Application To The Maintenance Of Large Data Bases	1976	SIGMOD	0.00039478403
87	Implementation of Integrity Constraints and Views by Query Modification	1975	SIGMOD	0.00035589793
595	Global Query Optimization	1986	SIGMOD	0.00015791231
709	A Snapshot Differential Refresh Algorithm	1986	SIGMOD	0.00014604787
2,760	An Implementation of Hypothetical Relations	1983	VLDB	8.0258643e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	556	Optimizing Queries Using Materialized Views: A Practical, Scalable Solution	2001	SIGMOD
2	2,809	Supporting Multiple View Maintenance Policies	1997	SIGMOD
3	746	Materialized View Maintenance and Integrity Constraint Checking: Trading Space for Time	1996	SIGMOD
4	1,150	Algorithms for Deferred View Maintenance	1996	SIGMOD
5	1,790	Lazy Maintenance of Materialized Views	2007	VLDB
6	39	Efficiently Updating Materialized Views	1986	SIGMOD
7	6,540	Analytical Modeling of Materialized View Maintenance	1988	PODS
8	1,833	Adapting Materialized Views after Redefinitions	1995	SIGMOD
9	927	Materialized View Selection and Maintenance Using Multi-Query Optimization	2001	SIGMOD
10	383	Maintenance Of Views	1984	SIGMOD