5:47 AM
VAAGESWARI COLLEGES
1. Define distributed database. Compare and contrast centralized and distributed data
base?
2. What is fragmentation explain in detail verification and horizontal fragmentation with examples
3. What are the technicalities involved in distributed database administration?
Disscuss reference model in detail?
4. How integrity constraints work in distributed databases?
5. What are rules to be followed trancslating global relation into fragmant relation ?
6. How aggregate function are graped and walnated?
7. Expalin in detail the prametric quries explain ent operation with examples
8. How can we simplify vertically fragumented relation
9. What are the different optimization problems to be discussed what is tprofile ? How
the relationalational alzebra evaluated
10. Write about algebra of qualified relation
11. How can we reduce the relation using semi joins explain using SDD1 algorithm and
how can we calculate Transaction cost
12. How could we calculate the Transaction delay and explain AHY algorithm in detail
13. Explain in detail R* approach.
14. Define Transaction. Explain Properties and Goals of Transaction management.
15. Write about the memory producer in centralized using Log and distributed database
using 2-PC protocol.
16. How can we control concurrency in Distributed databases.
