Title
Managing database server performance to meet QoS requirements in electronic commerce systems
Abstract
The performance of electronic commerce systems will have a major impact on their acceptability to users. Different users w ill also demand different levels of performance from the system, that is, they will have different Quality of Service (QoS) requirements. Electronic commerce systems are the integration of several different types of servers and each server must contribute to meeting the QoS demands of the users. In this paper we focus on the role, and the performance, of a database server within an electronic commerce system. We examine the characteristics of the workload placed on a database server by an electronic commerce system and suggest a range of QoS requirements for the database server based on the examination of the workload. We argue that a database server must be able to dynamically reallocate its resources in order to meet the QoS requirements of different transactions as the workload changes. We describe Quartermaster, which is a system to support dynamic goal-oriented resource management in database management systems, and discuss how it can be used to help meet the QoS requirements of the electronic commerce database server. We provide an example of the use of Quartermaster that illustrates how the dynamic reallocation of memory resources can improve the performance of the database server under an example electronic commerce workload. We briefly describe the memory reallocation algorithms used by Quartermaster and present experiments to show the impact of the algorithms on the performance of the database server.
Year
DOI
Venue
2002
10.1007/s007990100046
Int. J. on Digital Libraries
Keywords
Field
DocType
database management systems,buffer manage- ment,quality of service,perform- ance management,database management system,electronic commerce,goal orientation
World Wide Web,Service quality,Computer science,Workload,Server,Quality of service,Database server,User requirements document,Database
Journal
Volume
Issue
Citations 
3
4
10
PageRank 
References 
Authors
0.76
14
4
Name
Order
Citations
PageRank
Patrick Martin1100.76
Wendy Powley232928.43
Hoi-ying Li3211.67
Keri Romanufa4744.28