Physical Database Design

Description:
This task defines the final data model based on the logical model and evolved through the event trace task. This model will include any technology specific design based on data and process placement and reflect performance related design characteristics.
Risk & Impact:
This task is critical as it defines exactly what will be built.
Inputs:
Upstream Tasks:
Downstream Tasks:
Coding
Questions Asked:
  1. What data will reside on this platform
  2. How will the data be accessed?
  3. Does the data need to be denormalized for performance?
Iterates with:
 
Deliverables:
Physical Data Model – This is the model depicting the actual way in which the database schema will be implemented. This model differs from the logical data model in that it will reflect concepts like denormalization for performance.
Replication Strategy – Assuming data will be replicated for fault tolerance or performance reasons, this defines the way data will be replicated throughout the architecture to