Summary: March 23, 2008 Databases: Physical DB Deign 1
Physical DB Design & Tuning
March 23, 2008 Databases: Physical DB Deign 2
What is Physical DB Design +
Why Physical DB Design is Needed +
I/O Model for DBs
Issues in Physical DB Design +
File Organization and access Methods +
Physical DB Design Process +
March 23, 2008 Databases: Physical DB Deign 3
- What is Physical DB Design?
Physical DB design is the process of choosing specific
storage structures and access paths for the DB files to
achieve good performance for the various DB applications.
Each DBMS offers a variety of options for file organization
and access paths.
Once a specific DBMS is chosen, the physical DB design
process is restricted to choosing the most appropriate file
organizations and access paths for the DB files from among