Data persistence I

Quadrimestre 2 -

36 hours

Coordinator : NPX

Teaching staff : NPX, SDR, JSS, HAL, CUV

General course description

The course presents an introduction to the elements involved in managing data persistence. It highlights the main differences between an FMS (File Management System) and a DBMS (Data Base Management System).

Learning basic skills

Basis of algorithmics

Course Aims

  • Understand the notions of representation, description and semantics of the data,
  • Know how to manipulate different file organizations, perceive their implementations
  • Provide the notions necessary to understand later (second-year course) the parameters of a relational BD physical schema,
  • Be able to write and understand queries in a relational database.

Learning outcomes

  • Be able to write structured file manipulation algorithms in a suitable pseudo-code,
  • Know the principles of the organization of the data in flat or structured files, and to be able to use them,
  • Know the basic principles of the relational databases,
Be able to write and understand queries in a relational database.

Course Outline

  • Introduction
  • Sequential file processing algorithms
  • Change processing algorithms
  • Database schema: analysis and creation
  • BD relational - SQL queries

Bibliography

  • Bases de données Concepts, utilisation et développement de Jean-Luc Hainaut, Dunod, 3ème édition