Coursebooks 2017-2018

PDF
 

Introduction to database systems

CS-322

Lecturer(s) :

Ailamaki Anastasia
Koch Christoph

Language:

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

In the programs

  • Energy Management and Sustainability, 2017-2018, Master semester 2
    • Semester
       Spring
    • Exam form
       Written
    • Credits
      4
    • Subject examined
      Introduction to database systems
    • Lecture
      2 Hour(s) per week x 14 weeks
    • Exercises
      1 Hour(s) per week x 14 weeks
    • Project
      1 Hour(s) per week x 14 weeks
  • Energy Management and Sustainability, 2017-2018, Master semester 4
    • Semester
       Spring
    • Exam form
       Written
    • Credits
      4
    • Subject examined
      Introduction to database systems
    • Lecture
      2 Hour(s) per week x 14 weeks
    • Exercises
      1 Hour(s) per week x 14 weeks
    • Project
      1 Hour(s) per week x 14 weeks
    • Semester
       Spring
    • Exam form
       Written
    • Credits
      4
    • Subject examined
      Introduction to database systems
    • Lecture
      2 Hour(s) per week x 14 weeks
    • Exercises
      1 Hour(s) per week x 14 weeks
    • Project
      1 Hour(s) per week x 14 weeks
  • Passerelle HES - IN, 2017-2018, Spring semester
    • Semester
       Spring
    • Exam form
       Written
    • Credits
      4
    • Subject examined
      Introduction to database systems
    • Lecture
      2 Hour(s) per week x 14 weeks
    • Exercises
      1 Hour(s) per week x 14 weeks
    • Project
      1 Hour(s) per week x 14 weeks
    • Semester
       Spring
    • Exam form
       Written
    • Credits
      4
    • Subject examined
      Introduction to database systems
    • Lecture
      2 Hour(s) per week x 14 weeks
    • Exercises
      1 Hour(s) per week x 14 weeks
    • Project
      1 Hour(s) per week x 14 weeks
    • Semester
       Spring
    • Exam form
       Written
    • Credits
      4
    • Subject examined
      Introduction to database systems
    • Lecture
      2 Hour(s) per week x 14 weeks
    • Exercises
      1 Hour(s) per week x 14 weeks
    • Project
      1 Hour(s) per week x 14 weeks
    • Semester
       Spring
    • Exam form
       Written
    • Credits
      4
    • Subject examined
      Introduction to database systems
    • Lecture
      2 Hour(s) per week x 14 weeks
    • Exercises
      1 Hour(s) per week x 14 weeks
    • Project
      1 Hour(s) per week x 14 weeks
    • Semester
       Spring
    • Exam form
       Written
    • Credits
      4
    • Subject examined
      Introduction to database systems
    • Lecture
      2 Hour(s) per week x 14 weeks
    • Exercises
      1 Hour(s) per week x 14 weeks
    • Project
      1 Hour(s) per week x 14 weeks
    • Semester
       Spring
    • Exam form
       Written
    • Credits
      4
    • Subject examined
      Introduction to database systems
    • Lecture
      2 Hour(s) per week x 14 weeks
    • Exercises
      1 Hour(s) per week x 14 weeks
    • Project
      1 Hour(s) per week x 14 weeks

Reference week

 MoTuWeThFr
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     
Under construction
 
      Lecture
      Exercise, TP
      Project, other

legend

  • Autumn semester
  • Winter sessions
  • Spring semester
  • Summer sessions
  • Lecture in French
  • Lecture in English
  • Lecture in German