Locks, MVCC, Isolation Levels, Atomic Updates, Optimistic and Pessimistic Concurrency; the major tools databases use to control concurrent operations.

Managing concurrent operations safely while maintaining performance is a central challenge of database engine design. Database engines achieve this using several core primitives and concurrency contro