For homonymous articles, see durability (disambiguation).
In the context of databases, sustainability is the property that ensures that a confirmed IT transaction survives permanently, regardless of the problems encountered by the database or IT system where this transaction occurs. has been treated. For example, in an airline seat reservation system, durability ensures that a confirmed reservation will remain recorded regardless of the problems encountered by the computer that manages the booking system (power failure, head crush) on the hard disk, etc.).
Sustainability is one of four ACID properties that ensure that a computer transaction is executed reliably.
Several database management systems implement sustainability by writing transactions on a transaction log that can be used to recreate the database in the state it was in immediately before a failure. A transaction is confirmed only after it has been posted to the transaction log.
In the case of distributed transactions, all the servers involved must coordinate to issue a confirmation only when the transaction is permanently registered on all servers. This is usually done using a two-phase commit protocol. Sourcemode the code
wiki
