News‎ > ‎

9IPT: Distributed Databases

posted Nov 14, 2012, 5:07 PM by Eddie Woo
Large organisations almost never hold all of their data in a single location - it's not practical. Instead, they use what's called a distributed database. Please complete the following tasks: 
  1. Compare and contrast centralised databases and distributed databases.
  2. Explain why fragmentation is often a sensible thing to do for a large organisation.
  3. Distinguish between vertical and horizontal fragmentation, and provide a concrete example where each would be appropriate.
  4. Describe the "download" model of distributed database, and identify situations where it would be particularly helpful.
  5. Explain the effects that the download model has on the DNS system.
  6. Outline the "replication" model and describe the different methods for resolving update conflicts.