'Isn't durability a property of database rather than of transaction?
When people talk about properties of the transaction, people always say the trasaction has four properties, ACID. For durability, a usual explanation is
Durability means that, once a transaction is committed, it will remain in the system – even if there’s a system crash immediately following the transaction.
I'm a bit confused about this. Isn't durability a property of a database? We use database for data durability. Even if I don't use a transaction, such as using a simple UPDATE directly, my change will still be preserved in the DB.
So why do people emphasize the durability as a property of a transaction?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|