Physical Database Design

• Translate global logical data model for target DBMS

• Design file organizations and indexes

• Design user views

• Design security mechanisms

• Consider the introduction of controlled redundancy

• Monitor and tune the operation system