Shivaji University 2009-8th Sem B.E Computer Science (Computer Sci& Engg.), ADVANCED DATABASE SYSTEM - Question Paper

B.E. (Computer Sci. & Engg.)(Semester-VIII)Examination, 2009

ADVANCED DATABASE SYSTEM


Day and Date: Wednesday, 18-05-2009
Time: 10.00a.m. To 1.00 p.m. Total Marks: 100


Instructions: 1) Q.4 &Q.8 are compulsory.
2) ans any 2 ques. from remaining in every part.
3) Figures to the right indicate full marks.


SECTION-I


1. a) Illustrate with example. Nested relational model.

b) discuss SQL functions and procedures.

2. a) explain in detail centralized and client-server systems.

b) What is distributed deadlock? How to handle it?

3. a) discuss Attribute value and partition skew. How to handle the skew?

b) What is homogenous and heterogeneous database? How to store data in distributed DBMS using replication?

4. Write short notes on: (any three)

a) Complex kinds.

b) Intraquery Parallelism.

c) 3 phase commit

d)Parallel database architecture.














SECTION-II

5. a) explain the need for standardization. discuss DB connectivity standards and XML-based standards.

b) What is support and confidence? discuss an algorithm for finding association rule.

6. a) discuss with example extended aggregation and ranking.

b) Draw typical data warehouse architecture. discuss every block in brief.
7. a) With the help of diagram explain detail structure of TP monitor..

b) What is the purpose of compensating transaction? current 2 examples of their use.

8. Write short notes on: (any three)

a) Clustering.

b) MOLAP.

c) Main memory database

d) E-commerce.

Earning:   Approval pending.