Performance and Optimization

Preparation

Fundamentals of Database Management Systems

• Chapter 8: Physical Database Design
  • Physical Database Design Techniques
• Chapter 12: Client / Server Database and Distributed Database

Learning Objectives

• Describe horizontal and vertical partitioning for relational schemas
• Describe the concept of denormalization and when to consider it