| Creators: |
Hieber, Daniel and Grambow, Gregor |
| Title: |
Hybrid Transactional and Analytical Processing Databases-State of Research and Production Usage |
| Item Type: |
Article or issue of a publication series |
| Journal or Series Title: |
International Journal on Advances in Software |
| Page Range: |
pp. 14-27 |
| Date: |
2022 |
| Divisions: |
Gesundheitsmanagement |
| Abstract (ENG): |
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 scaled-out 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. |
| Forthcoming: |
No |
| Language: |
English |
| Citation: |
Hieber, Daniel and Grambow, Gregor
(2022)
Hybrid Transactional and Analytical Processing Databases-State of Research and Production Usage.
International Journal on Advances in Software, 15 (1&2).
pp. 14-27.
ISSN 1942-2628
|
