News‎ > ‎

Distributed Databases

posted Nov 14, 2011, 11:41 AM by Eddie Woo
It's very rare (and usually impractical) for large organisations to hold all of their data in a single location. 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.