Derived horizontal fragmentation and mixed fragmentation?

Answer 1

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. The content of the tables differ by key value.

Horizontal Fragmentation is the classic distributed data base design approach. For example, you only allow customer data for the western region to enter the database in the Los Angeles office. The customer data for the eastern region can only be entered in the New York office's database. The Rule of Reconstruction dictates that no overlaps can be allowed by key content. In this case customers cannot be shared for update between the Eastern and Western offices.

Cheenu Gawri