Chapter 4. Logical and Physical Database Design
In traditional application development, the design of the data model occurs before almost any other design task. All subsequent application design activities build off the data model, and as a result the data model tends to constrain the ultimate performance of the application. Changing the data model in production is typically an expensive or nearly impossible undertaking, requiring coordinated changes to both schema and application code, and potentially expensive and time-consuming database rebuilds. Therefore, optimizing the data model is a critical, early task.
Logical Data Modeling
Application data models are commonly created in two phases. Establishing the logical data model involves modeling ...