DBScholar

Back to papers

On-Line Warehouse View Maintenance

Summary: Proposes 2VNL, a two-version warehouse view maintenance algorithm that lets maintenance run concurrently with reads. By maintaining two versions, it avoids locking and ensures serializability, with a query-rewrite on a conventional RDBMS. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
h035132077c54da9f
Venue
SIGMOD
Year
1997
Pagerank
9.6888572e-05
Overall Rank
1,766 | 88.17%
DOI
10.1145/253260.253352

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{quass_sigmod97,
        title = {{On-Line Warehouse View Maintenance}},
        author = {Quass, Dallan and Widom, Jennifer},
        series = {{SIGMOD} '97},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/253260.253352},
        url = {https://dl.acm.org/doi/10.1145/253260.253352},
        year = {1997}
}

Incoming Citations (Sorted by Pagerank)

Showing 15 of 15 citing papers.

Rank Citing Paper Year Venue Pagerank
1,790 Lazy Maintenance of Materialized Views 2007 VLDB 9.6228433e-05
2,233 Explaining Query Answers with Explanation-Ready Databases 2016 VLDB 8.7844607e-05
2,493 FAS - a Freshness-Sensitive Coordination Middleware for a Cluster of OLAP Components 2002 VLDB 8.3721565e-05
2,534 Stream Warehousing with DataDepot 2009 SIGMOD 8.3120592e-05
3,029 Asynchronous View Maintenance for VLSD Databases 2009 SIGMOD 7.7174537e-05
3,138 How to Win a Hot Dog Eating Contest: Distributed Incremental View Maintenance with Batch Updates 2016 SIGMOD 7.5866991e-05
3,859 QC-Trees: An Efficient Summary Structure for Semantic OLAP 2003 SIGMOD 6.9540456e-05
4,338 Generalized Scale Independence Through Incremental Precomputation 2013 SIGMOD 6.6413964e-05
4,571 Consistency in a Stream Warehouse 2011 CIDR 6.5152755e-05
5,838 Issues in Developing Very Large Data Warehouses 1998 VLDB 5.9592034e-05
9,327 Data Stream Warehousing 2013 SIGMOD 5.1808736e-05
9,468 Data Stream Warehousing in Tidalrace 2015 CIDR 5.1588779e-05
10,301 Keep Your Distributed Data Warehouse Consistent at a Minimal Cost 2023 SIGMOD 5.030064e-05
13,245 Exploiting Versions for Handling Updates in Broadcast Disks 1999 VLDB 4.9605343e-05
13,274 Low-Cost Compensation-Based Query Processing 1998 VLDB 4.9605343e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 10 of 10 cited papers.

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

Rank Cited Paper Year Venue Pagerank
11 Implementing Data Cubes Efficiently 1996 SIGMOD 0.00070860346
19 A Critique of ANSI SQL Isolation Levels 1995 SIGMOD 0.00058631912
87 Implementation of Integrity Constraints and Views by Query Modification 1975 SIGMOD 0.00035589793
148 On Rules, Procedures, Caching And Views In Data Base Systems 1990 SIGMOD 0.00028920518
388 Incremental Maintenance of Views with Duplicates 1995 SIGMOD 0.0001928135
417 Distributed Database Concurrency Controls Using Before-Values 1981 SIGMOD 0.00018599136
664 The Implementation of An Integrated Concurrency Control and Recovery Scheme 1982 SIGMOD 0.00014953985
2,059 Efficient and Flexible Methods for Transient Versioning of Records to Avoid Locking by Read-Only Transactions 1992 SIGMOD 9.0923662e-05
2,088 Modular Synchronization in Multiversion Databases: Version Control and Concurrency Control 1989 SIGMOD 9.0478134e-05
3,639 Multiversion Query Locking 1992 VLDB 7.1247466e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 904 Maintenance of Data Cubes and Summary Tables in a Warehouse 1997 SIGMOD
2 1,711 Algorithms for Materialized View Design in Data Warehousing Environment 1997 VLDB
3 1,790 Lazy Maintenance of Materialized Views 2007 VLDB
4 5,853 Shrinking the Warehouse Update Window 1999 SIGMOD
5 927 Materialized View Selection and Maintenance Using Multi-Query Optimization 2001 SIGMOD
6 1,150 Algorithms for Deferred View Maintenance 1996 SIGMOD
7 400 View Maintenance in a Warehousing Environment 1995 SIGMOD
8 2,753 Efficient View Maintenance at Data Warehouses 1997 SIGMOD
9 5,902 Multiple-View Self-Maintenance in Data Warehousing Environments 1997 VLDB
10 14,335 Exploiting Versions for On-line Data Warehouse Maintenance in MOLAP Servers 2002 VLDB