Database System Parameter Toning in the TPC-W Benchmark

TPC-W 성능 평가에서의 데이타베이스 시스템 성능 인자 튜닝

  • Published : 2004.08.01

Abstract

There have been an emerging interests in the importance of database tuning techniques under modem database environments in which very large-scale data should be managed. In Particular. database performance parameters should be tuned to reflect system loads appropriately. This paper presents two parameter tuning strategies, namely throughput-based and response-time-based, which tune each performance parameter accordingly. The proposed techniques are applied to two commercial database systems in the TPC-W benchmark to see the effectiveness of those methods. The results show that they can help improve system performance considerably.

대량의 데이타를 관리하는 현대 데이타베이스 시스템 환경에서는 데이타베이스 시스템 튜닝에 대한 중요성이 증가하고 있다. 특히, 데이타베이스 시스템 성능 인자(performance parameters)를 시스템부하에 따라 적절하게 튜닝하여야 한다. 본 논문에서는 TPC-W 환경에서 데이타베이스 시스템의 단일 성능 인자 튜닝 전략 2가지(처리량 평가 방법, 응답시간 평가 방법)를 제시한다. 효과성을 입증하기 위하여 제시한 튜닝 전략은 두 개의 상용 데이타베이스 시스템에 적용하였다. 실험 결과는 제시된 튜닝 전략이 성능 향상에 기여함을 보인다.

Keywords

References

  1. D. Shasha and P. Bonnet, 'Database Tuning: Principles, Experiments, and Troubleshooting Techniques,' p. 415, Morgan Kaufmann Publishers, 2002
  2. D. Shasha, 'Tuning Databases for High Performance,' ACM Computing Surveys, Vol. 28, No.1, pp. 113-115, 1996 https://doi.org/10.1145/234313.234363
  3. K. D. Ahn, J. S. Oh, and S. H. Lee, 'Development of a Tuning Aid for Database Systems,' The Transactions of the Korea Information Processing Society, pp. 3311-3322, 2000
  4. Oracle Corporation, 'Designing and Tuning for Performance,' http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76992.pdf, 1999
  5. S. Chaudhuri and R. Narasayya, 'AutcAdmin 'What-if' Index Analysis Utility,' Proceedings of ACM SIGMOD Conference, pp. 367-378, 1998
  6. D. Menasce, D. Barbara, and R. Dodge, 'Preserving QoS of E-commerce Sites Through Self- Tuning: A Performance Model Approach,' Proceedings of ACM Conference on Electronic Commerce, pp. 224-234, 2001 https://doi.org/10.1145/501158.501186
  7. Transaction Processing Performance Council, http://www.tpc.org/
  8. W. D. Smith, 'TPC-W: Benchmarking an Ecornmerce Solution,' http://www.tcp.org/tpcw/TPC-W_Wh.pdf
  9. H. S. Lee, S. J. Kim, and S. H. Lee, 'Parameter Tuning in Database Systems,' in preparation, 2003
  10. D. DeWitt, 'The Wisconsin Benchmark: Past, Present, and Future, In: The Benchmark Handbook,' pp. 269-315, Morgan Kaufmann Publishers, 1993
  11. The BEA Systems, http://www.bea.com/