Data Administration and Database Administration
Terms and Concepts
Database System Life Cycle
Database Planning
Database Planning: DA & DBA functions
Database Analysis
Database Analysis: DA & DBA functions
Database Design
Design 2: Physical Creation
Database Design: DA &DBA functions
Database Implementation
Database Implementation DA & DBA functions
Operation and Maintenance 1: Operations
Operation and Maintenance 2: Maintenance
Operation and Maintenance: DA & DBA functions
Growth & Change
Growth & Change: DA & DBA functions
Issues/functions in Database Administration
Data Integrity
No Concurrency Control: Lost updates
Concurrency Control: Locking
Concurrency Control: Updates with X locking
Concurrency Control: Deadlocks
Concurrency Control
Database Security
Views
Authorization Rules
Database Backup and Recovery
Email: ray@sherlock.berkeley.edu
Home Page: http://sims.berkeley.edu/~ray
Download presentation source