Database Server Workload Characterization in an E-Commerce Environment

Authors:
Fujian Liu;Yanping Zhao;Wenguang Wang;Dwight Makaroff
Affiliations:
University of Saskatchewan;University of Saskatchewan;University of Saskatchewan;University of Saskatchewan
Venue:
MASCOTS '04 Proceedings of the The IEEE Computer Society's 12th Annual International Symposium on Modeling, Analysis, and Simulation of Computer and Telecommunications Systems
Year:
2004

Citing 0
Cited 3

A survey on dynamic Web content generation and delivery techniques

Journal of Network and Computer Applications
Automatic virtual machine configuration for database workloads

ACM Transactions on Database Systems (TODS)
A simulation study of the effects of multi-path approaches in e-commerce applications

IPDPS'06 Proceedings of the 20th international conference on Parallel and distributed processing

Quantified Score

Hi-index	0.00

Visualization

Abstract

In an E-commerce system, the database server performance is crucial. Dynamic cache is often used to reduce the load on the database server, which reduces the need for scalability. A good understanding of the workload characteristics of the database server in an E-commerce environment is important to the design, tuning, and capacity planning of the database server. In this paper, we characterize the database server workloads in a benchmark E-commerce system. We focus on the response time, CPU utilization, the database page reference characteristics, and disk I/Os of the database server. We found that using dynamic cache can substantially reduce the CPU utilization but not always the number of disk I/Os of the database server. In most cases, using dynamic cache reduces temporal locality in database page references, but to a smaller degree than that reported in file servers and web proxies. Interestingly, in certain E-commerce workloads, using dynamic cache results in better temporal locality.