MVCC
Technology & Computing abbreviation · Data & Database
| Stands for | Multiversion concurrency control |
|---|---|
| Categories | Technology & Computing |
MVCC stands for Multiversion concurrency control, a data & database abbreviation.
A concurrency method in which a database keeps several versions of each row, so readers see a consistent snapshot while writers create new versions, and reads and writes rarely block each other. PostgreSQL, Oracle and MySQL's InnoDB engine use it.
Example: Thanks to MVCC, the long report query doesn't block the checkout transactions.
Usage notes
Described in academic work around 1980 and commercialized early in DEC's Rdb/VMS and InterBase. Old row versions must be cleaned up, which in PostgreSQL is the job of VACUUM. Snapshot isolation built on MVCC can still allow some anomalies, such as write skew.
Related abbreviations
More data & database abbreviations
- HDFS – Hadoop Distributed File System
- JDBC – Java Database Connectivity
- KV – Key-value (store)
- MDM – Master data management
- MPP – Massively parallel processing
- MSSQL – Microsoft SQL Server
- ODBC – Open Database Connectivity
- ODS – Operational data store
- OLAP – Online analytical processing
- OLTP – Online transaction processing
- PK – Primary key
- PL/SQL – Procedural Language/SQL