Modelling parallel oracle for performance prediction

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

doi:10.1023/A:1022875525392

Modelling parallel oracle for performance prediction

E. W. Dempster, N. T. Tomov, Howard Williams, H. Taylor, A. Burger, P. Trinder, J. Lü, P. Broughton

Research output: Contribution to journal › Article › peer-review

3 Citations (Scopus)

98 Downloads (Pure)

Abstract

The problem of predicting the performance of a parallel relational DBMS fora 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.

Original language	English
Pages (from-to)	251-269
Number of pages	19
Journal	Distributed and Parallel Databases
Volume	13
Issue number	3
DOIs	https://doi.org/10.1023/A:1022875525392
Publication status	Published - May 2003

Keywords

Analytical modelling
Parallel database
Parallel Oracle
Performance prediction

Access to Document

10.1023/A:1022875525392

Full textSubmitted manuscript, 371 KB

Cite this

@article{b707c964171b4f15b561194bce679dd8,

title = "Modelling parallel oracle for performance prediction",

abstract = "The problem of predicting the performance of a parallel relational DBMS fora 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 database, Parallel Oracle, Performance prediction",

author = "Dempster, {E. W.} and Tomov, {N. T.} and Howard Williams and H. Taylor and A. Burger and P. Trinder and J. L{\"u} and P. Broughton",

year = "2003",

month = may,

doi = "10.1023/A:1022875525392",

language = "English",

volume = "13",

pages = "251--269",

journal = "Distributed and Parallel Databases",

issn = "0926-8782",

publisher = "Springer",

number = "3",

}

TY - JOUR

T1 - Modelling parallel oracle for performance prediction

AU - Dempster, E. W.

AU - Tomov, N. T.

AU - Williams, Howard

AU - Taylor, H.

AU - Burger, A.

AU - Trinder, P.

AU - Lü, J.

AU - Broughton, P.

PY - 2003/5

Y1 - 2003/5

N2 - The problem of predicting the performance of a parallel relational DBMS fora 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.

AB - The problem of predicting the performance of a parallel relational DBMS fora 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.

KW - Analytical modelling

KW - Parallel database

KW - Parallel Oracle

KW - Performance prediction

UR - http://www.scopus.com/inward/record.url?scp=0037403974&partnerID=8YFLogxK

U2 - 10.1023/A:1022875525392

DO - 10.1023/A:1022875525392

M3 - Article

SN - 0926-8782

VL - 13

SP - 251

EP - 269

JO - Distributed and Parallel Databases

JF - Distributed and Parallel Databases

IS - 3

ER -

Modelling parallel oracle for performance prediction

Abstract

Keywords

Access to Document

Other files and links

Fingerprint

Cite this