When is it Time to Rethink the Aggregate Configuration of Your OLAP Server?

Summary: Continuous workload monitoring with quantified alerts for superior OLAP aggregate configurations. OLAP-level view selection, not SQL-level containment, simplifies checks and rewrites, enabling automatic reconfiguration under interactive workloads. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: h1a1ca0b7faefef55
Venue: VLDB
Year: 2008
Pagerank: 4.9793485e-05
Overall Rank: 12,887 | 13.36%
DOI: 10.14778/1454159.1454210

Incoming Non-self Citations Over Time

No non-self incoming citations found for this paper in this database.

Authors

1. Katja Hose (Ilmenau University of Technology)
2. Daniel Klan (Ilmenau University of Technology)
3. Matthias Marx (Ilmenau University of Technology)
4. Kai-Uwe Sattler (Ilmenau University of Technology)

BibTeX Citation

@article{hose_vldb08,
        title = {{When is it Time to Rethink the Aggregate Configuration of Your OLAP Server?}},
        author = {Hose, Katja and Klan, Daniel and Marx, Matthias and Sattler, Kai-Uwe},
        journal = {PVLDB},
        series = {{VLDB} '08},
        volume = {1},
        number = {2},
        pages = {1492--1493},
        doi = {10.14778/1454159.1454210},
        url = {https://doi.org/10.14778/1454159.1454210},
        year = {2008}
}

Incoming Citations (Sorted by Pagerank)

Showing 0 of 0 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank

Outgoing Citations (Sorted by Pagerank)

Showing 7 of 7 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
88	Automated Selection of Materialized Views and Indexes for SQL Databases	2000	VLDB	0.00035351639
151	An Efficient, Cost-Driven Index Selection Tool for Microsoft SQL Server	1997	VLDB	0.00028672526
187	DB2 Design Advisor: Integrated Automatic Physical Database Design	2004	VLDB	0.0002592488
604	Rethinking Database System Architecture: Towards a Self-tuning RISC-style Database System	2000	VLDB	0.0001566686
2,373	To Tune or not to Tune? A Lightweight Physical Design Alerter	2006	VLDB	8.5606392e-05
5,468	QUIET: Continuous Query-driven Index Tuning	2003	VLDB	6.1192263e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	4,232	On the Content of Materialized Aggregate Views	2000	PODS
2	13,745	White-Box OLAP Performance Modeling for the Cloud	2021	CIDR
3	567	Answering Queries with Aggregation Using Views	1996	VLDB
4	553	Optimizing Queries Using Materialized Views: A Practical, Scalable Solution	2001	SIGMOD
5	88	Automated Selection of Materialized Views and Indexes for SQL Databases	2000	VLDB
6	901	Maintenance of Data Cubes and Summary Tables in a Warehouse	1997	SIGMOD
7	1,714	Spreadsheets in RDBMS for OLAP	2003	SIGMOD
8	12,607	Interactive Performance Monitoring of a Composite OLTP and OLAP Workload	2012	SIGMOD
9	5,200	Extending Practical Pre-Aggregation in On-Line Analytical Processing	1999	VLDB
10	700	Explaining differences in multidimensional aggregates	1999	VLDB