Online transaction processing systems - OLTP
- Low latency
- High responsiveness
- Data integrity
- Predefined UI worflows
- Examples: crm systems, e-commerce sites, e-banking systems
Analysis systems - online analytical processing - OLAP
- Produce complex analytical customizable queries
- Large multidimensional datasets
- Low latency response
- Examples: Business intelligence systems
Batch systems
- Perform operations on large datasets efficiently
- Job execution coordination to maximize CPU utilization
- Auto recover from exceptions
- Examples: Billing systems, provisioning systems
