Tuning database configuration parameters with ituned

Proceedings of the VLDB Endowment

Volumn 2, Issue 1, 2009, Pages 1246-1257

  Duan, Songyun ^a   Thummala, Vamsidhar ^a   Babu, Shivnath ^a  

^a Duke University   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

INTELLIGENT DATABASES; ONLINE SYSTEMS; QUERY PROCESSING;

ADAPTIVE SAMPLING; CONFIGURATION PARAMETERS; DATABASE ADMINISTRATORS; DATABASE CONFIGURATION PARAMETERS; ON-LINE EXPERIMENTS; PERFORMANCE PARAMETERS; PRODUCTION WORKLOADS; USAGE SCENARIOS;

DATABASE SYSTEMS;

EID: 79953889531     PISSN: None     EISSN: 21508097     Source Type: Conference Proceeding    
DOI: 10.14778/1687627.1687767     Document Type: Article

References (24)

1. E. Cecchet, J. Marguerite, and W. Zwaenepoel. Performance and Scalability of EJB Applications. In OOPSLA, 2002.
2. S. Chaudhuri, G. Das, and U. Srivastava. Effective use of block-level sampling in statistics estimation. In SIGMOD, 2004.
3. S. Chaudhuri, A. K. Gupta, and V. R. Narasayya. Compressing SQL workloads. In SIGMOD, 2002.
4. S. Chaudhuri and V. R. Narasayya. Autoadmin 'what-if' index analysis utility. In SIGMOD Conference, 1998.
5. B. K. Debnath, D. J. Lilja, and M. F. Mokbel. SARD: A statistical approach for ranking database tuning parameters. In SMDB, 2008.
6. A. Deshpande, C. Guestrin, S. Madden, J. M. Hellerstein, and W. Hong. Model-driven data acquisition in sensor networks. In VLDB, 2004.
7. S. Duan, V. Thummala, and S. Babu. Tuning Database Configuration Parameters with iTuned. Technical report, Mar. 2009. Available at www.cs.duke.edu/~shivnath/ituned.
8. R. G. Freeman and A. Nanda. Oracle Database 11g New Features. McGraw-Hill Osborne Media, 2007.
9. R. B. Gramacy. tgp: An R Package for Bayesian Nonstationary, Semiparametric Nonlinear Regression and Design by Treed Gaussian Process Models. Journal of Statistical Software, 19(9), June 2007.
10. J. Hellerstein, P. Haas, and H. Wang. Online aggregation. In Proc. of the 1997 ACM SIGMOD Intl. Conf. on Management of Data, May 1997.
11. C. R. Hicks and K. V. Turner. Fundamental Concepts in the Design of Experiments. Oxford University Press, 1999.
12. S. Kwan, S. Lightstone, et al. Automatic Configuration of IBM DB2 Universal Database. In IBM Perf. Technical Report, Jan. 2002.
13. Postgresql performance optimization. wiki.postgresql.org/wiki/Performance_Optimization.
14. T. J. Santner, B. J. Williams, and W. Notz. The Design and Analysis of Computer Experiments. Springer, first edition, July 2003.
15. Dtrace, ZFS, and Zones in Solaris. www.sun.com/software/solaris.
16. A. A. Soror, U. F. Minhas, A. Aboulnaga, K. Salem, P. Kokosielis, and S. Kamath. Automatic virtual machine configuration for database workloads. In SIGMOD Conference, 2008.
17. A. J. Storm, C. Garcia-Arellano, S. Lightstone, Y. Diao, and M. Surendra. Adaptive Self-tuning Memory in DB2. In VLDB, 2006.
18. D. G. Sullivan, M. I. Seltzer, and A. Pfeffer. Using probabilistic reasoning to automate software tuning. In SIGMETRICS, 2004.
19. TPC-H and TPC-W Benchmarks from the Transaction Processing Council. http://www.tpc.org.
20. D. N. Tran, P. C. Huynh, Y. C. Tay, and A. K. H. Tung. A new approach to dynamic self-tuning of database buffers. ACM Transactions on Storage, 4(1), 2008.
21. G. Weikum, A. Moenkeberg, C. Hasse, and P. Zabback. Self-tuning database technology and information services: from wishful thinking to viable engineering. In VLDB, 2002.
22. I. H. Witten and E. Frank. Data Mining: Practical Machine Learning Tools and Techniques. Morgan Kaufmann, second edition, June 2005.
23. B. Xi, Z. Liu, M. Raghavachari, C. H. Xia, and L. Zhang. A smart hill-climbing algorithm for application server configuration. In WWW, pages 287-296, 2004.
24. K. Yagoub, P. Belknap, et al. Oracle's sql performance analyzer. IEEE Data Engineering Bulletin, 31(1), 2008.