In-Memory Data Management Research

Benchmarking Transaction and Analytical Processing Systems

The Creation of a Mixed Workload Benchmark and its Application

Authors: Bog, Anja

  • ​This book introduces the first realistic benchmark that can be used by companies to evaluate hybrid OLTP and OLAP systems
  • A detailed description of database models helps the reader to understand the challenge of reuniting OLTP and OLAP
  • The reader is introduced into the scientific world of benchmarking hybrid OLTP and OLAP database systems
see more benefits

Buy this book

eBook $99.00
price for USA (gross)
  • ISBN 978-3-642-38070-9
  • Digitally watermarked, DRM-free
  • Included format: EPUB, PDF
  • ebooks can be used on all reading devices
  • Immediate eBook download after purchase
Hardcover $139.00
price for USA
  • ISBN 978-3-642-38069-3
  • Free shipping for individuals worldwide
  • Usually dispatched within 3 to 5 business days.
Softcover $139.00
price for USA
  • ISBN 978-3-642-42994-1
  • Free shipping for individuals worldwide
  • Usually dispatched within 3 to 5 business days.
About this book

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.

About the authors

Anja Bog is a PhD candidate and research assistant at the research group "Enterprise Platform and Integration Concepts" of Prof. Dr. h.c. Hasso Plattner, Hasso Plattner Institute, Potsdam, Germany. Her special interests lie in the data management systems underneath operational and analytical business applications, and in the question of validating the integrated data management of both domains. Anja Bog holds a Master of Science with Distinction in IT Systems Engineering from the Hasso Plattner Institute at the University of Potsdam.

Reviews

From the reviews:

“In this book, the author proposes to combine OLTP and OLAP systems to achieve enhanced efficiency and reduced cost, and introduces a benchmark to study the performance of such systems under different workload conditions. … I recommend this book to professionals handling online data processing services and applications, and researchers who are working toward enhancing existing online data processing systems and benchmarks.” (Rinki Sharma, Computing Reviews, December, 2013)


Table of contents (8 chapters)

  • Introduction

    Bog, Anja

    Pages 1-12

  • Enterprise Data Management for Transaction and Analytical Processing

    Bog, Anja

    Pages 15-43

  • Benchmarks for Transaction and Analytical Processing Systems

    Bog, Anja

    Pages 45-62

  • Combined Transaction Processing and Reporting Benchmark

    Bog, Anja

    Pages 65-91

  • Database Schema Variants for Mixed OLTP and OLAP

    Bog, Anja

    Pages 93-107

Buy this book

eBook $99.00
price for USA (gross)
  • ISBN 978-3-642-38070-9
  • Digitally watermarked, DRM-free
  • Included format: EPUB, PDF
  • ebooks can be used on all reading devices
  • Immediate eBook download after purchase
Hardcover $139.00
price for USA
  • ISBN 978-3-642-38069-3
  • Free shipping for individuals worldwide
  • Usually dispatched within 3 to 5 business days.
Softcover $139.00
price for USA
  • ISBN 978-3-642-42994-1
  • Free shipping for individuals worldwide
  • Usually dispatched within 3 to 5 business days.
Loading...

Recommended for you

Loading...

Bibliographic Information

Bibliographic Information
Book Title
Benchmarking Transaction and Analytical Processing Systems
Book Subtitle
The Creation of a Mixed Workload Benchmark and its Application
Authors
Series Title
In-Memory Data Management Research
Copyright
2014
Publisher
Springer-Verlag Berlin Heidelberg
Copyright Holder
Springer-Verlag Berlin Heidelberg
eBook ISBN
978-3-642-38070-9
DOI
10.1007/978-3-642-38070-9
Hardcover ISBN
978-3-642-38069-3
Softcover ISBN
978-3-642-42994-1
Series ISSN
2196-8055
Edition Number
1
Number of Pages
XIII, 164
Topics