Number of hours
- Lectures 16.5
- Projects -
- Tutorials 16.5
- Internship -
- Laboratory works -
- Written tests -
ECTS
ECTS 3.0
Goal(s)
This course focuses on DBMS performance. The Object-Relational data model and system aspects of DBMS will be studied.
Responsible(s)
Christophe BOBINEAU
Content(s)
Relational data model is widely used and offers good performance if the internal schema is well implemented (that is the role of the DMBS administrator), but scalability while maintaining good performance is difficult to achieve.
In this course, we will study Object extensions of the relational data model. They are far more flexible concerning data representation and permit to obtain far more performance by the use of object references and data collections in tables.
Then we will study internal structures and algorithms implemented in DBMS: storage systems/data access, accelerating structures/indices, query evaluation and optimization algorithms, and transaction management mechanisms.
Principles of database management systems
Object programming concepts
Test
NORMAL SESSION
Written exam (3 hours) and on-course evaluation
Documents:
- Allowed: personal notes and foreign language dictionary
- Forbidden: books
Equipment:
- Allowed: calculator
- Forbidden: everything else
SECOND SESSION
Written exam (2 or 3 hours)
Documents:
- Allowed: personal notes and foreign language dictionary
- Forbidden: books
Equipment:
- Allowed: calculator
- Forbidden: everything else
N1 = 1/3 TP + 2/3 Examen écrit
N2 = 1/3 N1 + 2/3 Examen écrit
Calendar
The course exists in the following branches:
- Curriculum - Information Systems Engineering - Semester 8
Additional Information
Course ID : 4MMCSGB6
Course language(s): 
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.