Editing Database (section)

==Transactions and concurrency==
{{Further|Concurrency control}}

[[Database transactions]] can be used to introduce some level of [[fault tolerance]] and [[data integrity]] after recovery from a [[Crash (computing)|crash]]. A database transaction is a unit of work, typically encapsulating a number of operations over a database (e.g., reading a database object, writing, acquiring or releasing a [[Lock (database)|lock]], etc.), an abstraction supported in database and also other systems. Each transaction has well defined boundaries in terms of which program/code executions are included in that transaction (determined by the transaction's programmer via special transaction commands).

The acronym [[ACID]] describes some ideal properties of a database transaction: [[Atomicity (database systems)|atomicity]], [[Consistency (database systems)|consistency]], [[Isolation (database systems)|isolation]], and [[Durability (database systems)|durability]].