Database Management Systems

The aim of this course is to enable students to acquire competence in the field of databases and their implementation. In addition to familiarizing students with the technical characteristics of the database management systems used, the course covers methodological aspects aimed at making the best use of the functionalities offered by these systems. We explain the fundamental concepts of database implementation in a relational context. At a more detailed level, the internal workings of DBMS will be studied: DBMS organization, query optimization, concurrent access management and failure recovery mechanisms... Numerous exercises during tutorials illustrate the concepts covered in the course. A practical application is carried out by students using the ORACLE DBMS
Outline

Comparison of database management system and multi-file management system concepts
Database modeling: conceptual models
Relational model (relational algebra, normal forms, ....)
Data manipulation languages: SQL
Learning the ORACLE DBMS
Physical organization of relational DBMS
Implementation of relational operators
Query optimization
Transaction and concurrent access
General DBMS security issues
Fault recovery mechanisms

Skills
C2. Level 2C3. Level 2C4. Level 3C5. Level 2C7. Level 2C8. Level 3

Algorithms, file management.

- Comparison of database management system and multi-file management system concepts
- Database modeling: conceptual models
- Relational model (relational algebra, normal forms, etc.))
- Data manipulation languages: SQL
- Learning the ORACLE DBMS
- Physical organization of relational DBMS
- Implementation of relational operators
- Query optimization
- Transaction and concurrent access
- General security issues in DBMS
- Failover mechanisms

Handouts.