OLTP

Online Transaction Processing

Operational workload pattern -- many small fast transactions.

When you'd see it: System architecture, paired with OLAP. Your application's main database is an OLTP system.

Why it matters: OLTP handles the many small, fast reads and writes that run an application, like placing a single order. It is optimized for transaction speed and integrity, not for analysis.