horizontal fragmentation, Database Management System

Horizontal Fragmentation-Horizontal fragmentation groups together the tuples in a relation that are collectively used by the main transactions. A horizontal fragment is produced by specifying a WHERE clause condition that shows a restriction on the tuples in the relation. It can also be described using the Selection operation of the relational algebra.

Example:

Let us demonstrate horizontal fragmentation with the help of an example.

 DEPOSIT (branch-code, account-number, customer-name, balance)

A sample relation instance of the relation DEPOSIT is shown in Figure.

Branch-code

Account number

Customer name

Balance

1101

3050

Suresh

5000

1101

2260

Swami

3360

1102

1170

Swami

2050

1102

4020

Khan

10000

1101

1550

Khan

620

1102

4080

Khan

1123

1102

6390

Khan

7500

                                                              Figure: Sample DEPOSIT relation

Mathematically a fragment may be described as a selection on the global relation R. The reconstruction of the relation R can be taken by taking the union of all fragments.

So let us decay the table in Figure into horizontal fragments. Let us do these fragments on the branch-code as 1101 and 1102

DEPOSIT1 obtained by selection on branch-code as 1101

Branch-code

Account number

Customer name

Balance

1101

3050

Suresh

5000

1101

2260

Swami

3360

1101

1550

Khan

620

DEPOSIT2 obtained by selection on branch- code as 1102

Branch-code

Account number

Customer name

Balance

1102

1770

Swami

2050

1102

4020

Khan

10000

1102

4080

Khan

1123

1102

6390

Khan

7500

 

 

 

 

 

 

 

 

 

                                        Figure: Horizontal fragmentation of relation DEPOSIT

 

The two fragments can be described in relational algebra as:

 

DEPOSIT1 = σ branch-code= 1101 (DEPOSIT)

DEPOSIT2 = σ branch-code= 1102 (DEPOSIT)

These two fragments are given in Figure. Fragment 1 can be stored in the branch whose code is 1101 whereas the second fragment can be stored at branch 1102.

In our example, the fragments are disjoint. Though, by changing the selection predicates used to construct the fragments; we may have overlapping horizontal fragments. This is a type of data replication.

Posted Date: 3/13/2013 8:39:45 AM | Location : United States







Related Discussions:- horizontal fragmentation, Assignment Help, Ask Question on horizontal fragmentation, Get Answer, Expert's Help, horizontal fragmentation Discussions

Write discussion on horizontal fragmentation
Your posts are moderated
Related Questions
Question 1 Describe the following- Clustering Indexing Question 2 Explain the following with suitable real time examples- Implementation of Integrity rules

We will explain here an example database application having COLLEGE database and use it in showing several E-R modelling concepts. College database remains track of faculty, Stu

A full discription of the new, a discription of its components, and the bebefit it will provide a company. A disscussion of the information usedin the system. A disscussion of any

Give an example of Object Representation  For illustration, consider the implementation of a social security number within an employee object that is shown in Figure. The soci

Create a view emp_dep containing e_name and number of dependents from the tables employee and dependent of (i) CREATE VIEW emp_dept AS SELECT ename, COUNT(*) FROM employee, dep

A software contract and consultancy firm maintains details of all the various projects in which its employees are currently involved. These details comprise: Employee Numbe

1. Will you advise that your organization uses open source software and why? 2. Why is it important for business managers to have a basic understanding of the software development

Which sorting technique is used to sort databases, whose sizes are very big?  Give one such algorithm.  Why do sorting techniques like quicksort, insertion sort, etc.  not applied

What is a primary key? Primary key is chosen by the database designer as the principal means of identifying an entity in the entity set.

Draw an entity relationship diagram (ERD) for the following situation: A company has a number of employees. Each employee is identified by an Employee_Id. The company wants to st