Microsoft SQL Server (with snapshot isolation)
GPTKB entity
Statements (18)
| Predicate | Object |
|---|---|
| gptkbp:instanceOf |
database management system feature
|
| gptkbp:cause |
update conflicts
|
| gptkbp:compatibleWith |
ACID properties
|
| gptkbp:enables |
row versioning
|
| gptkbp:features |
gptkb:Microsoft_SQL_Server
|
| gptkbp:heldBy |
multi-version concurrency control (MVCC)
|
| https://www.w3.org/2000/01/rdf-schema#label |
Microsoft SQL Server (with snapshot isolation)
|
| gptkbp:introducedIn |
gptkb:SQL_Server_2005
|
| gptkbp:isolationLevel |
snapshot
|
| gptkbp:prevention |
non-repeatable reads
phantom reads blocking reads read phenomena such as dirty reads |
| gptkbp:provides |
snapshot isolation
|
| gptkbp:requires |
ALTER DATABASE command to enable
|
| gptkbp:uses |
tempdb for version storage
|
| gptkbp:bfsParent |
gptkb:Multi-Version_Concurrency_Control
|
| gptkbp:bfsLayer |
7
|