
As an Amazon Associate and affiliate partner, Menrva Books earns from qualifying purchases. Learn more
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.
The separation of transactional and analytical database systems is being challenged by the emergence of hybrid systems, necessitating new methods for their evaluation. This book addresses the need for benchmarks that can assess these new hybrid database systems, which combine Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP) workloads. It examines existing benchmarks, which are typically focused on only one type of workload, and introduces a novel benchmark designed specifically for hybrid systems. The research further investigates the effects of integrating OLAP operations into an OLTP environment and analyzes the impact of common optimizations in mixed-workload scenarios.
This book is a technical examination of database system benchmarking, likely aimed at researchers and professionals in the field of database management and data analytics. The author's focus on developing and applying a new benchmark for hybrid systems suggests a contribution to the ongoing evolution of database technology. The detailed analysis of mixed-workload scenarios and optimization impacts indicates a rigorous, data-driven approach to understanding system performance.
Page Count:
164
Publication Date:
2013-07-11
Publisher:
Springer Nature
ISBN-10:
3642380700
ISBN-13:
9783642380709
No comments yet. Be the first to share your thoughts!