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
Evaluation : 33% of TP notés and 67% of Examen Ecrit (3h)
Resit : 33% of TP notés (reported score) and 67% of Examen Ecrit (3h)
NORMAL SESSION
CC : Evaluated practices
ET : Written exam (3 hours)
Documents:
- Allowed: 2 A4 double-sided paper sheets and foreign language dictionary
- Forbidden: books
Equipment:
- Allowed: calculator
- Forbidden: everything else
N1 = 1/3 CC + 2/3 ET
SECOND SESSION
ET : Written exam (3 hours)
Documents:
- Allowed: 2 A4 double-sided paper sheets and foreign language dictionary
- Forbidden: books
Equipment:
- Allowed: calculator
- Forbidden: everything else
N2 = 1/3 CC (reported) + 2/3 ET
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:
- Team Database, IS and knwoledge
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.