Database Paper Browser

Back to papers

Efficiently Updating Materialized Views

Summary: Filters base updates to drop irrelevant ones before re-evaluating the materialized view; irrelevance conditions are necessary, sufficient, and state-independent. For remaining updates, a differential algorithm reuses the view expression and update operations to refresh the view. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
2294
Venue
SIGMOD
Year
1986
Pagerank
0.00047924678
Overall Rank
39 | 99.74%
DOI
-

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 48 of 98 citing papers.

Rank Citing Paper Year Venue Pagerank
2,992 Applying Update Streams in a Soft Real-Time Database System 1995 SIGMOD 7.9351799e-05
3,336 Expiring Data in a Warehouse 1998 VLDB 7.5696054e-05
3,780 Efficiently Incorporating User Feedback into Information Extraction and Integration Programs 2009 SIGMOD 7.1845634e-05
3,826 On Efficiently Implementing SchemaSQL on a SQL Database System 1999 VLDB 7.1508566e-05
3,879 Data Canopy: Accelerating Exploratory Statistical Analysis 2017 SIGMOD 7.1089955e-05
4,079 Generalized Scale Independence Through Incremental Precomputation 2013 SIGMOD 6.9792943e-05
4,082 Efficiently Supporting Procedures In Relational Database Systems 1987 SIGMOD 6.9777736e-05
4,346 Incremental View Maintenance over Array Data 2017 SIGMOD 6.8209882e-05
4,666 Processing Queries Against Database Procedures: A Performance Analysis 1988 SIGMOD 6.637324e-05
5,041 View Invalidation for Dynamic Content Caching in Multitiered Architectures 2002 VLDB 6.4566199e-05
5,115 Density-optimized Intersection-free Mapping and Matrix Multiplication for Join-Project Operations 2022 VLDB 6.4228413e-05
5,514 iTurboGraph: Scaling and Automating Incremental Graph Analytics 2021 SIGMOD 6.2553299e-05
5,753 Inspector Joins 2005 VLDB 6.1626412e-05
5,754 Incrementally Maintaining Classification using an RDBMS 2011 VLDB 6.1624967e-05
5,779 An In-Depth Study of Continuous Subgraph Matching 2022 VLDB 6.1549096e-05
5,980 Extending Logging for Database Snapshot Refresh 1987 VLDB 6.0815008e-05
6,057 iOLAP: Managing Uncertainty for Efficient Incremental OLAP 2016 SIGMOD 6.0536473e-05
6,091 Incremental View Maintenance For Collection Programming 2016 PODS 6.0420866e-05
6,192 Solving Implication Problems in Database Applications 1989 SIGMOD 6.0190924e-05
6,314 Analytical Modeling of Materialized View Maintenance 1988 PODS 5.9761725e-05
6,382 MonetDB/DataCell: Online Analytics in a Streaming Column-Store 2012 VLDB 5.9591195e-05
6,521 Compensation-Based On-Line Query Processing 1992 SIGMOD 5.910784e-05
6,561 Stacked Indexed Views in Microsoft SQL Server 2005 SIGMOD 5.8970869e-05
6,631 A Decision Procedure for Conjunctive Query Disjointness 1989 PODS 5.8768586e-05
6,642 Utilizing IDs to Accelerate Incremental View Maintenance 2015 SIGMOD 5.8732813e-05
6,966 Tempura: A General Cost-Based Optimizer Framework for Incremental Data Processing 2021 VLDB 5.7974227e-05
7,091 Intermittent Query Processing 2019 VLDB 5.7589718e-05
7,844 Thrifty Query Execution via Incrementability 2020 SIGMOD 5.6022439e-05
7,856 Incremental Maintenance of Path-Expression Views 2005 SIGMOD 5.6000286e-05
7,999 Maintaining XPath Views in Loosely Coupled Systems 2006 VLDB 5.5668597e-05
8,081 Foreign Keys Open the Door for Faster Incremental View Maintenance 2023 SIGMOD 5.5504198e-05
8,090 Ajax-based Report Pages as Incrementally Rendered Views 2010 SIGMOD 5.5480119e-05
8,095 Data Management for Large Rule Systems 1991 VLDB 5.5468512e-05
8,241 Minimizing Efforts in Validating Crowd Answers 2015 SIGMOD 5.5254556e-05
8,416 Satisfiability and Relevance for Queries over Active Documents 2009 PODS 5.4958075e-05
9,354 READY: Completeness is in the Eye of the Beholder 2017 CIDR 5.3439916e-05
9,415 TreeToaster: Towards an IVM-Optimized Compiler 2021 SIGMOD 5.3341661e-05
9,576 Incremental View Maintenance for Property Graph Queries 2018 SIGMOD 5.3128975e-05
9,908 Keep Your Distributed Data Warehouse Consistent at a Minimal Cost 2023 SIGMOD 5.2450101e-05
10,427 Streaming Democratized: Ease Across the Latency Spectrum with Delayed View Semantics and Snowflake Dynamic Tables 2025 SIGMOD 5.1725247e-05
11,196 A Step Toward Deep Online Aggregation 2023 SIGMOD 5.1725247e-05
11,242 Autonomously Computable Information Extraction 2023 VLDB 5.1725247e-05
11,629 InvaliDB: Scalable Push-Based Real-Time Queries on Top of Pull-Based Databases (Extended) 2020 VLDB 5.1725247e-05
12,445 K-Relevance: A Spectrum of Relevance for Data Sources Impacting a Query 2007 SIGMOD 5.1725247e-05
12,736 Dynamic Tree Isomorphism via First-order Updates to a Relational Database 1998 PODS 5.1725247e-05
12,803 Space-Bounded FOIES 1995 PODS 5.1725247e-05
12,923 Function Materialization in Object Bases 1991 SIGMOD 5.1725247e-05
13,001 Query Optimization By Stored Queries 1987 VLDB 5.1725247e-05
Previous Page 2 / 2 Next

Outgoing Citations (Sorted by Pagerank)

Showing 3 of 3 cited papers.

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

Rank Cited Paper Year Venue Pagerank
95 Efficient Optimization of a Class of Relational Expressions 1978 SIGMOD 0.00034884701
369 Maintenance Of Views 1984 SIGMOD 0.00020062871
528 Efficient Monitoring of Database Assertions 1978 SIGMOD 0.00017107035
Previous Page 1 / 1 Next

Semantically Similar Papers