Location of Repository

Modelling parallel Oracle for performance prediction

By E.W. Dempster, N.T. Tomov, M.H. Williams, H. Taylor, A. Burger, P. Trinder, J. Lu and P. Broughton

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. Keywords: Analytical modelling,parallel Oracle, performance prediction, parallel database 1. Introduction The inherent parallelism in relational databases is well suited to parallel computer technology and commercial interest in the use of parallel computers for running relational database systems has been growing [16]. A number of parallel database systems running on different paralle..

Topics: Analytical modelling, parallel Oracle, performance prediction, parallel database
Year: 2007
OAI identifier: oai:CiteSeerX.psu:10.1.1.32.5366
Provided by: CiteSeerX
Download PDF:
Sorry, we are unable to provide the full text but you may find it at the following location(s):
  • http://citeseerx.ist.psu.edu/v... (external link)
  • http://www.cee.hw.ac.uk/~hamis... (external link)
  • Suggested articles


    To submit an update or takedown request for this paper, please submit an Update/Correction/Removal Request.