Online Transaction Processing (OLTP)
  • Ex: Airline reservation systems & e-commerce

  • Many concurrent short-lived transactions

  • 24x7

  • Support thousands of concurrent users, efficiently

  • User authentication and authorization

  • Distributed transaction processing

  • Workload balancing

  • Transaction queueing and prioritization

  • Application parallelization

  • ACID (atomic, consistent, isolated, durable) transactions

Notes: