Features of Distributed DBMS

There is a presence of a certain number of features that make DDBMS very popular in organizing data.

• Data Fragmentation: The overall database system is divided into smaller subsets which are fragmentations. This fragmentation can be three types horizontal (divided by rows depending upon conditions), vertical (divided by columns depending upon conditions), and hybrid (horizontal + vertical).
• Data Replication: DDBMS maintains and stores multiple copies of the same data in its different fragments to ensure data availability, fault tolerance, and seamless performance.
• Data Allocation: It determines if all data fragments are required to be stored in all sites or not. This feature is used to reduce network traffic and optimize the performance.
• Data Transparency: DDBMS hides all the complexities from its users and provides transparent access to data and applications to users.

A system that is used for managing the storage and retrieval of data across multiple interconnected databases is called a Distributed Database Management System(DDBMS). In this case, the interconnected databases are situated in different geographical areas. In DDBMS, one can access and store data transparently from different geographical locations and ensure high availability, scalability, and fault tolerance mechanisms. DDBMSs are designed to handle huge amounts of data spread across different sites. It can give seamless performance in data sharing and collaboration by organizations.