Physical Design

  1. What are the inputs to physical database design process?
  2. What are the key decisions in physical database design?
  3. What are the techniques used to minimize data storage (data type, code table, compression)?
  4. What are the techniques used to improve data processing speed (addressing, denormalization, partitioning, clustering, replication)?