This Article 
   
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
28th Hawaii International Conference on System Sciences (HICSS'95)
Hawaii, USA
January 04-January 07
ISBN: 0-8186-6935-7
ASCII Text
x 
 
J.A. Keane, T.N. Franklin, R. Dipper, A.J. Grant, R. Sumner, M.Q. Xu, "Benchmarking financial database queries on a parallel machine," 2013 46th Hawaii International Conference on System Sciences, pp. 402, 28th Hawaii International Conference on System Sciences (HICSS'95), 1995.
 
 
BibTex
x
 
@article{ 10.1109/HICSS.1995.375518,
author = {J.A. Keane and T.N. Franklin and R. Dipper and A.J. Grant and R. Sumner and M.Q. Xu},
title = {Benchmarking financial database queries on a parallel machine},
journal ={2013 46th Hawaii International Conference on System Sciences},
volume = {0},
year = {1995},
issn = {1060-3425},
pages = {402},
doi = {http://doi.ieeecomputersociety.org/10.1109/HICSS.1995.375518},
publisher = {IEEE Computer Society},
address = {Los Alamitos, CA, USA},
}
 
 
RefWorks Procite/RefMan/Endnote
x 
 
TY - CONF
JO - 2013 46th Hawaii International Conference on System Sciences
TI - Benchmarking financial database queries on a parallel machine
SN - 1060-3425
SP
EP
A1 - J.A. Keane,
A1 - T.N. Franklin,
A1 - R. Dipper,
A1 - A.J. Grant,
A1 - R. Sumner,
A1 - M.Q. Xu,
PY - 1995
KW - 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
VL - 0
JA - 2013 46th Hawaii International Conference on System Sciences
ER -
 
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
R. Dipper, 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
M.Q. Xu, Dept. of Comput., Univ. of Manchester Inst. of Sci. & Technol., UK
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:
J.A. Keane, T.N. Franklin, R. Dipper, A.J. Grant, R. Sumner, M.Q. Xu, "Benchmarking financial database queries on a parallel machine," hicss, pp.402, 28th Hawaii International Conference on System Sciences (HICSS'95), 1995
Usage of this product signifies your acceptance of the Terms of Use.