Which property of the ACID acronym ensures that a transaction, once committed, remains intact even in the event of a system failure?

The correct answer is Durability.

Key Points

• Durability is a key property of the ACID (Atomicity, Consistency, Isolation, Durability) acronym in database systems.
• This property ensures that once a transaction is committed, its changes are permanently recorded in the database, even in the event of system failures such as power outages or crashes.
• Durability is achieved by writing transaction data to non-volatile storage, such as a hard disk or SSD, ensuring that the data remains intact.
• For example, in banking systems, when a customer transfers money between accounts and the transaction is committed, the changes are durable, meaning they will persist regardless of system failures.
• Durability provides reliability and trustworthiness in database operations, ensuring data integrity over time.

Additional Information

• Durability often relies on mechanisms like write-ahead logging (WAL) or transaction logs, which ensure that committed transactions are stored before the system updates the database.
• Databases implement durability using techniques such as redundant storage and backups to protect against data loss.
• In distributed systems, durability may involve replication across multiple nodes to ensure data availability in case of hardware failure.
• Durability is a critical component for applications that require high reliability, such as financial systems, inventory management, and e-commerce platforms.