Advantage and disadvantage of horizontal fragmentation
Answers
Answered by
6
Answer:
Which is an advantage of fragmentation?
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.
Explanation:
Vertical fragmentation divides the relation into attributes called columns. ... Horizontal Fragmentation splits tables by rows. It differs from Vertical Fragmentation in that the relationship between key columns and non-key columns remains the same.
Similar questions