Benchmarking parallel SQL database machines

Jelly, Innes; Kerridge, Jon; Bates, Chris

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.

• Presentation Conference Type: Conference Paper (Published)
• Conference Name: Directions in Databases 12th British National Conference on Databases, BNCOD 12
• Start Date: Jul 6, 1994
• End Date: Jul 8, 1994
• Online Publication Date: May 31, 2005
• Publication Date: 1994
• Deposit Date: Jul 24, 2019
• Journal: Directions in Databases; Lecture Notes in Computer Science
• Print ISSN: 0302-9743
• Electronic ISSN: 1611-3349
• Pages: 105-120
• Series Title: Lecture Notes in Computer Science
• Series Number: 826
• Series ISSN: 0302-9743
• Book Title: Directions in Databases 12th British National Conference on Databases, BNCOD 12 Guildford, United Kingdom, July 6–8, 1994 Proceedings
• ISBN: 9783540582359
• DOI: https://doi.org/10.1007/3-540-58235-5_38
• Keywords: parallel databases; SQL; benchmark system; scalability
• Public URL: http://researchrepository.napier.ac.uk/Output/1992589