Question Paper: Distributed Databases Question Paper - Dec 16 - Computer Engineering (Semester 6) - Mumbai University (MU)
Distributed Databases - Dec 16
Computer Engineering (Semester 6)
Total marks: 80
Total time: 3 Hours
(1) Question 1 is compulsory.
(2) Attempt any three from the remaining questions.
(3) Draw neat diagrams wherever necessary.
What are advantages and disadvantage of Distributed DBMS.
(b) What are the features of DDBMS?
(c) Explain the basic Timestamp Ordering Algorithm.
(d) What are the objectives of Distributed Query Processing?
(a) What is horizontal and vertical fragmentation? What are the types of horizontal fragmentation. Perform horizontal fragmentation for student relation as given below. Also give the correctness criteria for it.
Student (Studentrollno., StudentName, CourseNarne, Course Fees, year).
(b) What are the various kinds of transparencies in distributed database design? Explain each with the help of an example.
(a) What are the various concurrency control techniques? Compare Lock based Concurrency Control strategies in detail.
(b) Compare Distributed Deadlock prevention to Distributed Deadlock Avoidance Explain one scheme of Distributed deadlock Detection and Recovery.
(a) A banking database should contain the customer's information along with
the types of accounts customer is maintatining. Customer information is its full profile information along with his current address, PAN ID, adhar Card no included and account information should include type of account (Saving, fixed, demat, recuring, current), date and time of access and the transactions details.
(i) Write the DTD rules for the above XML documents.
(ii) Create an XML schema for the above XML document.
(b) What are homogenous and heterogeneous database. Give the architecture
of heterogeneous databases along with some query processing issues.
(a) What problems can occur in a distributed system due to the failure of link? What are the ways by which recovery can take place?
(b) Explain the phases of query processing in distributed database.
Q.6 Answer any two: (20 marks)
(a) Bond Energy Algorithm
(b) Design issues of Distributed Database
(d) Transaction management model for distributed System.