BIT 3201A Distributed Databases Assignment

Assignment Help Database Management System

Reference no: EM132467698 , Length: 4 pages

BIT 3201A Distributed Databases

Question 1

Qa) Why the top three layers in the reference architecture for distributed database systems are often referred to as site-independent schemas? Define physical image of a global relation at a site.

Qb) Comment on the different types of dependency for the bottom layers in the reference architecture of DDBMS. Explain the role of local mapping schema towards the integration of heterogeneous multi-site databases in this context.

Question 2)

Qa) Differentiate between transaction recovery and crash recovery.
Qb) Briefly explain the objectives of distributed transaction management.

Question 3)
a) Write down the responsibilities of transaction manager and transaction coordinator.
b) Define distributed serializability. How is it ensured in a DDBMS?

Question 4)
a) Compare and contrast Pessimistic and Optimistic Concurrency Control techniques.
b) Describe quorum-based protocol for distributed concurrency control.

Question 5) Discuss how distributed systems are used in organizations.

Question 6) Discuss the techniques used to facilitate distributed query processing and Optimization.

Reference no: EM132467698

Questions Cloud

Prepare journal entries to record each of partner investment : Prepare the journal entries to record each of the partners' investments. Hassan, Ali, and Reem are forming a partnership. Hassan is transferring $50,000

Describe types of life forms : Describe three types of life forms that have been discovered on Earth that could survive in the conditions on that planet or moon

Prepare the adjusting entry at the end of warranty contract : Prepare the adjusting entry at the end of warranty contract. Prepare the adjusting entry at December 31 to accrue the estimated warranty cost.

Prepare adjusting entry at december to accrue estimate cost : Prepare the adjusting entry at December 31 to accrue the estimated warranty cost.In 2015 warranty contract honored in 50 units, prepare the journal entry.

BIT 3201A Distributed Databases Assignment : BIT 3201A Distributed Databases Assignment Help and Solution - Differentiate between transaction recovery and crash recovery and Briefly explain the objective

How much will mortgage payments increase : How much would his monthly repayments to the credit card company be if he intended to pay out the debt over five years?By how much will his mortgage payments

What will be maximum amount in market interest rate : What will be the maximum amount he/she is willing to pay for it if the market interest rate (i.e. the best alternative rate of return the investor can get) is 8

Calculate the amount of uncollectible account expense : Prepare one bank reconciliation statement for Dewey Company as at 30 November 2019. Calculate the amount of uncollectible account expense

Determine accumulated depreciation and printing press : Prepare a table to show year (1, 2, 3. . .]I, deprecia?on expense, accumulated depreciation and book value of the printing press.

User Account

All Pages