STUPIDSID
1(a)
Consider an International multiplex movie house having branches in all over world, discuss its design of distributed database with type of fragmentation and allocation strategy.
7 M
1(b)
List and briefly explain advantages of Distributed database with centralized approach.
7 M
2(a)
Give comparison of all architecture for distributed DBMS with its application.
7 M
Solve any one question from Q.2(b) & Q.2(c)
2(b)
Explain top-down design process in detail.
7 M
2(c)
Explain Client Server architecture for Distributed DBMS.
7 M
Solve any one question from Q.3 & Q.4
3(a)
Explain, Min term predict, COM_MIN and PHORIZONTAL algorithm in context of horizontal fragmentation.
7 M
3(b)
Explain views in centralized DBMSs with examples.
7 M
4(a)
Explain AA matrix, CA matrix and BEA algorithm in context of vertical fragmentation.
7 M
4(b)
What is distributed integrity Assertion ? Explain any one assertion with example.
7 M
Solve any one question from Q.5 & Q.6
5(a)
Explain layers of query processing.
7 M
5(b)
Explain Elimination of redundancy and rewriting in the context of query decomposition.
7 M
6(a)
Explain Centralized query optimization.
7 M
6(b)
What are the various types of networks? Explain in detail.
7 M
Solve any one question from Q.7 & Q.8
7(a)
Explain distributed cost model with example.
7 M
7(b)
Briefly describe the characterization of query processors.
7 M
8(a)
Differentiate 1) Data warehousing Vs Distributed Database
2) Distributed Processing Vs Cooperative Processing
2) Distributed Processing Vs Cooperative Processing
7 M
8(b)
Explain reduction in primary horizontal fragmentation for localization of distributed data.
7 M
More question papers from Distributed Systems