Explain about MVCC

Question

Explain about MVCC

Accepted Answer

MVCC stands for Multi-Version Concurrency Control, a technique used in database management systems to allow multiple transactions to access the same data simultaneously.

MVCC is used to maintain data consistency and prevent conflicts between transactions.
It works by creating multiple versions of a data item, each with a timestamp indicating when it was created.
When a transaction reads a data item, it sees the version with the latest timestamp that is earlier than the transaction's start time.
When a transaction updates a data item, it creates a new version with a new timestamp.
MVCC is used in popular database systems like PostgreSQL and Oracle.
MVCC allows for high concurrency and scalability in database systems.

Explain about MVCC

Popular interview questions of Database Administrator DBA