Data Systems
serial execution / 2PL / SSI
one thread / locks (pessimistic) / detect-at-commit (optimistic)
Source board
This definition comes from the board below. Open it to see the term in context.
TransactionsData SystemsMore terms from this board
- abortroll back
- ACIDatomicity/consistency/isolation/durability
- BASEthe vague 'eventually consistent' opposite
- compare-and-set (CAS)write only if unchanged
- deadlockmutual lock-wait
- dirty read/writeseeing/overwriting uncommitted data
- lost updateone write clobbers another
- phantoma write changes another query's result
- predicate locka lock on a search condition
- read committedno dirty reads/writes
- read skewinconsistent multi-read
- serializabilityas-if one-at-a-time
- snapshot isolationread a consistent point-in-time (MVCC)
- transactiona group of ops that commit/abort together
- write skewread-same/write-different breaks an invariant