Information Systems, Databases, and Models › Physical Models › Transformation Model

Transformation Model

The objectives of the Transformation Model are to provide the Database Administrator (DBA) with sufficient information to create an efficient physical database, to provide a context for the definition and recording of the data elements and records that form the database in the data dictionary, and to help the application team choose a physical structure for the programs that will access the data.

When it is appropriate for the development effort, the model can also provide the basis for comparing the physical database design against the original business information requirements to:

• Demonstrate that the physical database design adequately supports those requirements.
• Document physical design choices and their implications, such as what is satisfied, and what is not.
• Identify database extensibility capabilities and constraints.