Data are now central to our information society. An adaptive, reliable and efficient data management is crucial for the effective operation of enterprises and their evolution. Database Management Systems (DBMS) tools are vital for ensuring that management. The objective of this course is to present the fundamentals of DBMS, their architecture and their evolutions.
We remind the principles of Relational DBMS (the most used): models, properties of relations (normalization) and manipulation languages. The design aspects of database schemas will be revisited. We will also present extensions of relational systems (non-relational systems and object-relational ones). We also discuss mechanisms such as active rules for associating behavior to relations and, in particular, to ensure the verification of integrity constraints on data.
We will study the architecture of Database Management Systems, looking their various components including the transactional core constituting an essential element of these systems. We will discuss the main aspects (techniques, algorithms) with the transactional support mechanisms for fault tolerance, concurrency control and consistency management. We will also look at query evaluation and optimization techniques, algebraic optimization techniques, data structures and methods for indexing data and other data paths.
We conclude the course with an overview of developments in the field (models, languages, system) related to Big Data phenomenon.Prerequisites
Databases simple principles
Written exams (during 3h for the first part and 2h for the second part) + practical tests (second period); documents are allowed.
• Examen écrit + épreuves pratiques (période 5) : E1a, P5 = E1a
• Examen écrit + épreuves pratiques (période 6) : E1b, P6 = E1b
N1 = 0,5 x P5 + 0,5 x P6
• Examen écrit de 3h ou épreuve orale : E2
N2 = (Max(P5, P6) + 2 x E2)/3
The course exists in the following branches:
Course ID : 4MM1SGBD
The course is attached to the following structures:
You can find this course among all other courses.
have a look to
Date of update January 15, 2017