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. Keane | 1 | 96 | 7.33 |
T. N. Franklin | 2 | 0 | 0.34 |
Dipper, R. | 3 | 0 | 0.68 |
A. J. Grant | 4 | 110 | 18.57 |
R. Sumner | 5 | 0 | 0.34 |
M. Q. Xu | 6 | 0 | 0.34 |