Online transactional processing

Back in the day, reads and writes were tied to a commercial transaction. The name stuck as databases expanded, so the term transactional here, refers to groups of reads and writes that form a logical unit. OLTP is row-based.

  • User facing and may see large volumes of requests.
  • Disk seek time is the bottleneck here