Database Workload Analysis: An Empirical Study 


Vol. 11,  No. 4, pp. 747-754, Aug.  2004
10.3745/KIPSTD.2004.11.4.747


PDF
  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
  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.

Forms

Search
(IN TITLE, AUTHOR, ABSTRACT,KEYWORDS)

Advanced Search ▼

POPULAR KEYWORDS
(TOP 10 KEYWORDS)

Recent Publications
(LAST 3 YEARS)

Old Journals

Indexing

All publications of TKIPS is indexed in DOI, EBSCO, Google Scholar, Crossref, and CrossCheck.

TKIPS is also selected as the Journal for Accreditation by NRF (National Research Foundation of Korea).

Related Journals