Transaction states, Database Management System

The following variant of the primary copy asynchronous-update replication protocol has been proposed for totally replicated systems.

(a)  A transaction executing at site A updates only the replicas at A before it commits (it needed to access no other site since replication is total).

(b)  After the transaction commits, a second transaction is initiated to update the primary copies of all items updated at A.

(c)  After the transaction in step (b) has completed, each primary site propagates the update made at that site to all secondaries (including the one at site A). Updates made to a primary copy by several transactions are propagated to secondaries in the order in which the primary was updated.

Explain why, in step (b), all primaries must be updated in a single transaction and, in step (c), the update is propagated to site A.

 

Posted Date: 3/11/2013 1:18:10 AM | Location : United States







Related Discussions:- Transaction states, Assignment Help, Ask Question on Transaction states, Get Answer, Expert's Help, Transaction states Discussions

Write discussion on Transaction states
Your posts are moderated
Related Questions
What is Collation Collation is a kind of sort order. There are majorly 3 types of sort orders, namely: i.) Dictionary case insensitive ii.)Dictionary - case sensitive

create an e-r diagram usuing graphical dipicted software that could theoritically be used in resturant application

I want an iPad app that is a simple 1 page form to complete with text. The Objective is to allow a few dozen people of the same organization (they're all on iPad) to open the app,

Two-way Associations Mostly, associations are travel in both directions, although not usually with same frequency. There are three approaches for the implementation. In

write a short note on participation role? Participation role: roles are indicating in E-R diagram by labelling the lines that connect diamonds to rectangles.


Northwind Pty Ltd sells a variety of food products throughout the world. They want to use the reporting features of SAP''s Business Information Warehouse to better understand thei

intent locking

For Colorado customers calculate the number of single products ordered. If a product is purchased on multiple orders, it should be counted only single time. The result should conta

Demonstrate the Design of associations During object design phase we must design a strategy to implement associations. Association may be unidirectional or bi-directional. Wha