DBScholar

Back to papers

DynaMat: A Dynamic View Management System for Data Warehouses

Summary: DynaMat materializes multi-level views to fit workload and maintenance, unifying selection and refresh by a goodness metric. Tracks queries, updates best subset under space/downtime limits, and uses Detailed Cost Savings Ratio to beat precomputation. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
hfb17dd4e55535e13
Venue
SIGMOD
Year
1999
Pagerank
0.00012902181
Overall Rank
949 | 93.63%
DOI
10.1145/304182.304215

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{kotidis_sigmod99,
        title = {{DynaMat: A Dynamic View Management System for Data Warehouses}},
        author = {Kotidis, Yannis and Roussopoulos, Nick},
        series = {{SIGMOD} '99},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/304182.304215},
        url = {https://dl.acm.org/doi/10.1145/304182.304215},
        year = {1999}
}

Incoming Citations (Sorted by Pagerank)

Showing 19 of 19 citing papers.

Rank Citing Paper Year Venue Pagerank
12 C-Store: A Column-oriented DBMS 2005 VLDB 0.00068998927
88 Automated Selection of Materialized Views and Indexes for SQL Databases 2000 VLDB 0.00035351639
2,607 WebView Materialization 2000 SIGMOD 8.229525e-05
3,087 Continuous Sampling for Online Aggregation Over Multiple Queries 2010 SIGMOD 7.6624333e-05
3,505 Fast Queries Over Heterogeneous Data Through Engine Customization 2016 VLDB 7.2508161e-05
4,321 Generalized Scale Independence Through Incremental Precomputation 2013 SIGMOD 6.6660222e-05
4,341 An Adaptive Peer-to-Peer Network for Distributed Caching of OLAP Results 2002 SIGMOD 6.6513835e-05
4,525 Just-in-time compilation for SQL query processing 2013 VLDB 6.5616553e-05
4,832 ReCache: Reactive Caching for Fast Analytics over Heterogeneous Data 2018 VLDB 6.3895407e-05
5,088 ROBUS: Fair Cache Allocation for Data-parallel Workloads 2017 SIGMOD 6.2805079e-05
5,446 Crystal: A Unified Cache Storage System for Analytical Databases 2021 VLDB 6.1266228e-05
5,844 Graph-Aware, Workload-Adaptive SPARQL Query Caching 2015 SIGMOD 5.9730023e-05
6,796 Intermittent Query Processing 2019 VLDB 5.6803529e-05
6,928 Balancing Performance and Data Freshness in Web Database Servers 2003 VLDB 5.6414724e-05
7,376 Stop-and-Restart Style Execution for Long Running Decision Support Queries 2007 VLDB 5.540013e-05
7,598 SageDB: An Instance-Optimized Data Analytics System 2022 VLDB 5.4871733e-05
7,881 ChronoCache: Predictive and Adaptive Mid-Tier Query Result Caching 2020 SIGMOD 5.4339026e-05
10,187 Saving Money for Analytical Workloads in the Cloud 2024 VLDB 5.0651993e-05
13,149 Proxy-Server Architectures for OLAP 2001 SIGMOD 4.9793485e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 20 of 20 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.00071084324
62 Maintaining Views Incrementally 1993 SIGMOD 0.00039045511
116 Direct Spatial Search on Pictorial Databases Using Packed R-trees 1985 SIGMOD 0.00031645463
214 On the Computation of Multidimensional Aggregates 1996 VLDB 0.00024656893
323 An Array-Based Algorithm for Simultaneous Multidimensional Aggregates 1997 SIGMOD 0.0002100085
388 Incremental Maintenance of Views with Duplicates 1995 SIGMOD 0.00019350381
416 Semantic Data Caching and Replacement 1996 VLDB 0.00018658244
644 Materialized View Selection in a Multidimensional Database 1997 VLDB 0.00015213935
648 Materialized Views In Oracle 1998 VLDB 0.00015151422
901 Maintenance of Data Cubes and Summary Tables in a Warehouse 1997 SIGMOD 0.00013185553
957 Materialized View Selection for Multidimensional Datasets 1998 VLDB 0.00012861484
1,547 Data Warehouse Configuration 1997 VLDB 0.00010292395
1,764 Caching Multidimensional Queries Using Chunks 1998 SIGMOD 9.6965217e-05
2,115 View Maintenance Issues for the Chronicle Data Model (Extended Abstract) 1995 PODS 9.0155433e-05
2,511 WATCHMAN: A Data Warehouse Intelligent Cache Manager 1996 VLDB 8.3696476e-05
3,442 Cubetree: Organization of and Bulk Incremental Updates on the Data Cube 1997 SIGMOD 7.2979501e-05
4,018 Preliminary Design of ADMS+: A Workstation-Mainframe Integrated Architecture for Database Management Systems 1986 VLDB 6.8519517e-05
5,714 An Alternative Storage Organization for ROLAP Aggregate Views Based on Cubetrees 1998 SIGMOD 6.0202342e-05
5,825 Issues in Developing Very Large Data Warehouses 1998 VLDB 5.9812429e-05
8,936 Performance and Scalability of Client-Server Database Architectures 1992 VLDB 5.2559789e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 901 Maintenance of Data Cubes and Summary Tables in a Warehouse 1997 SIGMOD
2 14,343 DyDa : Data Warehouse Maintenance in Fully Concurrent Environments 2001 SIGMOD
3 4,232 On the Content of Materialized Aggregate Views 2000 PODS
4 238 Complexity of Answering Queries Using Materialized Views 1998 PODS
5 9,121 What is the data warehousing problem? (Are materialized views the answer?) 1996 VLDB
6 13,211 Dynamic Assembly of Views in Data Cubes 1998 PODS
7 1,547 Data Warehouse Configuration 1997 VLDB
8 644 Materialized View Selection in a Multidimensional Database 1997 VLDB
9 923 Materialized View Selection and Maintenance Using Multi-Query Optimization 2001 SIGMOD
10 1,706 Algorithms for Materialized View Design in Data Warehousing Environment 1997 VLDB