Definition: OLTP = Online Transaction Processing, designed for frequent, fast operational transactions such as inserts, updates, and individual lookups.
Examples include orders, payments, account updates, and inventory changes.
Examples:
- PostgreSQL storing online-shop orders.
- MySQL processing bank transactions.
- SQL Server handling employee/customer updates.