🧭Hybrid Transactional/Analytical Processing (HTAP)
Also known as HTAP, Hybrid Database
One database does both jobs at once. It runs the app and the big reports.
Think of it like
It is like a shop till that can also add up the year. It keeps on selling while it adds.
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.
Definition
Common mistake
Key takeaways
- 1Both jobs. App writes and big reports together.
- 2Two layouts. Rows for writes, columns for reads.
- 3Fresh reports. No nightly copy to wait for.