Optimistic Locking vs Pessimistic Locking

Choose the appropriate concurrency control pattern based on expected collision frequency.