Number of hours
- Lectures 16.5
- Tutorials 16.5
ECTS
ECTS 2.5
Goal(s)
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.
Contact Christophe BOBINEAUContent(s)
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
Test
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
Additional Information
Curriculum->ENGINEERING systm of information->Semester 4
Team->Database, IS and knwoledge
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.