Browse > Article
http://dx.doi.org/10.3745/KIPSTD.2006.13D.2.183

Resource Identification in Database Workloads  

Oh Jeong-Seok (한국가스안전공사 가스안전연구개발원)
Lee Sang-Ho (숭실대학교 컴퓨터학부)
Publication Information
The KIPS Transactions:PartD / v.13D, no.2, 2006 , pp. 183-190 More about this Journal
Abstract
Database workloads may show different resource usages for database applications. Database administrators can enhance the DBMS performances through resource management that reflects workload characteristics. We provide a method that can identify tunable resources from analyzing the relationship between performance indicators and resources. First, we select which performance indicators increase or decrease by expanding resources using a correlation coefficient and a significance level test. Next, we identify resources that can affect the DBMS Performances by using increasing or decreasing performance indicators. We evaluated our method in the TPC-C and TPC-W environments.
Keywords
Database Workload; Performance Indicator; Resource Usage;
Citations & Related Records
Times Cited By KSCI : 1  (Citation Analysis)
연도 인용수 순위
1 G. Weikurn, A. C. Konig, A Krasis, and M Sinnewell, 'Towards Self Tuning Memory Management of Data Servers', Bulletin of the Technical Committee on Data Engineering, IEEE Computer Society, Vol.22, No.2, pp.3-11, 1999
2 박정식, 윤영석, '현대 통계학(제 4판)，다산 출판사，2005
3 오정석, 이상호, '데이터베이스 워크로드 분석: 실험적 연구' 정보처리학회 논문지, 제 11-D권，4호，pp.747-754，2004   과학기술학회마을   DOI
4 TPC Benchmark W (Web Commerce) Specification (version 1.8), 2002. http://www.tpc.org/tpcw/default.asp
5 G. Weikum, C. Hasse, A. Moenkeberg, and P. Zabback, 'The COMFORT Automatic Tuning Project', Information Systems, Vol.19, No.5, pp.381-432, 1994   DOI   ScienceOn
6 D. E. Shasha, 'Database Tuning: A Principled Approach', Prentice Hall PTR, 1992
7 TPC Benchmark C Specification (Revision 5.0), 2001,http://www.tpc.org/tpcc/default.asp
8 J. S. Oh and S. H. Lee, 'Resource Selection for Autonomic Database Tuning', Proceedings of IEEE International Workshop on Self-Managing Database Systems, pp.66-73, Tokyo, 2005   DOI
9 V. Signhal and A. J. Smith, 'Analysis of Locking Behavior in Three Real Database Systems', The VLDB Journal, Vol.6, No.1, pp.40-52, 1997   DOI
10 T. Morals and D. Lorentz, 'Oracle 9i : Database Reference, Release 2(9.2)', Oracle Corporation, 2001
11 J. Neter, M. J. Kunter, C. J. Nachtsheim, W. Wasserman, 'Applied Linear Regression Models', IRWIN Books, 1996
12 D. Menasce, D. Barbara, and R. Dodge, 'Reserving QoS of E -Commerce Sites through Self-Tuning: A Performance Model Approach', Proceedings of 3rd ACM-EC Conference, Florida, 2001   DOI
13 D. S. Moore, 'Statistics Concepts and Controversies (the fifth edition)', W.H.Freeman and Company, 2001
14 P. Martin, W. Powley, H. Y. Li, and K. Romanufa, 'Managing Database Server Performance to Meet QoS Requirements in Electronic Commerce Systems', International Journal on Digital Libraries, Vol.3, No.4, pp.316-324, 2002   DOI
15 P. Martin, H. Y. Li, M. Zheng, K Romanufa, and W. Powley, 'Dynamic Reconfiguration Algorithm: Dynamically Tuning Multiple Buffer Pools', Proceedings of 11th DEXA Conference, pp.92-101, London, 2000
16 D. M. Lane, 'Hyerstat Online: An Introductory Satistics Textbook and Online Tutorial for Help in Statistic', http://davidmlane.com/hyperstat/index.html
17 K. P. Brown, M. Mehta, M. J. Carey, and M. Livny, 'Towards Automated Performance Tuning For Complex Workloads', Proceedings of 20th VLDB Conference, pp.72-84, Santiago, 1994
18 M. Cyran, 'Oracle 9i: Database Performance Guide and Reference, Release 2(9.2)', Oracle Corporation, 2001
19 S. Elnaffar, P. Martin, and R. Horman, 'Automatically Classifying Database Workloads', Proceedings of 11th CKIM Conference, pp.622-624, McLean, 2002   DOI
20 D. G. Benoit, 'Automated Diagnosis and Control of DBMS Resources', Ph.D Workshop on EDBT Conference, 2000
21 K. P. Brown, M. J. Carey, and M. Livny, 'Goal-Oriented Buffer Management Revisited', Proceedings of ACM SIGMOD Conference, pp.353-364, Montreal, 1996   DOI