Fiches de cours 2017-2018

PDF
 

Introduction to database systems

CS-322

Enseignant(s) :

Ailamaki Anastasia
Koch Christoph

Langue:

English

Summary

This course provides a deep understanding of the concepts behind data management systems. It covers fundamental data management topics such as system architecture, data models, query processing and optimization, database design, storage organization, and transaction management.

Content

This course provides a deep understanding of the concepts behind data management systems.

During this course, the students will learn about:

Homework

Homeworks will be assigned to aid and assess comprehension of the above material. Homework will be either done using pen and paper or they will be programming exercises. During the semester the students will be asked to do a project to gain experience on how to build a database application, and to apply what they learn in class.

Keywords

databases, database design, data modeling, normalization, database management systems (DBMS), files, indexes, storage, external sorting, queries, query evaluation, query optimization, transactions, concurrency, recovery, SQL

Learning Prerequisites

Required courses

Data structures

Recommended courses

For the practical part of the course (project) the following skills will be needed:

Important concepts to start the course

Before the beginning of the course students must be familiar with:

Learning Outcomes

By the end of the course, the student must be able to:

Transversal skills

Teaching methods

Ex cathedra; including exercises in class, practice with pen and paper or with a computer, and a project

Expected student activities

During the semester, the students are expected to:

Assessment methods

Homework, project, written examinations and continuous control.

Supervision

Office hours Yes
Assistants Yes
Forum Yes

Resources

Bibliography

Slides, list of books, additional material (research articles), all indicated and/or available on moodle page.

Ressources en bibliothèque
Notes/Handbook

The slides that are used in the class are available for the students.

Websites
Moodle Link

Dans les plans d'études

  • Gestion de l'énergie et durabilité, 2017-2018, Master semestre 2
    • Semestre
       Printemps
    • Forme de l'examen
       Ecrit
    • Crédits
      4
    • Matière examinée
      Introduction to database systems
    • Cours
      2 Heure(s) hebdo x 14 semaines
    • Exercices
      1 Heure(s) hebdo x 14 semaines
    • Projet
      1 Heure(s) hebdo x 14 semaines
  • Gestion de l'énergie et durabilité, 2017-2018, Master semestre 4
    • Semestre
       Printemps
    • Forme de l'examen
       Ecrit
    • Crédits
      4
    • Matière examinée
      Introduction to database systems
    • Cours
      2 Heure(s) hebdo x 14 semaines
    • Exercices
      1 Heure(s) hebdo x 14 semaines
    • Projet
      1 Heure(s) hebdo x 14 semaines
    • Semestre
       Printemps
    • Forme de l'examen
       Ecrit
    • Crédits
      4
    • Matière examinée
      Introduction to database systems
    • Cours
      2 Heure(s) hebdo x 14 semaines
    • Exercices
      1 Heure(s) hebdo x 14 semaines
    • Projet
      1 Heure(s) hebdo x 14 semaines
  • Passerelle HES - IN, 2017-2018, Semestre printemps
    • Semestre
       Printemps
    • Forme de l'examen
       Ecrit
    • Crédits
      4
    • Matière examinée
      Introduction to database systems
    • Cours
      2 Heure(s) hebdo x 14 semaines
    • Exercices
      1 Heure(s) hebdo x 14 semaines
    • Projet
      1 Heure(s) hebdo x 14 semaines
    • Semestre
       Printemps
    • Forme de l'examen
       Ecrit
    • Crédits
      4
    • Matière examinée
      Introduction to database systems
    • Cours
      2 Heure(s) hebdo x 14 semaines
    • Exercices
      1 Heure(s) hebdo x 14 semaines
    • Projet
      1 Heure(s) hebdo x 14 semaines
    • Semestre
       Printemps
    • Forme de l'examen
       Ecrit
    • Crédits
      4
    • Matière examinée
      Introduction to database systems
    • Cours
      2 Heure(s) hebdo x 14 semaines
    • Exercices
      1 Heure(s) hebdo x 14 semaines
    • Projet
      1 Heure(s) hebdo x 14 semaines
    • Semestre
       Printemps
    • Forme de l'examen
       Ecrit
    • Crédits
      4
    • Matière examinée
      Introduction to database systems
    • Cours
      2 Heure(s) hebdo x 14 semaines
    • Exercices
      1 Heure(s) hebdo x 14 semaines
    • Projet
      1 Heure(s) hebdo x 14 semaines
    • Semestre
       Printemps
    • Forme de l'examen
       Ecrit
    • Crédits
      4
    • Matière examinée
      Introduction to database systems
    • Cours
      2 Heure(s) hebdo x 14 semaines
    • Exercices
      1 Heure(s) hebdo x 14 semaines
    • Projet
      1 Heure(s) hebdo x 14 semaines
    • Semestre
       Printemps
    • Forme de l'examen
       Ecrit
    • Crédits
      4
    • Matière examinée
      Introduction to database systems
    • Cours
      2 Heure(s) hebdo x 14 semaines
    • Exercices
      1 Heure(s) hebdo x 14 semaines
    • Projet
      1 Heure(s) hebdo x 14 semaines

Semaine de référence

 LuMaMeJeVe
8-9     
9-10     
10-11     
11-12     
12-13     
13-14     
14-15     
15-16     
16-17     
17-18     
18-19     
19-20     
20-21     
21-22     
En construction
 
      Cours
      Exercice, TP
      Projet, autre

légende

  • Semestre d'automne
  • Session d'hiver
  • Semestre de printemps
  • Session d'été
  • Cours en français
  • Cours en anglais
  • Cours en allemand