More on Physical Database Design and Referential Integrity
Review
Physical Design Decisions
Storage Format
Objectives of data type selection
Access Data Types
Access Numeric types
Physical Design
Internal Model Access Methods
Index Sequential
Indexed Sequential: Two Levels
Indexed Random
Btree
Inverted
Direct
Hashing
Today
Indexes
Type of Keys
Primary Key Indexes
Secondary Key Indexes
When to Index
When to Use Indexes
Parallel Processing with RAID
RAID
RAID Technology
Raid 0
RAID-1
RAID-2
RAID-3
Raid-4
RAID-5
Integrity Constraints
Required Data
Attribute Domain Constraints
Entity Integrity
Referential Integrity
Insertion rules
Deletion rules
Enterprise Constraints
Email: ray@sherlock.berkeley.edu
Home Page: http://sims.berkeley.edu/~ray
Download presentation source