A distributed transaction consists of subtransactions that execute at different sites and access local DBMSs at those sites. For example, a distributed transaction that transfers money from a bank account at site A to a bank account at site B executes a subtransaction at A that does the withdrawal and then a subtransaction at B that does the deposit.

Such a distributed transaction must satisfy the ACID properties in a global sense: it must be globally atomic, isolated, consistent, and durable. The issue is, if the subtransactions at each site individually satisfy the ACID properties, does the distributed transaction necessarily satisfy the ACID properties? Certainly if the subtransactions at each site are individually durable, the distributed transaction is durable. Give examples of situations in which

(a)   The subtransactions at each site are atomic, but the distributed transaction is not atomic.

(b)   The subtransactions at each site are consistent, but the distributed transaction is not consistent.

(c)    The subtransactions at each site are isolated, but the distributed transaction is not isolated.

 

 

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

Ask an Expert

Related Discussions:- Distributed transaction atomic-consistent-isolated, Assignment Help, Ask Question on Distributed transaction atomic-consistent-isolated, Get Answer, Expert's Help, Distributed transaction atomic-consistent-isolated Discussions

Write discussion on Distributed transaction atomic-consistent-isolated
Your posts are moderated

Write your message here..

Related Questions

What is database trigger, What is database Trigger? A database trigger ... What is database Trigger? A database trigger is a PL/SQL block that can explained to automatically execute for insert, update, and delete statements against a table. The trigge

Computing the closure of a set of functional dependency, What is meant by c... What is meant by computing the closure of a set of functional dependency? The closure of F denoted by F + is the set of functional dependencies logically implied by F.

Why do so various organizations use mysql, Why do so various organizations ... Why do so various organizations use MySQL? Advantages: Open source Highly efficient Offers a high scalability in terms of size and connectivity. Highly prote

Define the concept of design documentation, Design Documentation  The ... Design Documentation  The Design Document shall be an extension of Requirements Analysis Design. "The Design Document will comprise a revised and much more detailed descrip

Explain the functions trim-length-count in oracle, Explain the following fu... Explain the following functions of Oracle with suitable examples: (i) To_Char( ) (ii) Count( ) (iii) Trim( ) (iv) Length( ) Ans: (i) To_char( ): The TO_CHAR function conver

Atomicity-transaction , Atomicity: It describes a transaction to be a one ... Atomicity: It describes a transaction to be a one unit of processing. We can also say either a transaction will be finished completely or not at all. In the transaction example 1

Describe difference between a one-to-many and a many-to-many, Describe the ... Describe the difference between a one-to-many and a many-to-many relationship. Which logical data structures comprise one-to-many and which comprise many-to-many relationship?

Concatenation operator-data manipulation language, Concatenation operator ... Concatenation operator Example : Printing name and job as one string as column name employees: SELECT ENAME||JOB "EMPLOYEES" FROM EMP;

Difference between functions along with or without grouping, Explain the di... Explain the difference between using functions along with and without grouping attributes in relational algebra. Give examples. Ans: Group functions are used to group data of

Who will teach, Do you have experts of the dbms Do you have experts of the dbms