Goals and benchmarks for autonomic configuration recommenders

Proceedings of the ACM SIGMOD International Conference on Management of Data

Volumn , Issue , 2005, Pages 239-250

  Consens, Mariano P ^a   Barbosa, Denilson ^b   Teisanu, Adrian ^a   Mignet, Laurent ^c  

^a UNIVERSITY OF TORONTO   (Canada)

^b UNIVERSITY OF CALGARY   (Canada)

^c IBM RESEARCH   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

BENCHMARKING; COMPUTATIONAL COMPLEXITY; DATA STRUCTURES; DATABASE SYSTEMS; INFORMATION TECHNOLOGY; QUERY LANGUAGES;

AUTONOMIC CONFIGURATION RECOMMENDERS; AUTONOMIC TOOLS; DATABASE CONFIGURATIONS; INFORMATION SYSTEMS;

INFORMATION RETRIEVAL SYSTEMS;

EID: 29844439310     PISSN: 07308078     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1145/1066157.1066185     Document Type: Conference Paper

References (26)

1. S. Agrawal, S. Chaudhuri, L. Kollár, A. P. Marathe, V. R. Narasayya, and M. Syamala. Database tuning advisor for microsoft sql server 2005. In Proceedings of 30th International Conference on Very Large Data Bases, pages 1110-1121, Toronto, Canada, 2004.
2. S. Agrawal, S. Chaudhuri, and V. R. Narasayya. Automated Selection of Materialized Views and Indexes in SQL Databases. In VLDB, 2000.
3. H. Boral and D. J. DeWitt. Database machines: An idea whose time has passed? a critique of the future of database machines. In Proceedings of the International Workshop on Database Machines, 1983.
4. Reprinted in Parallel Architectures for Database Systems. IEEE Computer Society Press, 1989.
5. S. Chaudhuri, A. K. Gupta, and V. Narasayya. Compressing sql workloads. In SIGMOD. ACM Press, 2002.
6. S. Chaudhuri and V. R. Narasayya. TPC-D Data Generation with Skew. Available via anonymous ftp from ftp.research.microsoft.com/users/viveknar/ tpcdskew.
7. S. Chaudhuri and V. R. Narasayya. An efficient cost-driven index selection tool for microsoft sql server. In VLDB. Morgan Kaufmann Publishers Inc., 1997.
8. S. Chaudhuri and V. R. Narasayya. Auto Admin 'What-if' Index Analysis Utility. In SIGMOD, 1998.
9. S. Chaudhuri and V. R. Narasayya. Microsoft Index Tuning Wizard for SQL Server 7.0. In SIGMOD, 1998.
10. W. Cleveland. The Elements of Graphing Data. Hobart Press, 1994.
11. B. Dageville, D. Das, K. Dias, K. Yagoub, M. Zaït, and M. Ziauddin. Automatic sql tuning in oracle 10g. In Proceedings of 30th International Conference on Very Large Data Bases, pages 1098-1109, Toronto, Canada, 2004.
12. M. Fang, N. Shivakumar, H. Garcia-Molina, R. Motwani, and J. D. Ullman. Computing Iceberg Queries Efficiently. In Proceedings of 24rd International Conference on Very Large Data Bases, pages 299-310, New York City, New York, USA, August 24-27 1998.
13. J. Gray, editor. The Benchmark Handbook for Database and Transaction Systems (2nd Edition). Morgan Kaufmann, 1993.
14. Y. E. Ioannidis and S. Christodoulakis. On the propagation of errors in the size of join results. In SIGMOD, 1991.
15. S. S. Lightstone, G. Lohman, and D. Zilio. Toward Autonomic Computing with DB2 Universal Database. ACM SIGMOD Record, 31(3), 2002.
16. V. Markl, G. M. Lohman, and V. Raman. LEO: An Autonomic Query Optimizer for DB2. IBM Systems Journal, 42(1), 2003.
17. S. Papadomanolakis and A. Ailamaki. Autopart: Automating schema design for large scientific databases using data partitioning. In Proceedings of the 16th International Conference on Scientific and Statistical Database Management, 2004.
18. M. Poess, B. Smith, L. Kollar, and P. Larson. Tpc-ds, taking decision support benchmarking to the next level. In Proceedings of the 2002 ACM SIGMOD international conference on Management of data, pages 582-587. ACM Press, 2002.
19. M. Poess and J. M. Stephens. Generating Thousand Benchmark Queries in Seconds. In Proceedings of the Thirtieth International Conference on Very Large Data Bases, pages 1045-1053, Toronto, Canada, August 31 - September 3 2004.
20. K. Runapongsa, J. M. Patel, R. Bordawekar, and S. Padmanabhan. XIST: An XML Index Selection Tool. In XSym, 2004.
21. T. Sawyer. Doing your own benchmark. In J. Gray, editor, The Benchmark Handbook for Database and Transaction Systems (2nd Edition). Morgan Kaufmann, 1993.
22. Transaction Processing Performance Council. TPC Benchmark H - Decision Support, 1999. Revision 1.3.0.
23. G. Valentin, M. Zuliani, D. C. Zilio, and A. S. Guy Lohman. DB2 Advisor: An Optimizer Smart Enough to Recommend its own Indexes. In ICDE, 2000.
24. C. H. Wu, H. Huang, L. Arminski, J. Castro-Alvear, Y. Chen, Z.-Z. Hu, R. S. Ledley, K. C. Lewis, H.-W. Mewes, B. C. Orcutt, B. E. Suzek, A. Tsugita, C. R. Vinayaka, L.-S. L. Yeh, J. Zhang, and W. C. Barker. The protein information resource: an integrated public resource of functional annotation of proteins. Nucleic Acids Research, 30, 2002.
25. D. Zilio, C. Zuzarte, S. Lightstone, W. Ma, G. Lohman, R. Cochrane, H. Pirahesh, L. Colby, J. Gryz, E. Alton, D. Liang, and G. Valentin. Recommending Materialized Views and Indexes with IBM DB2 Design Advisor. In Proceedings of the International Conference on Autonomic Computing, 2004.
26. D. C. Zilio, J. Rao, S. Lightstone, G. M. Lohman, A. Storm, C. Garcia-Arellano, and S. Fadden. Db2 design advisor: Integrated automatic physical database design. In Proceedings of 30th International Conference on Very Large Data Bases, pages 1087-1097, Toronto, Canada, 2004.