Goals and Benchmarks for Autonomic Configuration Recommenders

Summary: Flexible performance-goal characterization and benchmarking for autonomic configuration recommenders (indexes, materialized views, partitions) in DBMS. Exploratory workloads with real and synthetic data; single-column index baseline; results show unfulfilled potential for several orders of magnitude improvements over current tools. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 3701
Venue: SIGMOD
Year: 2005
Pagerank: 5.4048965e-05
Overall Rank: 8,601 | 40.99%
DOI: 10.1145/1066157.1066185

Incoming Non-self Citations Over Time

Authors

1. Mariano P. Consens (University of Toronto)
2. Denilson Barbosa (University of Calgary)
3. Adrian Teisanu (University of Toronto)
4. Laurent Mignet (IBM)

BibTeX Citation

@inproceedings{consens_sigmod05,
        title = {{Goals and Benchmarks for Autonomic Configuration Recommenders}},
        author = {Consens, Mariano P. and Barbosa, Denilson and Teisanu, Adrian and Mignet, Laurent},
        series = {{SIGMOD} '05},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/1066157.1066185},
        url = {https://dl.acm.org/doi/10.1145/1066157.1066185},
        year = {2005}
}

Incoming Citations (Sorted by Pagerank)

Showing 2 of 2 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
1,997	Efficient Use of the Query Optimizer for Automated Physical Design	2007	VLDB	9.3378162e-05
7,037	Designing Information-Preserving Mapping Schemes for XML	2005	VLDB	5.7209033e-05

Outgoing Citations (Sorted by Pagerank)

Showing 12 of 12 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
87	Automated Selection of Materialized Views and Indexes for SQL Databases	2000	VLDB	0.00035281619
89	On the Propagation of Errors in the Size of Join Results	1991	SIGMOD	0.00035031529
156	An Efficient, Cost-Driven Index Selection Tool for Microsoft SQL Server	1997	VLDB	0.00028636811
184	DB2 Design Advisor: Integrated Automatic Physical Database Design	2004	VLDB	0.00026256101
387	AutoAdmin "What-if" Index Analysis Utility	1998	SIGMOD	0.00019442332
501	Database Tuning Advisor for Microsoft SQL Server 2005	2004	VLDB	0.0001738508
524	Automatic SQL Tuning in Oracle 10g	2004	VLDB	0.00017120666
577	Computing Iceberg Queries Efficiently	1998	VLDB	0.00016235949
1,266	Compressing SQL Workloads	2002	SIGMOD	0.00011412078
1,870	Microsoft Index Tuning Wizard for SQL Server 7.0	1998	SIGMOD	9.579726e-05
2,690	Generating Thousand Benchmark Queries in Seconds	2004	VLDB	8.2519326e-05
2,726	TPC-DS, Taking Decision Support Benchmarking to the Next Level	2002	SIGMOD	8.203274e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	5,073	Database Workload Characterization with Query Plan Encoders	2022	VLDB
2	10,984	Benchmarking Adaptive Multidimensional Indices	2025	VLDB
3	6,131	Foundations of Automated Database Tuning	2006	VLDB
4	3,003	Configuration-Parametric Query Optimization for Physical Design Tuning	2008	SIGMOD
5	9,941	An Adaptive Benchmark for Modeling User Exploration of Large Datasets	2025	SIGMOD
6	6,327	Breaking It Down: An In-depth Study of Index Advisors	2024	VLDB
7	461	Query-based Workload Forecasting for Self-Driving Database Management Systems	2018	SIGMOD
8	768	Automatic Physical Database Tuning: A Relaxation-based Approach	2005	SIGMOD
9	2,740	Facilitating Database Tuning with Hyper-Parameter Optimization: A Comprehensive Experimental Evaluation	2022	VLDB
10	4,643	Learned Index Benefits: Machine Learning Based Index Performance Estimation	2022	VLDB