Data Architecture

14. Basic Requirements for Physical Design

Requirements for Physical Design

At this point in the development life cycle the logical model exists and there is an application architecture design. Hopefully (and unfortunately this is not always the case), the majority of requirements will have been defined and physical database design can begin. It is this author’s belief that there is a direct proportion between time spent in the previous analysis and design phases and the success of the project. It is truly a case of “pay me now or pay me later.”

This chapter focuses on all the input necessary to create a good physical design that will stand the test of time in terms of flexibility, availability, and performance. In the previous chapter, the considerations ...