Abstract
New parallel database systems are being developed to support the data processing needs of large commercial organisations: these offer increased performance in terms of processing throughput and enhanced support for both on-line transaction processing and management information provision. In order to evaluate the performance of these systems a new SQL benchmark has been developed which models the requirements for real database applications. Based on a large commercial database the benchmark system includes the specification of the test or “mimic” database and sets of transactions and queries, and the data/transaction generation tools. The benchmark uses synthetic data which closely resembles real world data and provides for evaluation of the scalability of system under test.
This is a preview of subscription content, log in via an institution to check access.
Preview
Unable to display preview. Download preview PDF.
References
JM Kerridge, “The Design of the IDIOMS Parallel Database Machine”, Proc. British National Conf. on Databases 9 (Wolverhampton, 1991), pub. Aspects of Databases, eds. M.S. Jackson and A.E. Robinson Oxford: Butterworth — Heinemann, 1991.
R England et al, “The Performance of the IDIOMS Parallel Database Machine”, Parallel Computing and Transputer Applications '92 (PACTA '92), eds M. Valero, M.R. Jane and E Onate IOS Press Amsterdam, 1992.
E Brocklehurst, T Chambers, C Francis, A Mansfield, M Stevens, H Symm, “PEPS Benchmark Methodology — Draft 5.1”, NPL Report, April 1992
International Standards Organisation, Database Language SQL, ISO 9075:1987(E), 1987.
J Page, “High Performance Database for Client/Server Systems”, in Parallel Processing and Data Management, ed. P. Valduriez, Chapman and Hall, 1992.
“The Benchmark Handbook” Ed J Gray, Morgan Kaufmann, 1991
S Dietrich, M Brown, E Cortes-Rello and S Wunderlin “A Practitioners Introduction to Database Performance Measurement” in Computer Journal, Vol 35, No. 4, August 1992
O Serlin “The History of DebitCredit and TPC, TPC-A and TPC-B” in [6]
N Revell and M W Youssef “Database Performance Evaluation: A Methodological Approach” in Proc DEXA '93, Database and Expert Systems Applications, Sept 1993, Prague, Czeck Republic, LNCS, Springer Verlag (1993)
D DeWitt “The Wisconsin Benchmark: Past, Present and Future” in [6]
P E O'Neil “The Set Query Benchmark” in [6]
C Turbifill, C Orji and D Bitton “AS3AP: An ANSI SQL Standard Scalable and Portable Benchmark for Relational Database Systems” in [6]
Jon Kerridge, Innes Jelly, Chris Bates and Yannis Tsitsogiannis, “Towards a Benchmark for Scalable Parallel Database Machines” Proceedings of PEPS Workshop on Performance Evaluation of Parallel Systems, ESPRIT/BCS, November 1993, Warwick University, UK
A Mansfield “SOSIP and the PEPS Benchmarking Methodology” Proceedings of PEPS Workshop on Performance Evaluation of Parallel Systems, ESPRIT/BCS, November 1993, Warwick University, UK
RJ Cook “Performance Testing of the IDIOMS Parallel Database Machine”, MSc Thesis, University of Sheffield, 1993
P Valduriez “Parallel Database Systems: Open Problems and New Issues” in Distributed and Parallel Databases 1 (1993)
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 1994 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Jelly, I., Kerridge, J., Bates, C. (1994). Benchmarking parallel SQL database machines. In: Bowers, D.S. (eds) Directions in Databases. BNCOD 1994. Lecture Notes in Computer Science, vol 826. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-58235-5_38
Download citation
DOI: https://doi.org/10.1007/3-540-58235-5_38
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-58235-9
Online ISBN: 978-3-540-48580-3
eBook Packages: Springer Book Archive