(See related pages)
This chapter describes physical database design, the final phase of the database development process. Physical database design transforms a table design from the logical design phase into an efficient implementation that supports all applications using the database. After this chapter, the student should have acquired the following knowledge and skills:
|
|
|
Describe the inputs, outputs, and objectives of physical database design. |
|
|
|
Appreciate the difficulties of performing physical database design and the need for periodic review of physical database design choices. |
|
|
|
List characteristics of sequential, Btree, hash, and bitmap file structures. |
|
|
|
Understand the choices made by a query optimizer and the areas in which optimization decisions can be improved. |
|
|
|
Understand the trade-offs in index selection and denormalization decisions. |
|
|
|
Understand the need for computer-aided tools to assist with physical database design decisions, especially with decisions affected by the query optimization process. |