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 ...

Get Oracle now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.