Benchmarking financial database queries on a parallel machine

Author

Keane, J.A. ; Franklin, T.N. ; Dipper, R. ; Grant, A.J. ; Sumner, Robert ; Xu, M.Q.

Author_Institution

Dept. of Comput., Univ. of Manchester Inst. of Sci. & Technol., UK

Volume

2

fYear

1995

fDate

3-6 Jan 1995

Firstpage

402

Abstract

A database benchmark exercise on a parallel machine (a Kendall Square Research KSR1-32 virtual shared memory computer) for a large UK bank is discussed. The benchmark involved 8 queries running on a subset of the bank´s database across 10 processors. All queries were of the MIS variety, and included “real” marketing queries. Some queries give speedup of over 5 times on 10 processors. As a result of the data distribution, most queries showed speedup for up to 5 processors but then no more speedup until 10 processors were used. Tests suggest that the limit to I/O throughput lies in the disk controllers. The effectiveness of query optimisation and decomposition are also discussed

Keywords

bank data processing; distributed databases; management information systems; marketing data processing; parallel machines; query processing; software performance evaluation; I/O throughput limit; Kendall Square Research KSR1-32; MIS; UK bank; data distribution; database benchmark; disk controllers; financial database queries; marketing queries; parallel machine; query decomposition; query optimisation; speedup; virtual shared memory computer; Benchmark testing; Computer science; Concurrent computing; Databases; Indexes; Parallel machines; Throughput;

fLanguage

English

Publisher

ieee

Conference_Titel

System Sciences, 1995. Proceedings of the Twenty-Eighth Hawaii International Conference on

Conference_Location

Wailea, HI

Print_ISBN

0-8186-6930-6

Type

conf

DOI

10.1109/HICSS.1995.375518

Filename

375518