🧭Online Transaction Processing (OLTP)
Also known as OLTP, Transactional Database
Many small, fast reads and writes. It is the work behind an app.
Think of it like
It is like a shop till. It rings up one sale at a time, very fast, all day long.
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.
Definition
Common mistake
Key takeaways
- 1Small and many. Each task touches a few rows.
- 2Fast and safe. Transactions must finish and not get lost.
- 3Row by row. Data is stored a row at a time.