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
4180
Venue
SIGMOD
Year
2009
Pagerank
7.9152992e-05
Overall Rank
2,966 | 79.66%
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,606 Mesa: Geo-Replicated, Near Real-Time, Scalable Data Warehousing 2014 VLDB 0.00010228576
1,676 Feeding Frenzy: Selectively Materializing Users' Event Feeds 2010 SIGMOD 0.00010034449
4,017 Napa: Powering Scalable Data Warehousing with Robust Query Performance at Google 2021 VLDB 6.9525581e-05
4,250 Generalized Scale Independence Through Incremental Precomputation 2013 SIGMOD 6.8031294e-05
4,406 Incremental View Maintenance over Array Data 2017 SIGMOD 6.7191598e-05
4,968 Towards Scalable Hybrid Stores: Constraint-Based Rewriting to the Rescue 2019 SIGMOD 6.4206525e-05
5,012 A Comparative Study of Secondary Indexing Techniques in LSM-based NoSQL Databases 2018 SIGMOD 6.4015289e-05
7,238 Kodiak: Leveraging Materialized Views For Very Low-Latency Analytics Over High-Dimensional Web-Scale Data 2016 VLDB 5.664642e-05
7,428 Invisible Glue: Scalable Self-Tuning Multi-Stores 2015 CIDR 5.6205394e-05
9,589 A Framework for Supporting DBMS-like Indexes in the Cloud 2011 VLDB 5.2521633e-05
9,711 PNUTS to Sherpa: Lessons from Yahoo!’s Cloud Database 2019 VLDB 5.2343601e-05
10,062 A BAD Demonstration: Towards Big Active Data 2017 VLDB 5.1653353e-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.00047309646
47 PNUTS: Yahoo!'s Hosted Data Serving Platform 2008 VLDB 0.00044503718
61 Maintaining Views Incrementally 1993 SIGMOD 0.00039026867
258 Deriving Production Rules for Incremental View Maintenance 1991 VLDB 0.00023131981
391 View Maintenance in a Warehousing Environment 1995 SIGMOD 0.00019370653
924 Algorithms for Creating Indexes for Very Large Tables Without Quiescing Updates 1992 SIGMOD 0.00013185068
1,133 Algorithms for Deferred View Maintenance 1996 SIGMOD 0.00012039326
1,715 On-Line Warehouse View Maintenance 1997 SIGMOD 9.9392931e-05
1,750 Lazy Maintenance of Materialized Views 2007 VLDB 9.8392477e-05
2,692 Efficient View Maintenance at Data Warehouses 1997 SIGMOD 8.2491468e-05
2,725 How To Roll a Join: Asynchronous Incremental View Maintenance 2000 SIGMOD 8.2043938e-05
3,627 Data Management Projects at Google 2006 SIGMOD 7.2439512e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 1,091 Incremental Maintenance of Externally Materialized Views 1996 VLDB
2 929 Materialized View Selection and Maintenance Using Multi-Query Optimization 2001 SIGMOD
3 5,269 View Management in Distributed Data Base Systems 1983 VLDB
4 2,771 Supporting Multiple View Maintenance Policies 1997 SIGMOD
5 373 Maintenance Of Views 1984 SIGMOD
6 2,692 Efficient View Maintenance at Data Warehouses 1997 SIGMOD
7 1,750 Lazy Maintenance of Materialized Views 2007 VLDB
8 4,250 Generalized Scale Independence Through Incremental Precomputation 2013 SIGMOD
9 9,502 Towards Adaptive Storage Views in Virtual Memory 2023 CIDR
10 1,133 Algorithms for Deferred View Maintenance 1996 SIGMOD