Scribd
Upload
5 views1 page

Data Fragmentation Examples

The document outlines examples of data fragmentation techniques, specifically horizontal, vertical, and hybrid fragmentation. It provides a table of employees and demonstrates how data can be fragmented based on location and attributes. Each fragmentation type is illustrated with specific fragments from the employee data set.

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
5 views1 page

Data Fragmentation Examples

The document outlines examples of data fragmentation techniques, specifically horizontal, vertical, and hybrid fragmentation. It provides a table of employees and demonstrates how data can be fragmented based on location and attributes. Each fragmentation type is illustrated with specific fragments from the employee data set.

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