Discuss the advantages and disadvantages of fragmentation.
Advantages
Disadvantages
What will be an ideal response?
Advantages
Locality of Reference. Data stored close to where it is used, if possible. If a fragment is used at a
number of sites, it may be advantageous to store copies of the fragment at these sites.
Improved Reliability and Availability. Reliability and availability are improved by replication;
there is another copy of the fragment available at another site in the event of one site failing.
Performance. Inherent parallelism and distribution of resources.
Storage capacities and costs.
Reduced Communication costs.
Security. Data not required by local applications is not stored and so not available for
unauthorized users.
Disadvantages
Design. May be difficult to design and allocate fragments efficiently.
Query optimization is more difficult.
Integrity is more difficult.
You might also like to view...
Which of the following can be done to harden an operating system?
A) Uninstall unneeded applications or utilities B) Close unused ports C) Apply the latest security patches and fixes D) All of the above
_______ conditions a system to remove any possibility of deadlocks occurring.
a) Deadlock avoidance b) Deadlock prevention c) Deadlock detection d) Deadlock recovery
Click a chart's ________ to select the entire chart
A) border B) title C) legend D) labels
In which order do most programs follow these general steps?
A. process data, accept input data, create output data B. create output data, accept input data, process data C. accept input data, process data, create output data D. accept input data, create output data, process data