Benchmarking Transaction and Analytical Processing Systems

The Creation of a Mixed Workload Benchmark and its Application

  • Anja Bog

Part of the In-Memory Data Management Research book series (IMDM)

Table of contents

  1. Front Matter
    Pages i-xiii
  2. Anja Bog
    Pages 1-12
  3. Background of Transactional and Analytical Systems in Logical Database Design and Benchmarking

  4. Towards a Benchmark for Mixed Workloads and Its Application in Evaluating Database Schemas

  5. Implementation, Evaluation, and Discussion

    1. Front Matter
      Pages 109-109
    2. Anja Bog
      Pages 111-119
    3. Anja Bog
      Pages 133-138
  6. Back Matter
    Pages 139-164

About this book

Introduction

Systems for Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP) are currently separate. The potential of the latest technologies and changes in operational and analytical applications over the last decade have given rise to the unification of these systems, which can be of benefit for both workloads. Research and industry have reacted and prototypes of hybrid database systems are now appearing.

Benchmarks are the standard method for evaluating, comparing and supporting the development of new database systems. Because of the separation of OLTP and OLAP systems, existing benchmarks are only focused on one or the other. With the rise of hybrid database systems, benchmarks to assess these systems will be needed as well.

Based on the examination of existing benchmarks, a new benchmark for hybrid database systems is introduced in this book. It is furthermore used to determine the effect of adding OLAP to an OLTP workload and is applied to analyze the impact of typically used optimizations in the historically separate OLTP and OLAP domains in mixed-workload scenarios.

Keywords

Analytical Business Processing Benchmarking Database Systems OLAP OLTP Transactional Business Processing

Authors and affiliations

  • Anja Bog
    • 1
  1. 1., Hasso-Plattner-InstituteUniversity of PotsdamPotsdamGermany

Bibliographic information

  • DOI https://doi.org/10.1007/978-3-642-38070-9
  • Copyright Information Springer-Verlag Berlin Heidelberg 2014
  • Publisher Name Springer, Berlin, Heidelberg
  • eBook Packages Business and Economics
  • Print ISBN 978-3-642-38069-3
  • Online ISBN 978-3-642-38070-9
  • Series Print ISSN 2196-8055
  • Series Online ISSN 2196-8063
  • About this book