ACID properties:

A: A transaction should either be performed in its entirety or not performed at all.

C: A transaction transforms a database state from a consistent state to another consistent state.

I: A transaction, though may execute concurrently, should appear as though it is executed in isolation from other transactions.

D: A committed transaction has a permanent impact on the database. The changes must be kept in case of any failure.

V and K look together for new hardware and find on the site MiBuy.com a great combo for the well-known tablet Pad351 together with a matching keyboard Key751. V successfully purchases one combo Pad351 plus Key751. K tries to buy another combo, but while waiting for confirmation, the website MiBuy.com crashes. When MiBuy.com comes online again, V’s order has disappeared in the system, and K has an order only for a Key751, without matching Pad351, in the system.

For each of the 4 ACID properties:

Say in no more than 3 sentences (for each property) whether MiBuy.com the system clearly violated this ACID property and give a reason for your answer.



Source link

Leave a Reply

Your email address will not be published. Required fields are marked *