Advantages of Data Fragmentation
Data fragmentation provides a number of advantages
that are listed in the following:
Better Usage: In general applications work with views, rather than the entire relation. Therefore, it seems to be beneficial to fragment the relations into sub-relations and store them into different sites as units of distribution in data distribution.
Improved Efficiency: Fragmented data can be stored close to where it is most frequently used. In addition, data that are not required by local applications are not stored locally, which may result in faster data access thereby increasing the efficiency.
Improved Parallelism or Concurrency: With a fragment as the unit of distribution, a transaction can be divided into several sub-transactions that operate on different fragments in parallel. This increases the degree of concurrency or parallelism in the system, thereby allowing transactions to execute in parallel in a safe way.
Better Security: Data that are not required by local applications are not stored locally and, consequently. are not available to unauthorized user of the distributed system thus, improving the security.