DBScholar

Back to papers

View Maintenance in a Warehousing Environment

Summary: Warehousing: materialized views decoupled from base data cause anomalies for traditional maintenance. Introduces ECA (Eager Compensating Algorithm) with compensating queries to remove anomalies; includes streamlined variants and a performance study vs recomputation. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
h0e8f5ff7b5451184
Venue
SIGMOD
Year
1995
Pagerank
0.00019089369
Overall Rank
400 | 97.33%
DOI
10.1145/223784.223848

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{zhuge_sigmod95,
        title = {{View Maintenance in a Warehousing Environment}},
        author = {Zhuge, Yue and Garcia-Molina, Hector and Hammer, Joachim and Widom, Jennifer},
        series = {{SIGMOD} '95},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/223784.223848},
        url = {https://dl.acm.org/doi/10.1145/223784.223848},
        year = {1995}
}

Incoming Citations (Sorted by Pagerank)

Showing 43 of 43 citing papers.

Rank Citing Paper Year Venue Pagerank
567 Answering Queries with Aggregation Using Views 1996 VLDB 0.00016228477
648 Materialized View Selection in a Multidimensional Database 1997 VLDB 0.00015161755
781 Lazy Database Replication with Snapshot Isolation 2006 VLDB 0.00014038257
904 Maintenance of Data Cubes and Summary Tables in a Warehouse 1997 SIGMOD 0.00013138723
1,003 Multi-Dimensional Database Allocation for Parallel Data Warehouses 2000 VLDB 0.00012558273
1,088 Incremental Maintenance of Externally Materialized Views 1996 VLDB 0.00012066587
1,128 Structured Streaming: A Declarative API for Real-Time Applications in Apache Spark 2018 SIGMOD 0.00011887295
1,150 Algorithms for Deferred View Maintenance 1996 SIGMOD 0.00011766641
1,168 Fast Algorithms for Maintaining Replica Consistency in Lazy Master Replicated Databases 1999 VLDB 0.00011696293
1,528 Managing Semantic Heterogeneity in Databases : A Theoretical Perspective 1997 PODS 0.00010322417
1,535 Change Detection in Hierarchically Structured Information 1996 SIGMOD 0.00010299485
1,550 Data Warehouse Configuration 1997 VLDB 0.00010257652
1,645 Synchronizing a database to Improve Freshness 2000 SIGMOD 9.9752579e-05
1,705 Feeding Frenzy: Selectively Materializing Users' Event Feeds 2010 SIGMOD 9.8056169e-05
1,790 Lazy Maintenance of Materialized Views 2007 VLDB 9.6228433e-05
2,140 Query Rewriting for Semistructured Data 1999 SIGMOD 8.9688891e-05
2,753 Efficient View Maintenance at Data Warehouses 1997 SIGMOD 8.0386655e-05
2,809 Supporting Multiple View Maintenance Policies 1997 SIGMOD 7.9616655e-05
2,825 Saga: A Platform for Continuous Construction and Serving of Knowledge At Scale 2022 SIGMOD 7.9503483e-05
2,978 A Framework for Supporting Data Integration Using the Materialized and Virtual Approaches 1996 SIGMOD 7.7768335e-05
3,029 Asynchronous View Maintenance for VLSD Databases 2009 SIGMOD 7.7174537e-05
4,571 Consistency in a Stream Warehouse 2011 CIDR 6.5152755e-05
4,896 Efficient Snapshot Differential Algorithms for Data Warehousing 1996 VLDB 6.3491215e-05
4,943 Efficient Answering of Historical What-if Queries 2022 SIGMOD 6.3304729e-05
5,266 View Invalidation for Dynamic Content Caching in Multitiered Architectures 2002 VLDB 6.1920335e-05
5,338 QIRANA: A Framework for Scalable Query Pricing 2017 SIGMOD 6.1613525e-05
5,604 Using Partial Evaluation in Distributed Query Evaluation 2006 VLDB 6.0512827e-05
5,781 Exchanging Intensional XML Data 2003 SIGMOD 5.9787261e-05
5,838 Issues in Developing Very Large Data Warehouses 1998 VLDB 5.9592034e-05
5,853 Shrinking the Warehouse Update Window 1999 SIGMOD 5.9520872e-05
5,902 Multiple-View Self-Maintenance in Data Warehousing Environments 1997 VLDB 5.9359247e-05
6,782 Performance Issues in Incremental Warehouse Maintenance 2000 VLDB 5.6677775e-05
6,951 Using Latency-Recency Profiles for Data Delivery on the Web 2002 VLDB 5.6201733e-05
7,183 Just-in-time Data Integration in Action 2010 VLDB 5.5757293e-05
8,231 Scaling a Declarative Cluster Manager Architecture with Query Optimization Techniques 2023 VLDB 5.3573407e-05
8,408 Ajax-based Report Pages as Incrementally Rendered Views 2010 SIGMOD 5.3215712e-05
10,955 Storing and Indexing Multiple Tables by Interesting Orderings: For Efficient Joins, Groupings, and Updates in Relational Databases 2026 VLDB 4.9605343e-05
11,189 Ultraverse: An Efficient What-if Analysis Framework for Software Applications Interacting with Database Systems 2025 SIGMOD 4.9605343e-05
12,121 Towards Scalable UDTFs in Noria 2020 SIGMOD 4.9605343e-05
12,968 K-Relevance: A Spectrum of Relevance for Data Sources Impacting a Query 2007 SIGMOD 4.9605343e-05
12,980 BIwTL: A Business Information Warehouse Toolkit and Language for Warehousing Simplification and Automation 2007 SIGMOD 4.9605343e-05
13,107 Vertical and Horizontal Percentage Aggregations 2004 SIGMOD 4.9605343e-05
13,245 Exploiting Versions for Handling Updates in Broadcast Disks 1999 VLDB 4.9605343e-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
39 Efficiently Updating Materialized Views 1986 SIGMOD 0.00046445099
62 Maintaining Views Incrementally 1993 SIGMOD 0.00038944207
246 Deriving Production Rules for Incremental View Maintenance 1991 VLDB 0.00023146423
383 Maintenance Of Views 1984 SIGMOD 0.00019446075
709 A Snapshot Differential Refresh Algorithm 1986 SIGMOD 0.00014604787
724 A Performance Analysis of View Materialization Strategies 1987 SIGMOD 0.00014436222
4,035 Preliminary Design of ADMS+: A Workstation-Mainframe Integrated Architecture for Database Management Systems 1986 VLDB 6.8266945e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 746 Materialized View Maintenance and Integrity Constraint Checking: Trading Space for Time 1996 SIGMOD
2 1,833 Adapting Materialized Views after Redefinitions 1995 SIGMOD
3 724 A Performance Analysis of View Materialization Strategies 1987 SIGMOD
4 1,711 Algorithms for Materialized View Design in Data Warehousing Environment 1997 VLDB
5 5,853 Shrinking the Warehouse Update Window 1999 SIGMOD
6 1,766 On-Line Warehouse View Maintenance 1997 SIGMOD
7 927 Materialized View Selection and Maintenance Using Multi-Query Optimization 2001 SIGMOD
8 1,150 Algorithms for Deferred View Maintenance 1996 SIGMOD
9 5,902 Multiple-View Self-Maintenance in Data Warehousing Environments 1997 VLDB
10 2,753 Efficient View Maintenance at Data Warehouses 1997 SIGMOD