Browse > Article
http://dx.doi.org/10.3745/KIPSTD.2004.11D.4.747

Database Workload Analysis : An Empirical Study  

Oh, Jeong-Seok (숭실대학교 대학원 컴퓨터학과)
Lee, Sang-Ho (숭실대학교 컴퓨터학부)
Abstract
Database administrators should be aware of performance characteristics of database systems in order to manage database system effectively. The usages of system resources in database systems could be quite different under database workloads. The objective of this paper is to identify and analyze performance characteristics of database systems in different workloads, which could help database tuners tune database systems Under the TPC-C and TPC-W workloads, which represent typical workloads of online transaction processing and electronic commerce respectively, we investigated usage types of resource that are determined by fourteen performance indicator, and are behaved in response to changes of four tuning parameters (data buffer, private memory, I/O process, shared memory). Eight out of the fourteen performance indicators cleary show the performance differences under the workloads. Changes of data buffer parameter give a influences to database system. The tuning parameter that affects the system performance significantly is the database buffer size in the both workloads.
Keywords
Database Workload; Performance Indicator; Database Parameter;
Citations & Related Records
Times Cited By KSCI : 1  (Citation Analysis)
연도 인용수 순위
1 D. G. Benoit, 'Automated Diagnosis and Control of DBMS Resources,' Conference on Extending Database Technology (EDBT) Ph.D. Workshop, 2000
2 K. P. Brown, M. Mehta, M. J. Carey and M. Livny, 'Towards Automated Performance Tuning For Complex Workloads,' International Conference on Very Large Data Bases(VLDB), pp.72-84, 1994
3 M. Calzarossa and G. Serazzi, 'Workload Characterization : A Survey,' Proceedings of the IEEE, 8(13), pp.1136-1150, 1993   DOI   ScienceOn
4 P. Martin, H. Y. Li, M. Zheng, K. Romanufa and W. Powley, 'Dynamic Reconfiguration Algorithm : Dynamically Tuning Multiple Buffer Pools,' International Conference on Database and Expert Systems Applications (DEXA) Conference, pp.92-101, 2000
5 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, 3(4), pp.316-324, 2002   DOI
6 T. Morals, and D. Lorentz, 'Oracle 9i : Database Reference, Release 1 (9.0.1)', Oracle Corporation, 2001
7 'TPC Benchmark C Specification (Revision 5.0),' http://www.tpc.org/tpcc/default.asp, 2001
8 'TPC Benchmark W (Web Commerce) Specification (version 1.8),' http://www.tpc.org/tpcw/default.asp, 2002
9 M. Cyran, 'Oracle 9i : Database Performance Guide and Reference, Release 1 (9.0.1),' Oracle Corporation, 2001
10 G. Weikum, A. C. Konig, A. Kraiss, and M. Sinnewell, 'Towards Self-Tuning Memory Management for Data Servers,' Bulletin of the Technical Committee on Data Engineering, IEEE Computer Society, 22(2), pp.3-11, 1999
11 'INFORMIX : Universal Server Administrator's Guide I and II (version 9.1),' Informix press, 1997
12 'UniSQL : Database Administration Guide (version 4.0),' UniSQL Inc., 1998
13 V. Singhal and A. J. Smith, 'Characterization of Contention in Real Relational Database,' Technical Reports : CSD-94-801, University of California at Berkely, 1994
14 D. E. Shasha, 'Database Tuning : a Principled Approach', Prentice Hall PTR, 1992
15 P. S. Yu, M. S. Chen, H. U. Heiss and S. H. Lee, 'On Workload Characterization of Relational Database Environments,' IEEE Transactions on Software Engineering, 18(4), pp.347-355, 1992   DOI   ScienceOn