Describe the purpose of the main steps in the physical design methodology presented in this chapter.
What will be an ideal response?
Step 7 of physical database design considers denormalizing the relational schema to improve
performance. There may be circumstances where it may be necessary to accept the loss of
some of the benefits of a fully normalized design in favor of performance. This should be
considered only when it is estimated that the system will not be able to meet its performance
requirements. As a rule of thumb, if performance is unsatisfactory and a relation has a low
update rate and a very high query rate, denormalization may be a viable option.
The final step (Step 8) of physical database design is the ongoing process of monitoring and
tuning the operational system to achieve maximum performance.
You might also like to view...
Which of the following statements is false?
a. Most operating systems support timeslicing, which enables threads of equal priority to share a processor. b. Without timeslicing, each thread in a set of equal-priority threads runs to completion before other threads of equal priority get a chance to execute. c. With timeslicing, even if a thread has not finished executing when its quantum expires, the processor is taken away from the thread and given to the next thread of equal priority, if one is available. d. An operating system’s thread scheduler determines which thread runs next.
You can use the Undo button on the Quick Access Toolbar to restore a deleted field value, but deleting a record permanently deletes it from the record source.
Answer the following statement true (T) or false (F)
________ is the act of having an online, text-based conversation with one or more individuals that occurs in real time.
A. Webcasting B. Uploading C. Instant messaging D. Blogging
An and gate has a controlling value of _____.
Fill in the blank(s) with the appropriate word(s).