Logo image
MyBenchmark: generating databases for query workloads
Journal article

MyBenchmark: generating databases for query workloads

Eric Lo, Nick Cheng, Wilfred W. K. Lin, Wing-Kai Hon and Byron Choi
VLDB Journal, Vol.23(6), pp.895-913
15/11/2014

Abstract

Benchmarking Data Generation Performance Query Processing
To evaluate the performance of database applications and database management systems (DBMSs), we usually execute workloads of queries on generated databases of different sizes and then benchmark various measures such as respond time and throughput. This paper introduces MyBenchmark, a parallel data generation tool that takes a set of queries as input and generates database instances. Users of MyBenchmark can control the characteristics of the generated data as well as the characteristics of the resulting workload. Applications of MyBenchmark include DBMS testing, database application testing, and application-driven benchmarking. In this paper, we present the architecture and the implementation algorithms of MyBenchmark. Experimental results show that MyBenchmark is able to generate workload-aware databases for a variety of workloads including query workloads extracted from TPC-C, TPC-E, TPC-H, and TPC-W benchmarks. © 2014, Springer-Verlag Berlin Heidelberg.

Metrics

1 Record Views

Details

Logo image