Search Log in FR EN

Mécanismes internes et fonctionnement des SGBD RelationnelsInformatique Fondamentale (STI)

FISEFISA STI Semester 7 Common Core Machine translation

Internal Mechanisms and Operation of Relational DBMS

Teaching unit Fundamental Computer Science · S07T_INF3  |  EC Code S07T_INF3-2
Course on Celene
8ECTS (EU)
1Coefficient
21:20Hours

Séquencement

2C 2TD 2C 2TD 2C 2TD 2C 2TD
↳ Clemente Patrice
C TD C TD C TD C TD
↳ Nguyen Benjamin
C TD C TD C TD C TD

Learning objectives

  • Allow an understanding of the internal functioning (concepts and algorithms) of a GBS with a level allowing to implement a query execution engine on a relational database with digital data.

Prerequisites

ModuleTeaching unitSemester
DatabasesDevelopment and Mathematics for EngineersS6

Program

  • GBS Performance: Files, Indexing, Query Optimization, Physical Operators
  • SGBD Security: Transactions and Failure Recovery

Assessment

  • Continuous control, with QCM type evaluation and paper table duty

References

  • Mr Bouzeghoub, Mr Jouve, P.Pucheral, "Models for storage and access: placement, indexing, navigation", eds Hermès, 1998. ISBN: 9782866017156 G. Gardarin, "Databases", Eyrolles, ISBN: 2-212-11281-5
  • MOOC: S. Abiteboul, B. Nguyen, Ph. Rigaux, "Relational databases: Understanding to master" presented on France Université Numérique
  • http://sys.bdpedia.fr/ by Philippe Rigaux

Skills

4
Ref.VerbDescriptionLevel
C1_4designa GBD running engine3
C2_1managean index3
C2_2analyzeTransactions2
C2_2analyzea query execution tree3

SecNumEdu Skills

SkillLecture hoursPractical hoursEntry levelExit level
Database security101002
GBS Performance: Files, Indexing, Query Optimization, Physical Operators, GBS Security: Transactions and fault recovery