Multi-Version Concurrency Control (MVCC)

Multi-Version Concurrency Control (MVCC) is a database management technique that allows multiple users to access and modify data simultaneously without conflicts. It achieves this by keeping multiple versions of data items. When a user reads data, they see the version that existed at the start of their transaction, ensuring consistency. If another user updates the data, they create a new version rather than altering the existing one. This way, transactions can occur concurrently, improving performance while maintaining the integrity and accuracy of the data. MVCC is commonly used in systems like PostgreSQL and Oracle.