DBDI 30/05/2007
Lecture_11 / PhysicalDB 1
DBDI / Lecture 11
Physical DB Design
Dr. Ala Al-Zobaidie
The slides are based on the textbook Fundamentals of Database Systems by Elmasri & Navathe
30/05/2007 DBDI / PhysicalDBs 2
Objectives /1
• DBA role in physical realization of a
database system
• Understand & Apply Physical DB Design
Techniques:
– Techniques for storing and finding data
– Selection of techniques for particular
application
30/05/2007 DBDI / PhysicalDBs 3
Objectives /2
• The main objective of good physical DB design
is to Improve Performance.
• Improving performance requires incorporating
various techniques during the transformation
process.
• The aim is to:
– Reduce the volumes of data transferred to or
from secondary storage, and/or by
– Decreasing the communication requirements
in a networked configuration.
30/05/2007 DBDI / PhysicalDBs 4
Database Administration
• Management of physical realization of a
database system including:
–Physical database design and
implementation,
–Setting security and integrity controls,
–Monitoring system performance, and
reorganizing the database.
30/05/2007 DBDI / PhysicalDBs 5
DBA role/ Operational Maintenance
• Process of monitoring and maintaining
database system following installation.
• Monitoring performance of system.
– if performance falls, may require
tuning or reorganization of the
database.
• Maintaining and upgrading database
application (when required).
• Incorporating new requirements into
database application.
30/05/2007 DBDI / PhysicalDBs 6
Other factors influence efficient DB
structures
• attribute access:
– which attribute should have built-in fast
access paths?
–E.g. pre-constructed joins
• buffers:
– how large should the buffer space be?
• clustering physical relations:
– which base relations should be stored
together in the same file?
