Planning the Physical Architecture

Abstract

In this chapter, you start the process of physical implementation by considering questions about how you should architect the solution. In order to illustrate the type of judgments you may have to make, consider the following scenarios and assess what each requires for successful implementation. Consider some of the possibilities discussed earlier in the book, such as an ODS or operational data store (used to separate reasonably current read-only structures for reporting) or simply additional hardware to improve query performance. Each is a realistic example of databases that are quite commonplace today. Let’s assume in each case that the logical design is complete and appropriate in each case.