Managing database server performance to meet QoS requirements in electronic commerce systems |
| |
Authors: | Patrick Martin Wendy Powley Hoi-Ying Li Keri Romanufa |
| |
Affiliation: | (1) Department of Computing and Information Science, Queen’s University, Kingston, Ontario, Canada K7L 3N6, CA;(2) IBM Toronto Laboratory, Toronto, Ontario, Canada M3C 1H7, CA |
| |
Abstract: | The performance of electronic commerce systems has a major impact on their acceptability to users. Different users 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 this analysis 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 be
used to meet the QoS requirements of a set of transactions similar to transactions found in an electronic commerce workload.
We briefly describe the memory reallocation algorithms used by Quartermaster and present experiments to show the impact of
the reallocations on the performance of the transactions.
Published online: 22 August 2001 |
| |
Keywords: | : Database management systems – Performance management – Quality of service – Buffer management |
本文献已被 SpringerLink 等数据库收录! |
|