Benchmarking for Transaction Processing Database Systems in Big Data Era

Research output: Chapter in Book/Report/Conference proceedingConference contributionpeer-review

2 Scopus citations

Abstract

Benchmarking is an essential suite supporting development of database management systems. It runs a set of well defined data and workloads on a specific hardware configuration to gather the results to fill the measurements. It is used widely for evaluating new technology or comparing different systems so as to promote the progress of database systems. To date, under the requirement of data management, new databases are designed and issued for different application requirements. Most of the state-of-the-art benchmarks are also designed for specific types of applications. Based on our experiences, however, we argue that considering the characteristics of data or workloads in big data era, benchmarking transaction processing databases (TP) must put much effort for domain specific needs to reflet 4V properties (i.e. volume, velocity, variety and veracity). With the critical transaction processing requirements of new applications, we see an explosion of designing innovative scalable databases or new processing architecture on traditional databases dealing with high intensive transaction workloads, which are called SecKill and can saturate the traditional database systems by high workloads, for example “11 (Formula Presented) ” of Tmall, “ticket booking” during China Spring Festival and “Stock Exchange” applications. In this paper, we first analyze SecKill applications and the implementation logics, and also summarize and abstract the business model in details. Then, we propose a totally new benchmark called PeakBench for simulating SecKill applications, including workload characteristics definition, workload distribution simulating, and logics implementing. Additionally, we define new evaluation metrics for performance comparison among DBMSs under different implementation architecture from the micro- and macro- points of views. At last, we provide a package of tools for simulating and evaluating purpose.

Original languageEnglish
Title of host publicationBenchmarking, Measuring, and Optimizing 1st BenchCouncil International Symposium, 2018 Revised Selected Papers
EditorsChen Zheng, Jianfeng Zhan
PublisherSpringer
Pages147-158
Number of pages12
ISBN (Print)9783030328122
DOIs
StatePublished - 2019
Event1st International Symposium on Benchmarking, Measuring, and Optimization, Bench 2018 - Seattle, United States
Duration: 10 Dec 201813 Dec 2018

Publication series

NameLecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)
Volume11459 LNCS
ISSN (Print)0302-9743
ISSN (Electronic)1611-3349

Conference

Conference1st International Symposium on Benchmarking, Measuring, and Optimization, Bench 2018
Country/TerritoryUnited States
CitySeattle
Period10/12/1813/12/18

Keywords

  • DB-testing
  • Evaluation
  • Intensive workloads
  • Transaction processing

Fingerprint

Dive into the research topics of 'Benchmarking for Transaction Processing Database Systems in Big Data Era'. Together they form a unique fingerprint.

Cite this