Section outline

  • Chapter 1. Introduction
    1. Relational DBMS
    2. SQL language

     

    Chapter 2. Data Storage and Index Structure
    1. Storage media (Structures, RAID, Cache, etc.)
    2. Indexes (Structures, types: B B+ Bitmap, management)

     

    Chapter 3. Query Optimization
    1. Basic operations (joins...)
    2. Interpretation of queries
    3. Query optimization (Query Plan, Rule-based, Cost-based)

     

    Chapter 4. Transaction Management and Competition
    1. Transaction
    2. Serializability
    3. Concurrency management (Two-phase locking, Stamping)

     

    Chapter 5. Object-Relational Databases
     
    Chapter 6. NoSQL Databases

    Chapter 7. Cloud Databases

    References