Passer au contenu

Transactions and concurrency

Introduit
Fiche de cours
Vocabulaire
English Sens
transaction/trænˈsækʃn/A group of database operations treated as one unit with defined commit or rollback behaviour.
atomicityThe transaction property that its changes take effect together or are rolled back together.
consistencyThe requirement that a correctly defined transaction preserves database constraints.
isolation/ˌaɪsəˈleɪʃn/The degree to which concurrent transactions are protected from one another's intermediate effects.
durabilityThe guarantee that committed changes survive the failures covered by the database's recovery model.
serializabilityEquivalence of a concurrent transaction schedule to some serial schedule under the chosen equivalence criterion.
two-phase lockingA locking protocol that permits no new lock acquisition after the first lock release.
isolation levelsSpecified concurrency guarantees defining which transaction anomalies are prevented or allowed.

Fiche de cours

Se connecter ou créer un compte

IGCSE, A-Level & AP