Parallel database systems are generally recognised as one of the most important application areas for commercial parallel systems. However, the task of managing the performance of a parallel database system is exceedingly complex. The initial choice of hardware conngura-tion to support a particular DBMS application and the subsequent task of tuning the DBMS to improve performance rely not only on the way in which the data is structured, but also on how it is fragmented, replicated and distributed across the processing elements of the system. To understand the behaviour of a particular application requires the study of large volumes of performance data. To simplify this process it is essential to provide some means of presenting performance data in a comprehensible form which will aid visualisation. This paper explores some of the issues relating to decision support for the performance management of parallel database systems and describes an analytical capacity planning tool to assist users in this task.
[1]
M. Howard Williams,et al.
Practical throughput estimation for parallel databases
,
1996,
Softw. Eng. J..
[2]
M. Howard Williams,et al.
Data Placement in Parallel Database Systems
,
1996
.
[3]
Kien A. Hua,et al.
An Efficient Load Balancing Strategy for Shared-Nothing Database Systems
,
1992,
DEXA.
[4]
M. Howard Williams,et al.
Data Placement Strategy for a Parallel Database System
,
1992,
DEXA.
[5]
Martin L. Kersten,et al.
Design and Implementation of a DBMS Performance Assessment Tool
,
1993,
DEXA.
[6]
Tom W. Keller,et al.
Data placement in Bubba
,
1988,
SIGMOD '88.
[7]
B. Schneiderman,et al.
Designing the User Interface. Strategies for Effective Human-Computer Interaction
,
1992
.