Home // DATA ANALYTICS 2020, The Ninth International Conference on Data Analytics // View article

Hybrid Transactional and Analytical Processing Databases: A Systematic Literature Review

Authors:
Daniel Hieber
Gregor Grambow

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

Abstract:
Hybrid Transactional and Analytical Processing databases (HTAP, OLxP) are an emerging sector of databases combining Online Transactional Processing and Online Analytical Processing in the same system. Such databases yield many advantages like the reduction of the total cost of ownership or the elimination of redundant data sets for analytical and live data. Therefore, both Gartner and Forrester Research see disruptive potential in HTAP databases. While following a common goal, the database architectures of HTAP databases are quite diverse. The solutions range from scaled-up single server systems, using Multi Version Concurrency Control to keep their data consistent while at the same time executing thousands of queries, to scaled-out clusters of many servers using last writer wins approaches to allow even faster transactional processing. 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. This paper provides a comprehensive summary of these implementations, giving an overview of the last decade of research on the emerging sector of HTAP databases and discussing fundamental involved technologies.

Pages: 90 to 98

Copyright: Copyright (c) IARIA, 2020

Publication date: October 25, 2020

Published in: conference

ISSN: 2308-4464

ISBN: 978-1-61208-816-7

Location: Nice, France

Dates: from October 25, 2020 to October 29, 2020