BCA / B.Tech 12 min read

DDBMS

What is a DDBMS (Distributed Database Management System)?

A DDBMS is a centralized software system that manages a distributed database in a way that makes it appear to users as a single database. It synchronizes all the data periodically and ensures that updates to the database are broadcast to all sites.

Data Placement Strategies in DDBMS:
  • Replication: Storing copies of the database at different sites to improve availability and read performance. This can be full replication (copy of the entire database at every site) or partial replication (copies of only some fragments at some sites).
  • Fragmentation: Breaking the database into smaller logical units (fragments) and distributing them across different sites. This helps in placing data closer to where it is most frequently used.
  • Allocation: After fragmenting or deciding on replicas, the allocation strategy specifies where to store these units. The goal is to minimize communication costs and query response times.