Introduction to Physical Design › Steps in the Physical Database Design Process

Steps in the Physical Database Design Process

The physical database design process involves creating a base physical design followed by refinements based on the implementation choice. The physical database design process involves the following steps:

1. Create a preliminary data structure diagram based on the logical database design.
2. Identify application performance requirements.
3. Assign location modes.
4. Evaluate and refine the physical database design.
5. Choose physical tuning options.
6. Minimize contention among transactions.