Database Chapter 8

Get Started. It's Free
or sign up with your email address
Database Chapter 8 by Mind Map: Database Chapter 8

1. Types of Tablespace


1.1.1. Stores the data dictionary data

1.2. USERS

1.2.1. Stores the table data created by the end users

1.3. TEMP

1.3.1. Stores the temporary tables and indexes created during the execution of SQL statements


1.4.1. Stores database transaction recovery information

2. Evolution of the Database Administration Function

2.1. Information systems (IS) department

2.2. Database administrator

2.3. Systems administrator

2.4. Data administrator (DA) or information resource manager (IRM)

3. DBA’s Managerial Role

3.1. Disaster management

3.2. Concurrent backup

3.3. Incremental backup

3.4. Full backup or database dump

4. Developing a Data Administration Strategy

4.1. Information engineering (IE):

4.2. Information systems architecture (ISA):

5. Computer-Aided Systems Engineering (CASE) Tools

5.1. Front-end CASE tools

5.1.1. Provide support for the planning, analysis, and design phases

5.2. Back-end CASE tools

5.2.1. Provide support for the coding and implementation phases

6. Data

6.1. Dirty data

6.2. Data quality

6.3. Data profiling software

6.4. Master data management ( MDM ) software

7. Special Considerations

7.1. Technological aspect

7.2. Managerial aspect

7.3. Cultural aspect

8. Contrasting DA and DBA activities and characteriestics

8.1. DA(Data administrator)

8.1.1. Perform strategic planning

8.1.2. Sts long-term goals

8.1.3. Sets policies and standards

8.1.4. job is broad in scope

8.2. DBA(Database administrator)

8.2.1. Controls and supervises

8.2.2. Executes plans to reach goals

8.2.3. Enforces policies and procedures

8.2.4. Job is narrow in scope

9. Data Dictionary

9.1. Active data dictionary

9.1.1. Automatically updated by the DBMS with every database access

9.2. Passive data dictionary

9.2.1. Requires running a batch process

10. Security Vulnerability

10.1. Security threat

10.1.1. Imminent security violation

10.2. Security breach

10.2.1. Occurs when a security threat is exploited and could lead to a database whose integrity is preserved or corrupted