- 4MMFSGBD

Goal(s)

This course covers the operation of DBMSs in order to fully understand their characteristics and to be able to use them effeciently.

Responsible(s)

Christophe BOBINEAU

Content(s)

The relational model is very widespread and offers good performance if the physical schema is well configured (this is the job of the DBMS administrator), but scaling proves difficult. We will study the internal structures of DBMSs to understand how to improve efficiency: data storage/access media, accelerating structures/indexes, query evaluation and optimization algorithms, and transaction management mechanisms.
The Object extensions of the Relational Model will also be developed here.

• Storage/Indexing
• Triggers and Stored Procedures
• Query Evaluation/Optimization
• Oracle and MySQL Practical Exercises
• Transaction Operations
• Caching
• Project

Utilisation des SGBD (4MMUSGBD)

Test

Evaluation : 33% of TP et projets notés + examens écrits et oraux and 67% of Examen écrit (3h)

Resit : 33% of TP et projets notés + examens écrits et oraux (reported score) and 67% of Examen écrit (3h)

NORMAL SESSION
CC : Evaluated practices and Project
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 - Core curriculum - Semester 8

Additional Information

Course ID : 4MMFSGBD
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.