Database
288 views
Transaction
Quick Definition
Single unit of work that succeeds or fails completely
Full Definition
A sequence of database operations treated as a single unit that succeeds or fails completely.
Examples
BEGIN, COMMIT, ROLLBACK, isolation levels, savepoints
Related Terms
acid
concurrency-control
More Database Terms
Referential Integrity
Constraint ensuring table relationships remain consistent
Partitioning
Dividing tables into smaller pieces for better performance
Foreign Key
Field referencing primary key to establish table relationships
SQL
Standard language for managing and querying databases
Database Migration
Version-controlled changes to database schema
Write Ahead Log
Persistence mechanism writing changes to log before database