Summary: March 24, 2008 ADBS: The course 1
Practical Database Design and Tuning
Chapter 16 (Self read)
March 24, 2008 ADBS: The course 2
Physical Database Design in Relational Databases
An Overview of Database Tuning in Relational Systems.
March 24, 2008 ADBS: The course 3
Physical Database Design in Relational Databases ...
Factors that Influence Physical Database Design
A. Analyzing the database queries and transactions
For each query, the following information is needed.
The files that will be accessed by the query;
The attributes on which any selection conditions for the query
The attributes on which any join conditions or conditions to link
multiple tables or objects for the query are specified;
The attributes whose values will be retrieved by the query.
Note: the attributes listed in items 2 and 3 above are candidates for
definition of access structures.