Decision Support for Management of Parallel Database Systems

摘要

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 configuration 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, relicated 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.