Multi-Version Concurrency Control
GPTKB entity
Statements (38)
| Predicate | Object |
|---|---|
| gptkbp:instanceOf |
database concurrency control method
|
| gptkbp:abbreviation |
MVCC
|
| gptkbp:advantage |
garbage collection needed for old versions
high read throughput increased storage requirements |
| gptkbp:category |
computer science
transaction processing database management |
| gptkbp:feature |
readers do not block writers
stores multiple versions of data writers do not block readers |
| gptkbp:handles |
concurrent transactions
|
| https://www.w3.org/2000/01/rdf-schema#label |
Multi-Version Concurrency Control
|
| gptkbp:introduced |
gptkb:Philip_A._Bernstein
|
| gptkbp:introducedIn |
1970s
|
| gptkbp:mechanismOfAction |
assigns transaction timestamps
creates new data versions on write old versions retained for active transactions |
| gptkbp:prevention |
dirty reads
non-repeatable reads phantom reads |
| gptkbp:purpose |
avoid locking
increase concurrency provide snapshot isolation |
| gptkbp:relatedTo |
optimistic concurrency control
serializability pessimistic concurrency control snapshot isolation |
| gptkbp:usedBy |
gptkb:CouchDB
gptkb:Oracle_Database gptkb:MongoDB gptkb:PostgreSQL gptkb:Microsoft_SQL_Server_(with_snapshot_isolation) gptkb:MySQL_(InnoDB) |
| gptkbp:usedIn |
NoSQL databases
relational databases |
| gptkbp:bfsParent |
gptkb:CouchDB
|
| gptkbp:bfsLayer |
6
|