Advantages of Data Fragmentation


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.

Disadvantages of Data Fragmentation