MyBenchmark: generating databases for query workloads

Eric Lo; Nick Cheng; Wilfred W.K. Lin; Wing Kai Hon; Koon Kau CHOI

doi:10.1007/s00778-014-0354-1

MyBenchmark: generating databases for query workloads

Eric Lo^*, Nick Cheng, Wilfred W.K. Lin, Wing Kai Hon, Koon Kau CHOI

^*Corresponding author for this work

Department of Computer Science

Research output: Contribution to journal › Journal article › peer-review

21 Citations (Scopus)

Abstract

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.

Original language	English
Pages (from-to)	895-913
Number of pages	19
Journal	VLDB Journal
Volume	23
Issue number	6
DOIs	https://doi.org/10.1007/s00778-014-0354-1
Publication status	Published - 15 Nov 2014

Scopus Subject Areas

Information Systems
Hardware and Architecture

User-Defined Keywords

Benchmarking
Data Generation
Performance
Query Processing

Access to Document

10.1007/s00778-014-0354-1

Cite this

@article{2b9e75771ab8464e9f3372f4ff120979,

title = "MyBenchmark: generating databases for query workloads",

abstract = "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.",

keywords = "Benchmarking, Data Generation, Performance, Query Processing",

author = "Eric Lo and Nick Cheng and Lin, {Wilfred W.K.} and Hon, {Wing Kai} and CHOI, {Koon Kau}",

year = "2014",

month = nov,

day = "15",

doi = "10.1007/s00778-014-0354-1",

language = "English",

volume = "23",

pages = "895--913",

journal = "VLDB Journal",

issn = "1066-8888",

publisher = "Springer New York",

number = "6",

}

TY - JOUR

T1 - MyBenchmark

T2 - generating databases for query workloads

AU - Lo, Eric

AU - Cheng, Nick

AU - Lin, Wilfred W.K.

AU - Hon, Wing Kai

AU - CHOI, Koon Kau

PY - 2014/11/15

Y1 - 2014/11/15

N2 - 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.

AB - 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.

KW - Benchmarking

KW - Data Generation

KW - Performance

KW - Query Processing

UR - http://www.scopus.com/inward/record.url?scp=84912077093&partnerID=8YFLogxK

U2 - 10.1007/s00778-014-0354-1

DO - 10.1007/s00778-014-0354-1

M3 - Journal article

AN - SCOPUS:84912077093

SN - 1066-8888

VL - 23

SP - 895

EP - 913

JO - VLDB Journal

JF - VLDB Journal

IS - 6

ER -

MyBenchmark: generating databases for query workloads

Abstract

Scopus Subject Areas

User-Defined Keywords

Access to Document

Other files and links

Fingerprint

Cite this