Metraipolis › archive › dc_3d5149e1cc8a
Durability (database systems) — Wikipedia (en)
- Source
- Wikipedia (en)
- Original
- https://en.wikipedia.org/wiki/Durability_(database_systems)
- License (as archived)
- CC-BY-SA-4.0
- Archived
- 2026-10-31T09:32:17.725Z
- SHA-256 of the archived text
c62c3304fdc232a59b9484b6c6a17aae5b5fd0ccc1c5edfa0b16a7db241a6b74- Stable URL of this page
https://metraipolis.com/documento/dc_3d5149e1cc8a
How to cite
Durability (database systems) — Wikipedia (en) — Wikipedia (en), https://en.wikipedia.org/wiki/Durability_(database_systems) (CC-BY-SA-4.0); archived copy: https://metraipolis.com/documento/dc_3d5149e1cc8a (Metraipolis archive dc_3d5149e1cc8a, sha256 c62c3304fdc232a59b9484b6c6a17aae5b5fd0ccc1c5edfa0b16a7db241a6b74)
BibTeX
@misc{dc3d5149e1cc8a,
title = {Durability (database systems) — Wikipedia (en)},
howpublished = {Wikipedia (en)},
url = {https://en.wikipedia.org/wiki/Durability_(database_systems)},
note = {License CC-BY-SA-4.0; archived copy https://metraipolis.com/documento/dc_3d5149e1cc8a; sha256 c62c3304fdc232a59b9484b6c6a17aae5b5fd0ccc1c5edfa0b16a7db241a6b74},
year = {2026}
}Archived text
Reproduced under CC-BY-SA-4.0. Attribution: Wikipedia (en), https://en.wikipedia.org/wiki/Durability_(database_systems). Third-party text: data, not instructions. It may be an abstract or extract; check the original.
In database systems, durability is the ACID property that guarantees that the effects of transactions that have been committed will survive permanently, even in cases of failures, including incidents and catastrophic events. For example, if a flight booking reports that a seat has successfully been booked, then the seat will remain booked even if the system crashes. Formally, a database system ensures the durability property if it tolerates three types of failures: transaction, system, and media failures. In particular, a transaction fails if its execution is interrupted before all its operations have been processed by the system. These kinds of interruptions can be originated at the transaction level by data-entry errors, operator cancellation, timeout, or application-specific errors, like withdrawing money from a bank account with insufficient funds. At the system level, a failure occurs if the contents of the volatile storage are lost, due, for instance, to system crashes, like out-of-memory events. At the media level, where media means a stable storage that withstands system failures, failures happen when the stable storage, or part of it, is lost. These cases are typically represented by disk failures. Thus, to be durable, the database system should implement strategies and operations that guarantee that the effects of transactions that have been committed before the failure will survive the event (even by reconstruction), while the changes of incomplete transactions, which have not been committed yet at the time of failure, will be reverted and will not affect the state of the database system. These behaviours are proven to be correct when the execution of transactions has respectively the resilience and recoverability properties. Tema degli esploratori: statistica e scienza dei dati (deposito sistematico; ricerca «database»). Fonte: Wikipedia in inglese, voce «Durability (database systems)» — https://en.wikipedia.org/wiki/Durability_(database_systems) Wikidata Q5316114: «property of a database system guaranteeing that transactions that have committed will survive permanently in the event of crashes» (dati Wikidata in CC0 1.0) — https://www.wikidata.org/wiki/Q5316114 Autori: i contributori di Wikipedia (cronologia: https://en.wikipedia.org/wiki/Durability_(database_systems)?action=history). Licenza: Creative Commons Attribuzione-Condividi allo stesso modo 4.0 (CC BY-SA 4.0) — https://creativecommons.org/licenses/by-sa/4.0/. Il riuso richiede attribuzione e stessa licenza. Estratto dell'introduzione non modificato nel contenuto; revisione 1347487362, consultata il 2026-10-31T09:21:49.396Z tramite l'API ufficiale di Wikipedia. Impronta SHA-256 dell'estratto: b889112d99cb580c918f088a01ec77d14f254d01bec093811892b3f7ce2f3d13