Title
Benchmarking financial database queries on a parallel machine
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.
Year
DOI
Venue
1995
10.1109/HICSS.1995.375518
HICSS (2)
Keywords
Field
DocType
financial database query,kendall square research,database benchmark exercise,query optimisation,parallel machine,disk controller,mis variety,marketing query,data distribution,o throughput,large uk bank,indexes,management information systems,mis,distributed databases,speedup,throughput,benchmark testing,computer science,databases,concurrent computing
Management information systems,Computer science,Theoretical computer science,Shared virtual memory,Concurrent computing,Distributed database,Throughput,Benchmarking,Database,Benchmark (computing),Speedup
Conference
Volume
ISBN
Citations 
2
0-8186-6935-7
0
PageRank 
References 
Authors
0.34
2
6
Name
Order
Citations
PageRank
J. A. Keane1967.33
T. N. Franklin200.34
Dipper, R.300.68
A. J. Grant411018.57
R. Sumner500.34
M. Q. Xu600.34