Browse > Article

Database System Parameter Toning in the TPC-W Benchmark  

류문수 (핸디소프트 공동개발팀)
정회진 (숭실대학교 컴퓨터학)
이상호 (숭실대학교 컴퓨터학부)
Publication Information
Journal of KIISE:Databases / v.31, no.4, 2004 , pp. 373-383 More about this Journal
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.
Keywords
database system tuning; parameter tuning; TPC-W;
Citations & Related Records
Times Cited By KSCI : 1  (Citation Analysis)
연도 인용수 순위
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   DOI
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   DOI
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/