HTAP Workloads: Challenges and Solutions

In this talk, we consider challenges posed to modern DMBS by so-called HTAP workloads. HTAP (Hybrid Transactional & Analytical Processing) combines:

1. Fast OLTP-style requests that should be executed with maximal throughput and reasonably low latency.
2. OLAP-style analytical queries that require reading a lot of rows to be executed.

As a solution to this question, we consider several approaches: persistent-parallel trees, fork+COW approach (from HyPer), MVCC, and HTAP-aware LSM tree (from LASER).