Title :
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
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;
Conference_Titel :
System Sciences, 1995. Proceedings of the Twenty-Eighth Hawaii International Conference on
Conference_Location :
Wailea, HI
Print_ISBN :
0-8186-6930-6
DOI :
10.1109/HICSS.1995.375518
