Aller au menu Aller au contenu
Une voie, plusieurs choix
Informatique et Mathématiques appliquées
Une voie, plusieurs choix

> Formation > Cursus ingénieur

Inside object relational database management system - 4MMCSGB6

A+Augmenter la taille du texteA-Réduire la taille du texteImprimer le documentEnvoyer cette page par mail cet article Facebook Twitter Linked In
  • Number of hours

    • Lectures : 16.5
    • Tutorials : 16.5
    • Laboratory works : -
    • Projects : -
    • Internship : -
    • Written tests : -
    ECTS : 3.0
  • Officials : Christophe BOBINEAU

Goals

The objective of this course is to give an overview of system features of DBMS and to study post relational approaches and the new trends in database applications.

Content

The first part is devoted to the DBMS architecture and its components. Special attention will be given to transactions support. Several aspects of transactions will be studied, techniques and algorithms to support concurrency control, recovery and consistency. Query evaluation and optimization will also be covered in this course. Approaches for algebraic optimization and index will be studied. The second part of this course is devoted to the study of the evolution of DB technology and their use. We study the extended relational and the object oriented approaches including data model, language and architectural topics. We will also study features related to coherency and mechanisms, as active rules or triggers, to support them.

Prerequisites

Principles of DBMS

Tests

1 exam and practical work.

Session 1 :

  • Examen écrit de 3h + éventuelles épreuves pratiques : E1
    N1=E1

Session 2 :

  • Examen écrit de 2 ou 3h : E2
    N2=(N1+2*E2)/3

Calendar

The course exists in the following branches:

  • Curriculum - Information Systems Engineering - Semester 8
see the course schedule for 2020-2021

Additional Information

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

The course is attached to the following structures:

You can find this course among all other courses.

Bibliography

  • 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
  • J. Ullman, J. Widom, A First Course in Database Systems, Prentice-Hall, 1997
  • 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.

A+Augmenter la taille du texteA-Réduire la taille du texteImprimer le documentEnvoyer cette page par mail cet article Facebook Twitter Linked In

Date of update January 15, 2017

Université Grenoble Alpes