Transaktionen (EN)

Concept

Group of database operations treated as a single unit

Transaction lifecycle

stateDiagram-v2     [*] --> Begin     Begin --> InProgress : BEGIN     InProgress --> Commit : Operations     InProgress --> Rollback : Error     Commit --> [*] : COMMIT     Rollback --> [*] : ROLLBACK

ACID properties

  • Atomicity: A transaction is either fully executed or not at all.
  • Consistency: A transaction moves the database from one consistent state to another consistent state.
  • Isolation: Concurrent transactions do not affect each other.
  • Durability: After a transaction is completed, the changes are preserved even in case of system failure.
Quelle: AI Generated