• Table of contents

Three major categories of DBMS

⮑ Online transaction processing (OLTP) databases

Optimized for transactional workloads; handles large user-facing requests and transactions.

⮑ Online analytical processing (OLAP) databases

optimized for analytic workloads (complex aggregations); handles complex, long-running ad hoc queries

⮑ Hybrid transactional and analytical processing (HTAP)

Combine properties from OLTP and OLAP stores.

<aside> <img src="/icons/question-mark_yellow.svg" alt="/icons/question-mark_yellow.svg" width="40px" />

Why not use HTAP?

HTAP is a compromise between OLTP and OLAP. It has both things but it's not the best at either of them, it’s a compromise.

</aside>

Database Architecture

Uses a client/server model:

• Client → application accessing the DB.
• Server → database system instances (nodes).