Introduction to Database Concepts
by amol kharat
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