Modelling Parallel Oracle for Performance Prediction

  • Authors:

  • E. W. Dempster;N. T. Tomov;M. H. Williams;H. Taylor;A. Burger;P. Trinder;J. Lü;P. Broughton

  • Affiliations:

  • School of Mathematics and Computer Sciences, Heriot-Watt University, Riccarton, Edinburgh, Scotland, EH14 4AS, UK;School of Mathematics and Computer Sciences, Heriot-Watt University, Riccarton, Edinburgh, Scotland, EH14 4AS, UK;School of Mathematics and Computer Sciences, Heriot-Watt University, Riccarton, Edinburgh, Scotland, EH14 4AS, UK. mhw@macs.hw.ac.uk;School of Mathematics and Computer Sciences, Heriot-Watt University, Riccarton, Edinburgh, Scotland, EH14 4AS, UK. hamish@macs.hw.ac.uk;School of Mathematics and Computer Sciences, Heriot-Watt University, Riccarton, Edinburgh, Scotland, EH14 4AS, UK. ab@macs.hw.ac.uk;School of Mathematics and Computer Sciences, Heriot-Watt University, Riccarton, Edinburgh, Scotland, EH14 4AS, UK. trinder@macs.hw.ac.uk;The School of Computing, Information Systems and Mathematics, South Bank University, Borough Road, London, SE1 0AA, UK;International Computers Limited, High Performance Technology, Wenlock Way, West Gorton, Manchester, England, M12 5DR, UK

  • Venue:
  • Distributed and Parallel Databases
  • Year:
  • 2003

Quantified Score

Hi-index 0.00

Visualization

Abstract

The problem of predicting the performance of a parallel relational DBMS for a set of queries applied to a particular data set on a shared nothing parallel architecture without transferring the application to a parallel system is a challenging one. An analytical approach has been developed to assist with this task and has been applied to the ICL GoldRush machine, a parallel machine with a shared-nothing architecture. This paper describes how the Oracle Parallel Server and the Parallel Query Option are modelled by the method and compares the predictions of the model against actual measurements obtained.