Should transactions completed with failures persist in the database?

Navigation
2

When I came across this statement I was confused, could anyone clarify?

  

Question : One of the properties known in relational databases such as ACID is durability, according to which, in a transaction completed with success, any updates made to the database by this transaction should persist.

     
    

(1) Unless other transactions are running at the time of failure.

         

(2) Even in the occurrence of failures in the database system, after the end of the transaction.

  

Is the statement (1) or (2) or both both correct? What would be the justification?

If the (2) statement, performing persistence of failed transactions does not violate the " C " property for consistency?

For more information about the questioning, here the origin of the question.

    
asked by anonymous 10.02.2018 / 17:19

1 answer

1

Durability is a property that must be guaranteed at all times when the transaction is completed no matter what happens outside the transaction. Then D is the correct one.

The transaction only completes itself after it has become durable, that is, persisted. It is obvious that if a problem occurs after all necessary operations are completed and before the durability completes, ACID will not be fulfilled.

But it is questionable how it was put, gives scope for interpretation, it seems that persistence is not part of the transaction.

    
14.02.2018 / 11:38
Close read when clicking next The whole name does not appear