DBScholar

Back to papers

Asynchronous View Maintenance for VLSD Databases

Summary: Asynchronous maintenance of materialized views and indexes in VLSD shared-nothing databases. Introduces remote and local view tables (RVTs/LVTs) to trade throughput for view staleness, enabling indexes, group-by-aggregates, equijoins, and selections with a practical consistency model and empirical maintenance-cost benefits. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
hb7bf0268cc86bc38
Venue
SIGMOD
Year
2009
Pagerank
7.7461391e-05
Overall Rank
3,019 | 79.71%
DOI
10.1145/1559845.1559866

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{agrawal_sigmod09,
        title = {{Asynchronous View Maintenance for VLSD Databases}},
        author = {Agrawal, Parag and Silberstein, Adam and Cooper, Brian F. and Srivastava, Utkarsh and Ramakrishnan, Raghu},
        series = {{SIGMOD} '09},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/1559845.1559866},
        url = {https://dl.acm.org/doi/10.1145/1559845.1559866},
        year = {2009}
}

Incoming Citations (Sorted by Pagerank)

Showing 12 of 12 citing papers.

Rank Citing Paper Year Venue Pagerank
1,622 Mesa: Geo-Replicated, Near Real-Time, Scalable Data Warehousing 2014 VLDB 0.00010051462
1,701 Feeding Frenzy: Selectively Materializing Users' Event Feeds 2010 SIGMOD 9.8371359e-05
4,105 Napa: Powering Scalable Data Warehousing with Robust Query Performance at Google 2021 VLDB 6.8053165e-05
4,321 Generalized Scale Independence Through Incremental Precomputation 2013 SIGMOD 6.6660222e-05
4,503 Incremental View Maintenance over Array Data 2017 SIGMOD 6.5734419e-05
4,946 A Comparative Study of Secondary Indexing Techniques in LSM-based NoSQL Databases 2018 SIGMOD 6.3435811e-05
5,091 Towards Scalable Hybrid Stores: Constraint-Based Rewriting to the Rescue 2019 SIGMOD 6.2797352e-05
7,360 Kodiak: Leveraging Materialized Views For Very Low-Latency Analytics Over High-Dimensional Web-Scale Data 2016 VLDB 5.5427171e-05
7,528 Invisible Glue: Scalable Self-Tuning Multi-Stores 2015 CIDR 5.5011847e-05
9,768 A Framework for Supporting DBMS-like Indexes in the Cloud 2011 VLDB 5.1343627e-05
9,882 PNUTS to Sherpa: Lessons from Yahoo!’s Cloud Database 2019 VLDB 5.117064e-05
10,265 A BAD Demonstration: Towards Big Active Data 2017 VLDB 5.0494455e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 12 of 12 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.00046602544
47 PNUTS: Yahoo!'s Hosted Data Serving Platform 2008 VLDB 0.00044066403
62 Maintaining Views Incrementally 1993 SIGMOD 0.00039045511
246 Deriving Production Rules for Incremental View Maintenance 1991 VLDB 0.00023212582
398 View Maintenance in a Warehousing Environment 1995 SIGMOD 0.00019152162
951 Algorithms for Creating Indexes for Very Large Tables Without Quiescing Updates 1992 SIGMOD 0.00012893557
1,150 Algorithms for Deferred View Maintenance 1996 SIGMOD 0.00011809311
1,753 On-Line Warehouse View Maintenance 1997 SIGMOD 9.7248839e-05
1,779 Lazy Maintenance of Materialized Views 2007 VLDB 9.6583009e-05
2,741 Efficient View Maintenance at Data Warehouses 1997 SIGMOD 8.0688837e-05
2,761 How To Roll a Join: Asynchronous Incremental View Maintenance 2000 SIGMOD 8.0473806e-05
3,700 Data Management Projects at Google 2006 SIGMOD 7.0864941e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 1,089 Incremental Maintenance of Externally Materialized Views 1996 VLDB
2 923 Materialized View Selection and Maintenance Using Multi-Query Optimization 2001 SIGMOD
3 5,393 View Management in Distributed Data Base Systems 1983 VLDB
4 2,801 Supporting Multiple View Maintenance Policies 1997 SIGMOD
5 380 Maintenance Of Views 1984 SIGMOD
6 2,741 Efficient View Maintenance at Data Warehouses 1997 SIGMOD
7 1,779 Lazy Maintenance of Materialized Views 2007 VLDB
8 4,321 Generalized Scale Independence Through Incremental Precomputation 2013 SIGMOD
9 9,642 Towards Adaptive Storage Views in Virtual Memory 2023 CIDR
10 1,150 Algorithms for Deferred View Maintenance 1996 SIGMOD