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: 3176
Venue: SIGMOD
Year: 1999
Pagerank: 0.00013068595
Overall Rank: 943 | 93.54%
DOI: 10.1145/304182.304215

Incoming Non-self Citations Over Time

Authors

1. Yannis Kotidis (University of Maryland)
2. Nick Roussopoulos (University of Maryland)

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.00069513174
87	Automated Selection of Materialized Views and Indexes for SQL Databases	2000	VLDB	0.00035281619
2,557	WebView Materialization	2000	SIGMOD	8.4161033e-05
3,042	Continuous Sampling for Online Aggregation Over Multiple Queries	2010	SIGMOD	7.8231049e-05
3,638	Fast Queries Over Heterogeneous Data Through Engine Customization	2016	VLDB	7.2338361e-05
4,250	Generalized Scale Independence Through Incremental Precomputation	2013	SIGMOD	6.8031294e-05
4,252	An Adaptive Peer-to-Peer Network for Distributed Caching of OLAP Results	2002	SIGMOD	6.8029543e-05
4,452	Just-in-time compilation for SQL query processing	2013	VLDB	6.6942969e-05
4,764	ReCache: Reactive Caching for Fast Analytics over Heterogeneous Data	2018	VLDB	6.51896e-05
5,348	Crystal: A Unified Cache Storage System for Analytical Databases	2021	VLDB	6.2562688e-05
5,716	Graph-Aware, Workload-Adaptive SPARQL Query Caching	2015	SIGMOD	6.1100964e-05
6,795	Balancing Performance and Data Freshness in Web Database Servers	2003	VLDB	5.7707686e-05
7,200	Intermittent Query Processing	2019	VLDB	5.6756294e-05
7,244	Stop-and-Restart Style Execution for Long Running Decision Support Queries	2007	VLDB	5.6638746e-05
7,673	ROBUS: Fair Cache Allocation for Data-parallel Workloads	2017	SIGMOD	5.5705944e-05
7,722	ChronoCache: Predictive and Adaptive Mid-Tier Query Result Caching	2020	SIGMOD	5.5586232e-05
8,323	SageDB: An Instance-Optimized Data Analytics System	2022	VLDB	5.4539294e-05
10,000	Saving Money for Analytical Workloads in the Cloud	2024	VLDB	5.1814573e-05
12,859	Proxy-Server Architectures for OLAP	2001	SIGMOD	5.093636e-05

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.00071822821
61	Maintaining Views Incrementally	1993	SIGMOD	0.00039026867
116	Direct Spatial Search on Pictorial Databases Using Packed R-trees	1985	SIGMOD	0.0003221055
207	On the Computation of Multidimensional Aggregates	1996	VLDB	0.00025088003
324	An Array-Based Algorithm for Simultaneous Multidimensional Aggregates	1997	SIGMOD	0.00021200835
375	Incremental Maintenance of Views with Duplicates	1995	SIGMOD	0.00019681204
409	Semantic Data Caching and Replacement	1996	VLDB	0.00018985783
638	Materialized View Selection in a Multidimensional Database	1997	VLDB	0.000154719
643	Materialized Views In Oracle	1998	VLDB	0.00015372449
905	Maintenance of Data Cubes and Summary Tables in a Warehouse	1997	SIGMOD	0.0001331508
942	Materialized View Selection for Multidimensional Datasets	1998	VLDB	0.00013076262
1,543	Data Warehouse Configuration	1997	VLDB	0.00010413384
1,732	Caching Multidimensional Queries Using Chunks	1998	SIGMOD	9.9065981e-05
2,080	View Maintenance Issues for the Chronicle Data Model (Extended Abstract)	1995	PODS	9.2052704e-05
2,456	WATCHMAN: A Data Warehouse Intelligent Cache Manager	1996	VLDB	8.5526697e-05
3,379	Cubetree: Organization of and Bulk Incremental Updates on the Data Cube	1997	SIGMOD	7.4582502e-05
3,956	Preliminary Design of ADMS+: A Workstation-Mainframe Integrated Architecture for Database Management Systems	1986	VLDB	6.9949992e-05
5,638	An Alternative Storage Organization for ROLAP Aggregate Views Based on Cubetrees	1998	SIGMOD	6.138684e-05
5,703	Issues in Developing Very Large Data Warehouses	1998	VLDB	6.1147109e-05
8,774	Performance and Scalability of Client-Server Database Architectures	1992	VLDB	5.3766157e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	905	Maintenance of Data Cubes and Summary Tables in a Warehouse	1997	SIGMOD
2	14,032	DyDa : Data Warehouse Maintenance in Fully Concurrent Environments	2001	SIGMOD
3	4,155	On the Content of Materialized Aggregate Views	2000	PODS
4	225	Complexity of Answering Queries Using Materialized Views	1998	PODS
5	8,957	What is the data warehousing problem? (Are materialized views the answer?)	1996	VLDB
6	12,921	Dynamic Assembly of Views in Data Cubes	1998	PODS
7	638	Materialized View Selection in a Multidimensional Database	1997	VLDB
8	1,543	Data Warehouse Configuration	1997	VLDB
9	929	Materialized View Selection and Maintenance Using Multi-Query Optimization	2001	SIGMOD
10	1,743	Algorithms for Materialized View Design in Data Warehousing Environment	1997	VLDB