Database Paper Browser

Back to papers

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
2365
Venue
SIGMOD
Year
1987
Pagerank
0.00018566555
Overall Rank
658 | 95.43%
DOI
-

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 20 of 20 citing papers.

Rank Citing Paper Year Venue Pagerank
253 Query Caching and Optimization in Distributed Mediator Systems 1996 SIGMOD 0.00030517335
255 Efficient Management of Transitive Relationships in Large Data and Knowledge Bases 1989 SIGMOD 0.00030342925
402 View Maintenance in a Warehousing Environment 1995 SIGMOD 0.00024179174
939 Performance Enhancement Through Replication in an Object-Oriented DBMS 1989 SIGMOD 0.000151516
963 Maintenance of Data Cubes and Summary Tables in a Warehouse 1997 SIGMOD 0.00014975448
1,428 Algorithms for Deferred View Maintenance 1996 SIGMOD 0.00012030912
1,663 Incremental Maintenance for Materialized Views over Semistructured Data 1998 VLDB 0.00010961643
2,380 Improving Performance in Replicated Databases through Relaxed Coherency 1995 VLDB 8.928101e-05
2,927 Applying Update Streams in a Soft Real-Time Database System 1995 SIGMOD 7.8860697e-05
3,004 Supporting Multiple View Maintenance Policies 1997 SIGMOD 7.7337788e-05
3,480 Efficient Maintenance of Materialized Mediated Views (Extended Abstract) 1995 SIGMOD 7.053069e-05
4,054 Orca: Scalable Temporal Graph Neural Network Training with Theoretical Guarantees 2023 SIGMOD 6.4910804e-05
4,074 Processing Queries Against Database Procedures: A Performance Analysis 1988 SIGMOD 6.4711064e-05
5,127 View Invalidation for Dynamic Content Caching in Multitiered Architectures 2002 VLDB 5.6735949e-05
6,031 Intra-Transaction Parallelism in the Mapping of an Object Model to a Relational Multi-Processor System 1996 VLDB 5.2365238e-05
6,304 Analytical Modeling of Materialized View Maintenance 1988 PODS 5.1160893e-05
7,802 Data Management for Large Rule Systems 1991 VLDB 4.6429128e-05
8,182 Foreign Keys Open the Door for Faster Incremental View Maintenance 2023 SIGMOD 4.5616384e-05
12,923 Function Materialization in Object Bases 1991 SIGMOD 4.1905499e-05
12,976 Temporal Relationships in Databases 1988 VLDB 4.1905499e-05
Previous Page 1 / 1 Next

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.0040465394
32 Differential Files: Their Application To The Maintenance Of Large Data Bases 1976 SIGMOD 0.00077553033
55 Efficiently Updating Materialized Views 1986 SIGMOD 0.00065687017
69 Implementation of Integrity Constraints and Views by Query Modification 1975 SIGMOD 0.00060388875
406 Global Query Optimization 1986 SIGMOD 0.00023989944
566 A Snapshot Differential Refresh Algorithm 1986 SIGMOD 0.00019944675
2,159 An Implementation of Hypothetical Relations 1983 VLDB 9.4077408e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

Overall Rank Paper Year Venue Pagerank
728 Optimizing Queries Using Materialized Views: A Practical, Scalable Solution 2001 SIGMOD 0.00017459654
3,004 Supporting Multiple View Maintenance Policies 1997 SIGMOD 7.7337788e-05
775 Materialized View Maintenance and Integrity Constraint Checking: Trading Space for Time 1996 SIGMOD 0.00016775051
1,428 Algorithms for Deferred View Maintenance 1996 SIGMOD 0.00012030912
2,026 Lazy Maintenance of Materialized Views 2007 VLDB 9.7466372e-05
55 Efficiently Updating Materialized Views 1986 SIGMOD 0.00065687017
6,304 Analytical Modeling of Materialized View Maintenance 1988 PODS 5.1160893e-05
1,620 Adapting Materialized Views after Redefinitions 1995 SIGMOD 0.00011112989
1,110 Materialized View Selection and Maintenance Using Multi-Query Optimization 2001 SIGMOD 0.00013902997
261 Maintenance Of Views 1984 SIGMOD 0.00029976111