Physical Database Design:
Definition and Explanation:
Physical database design is the last stage of database design process. It is the
process of mapping the logical database structures into the internal database
model. Physical database design can be defined as "the conversion of logical
model (e.g., relational data model) into actual database, structures like files,
stored procedures, indexes etc.
There are three major inputs to physical database design.
(i) Logical database structures developed during logical database design i.e.,
the Normalized Relations.
(ii) User processing requirements such as the size and frequency of use of the
database, response time, security, backup, and recovery etc.
(iii) Characteristics of the DBMS and other-components of the computer operating
Components of Physical Database Design Process:
There are seven types of objects in semantic object model to represent each of these objects into relational
The physical database design has five major components. A complete description of each component is given below: