Advanced Databases

Section outline

• Select section General

  Collapse Expand

  General

  Collapse all Expand all

  • Select activity Announcements

    

    Announcements Forum

    Welcome to the Course of "Advanced Databases"

• Select section Course Sheet

  Collapse Expand

  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
• Select section Course objectives

  Collapse Expand

  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.
• Select section Teaching and assessment methods

  Collapse Expand

  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
• Select section Course topics

  Collapse Expand

  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
• Select section Chapter 1. Introduction

  Collapse Expand

  Chapter 1. Introduction

  1. Relational DBMS
  2. SQL language

  • Select activity ADB-Course-Chapter_1 - Introduction & Basics

    

    ADB-Course-Chapter_1 - Introduction & Basics File
  • Select activity ADB-SW_01

    

    ADB-SW_01 File
  • Select activity ADB-SW_02

    

    ADB-SW_02 File
  • Select activity ADB-SW_02_solution

    

    ADB-SW_02_solution File
• Select section Chapter 2. Data Storage and Index Structure

  Collapse Expand

  Chapter 2. Data Storage and Index Structure

  1. Storage media (Structures, RAID, Cache, etc.)
  2. Indexes (Structures, types: B B+ Bitmap, management)

  • Select activity ADB-SW_03

    

    ADB-SW_03 File
  • Select activity ADB-Course-Chapter_2 - 1. Database System Architecture

    

    ADB-Course-Chapter_2 - 1. Database System Architecture File
  • Select activity ADB-Course-Chapter_2 - 2. Data Storage & Indexes

    

    ADB-Course-Chapter_2 - 2. Data Storage & Indexes File
• Select section Chapter 3. Query Optimization

  Collapse Expand

  Chapter 3. Query Optimization

  1. Algebric Relations and Basic operations (joins...)
  2. Query Interpretation
  3. Query Optimization (Query Plan, Rule-based, Cost-based)

  • Select activity ADB-SW_04

    

    ADB-SW_04 File
  • Select activity ADB-SW_04_solution

    

    ADB-SW_04_solution File
  • Select activity ADB-SW_05

    

    ADB-SW_05 File
  • Select activity ADB-SW_05_solution

    

    ADB-SW_05_solution File
• Select section Chapter 4. Transaction Management and Competition

  Collapse Expand

  Chapter 4. Transaction Management and Competition

  1. Transaction
  2. Serializability
  3. Concurrency management (Two-phase locking, Stamping)