Database Workload Analysis: An Empirical Study


The KIPS Transactions:PartD, Vol. 11, No. 4, pp. 747-754, Aug. 2004
10.3745/KIPSTD.2004.11.4.747,   PDF Download:

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.


Statistics
Show / Hide Statistics

Statistics (Cumulative Counts from September 1st, 2017)
Multiple requests among the same browser session are counted as one view.
If you mouse over a chart, the values of data points will be shown.


Cite this article
[IEEE Style]
J. S. Oh and S. H. Lee, "Database Workload Analysis: An Empirical Study," The KIPS Transactions:PartD, vol. 11, no. 4, pp. 747-754, 2004. DOI: 10.3745/KIPSTD.2004.11.4.747.

[ACM Style]
Jeong Seok Oh and Sang Ho Lee. 2004. Database Workload Analysis: An Empirical Study. The KIPS Transactions:PartD, 11, 4, (2004), 747-754. DOI: 10.3745/KIPSTD.2004.11.4.747.