The Community for Technology Leaders
2014 47th Hawaii International Conference on System Sciences (1995)
Hawaii, USA
Jan. 4, 1995 to Jan. 7, 1995
ISSN: 1060-3425
ISBN: 0-8186-6935-7
pp: 402
M.Q. Xu , Dept. of Comput., Univ. of Manchester Inst. of Sci. & Technol., UK
R. Dipper , Dept. of Comput., Univ. of Manchester Inst. of Sci. & Technol., UK
J.A. Keane , Dept. of Comput., Univ. of Manchester Inst. of Sci. & Technol., UK
T.N. Franklin , Dept. of Comput., Univ. of Manchester Inst. of Sci. & Technol., UK
A.J. Grant , Dept. of Comput., Univ. of Manchester Inst. of Sci. & Technol., UK
R. Sumner , 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.
INDEX TERMS
bank data processing; marketing data processing; software performance evaluation; parallel machines; management information systems; distributed databases; query processing; database benchmark; financial database queries; parallel machine; UK bank; MIS; marketing queries; speedup; data distribution; I/O throughput limit; disk controllers; query optimisation; query decomposition; Kendall Square Research KSR1-32; virtual shared memory computer
CITATION
M.Q. Xu, R. Dipper, J.A. Keane, T.N. Franklin, A.J. Grant, R. Sumner, "Benchmarking financial database queries on a parallel machine", 2014 47th Hawaii International Conference on System Sciences, vol. 00, no. , pp. 402, 1995, doi:10.1109/HICSS.1995.375518
93 ms
(Ver 3.3 (11022016))