Design file organizations and indexes

• objective:achieve acceptable performance

• transaction throughput
• response time
• disk storage

• System resource:Memory,CPU,Disk,Network

• Analyze transactions:Table 18.1(17.1),pp.531(504)

• Choose file organizations

• Choose indexes

• Estimate disk space requirements