Abstract
There has recently been considerable research on physical design tuning algorithms. At the same time, there is only one published methodology to evaluate the quality of different, competing approaches: the TAB benchmark. In this paper we describe our experiences with TAB. We first report an experimental evaluation of TAB on our latest prototype for physical design tuning. We then identify certain weakness in the benchmark and briefly comment on alternatives to improve its usefulness.
- TPC Benchmark H. Available at http://www.tpc.org.Google Scholar
- S. Agrawal, S. Chaudhuri, and V. Narasayya. Automated selection of materialized views and indexes in SQL databases. In Proceedings of VLDB, 2000. Google ScholarDigital Library
- S. Agrawal et al. Database Tuning Advisor for Microsoft SQL Server 2005. In Proceedings of VLDB, 2004.Google ScholarCross Ref
- S. Agrawal, V. Narasayya, and B. Yang. Integrating vertical and horizontal partitioning into automated physical database design. In Proceedings of SIGMOD, 2004. Google ScholarDigital Library
- N. Bruno and S. Chaudhuri. Automatic physical database tuning: A relaxation-based approach. In Proceedings of SIGMOD, 2005. Google ScholarDigital Library
- N. Bruno and S. Chaudhuri. To tune or not to tune? A Lightweight Physical Design Alerter. In Proceedings of VLDB, 2006. Google ScholarDigital Library
- S. Chaudhuri, M. Datar, and V. Narasayya. Index selection for databases: A hardness study and a principled heuristic solution. In IEEE Trans. Knowl. Data Eng. 16(11), 2004. Google ScholarDigital Library
- S. Chaudhuri and V. Narasayya. An efficient cost-driven index selection tool for Microsoft SQL Server. In Proceedings of VLDB, 1997. Google ScholarDigital Library
- M. Consens, D. Barbosa, A. Teisanu, and L. Mignet. Goals and benchmarks for autonomic configuration recommenders. In Proceedings of SIGMOD, 2005. Google ScholarDigital Library
- B. Dageville et al. Automatic SQL Tuning in Oracle 10g. In Proceedings of VLDB, 2004. Google ScholarDigital Library
- S. Papadomanolakis and A. Ailamaki. An integer linear programming approach to database design. In Workshop on Self-Managing Database Systems, 2007. Google ScholarDigital Library
- G. Valentin, M. Zuliani, D. Zilio, G. Lohman, and A. Skelley. DB2 advisor: An optimizer smart enough to recommend its own indexes. In Proceedings of ICDE, 2000. Google ScholarDigital Library
- C. Wu et al. The protein information resource: an integrated public resource of functional annotation of proteins. In Nucleic Acids Research, 2002.Google ScholarCross Ref
- D. Zilio et al. DB2 design advisor: Integrated automatic physical database design. In Proceedings of VLDB, 2004. Google ScholarDigital Library
- D. Zilio et al. Recommending materialized views and indexes with IBM DB2 design advisor. In International Conference on Autonomic Computing, 2004. Google ScholarDigital Library
Index Terms
- A critical look at the TAB benchmark for physical design tools
Recommendations
Subsetting the SPEC CPU2006 benchmark suite
On August 24, 2006, the Standard Performance Evaluation Corporation (SPEC) announced CPU2006 -- the next generation of industry-standardized CPU-intensive benchmark suite. The SPEC CPU benchmark suite has become the most frequently used suite for ...
A Benchmark Characterization of the EEMBC Benchmark Suite
Benchmark consumers expect benchmark suites to be complete, accurate, and consistent, and benchmark scores serve as relative measures of performance. However, it is important to understand how benchmarks stress the processors that they aim to test. This ...
A Benchmark Suite to Jointly Consider Logic Synthesis and Physical Design
ISPD '15: Proceedings of the 2015 Symposium on International Symposium on Physical DesignThis paper presents an improved benchmark suite to jointly consider logic synthesis and physical design. Usually, benchmark circuits were provided by the physical design and the logic synthesis communities separately, according to their specific needs. ...
Comments