Ensimag Rubrique Formation 2022

Database Management Systems - 4MM1SGBD

  • Number of hours

    • Lectures 27.0
    • Projects -
    • Tutorials 27.0
    • Internship -
    • Laboratory works -
    • Written tests -

    ECTS

    ECTS 4.0

Goal(s)

Data are now central to our information society. An adaptive, reliable and efficient data management is crucial for the effective operation of enterprises and their evolution. Database Management Systems (DBMS) tools are vital for ensuring that management. The objective of this course is to present the fundamentals of DBMS, their architecture and their evolutions.

Responsible(s)

Christophe BOBINEAU

Content(s)

We remind the principles of Relational DBMS (the most used): models, properties of relations (normalization) and manipulation languages. The design aspects of database schemas will be revisited. We will also present extensions of relational systems (non-relational systems and object-relational ones). We also discuss mechanisms such as active rules for associating behavior to relations and, in particular, to ensure the verification of integrity constraints on data.

We will study the architecture of Database Management Systems, looking their various components including the transactional core constituting an essential element of these systems. We will discuss the main aspects (techniques, algorithms) with the transactional support mechanisms for fault tolerance, concurrency control and consistency management. We will also look at query evaluation and optimization techniques, algebraic optimization techniques, data structures and methods for indexing data and other data paths.

We conclude the course with an overview of developments in the field (models, languages, system) related to Big Data phenomenon.

Prerequisites

Databases simple principles

Test

ACADEMIC PERIOD 5 :
Exam type : written and practices
Duration : 2 hours
Authorized documents : Personal notes, Foreign language dictionaries
Forbidden documents : Books
Equipment :

  • Authorized equipment : None
  • Forbidden equipment : All

ACADEMIC PERIOD 6 :
Exam type : written and practices
Duration : 2 hours
Authorized documents : Personal notes, Foreign language dictionnaries
Forbidden documents : Books
Equipment :

  • Authorized equipment : Calcs
  • Forbidden equipment : Everything else

SECOND SESSION :
Exam type : written
Duration : 2 hours
Authorized documents : personal notes, Foreign language dictionnaries
Forbidden documents: Books
Equipment :

  • Authorized equipment : Calcs
  • Forbidden equipments : Everything else

PA5 = 1/3 TP + 2/3 Examen écrit
PA6 = 1/3 TP + 2/3 Examen écrit
N1 = 1/2 PA5 + 1/2 PA6
N2 = 1/3 max(PA5, PA6) + 2/3 Examen écrit

Calendar

The course exists in the following branches:

  • Curriculum - Work Study Education - Alternance 2eme annee
see the course schedule for 2023-2024

Additional Information

Course ID : 4MM1SGBD
Course language(s): FR

The course is attached to the following structures:

You can find this course among all other courses.

Bibliography

  • C. Delobel, M. Adiba, Bases de données et Systèmes Relationnels, Dunod informatique, 1982
  • G. Gardarin, Objet et Relationnel , Eyrolles, 2003
  • T. Connolly et C. Begg, Systèmes de Bases de Données, Editions Reynald Goulet, 2005
  • J.-L. Hainaut, Bases de données : Concepts, utilisation et développement, Dunod, 2009
  • S. Navathe, R. Elamasri, Fundamentals of database systems, second ed., Adison-Wesley Pub, 1994
  • J. Ullman, J. Widom, A First Course in Database Systems, Prentice-Hall, 1997
  • J. Ullman, J. Widom, A Second Course in Database Systems, Prentice-Hall, 1999
  • M. Adiba et C. Collet. “Les SGBD a objets - le systeme O2”, vol. , Hermès, 1993.
  • J. Gray, A.Reuter. “Transaction processing”, vol. , Morgan Kaufmann, 1993.
  • H. Garcia-Molina, J. Ullman and J. Widom. “Database System Implementation”, Prentice-Hall, 1999.

have a look to