Explain how the two-phase commit protocol for nested transactions ensures that if the top-level
transaction commits, all the right descendents are committed or aborted.

What will be an ideal response?


Whenever a nested transaction commits, it reports its status and the status of its descendants to its parent.
Therefore when a transaction enters the committed state, it has a correct list of its committed descendants.
Therefore when the top-level transaction starts the two-phase commit protocol, its list of committed
descendants is correct. It checks the descendants and makes sure they can still commit or must abort. There
may be nodes that ran unsuccessful descendants which are not included in the two-phase commit protocol.
These will discover the outcome by querying the top-level transaction.

Computer Science & Information Technology

You might also like to view...

Delia is installing new software on her computer. Delia has read the ____, which specifies the operating system and minimum hardware requirements for the software to run correctly on her computer.

A. setup instructions B. validation codes C. system requirements D. shrink-wrap licenses

Computer Science & Information Technology

Match the following action buttons to the behavior:

I. Beginning II. End III. Home IV. Return V. Forward or Next A. moves to the last slide in a slide show B. moves to the first slide in a slide show C. goes to the last slide viewed D. can be set to go to any slide E. moves to the following slide

Computer Science & Information Technology

In the Camashaly Design database, a one-to-many relationship exists between the Business Analyst table and the Client table.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology

PowerPoint takes less time to insert embedded and linked objects than it takes to perform an ordinary cut-and-paste or copy-and-paste action.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology