Home

About

Advanced Search

Browse by Discipline

Scientific Societies

E-print Alerts

Add E-prints

E-print Network
FAQHELPSITE MAPCONTACT US


  Advanced Search  

 
March 24, 2008 ADBS: The course 1 Practical Database Design and Tuning
 

Summary: March 24, 2008 ADBS: The course 1
Practical Database Design and Tuning
Chapter 16 (Self read)
March 24, 2008 ADBS: The course 2
Chapter Outline
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
are specified;
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.

  

Source: Adam, Salah - Department of Information and Computer Science, King Fahd University of Petroleum and Minerals

 

Collections: Computer Technologies and Information Sciences