# Hybrid Transactional/Analytical Processing (HTAP)

> One database does both jobs at once. It runs the app and the big reports.

**Field:** Data Engineering  
**Category:** Foundations  
**Also known as:** HTAP, Hybrid Database

## Think of it like

It is like a shop till that can also add up the year. It keeps on selling while it adds.

## Definition

HTAP is one system that does both OLTP and OLAP work. It takes small, fast writes from an app. At the same time it runs big reports on the same data. Many HTAP systems keep a row copy for writes and a column copy for reports. The gain is reports on data that is seconds old, with no pipeline between.

## Example

TiDB keeps rows in TiKV for the app and a column copy in TiFlash for reports. A report can see an order placed a moment ago.

## Why it matters

It can remove the copy step between the app and the warehouse. Fewer pipelines means fewer things to break.

## Common mistake

Thinking it can take the place of a warehouse. Data from many apps still has to be joined somewhere.

## Three principles

- **Both jobs.** App writes and big reports together.
- **Two layouts.** Rows for writes, columns for reads.
- **Fresh reports.** No nightly copy to wait for.

## Related terms

- [Online Transaction Processing (OLTP)](https://learn.benibix.com/term/data/oltp)
- [Online Analytical Processing (OLAP)](https://learn.benibix.com/term/data/olap)
- [Data Pipeline](https://learn.benibix.com/term/data/data-pipeline)

## Taught in

- [OLTP, OLAP and HTAP](https://learn.benibix.com/learn/data-foundations/oltp-olap-and-htap): Data Engineering Basics, 11/11

---

Source: https://learn.benibix.com/term/data/htap
Author: Behnia Zarei (a developer in Vienna, Austria, who builds and teaches data, AI and business intelligence at BENIBIX)
Publisher: BENIBIX Learn (https://learn.benibix.com/)
Last updated: 2026-11-20
Licence: CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/). Quote freely with attribution.
