Week 7
Physical Database Design - Download PowerPoint
Topics Include:
Related Readings:
Physical Database Design - Download PowerPoint
Topics Include:
- Physical Design Process
- Usage Analysis
- Field Design
- Handling Missing Data
- Denormalization
- Partitioning - Horizontal and Vertical
- Physical File Organization - Sequential, Indexed and Hashed
- Clustering Files
- Using Indexes
- Query Optimization
Related Readings:
- Chapter 5 from Modern Database Management