The consistency and reliability aspects of transactions are due to the "ACIDity" properties of transactions. Discuss each of these properties and how they relate to the concurrency control and recovery mechanisms. Give examples to illustrate your answer.
What will be an ideal response?
Atomicity The ‘all or nothing’ property. It is the responsibility of the recovery subsystem of
the DBMS to ensure atomicity.
Consistency A transaction must transform the database from one consistent state to another
consistent state. It is the responsibility of both the DBMS and the application developers to
ensure consistency.
Isolation Transactions execute independently of one another. In other words, the partial
effects of incomplete transactions should not be visible to other transactions. It is the
responsibility of the concurrency control subsystem to ensure isolation.
Durability The effects of a successfully completed (committed) transaction are permanently
recorded in the database and must not be lost because of a subsequent failure. It is the
responsibility of the recovery subsystem to ensure durability.
You might also like to view...
Pressing the Alt+Tab keyboard shortcut increases the list level in an outline
Indicate whether the statement is true or false
Cost estimates are inherently risky, irrespective of the estimation technique used. Suggest four ways in which the risk in a cost estimate can be reduced.
What will be an ideal response?