Overview
- 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
- Includes supplementary material: sn.pub/extras
Part of the book series: In-Memory Data Management Research (IMDM)
Access this book
Tax calculation will be finalised at checkout
Other ways to access
Table of contents (8 chapters)
-
Background of Transactional and Analytical Systems in Logical Database Design and Benchmarking
-
Towards a Benchmark for Mixed Workloads and Its Application in Evaluating Database Schemas
-
Implementation, Evaluation, and Discussion
Keywords
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.
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)
Authors and Affiliations
About the author
Bibliographic Information
Book Title: Benchmarking Transaction and Analytical Processing Systems
Book Subtitle: The Creation of a Mixed Workload Benchmark and its Application
Authors: Anja Bog
Series Title: In-Memory Data Management Research
DOI: https://doi.org/10.1007/978-3-642-38070-9
Publisher: Springer Berlin, Heidelberg
eBook Packages: Business and Economics, Business and Management (R0)
Copyright Information: Springer-Verlag Berlin Heidelberg 2014
Hardcover ISBN: 978-3-642-38069-3Published: 29 July 2013
Softcover ISBN: 978-3-642-42994-1Published: 08 August 2015
eBook ISBN: 978-3-642-38070-9Published: 11 July 2013
Series ISSN: 2196-8055
Series E-ISSN: 2196-8063
Edition Number: 1
Number of Pages: XIII, 164
Topics: IT in Business, Database Management, Models and Principles, System Performance and Evaluation, Simulation and Modeling