Presentation #18
John Smith
Vertical Fragmentation
Section 5.3.2 - P.136
Review Questions
True/False
1. The heuristic approach Grouping, for the vertical
fragmentation of global relations starts by assigning each attribute to one
fragment, and at each step, joins some of the fragments until some criteria is
satisfied.
| Answer : |
|---|
2. The heuristic approach Splitting, for the
vertical fragmentation of global relations generates overlapping fragments
whereas other approach Grouping generates non-overlapping fragments.
| Answer : |
|---|
Fill in the Blank
3. Generation of Clustered affinity matrix is done in three steps : ________ ,__________ and ________.
| Answer : |
|---|
4. The Bond Energy Algorithm takes ______ ______
______ as input.
Answer :
Multiple choice
5. The _____ of the global relation's key in
the fragment is the characteristic of Vertical Fragmentation which allows
________ of the global relation.
a.
duplication, restructuring
b. replication,
reconstruction
c. multiplication,
building
d. unification, constructing
Answer :
6. The ______ of ______ indicates how
closely related the attributes are.
a.
togetherness, relations
b. hatredness,
attributes
c. affinity,
attributes
d. separation, relations
Answer :