Durability

Why Trust Techopedia

What Does Durability Mean?

Durability in databases is the property that ensures transactions are saved permanently and do not accidentally disappear or get erased, even during a database crash. This is usually achieved by saving all transactions to a non-volatile storage medium.

Advertisements

Durability is part of the ACID acronym, which stands for atomicity, consistency, isolation and durability. ACID is a set of properties guaranteeing the reliability of all database transactions.

Techopedia Explains Durability

There are several organizations, such as banks and hospitals, whose very existence depends on the information systems run on databases. The ability to recover 100% of all committed transactions is absolutely crucial. The recovery rate must be 100 percent, not 90 percent or even 99.6 percent. In addition, this recovery must be permanent, meaning all transactions must be reconstructed, even if the database server crashes due to OS failure or power loss.

You can immediately see why durability, as part of ACID, is a holy grail for designers of relational database systems. ACID, a term popularized by by Theo Harder and Andreas Reuter in their 1983 article “Principles of Transaction-Oriented Database Recovery”, is the set of qualities that, when properly implemented, will always guarantee the reliable processing, handling and storage of all database transactions.

Durability in modern relational database systems is usually achieved by means of transaction logs- recyclable files – files used to store all database transactions in a session. Once a user issues a commit command, then the transaction is first written to the database files stored on a non-volatile medium such as a hard disk, which is done before confirming to the user that the save has occurred. If a database crashes before the save, the data is still on the transaction logs the next time the database is restarted, but any uncommitted changes are undone or rolled back. In distributed computing where servers are geographically dispersed, this guarantee is difficult or tricky to implement, so the same is achieved by use of the two-phase commit.

Advertisements

Related Terms

Margaret Rouse
Technology Expert
Margaret Rouse
Technology Expert

Margaret is an award-winning technical writer and teacher known for her ability to explain complex technical subjects to a non-technical business audience. Over the past twenty years, her IT definitions have been published by Que in an encyclopedia of technology terms and cited in articles by the New York Times, Time Magazine, USA Today, ZDNet, PC Magazine, and Discovery Magazine. She joined Techopedia in 2011. Margaret's idea of a fun day is helping IT and business professionals learn to speak each other’s highly specialized languages.