OLTP

Learned in SE464.

Online Transaction Processing: the workload most applications run.

• Most applications: e-commerce, banking, Reddit, etc.
• User-facing: must be fast, low-latency, concurrent (many users)
• Tasks: small set of common queries
• Access patterns: random reads, small writes

OLTP services benefit from sharding and read replicas: lots of parallel reads and writes.

Related

• OLAP: the other main DB workload
• Database Sharding
• Read Replicas