What Is a Concurrency Control?
Explore how concurrency control manages simultaneous database operations to protect data integrity. Understand the difference between concurrency and parallelism, the problems of accessing shared data, and foundational strategies like optimistic and pessimistic control, MVCC, and two-phase locking.
We'll cover the following...
Concurrency vs. parallelism
Concurrency is the process of executing more than one task seemingly at the same time. Concurrency increases the application’s throughput by maximizing the utilization of a CPU core. It creates the illusion of parallel execution, but the operating system allocates a slice of the CPU time to the individual tasks, braiding them rather than processing them simultaneously. This braided processing is called context switching. Ultimately, concurrency is about dealing with a lot of ...