Chapter 8 Database Administration & Security

1. Role of Database in an Organization

1.1. Top management level

1.2. Middle management level

1.3. Operational management level

2. DBA's Managerial Role

2.1. Provide end-user support

2.2. Manage data security, privacy and integrity

2.3. Manage data backup and recovery

2.3.1. Database security officer (DSO)

2.3.2. Disaster management

2.3.3. Full backup or database dump

2.3.4. Incremental backup

2.3.5. Concurrent backup

2.4. Manage data distribution and use

3. Security Goals

3.1. Confidentiality

3.2. Compliance:

3.3. Integrity

3.4. Availability

4. Components of a CASE Tool

4.1. Graphics

4.2. Screen painters and report generators

4.3. Integrated repository

4.4. Analysis segment

4.5. Program documentation generator

5. Types of Tablespace

5.1. System

5.2. User

5.3. Temp

5.4. Undotbs1