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.

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

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

1 exam and practical work.

N1=(E1+TP)/2
N2=E2