Physical Design   «Prev 

Physical Design Overview

The process of producing a description of the implementation of the database database on secondary storage is known as physical design. Physical Design describes the
  1. base relations,
  2. file design organizations, and
  3. indexes
used to achieve efficient access to the data, and any associated integrity constraints and security measures.
The physical database design phase allows the designer to make decisions on how the database is to be implemented. Therefore, physical design is tailored to a specific DBMS. There is feedback between physical and logical design, because decisions taken during physical design for improving performance may affect the logical data model.

Indexing values in a field helps the RDBMS find values more quickly.

Clustering puts records which are often retrieved together on contiguous disk blocks

Partitioning separates a table into two(or more) tables to keep rows

or more columns close together on the hard disk.