Topic outline

  • General

    Collapse all Expand all

  • Course Sheet

    Level: 1st Year Master Artificial Intelligence and Big Data(M1-AIBD).

    Semester: 2

    Subject: Advanced Databases (BDDA).

    ---------------------------------------------------------

    Unit: Fundamental 2

    Credit: 05

    Coefficient: 03

    ---------------------------------------------------------

    Lecturer: Noureddine AZZOUZA

    Email: n.azzouza@univ-dbkm.dz

  • Course objectives

    • present the architecture and internal functioning of current DBMSs
    • introduce students to modern techniques, methods and results in the field of BD management.
    • New data management techniques are also covered such as: Object-Relational BDs, NoSQL and Cloud databases.

  • Teaching and assessment methods

    The Weekly Volume of this course "BDDA" in hours is as follows:

    • Lecture : 1 session
    • Supervised work : 1 session
    • Practical work : 1 session

    Therefore, the student must practice the concepts learned in the course and the tutorial as much as possible.

    The evaluation of the subject will be as follows:

    • Lecture : ------> Final Exam
    • SW : ----------> 1 / 2  Written tests
    • PW : ----------> presentation + homework

  • Course topics

    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

  • 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. Algebric Relations and Basic operations (joins...)
    2. Query Interpretation
    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)