MVCC
E717512
MVCC (Multi-Version Concurrency Control) is a database concurrency control method that allows multiple transactions to access data simultaneously by maintaining multiple versions of records, improving performance and reducing locking conflicts.
All labels observed (1)
| Label | Occurrences |
|---|---|
| MVCC canonical | 1 |
How this entity was disambiguated
This entity first appeared as the object of triple T8151713 — resolving that mention is where its identity was fixed. The disambiguator weighed these candidate entities and picked the highlighted one (or “None”, minting a new entity). This is how homonymy is resolved: the same surface form can point to different entities.
NED1
Entity disambiguation (via context triple)
gpt-5-mini-2025-08-07
Target entity: MVCC Context triple: [Aria, supportsFeature, MVCC]
-
A.
JMM
JMM is the largest annual mathematics conference in the world, jointly organized by major mathematical societies in the United States.
-
B.
Cascade Locks
Cascade Locks is a small city in northern Oregon along the Columbia River Gorge, known as a gateway to outdoor recreation and scenic waterfalls.
-
C.
LSM
LSM is an undergraduate dual-degree program at the University of Pennsylvania that integrates rigorous training in life sciences with business and management education.
-
D.
OMVS
OMVS is the multinational organization responsible for managing and developing the shared water resources and infrastructure of the Senegal River basin.
-
E.
Mdb
Mdb is the official station code used to identify Middelburg railway station in the Netherlands’ rail network.
- F. None of above. chosen
- G. Unsure - the case is ambiguous/there is not enough information to decide.
NED2
Entity disambiguation (via description)
gpt-5-mini-2025-08-07
Target entity: MVCC Target entity description: MVCC (Multi-Version Concurrency Control) is a database concurrency control method that allows multiple transactions to access data simultaneously by maintaining multiple versions of records, improving performance and reducing locking conflicts.
-
A.
JMM
JMM is the largest annual mathematics conference in the world, jointly organized by major mathematical societies in the United States.
-
B.
Cascade Locks
Cascade Locks is a small city in northern Oregon along the Columbia River Gorge, known as a gateway to outdoor recreation and scenic waterfalls.
-
C.
MMCC
MMCC is the ICAO airport code assigned to Piedras Negras International Airport in Coahuila, Mexico.
-
D.
LSM
LSM is an undergraduate dual-degree program at the University of Pennsylvania that integrates rigorous training in life sciences with business and management education.
-
E.
OMVS
OMVS is the multinational organization responsible for managing and developing the shared water resources and infrastructure of the Senegal River basin.
- F. None of above. chosen
Statements (49)
| Predicate | Object |
|---|---|
| instanceOf | database concurrency control method ⓘ |
| abbreviationOf | Multi-Version Concurrency Control ⓘ |
| category |
database technology
ⓘ
transaction management technique ⓘ |
| contrastsWith |
pessimistic locking
ⓘ
two-phase locking ⓘ |
| fullName | Multi-Version Concurrency Control ⓘ |
| hasPurpose |
allow multiple transactions to access data simultaneously
ⓘ
ensure transactional isolation ⓘ improve database performance ⓘ provide high concurrency ⓘ reduce locking conflicts ⓘ |
| implementsConcept |
concurrency control
ⓘ
optimistic concurrency control ⓘ snapshot isolation ⓘ |
| keyIdea |
each transaction sees a consistent snapshot of the database
ⓘ
maintains multiple versions of records ⓘ readers do not block writers ⓘ writers do not block readers in many workloads ⓘ |
| manages |
multiple versions of rows
ⓘ
multiple versions of tuples ⓘ |
| mayCause | write skew anomalies under snapshot isolation ⓘ |
| reduces |
blocking between concurrent transactions
ⓘ
lock contention ⓘ |
| requires |
garbage collection of old versions
ⓘ
vacuuming or cleanup processes ⓘ |
| supports |
ACID transactions
ⓘ
isolation levels ⓘ repeatable read semantics in some systems ⓘ snapshot isolation level ⓘ |
| tradeOff |
increased storage usage for multiple versions
ⓘ
more complex implementation logic ⓘ |
| usedBy |
CockroachDB
ⓘ
CouchDB ⓘ FoundationDB ⓘ Microsoft SQL Server (in snapshot-based features) ⓘ
linked to:
SQL Server
MySQL InnoDB ⓘ
linked to:
InnoDB storage engine
Oracle Database ⓘ PostgreSQL ⓘ SQLite (in WAL and versioned schemes) ⓘ
linked to:
SQLite
TiDB ⓘ |
| usedIn |
NoSQL databases
ⓘ
database management systems ⓘ relational databases ⓘ transaction processing systems ⓘ |
| usesMechanism |
timestamps
ⓘ
transaction IDs ⓘ version numbers ⓘ visibility rules ⓘ |
How these facts were elicited
The pipeline generated the facts above by prompting gpt-5.1 with this entity's name + description and the instruction below.
Instruction
You are a knowledge base construction expert. Given a subject entity and a description of it, return factual statements that you know for the subject as a JSON list of dictionaries(triples), where keys must be "subject", "predicate" and "object". The number of facts may be very high, between 25 to 50 or more, for very popular subjects. For less popular subjects, the number of facts can be very low, like 5 or 10. # Requirements - If you don't know the subject at all, return an empty list. - If the subject is not a named entity, return an empty list. - Include at least one triple where predicate is "instanceOf". - Do not get too wordy. - Separate several objects into multiple triples with one object.
Input
Subject: MVCC Description of subject: MVCC (Multi-Version Concurrency Control) is a database concurrency control method that allows multiple transactions to access data simultaneously by maintaining multiple versions of records, improving performance and reducing locking conflicts.
Referenced by (1)
Full triples — surface form annotated when it differs from this entity's canonical label.