Discuss the advantages and disadvantages of partitioning
What will be an ideal response?
Partitioning data has several advantages. First, queries are more efficient since data queried together are stored close to one another. Also, each partition of data can be stored in such a way as to optimize its own use. Partitioned data is more secure, since it is much easier to isolate data and make it available only to a group of users. Since smaller files take less time to backup and recover, it is easier to keep a partitioned database up and running. Also, the effects of damage are isolated, since other files (partitions) may not be affected by one damaged file. It is also easier to load balance, since the smaller files can be spread across multiple disks.
Some disadvantages include inconsistent access speed. Different partitions may have different access times, depending upon physical storage of the file. Also, partitioning adds complexity for the programmer. Although to the user, partitioning appears transparent, this is often not the case for a programmer. Finally, data may be replicated across multiple partitions, which will require more storage space and possibly more time for updates.
You might also like to view...
Put the listed steps in the corresponding parentheses in the risk assessment and response approach diagram below.(A) Avoid, share or accept risk(B) Reduce risk by implementing controls(C) Is it cost beneficial to protect the firm from the risk?(D) Estimate the likelihood of each risk occurring(E) Identify control to mitigate the risk(F) Estimate the costs and benefits from instituting controls(G) Identify the risks(H) Estimate the impact or potential loss, from each risk
What will be an ideal response?
The __________ Amendment provides that no state shall "deprive any person of life, liberty, or property, without due process of law."
a. Seventh b. Tenth c. Eleventh d. Fourteenth
Corporate directors are rarely compensated for their work, effort, and especially the risk involved.
Answer the following statement true (T) or false (F)
The SCOP process identifies and evaluates the environmental impact through all the phases of new product development, from design to disposal. This statement applies to which of the following functions?
a. new product development b. demand planning c. impact on existing products d. operations planning