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

Transformation Model

The objectives of the Transformation model include:

• Provide the database administrator with sufficient information to create an efficient physical database
• Provide a context for the definition and recording of the data elements
• Hold the records that form the database in the data dictionary
• Help the application team select a physical structure for the programs that will access the data.

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