Scribd
Upload
2 views1 page

Data Fragmentation Techniques Explained

Uploaded by

surajninjaking
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
2 views1 page

Data Fragmentation Techniques Explained

Uploaded by

surajninjaking
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Data Fragmentation Techniques Examples

Fragmentation Type Example

Table: Employees (EmpID, Name, Department, Location)

Fragment 1 (Location = 'New York'):


| EmpID | Name | Department | Location |
|-------|-------|------------|----------|
| 101 | Alice | Sales | New York |

Fragment 2 (Location = 'London'):


| EmpID | Name | Department | Location |
|-------|------|------------|----------|
Horizontal Fragmentation | 102 | Bob | Marketing | London |
Table: Employees (EmpID, Name, Address, Salary, Department)

Fragment 1:
| EmpID | Name | Address |
|-------|-------|------------|
| 101 | Alice | 123 NY St |

Fragment 2:
| EmpID | Salary | Department |
|-------|--------|------------|
Vertical Fragmentation | 101 | 60000 | Sales |
Step 1 (Horizontal):
Fragment 1 (New York):
| EmpID | Name | Department | Location |
|-------|-------|------------|----------|
| 101 | Alice | Sales | New York |

Step 2 (Vertical on Fragment 1):


Fragment 1A:
| EmpID | Name |
|-------|-------|
| 101 | Alice |

Fragment 1B:
| EmpID | Department | Location |
|-------|------------|-----------|
Hybrid (Mixed) Fragmentation | 101 | Sales | New York |

You might also like