Data processing and storage

Objectives
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, from design to development. Numerous exercises during the tutorials illustrate the concepts covered in the course. A practical application is carried out by students using a DBMS.
Acquired skills

Be able to use and implement databases.
Mobilize a broad field of fundamental and technical sciences related to avionics and space systems, and have the associated capacity for analysis and synthesis
Have a global systems approach
Communicate and work as part of a team

Algorithms, Programming: AP5NUCBI

Contents

Introduction to database management systems
Database modeling: conceptual models
Relational model (relational algebra, normal forms, ...)
Data manipulation languages: SQL
Learning Postgres DBMS, PHP
Physical organization of relational DBMS
Implementing relational operators
Optimizing queries
Transaction and concurrent access
Fault recovery mechanisms

Teaching method
Each lecture session will be followed by a practical session to acquire both theoretical and methodological concepts. The practical sessions will take the form of an application project, enabling engineering students to design and develop a database using a Postgres DBMS. The course, tutorials and practical sessions will be based on the school's Moodle platform.

Digital maintenance