Question

What are correctness rules for fragmentation ?

Answer 1

What are the correctness rules for verifying fragmentation

What are the correctness rules for verifying fragmentation? How do we verify the correctness of fragmentation?

Correctness rules of fragmentation

Fragmentation is the major concept in distributed database. We fragment a table horizontally, vertically, or both and distribute the data to different sites (servers at different geographical locations). While we perform the fragmentation process, as a result we expect the following as outcomes;

We should not lose data because of fragmentation

We should not get redundant data because of fragmentation

Hence, to ensure these properties we need to verify that whether we performed the fragmentation correctly or not. For this verification we use the correctness rules. The rules are as follows;