Introduction to Database Concepts

Get Started. It's Free
or sign up with your email address
Rocket clouds
Introduction to Database Concepts by Mind Map: Introduction to Database Concepts

1. Basic Concepts

1.1. Data

1.2. Database

1.3. DBMS

1.4. Data Abstraction

1.4.1. View Level

1.4.2. Logical Level

1.4.3. Physical Level

1.5. Data Independance

1.5.1. Logical

1.5.2. Physical

1.6. 3 Schema Architecture

1.6.1. External / View

1.6.2. Conceptual / Logical

1.6.3. Internal / Physical

2. File System Disadvantages

2.1. Data redundancy and inconsistency

2.2. Difficulty in accessing data

2.3. Data isolation

2.4. Integrity problems

2.5. Atomicity of updates

2.6. Concurrent access by multiple users

2.7. Security problems

3. DBMS Advantages

3.1. Controlling Redundancy

3.2. Restricting Unauthorized Access

3.3. Providing Storage Structures and Search Techniques for Efficient Query Processing

3.4. Providing Backup and Recovery

3.5. Providing Multiple User Interfaces

3.6. Representing Complex Relationships among Data

3.7. Enforcing Integrity Constraints

4. DBMS Functions

4.1. Defining

4.2. Constructing

4.3. Manipulating

4.4. Sharing

4.5. Protection

4.5.1. System

4.5.2. Security

5. DBMS Architecture

5.1. Storage Manager

5.1.1. Authorization and integrity manager

5.1.2. Transaction manager

5.1.3. File manager

5.1.4. Buffer manager

5.1.5. Physical system implementation

5.1.5.1. Data files

5.1.5.2. Data dictionary

5.1.5.3. Indices

5.2. Query Processor

5.2.1. DDL interpreter

5.2.2. DML compiler

5.2.3. Query evaluation engine

6. DBMS Users

6.1. Naive users

6.2. Application programmers

6.3. Sophisticated users

6.4. Specialized users

6.5. DBA

6.5.1. Functions

6.5.1.1. Schema definition

6.5.1.2. Storage structure and access-method definition

6.5.1.3. Granting of authorization for data access

6.5.1.4. Routine maintenance

7. DBMS Characteristics

7.1. Self-describing

7.2. Data Independence, and Data Abstraction

7.3. Multiple views of the data

7.4. Sharing of data and multiuser transaction processing