Amrendra Patel

Data Fragmentation, Replication, and Allocation Techniques for Distributed Database

Amrendra Patel

Updated on 13-Jul-2023 29K+ Views

Data Fragmentation The process of dividing the database into smaller multiple parts or sub−tables is called fragmentation. The smaller parts or sub−tables are called fragments and are stored at different locations. Data fragmentation should be done in a way that the reconstruction of the original parent database from the fragments is possible. The restoration can be done using UNION or JOIN operations. Database fragmentation is of three types: Horizontal fragmentation, Vertical fragmentation, and Mixed or Hybrid fragmentation. Horizontal Fragmentation It divides a table horizontally into a group of rows to create multiple fragments or subsets of a table. ...