# Online Transaction Processing (OLTP)

> Many small, fast reads and writes. It is the work behind an app.

**Field:** Data Engineering  
**Category:** Foundations  
**Also known as:** OLTP, Transactional Database

## Think of it like

It is like a shop till. It rings up one sale at a time, very fast, all day long.

## Definition

OLTP is the kind of work an app's database does all day. It runs many small reads and writes, each touching just a few rows. Placing an order or changing a password are OLTP tasks. Each one must be quick and must not get lost. These databases usually store data row by row.

## Example

When Lucy buys shoes online, the app writes one order row and lowers the stock by one. Both happen in a few milliseconds.

## Why it matters

It keeps the business running. If it slows down, customers wait at the checkout.

## Common mistake

Running big reports on the same database. One long report can slow down every checkout.

## Three principles

- **Small and many.** Each task touches a few rows.
- **Fast and safe.** Transactions must finish and not get lost.
- **Row by row.** Data is stored a row at a time.

## Related terms

- [Online Analytical Processing (OLAP)](https://learn.benibix.com/term/data/olap)
- [Hybrid Transactional/Analytical Processing (HTAP)](https://learn.benibix.com/term/data/htap)
- [Database Transaction](https://learn.benibix.com/term/development/transaction)
- [Atomicity, Consistency, Isolation, Durability (ACID)](https://learn.benibix.com/term/development/acid)

## Told apart from

- [OLTP vs OLAP](https://learn.benibix.com/compare/oltp-vs-olap): People think OLTP and OLAP are two brands of database. They are two kinds of work. OLTP is many tiny reads and writes, such as placing an order. OLAP is a few huge queries that add up millions of rows, such as sales by month. A system built for one is slow at the other.

## 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/oltp
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.
