Junior — Middle
Can you explain the meaning of property D (Durability) in ACID transaction principles?
sobes.tech AI
Answer from AI
The Durability property in ACID guarantees that after a transaction successfully completes, its changes will be permanently saved in the database, even if a system failure, power outage, or other emergency occurs. This means that data will not be lost and will be available upon the next startup.
For example, when you make a bank transfer, after confirming the operation, the money is debited and this information is stored so that even if the server crashes, it will not disappear.
Technically, this is achieved through transaction logs, which are written to persistent storage before the changes are committed.