A distributed transaction, Database Management System

Assignment Help:

A Distributed Transaction

Let us demonstrate the concept of a distributed transaction by considering a banking system having of three branches located in 3 different cities. Every branch has its own computer with a database having of all the accounts maintained at that branch. Each such installation is therefore a site. There also exists one single site which preserves information about all the other branches of the bank. Assume that the database systems at the several sites are based on the relational model. Every branch preserves its portion of the relation: DEPOSIT (DEPOSIT-BRANCH) where DEPOSIT-BRANCH = (branch-name, customer-name, account-number, balance)

A site having information about the 4 branches maintains the relation branch- details, which has the schema as:

BRANCH-DETAILS (Financial_ health, branch-name, city)

There are other relations maintained at the several sites which are ignored for the purpose of our example.

A local transaction is a transaction that accesses accounts in only one single site, at which the transaction was started. A global transaction, on the other hand, is one which either accesses accounts in a site dissimilar from the one at which the transaction was started, or accesses accounts in various different sites. To demonstrate the difference among these two types of transactions, take the transaction to add Rs.5000 to account number 177 located at the Delhi branch. If the transaction was started at the Delhi branch, then it is considered local; or else, it is considered global. A transaction to transfer Rs.5000 from account 177 to account 305, which is located at the Bombay branch, is a global transaction as accounts in two dissimilar sites are accessed as a result of its implementation. A transaction finding the total financial standing of each branch is global.

What creates the above configuration a distributed database system are the facts that:

  • The several sites may be locally controlled yet are aware of each other.
  • Every site gives an environment for executing both global and local transactions.

Though, a user need not know whether on underlying application is distributed or not.


Related Discussions:- A distributed transaction

Determine the concept of process, Determine the concept of Process Pro...

Determine the concept of Process Process: A process transforms the data values. It is represented as ellipse containing a description of transformation. Each procedure has a

Icloud based storage, Advantages and disadvantages of icloud based storage

Advantages and disadvantages of icloud based storage

Get details of employee working on both comp354 and comp345, Consider the r...

Consider the relations EMPLOYEE(emp#, name) ASSIGNED_TO(project#, emp#) PROJECT(project#, project_name, chief) Express the subsequent queries in Relational Algebra (i) Ge

Designing the database schema , The domain that you will model in this assi...

The domain that you will model in this assignment is that of courses and students at a university. So as not to make the task too large and unspecified, you will here get a descrip

I want to get database of a website, Project Description: I would like t...

Project Description: I would like to get a database of a website which has clients email name and phone number. If you are able to get information from a website, by entering

Explain mechanism of nested queries, Explain mechanism of nested queries? ...

Explain mechanism of nested queries? SQL gives a mechanism for nesting subqueries. A subquery is a select from where expression that is nested within one more query. A common u

Discuss difference between drop table r and delete from r, Discuss The diff...

Discuss The difference between drop table R and delete from R.  DROP TABLE command deletes all the records with the table definition. This command will automatically committed

Define partial key and primary key, Define Partial Key and Primary Key ...

Define Partial Key and Primary Key A partial key, also known as discriminator, is the set of attributes which can uniquely identify weak entities that are related to similar o

Why we use delegation to share implementation, Use Delegation to Share Impl...

Use Delegation to Share Implementation The delegation " Delegation comprises of catching an operation on one object and sending it to other object which is part, or related to

Abap/4 statements to access internal tables without header, What should be ...

What should be declared explicitly in the corresponding ABAP/4 Statements to access internal tables without header lines & why? Work Area. This is needed as the Work Area is

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd