Optimistic versus pessimistic concurrency control mechanisms in database management systems