Home // International Journal On Advances in Software, volume 15, numbers 1 and 2, 2022 // View article

Hybrid Transactional and Analytical Processing Databases - State of Research and Production Usage

Authors:
Daniel Hieber
Gregor Grambow

Keywords: Hybrid Transactional Analytical Processing; HTAP; Database; Literature Study; OLxP

Abstract:
The combination of Online Transactional Processing and Online Analytical Processing into one system is an emerging area in database research called Hybrid Transactional and Analytical Processing databases (HTAP, OLxP). Both Gartner and Forrester Research see disruptive potential in this technology as it provides important advantages. These include the elimination of redundant data sets for analytical and live data as well as the reduction of the total cost of ownership of analytics systems. The development of HTAP databases resulted in various advances in the database sector like the creation of new index and data structures or improvements of existing concurrency control implementations. However, there is a great variety regarding many architectural aspects in different HTAP systems. Examples include implementations of concurrency control, query handling, or scaling paradigms ranging from scaled-up single server systems using Multi Version Concurrency Control to scaledout cluster based systems using last writer wins approaches. This contribution provides a general overview of contemporary HTAP implementations. On the one hand, different fundamental technical aspects are presented and compared in detail. On the other, it goes beyond a standard literature review by also presenting an overview of production ready HTAP systems, including both free and commercial systems.

Pages: 14 to 27

Copyright: Copyright (c) to authors, 2022. Used with permission.

Publication date: June 30, 2022

Published in: journal

ISSN: 1942-2628