In many cases, the type of database you use is not as important as the storage engine that's being employed. The storage engine is the underlying software component that DBMS use to create, read, update and delete (CRUD) data. Most databases support several different types of storage engine...
This means that only a fragment of the update cannot be placed into the database, should a problem occur with either the hardware or the software involved. Features to consider for atomicity:a transaction is a unit of operation - either all the transaction's actions are completed or none ...
Durability.A transaction that is committed is guaranteed to remain committed -- that is, all changes are made permanent and will not be lost if an event such as a power failure should occur. This typically means persisting the changes to nonvolatilestorage. If durability were not guaranteed, ...