horizontal fragmentation, Database Management System

Assignment Help:

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.


Related Discussions:- horizontal fragmentation

The average amount of their orders , Make SQL statements for the following ...

Make SQL statements for the following scenarios. Your response should contain SQL statement, output and any other assumptions you have made to arrive at the answer. For Colorado cu

Need for client server computing, Need for Client Server Computing- Client/...

Need for Client Server Computing- Client/Server (C/S) architecture includes running the application on multiple machines in which every machine with its component software tackles

ER diagram, Explain the conventions (relationships) for displaying an ER sc...

Explain the conventions (relationships) for displaying an ER schema as an ER diagram.

Give the limitations of sql authorization, Give the limitations of SQL auth...

Give the limitations of SQL authorization. The code for checking authorization becomes intermixed with the rest of the application code. Implementing authorization by applic

Ordering of tuples, In a relation, tuples are not inserted in any definite ...

In a relation, tuples are not inserted in any definite order. Ordering of tuples is not defined as a part of a relation definition. Though, records may be structured later accordin

Using relational algebra which query finds customers, Using Relational Alge...

Using Relational Algebra which query finds customers, who have a balance of over 1000 ? Using Relational Algebra Π Customer_name( σ balance >1000(Deposit)) is query to find cu

What is datawarehousing, What is DataWarehousing? Subject-oriented, me...

What is DataWarehousing? Subject-oriented, meaning that the data in the database is organized so that all the data elements relating to the similar real-world event or object

List the drawbacks of relational database system, List the drawbacks of rel...

List the drawbacks of relational database system A) Repetition of data B) Inability to s certain information.

How many types of users works on database, How many types of users works on...

How many types of users works on database? Users are differentiated through the way they expect to interact along with the system (i) Application programmers-interact with

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd