The main purpose of data fragmentation is to place data at the location where the data is least often accessed. An advantage of a distributed database is that the database can handle more complex query processing. Systems that are record-at-a-time-oriented can create performance problems in distributed systems.
The main advantage of fragmentation is to improve the performance of distributed database design by increasing the efficiency since data is stored only where it is needed. Fragments can be allocated at different network sites in a process called data allocation.
Fragmentation in multicellular or colonial organisms is a form of asexual reproduction or cloning, where an organism is split into fragments. Advantage: Quick Reproduction, Requires no mate, only 1 parent needed Disadvantage: Can not adapt to change, no genetic diversity, DNA is exactly the same as parent 2.
Advantages : As the data is stored close to the usage site, the efficiency of the database system will increase. Local query optimization methods are sufficient for some queries as the data is available locally. In order to maintain the security and privacy of the database system, fragmentation is advantageous.