Progress
Database Design
Guide
Physical Database Design
The physical database design is a refinement of the logical design. In this phase, you examine how the user will access the database. During this phase you determine:
It is possible that at this stage you denormalize the database to meet performance requirements. Denormalizing a database means that you re-introduce redundancy into your database in order to meet processing requirements.
Let’s look at an example of when you might consider denormalizing a database. In "Table Relationships and Normalization," you looked at the Order table, which is shown here again in Table 3–1.
To reduce the table to third normal form, you eliminated the Total After Tax column because it contains data that can be derived. However, now you look at data access requirements. Although you can construct the Total After Tax value, your customer service representatives need this information immediately. Since this is an item of information that is constantly used, you don’t want to have to calculate it each time you need it. If you keep it in the database, it is available on request. In this instance, the performance outweighs other considerations.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |