Inside object relational database management system - 4MMCSGB6

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.

Principles of DBMS

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

The course exists in the following branches:

• Curriculum - Information Systems Engineering - Semester 8

Course ID : 4MMCSGB6
Course language(s):

The course is attached to the following structures:

• Team Database, IS and knwoledge

You can find this course among all other courses.

• 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.