Definition check: Are databases stored at multiple locations without any interconnecting network still considered “distributed databases”, or does distribution imply networked coordination among sites?

Difficulty: Easy

Correct Answer: Incorrect

Explanation:


Introduction / Context:
Distributed databases coordinate a single logical database across multiple networked sites. This question tests whether merely having databases in many places—without networking—meets the definition of “distributed.”



Given Data / Assumptions:

  • Multiple computers store related data sets.
  • No network connectivity or distributed DBMS services exist between them.
  • Goal of distributed systems: transparency (location, fragmentation, replication) via coordinated software.


Concept / Approach:
Distribution implies coordination. A distributed DBMS provides a unified interface, concurrency control, and recovery across nodes. Physically separated but unconnected databases are simply independent databases, not parts of a distributed database. Tape/drive sneaker-net copies do not create distribution; they create replicas or backups without online coordination.



Step-by-Step Solution:

Check for a single logical schema spanned across sites.Verify network connectivity enabling distributed query, concurrency, and recovery.If absent, recognize the systems as separate, not distributed.Add a distributed layer (e.g., sharding, replication) to achieve true distribution.


Verification / Alternative check:
Run a cross-site transaction. If there is no facility for two-phase commit, distributed queries, or global catalogs, the environment is not a distributed database.



Why Other Options Are Wrong:

  • Marking “Correct” confuses geographic dispersion with distributed database architecture.
  • Building location or portable media do not satisfy the defining characteristics.
  • Replication may exist without exposing a single logical database, but true distributed DBMSs coordinate more than copies.


Common Pitfalls:
Assuming offsite backups form a distributed DB; they do not provide distributed concurrency or transparency.



Final Answer:
Incorrect

Discussion & Comments

No comments yet. Be the first to comment!
Join Discussion