Sciweavers

40
Voted
SIGMOD
2005
ACM

Goals and Benchmarks for Autonomic Configuration Recommenders

14 years 6 months ago
Goals and Benchmarks for Autonomic Configuration Recommenders
We are witnessing an explosive increase in the complexity of the information systems we rely upon. Autonomic systems address this challenge by continuously configuring and tuning themselves. Recently, a number of autonomic features have been incorporated into commercial RDBMS; tools for recommending database configurations (i.e., indexes, materialized views, partitions) for a given workload are prominent examples of this promising trend. In this paper, we introduce a flexible characterization of the performance goals of configuration recommenders and develop an experimental evaluation approach to benchmark the effectiveness of these autonomic tools. We focus on exploratory queries and present extensive experimental results using both real and synthetic data that demonstrate the validity of the approach introduced. Our results identify a specific index configuration based on single-column indexes as a very useful baseline for comparisons in the exploratory setting. Furthermore, the exp...
Mariano P. Consens, Denilson Barbosa, Adrian M. Te
Added 08 Dec 2009
Updated 08 Dec 2009
Type Conference
Year 2005
Where SIGMOD
Authors Mariano P. Consens, Denilson Barbosa, Adrian M. Teisanu, Laurent Mignet
Comments (0)