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

Using sql create a view rs for the relations r and s, Using SQL create a vi...

Using SQL create a view RS for the relations R and S. The view consists of the columns A and D renamed as X and Y in that order. Insert a tuple into it. Show the contents of t

Intersection, If R1 and R2 are two union compatible relations or functions,...

If R1 and R2 are two union compatible relations or functions, then the result of R3 = R1 ∩R2 is the relation that contains all tuples that are in both the relations In other words,

What is relational model feature, What is relational model feature? A r...

What is relational model feature? A relational model feature is much more data independence than some other database models.

What is recursive closure and operation relational algebra, What is recursi...

What is recursive closure? Why is it not possible to describe this operation in relational algebra? Recursive closure is applied to recursive relationship. An instance of rec

Create a company database, Company Database: a-)Here is the ER Model ...

Company Database: a-)Here is the ER Model b-)Here is the Relational Model:     IMPORTANT NOTICE FOR SOLUTION TYPE: ***THIS ASSIGNMENT WILL BE SOLVED BY THE

Relational database, Consider the following relational database: STUDENT (n...

Consider the following relational database: STUDENT (name, student#, class, major) COURSE (course name, course#, credit hours, department) SECTION (section identifier, course#, sem

What are temporary tables, What are temporary tables? Temporary tables...

What are temporary tables? Temporary tables exist solely for a particular session or whose data persists for the duration of the transaction.

ERD, A student entity type has the following attributes,name..

A student entity type has the following attributes,name..

relationship with the owner entity, A database for the Service and Mainten...

A database for the Service and Maintenance (SM) section of a Computer sales and service Company has to be developed. SM gives after sales service to customers. SM branch has a numb

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