Program Overview

University Programs

The university offers a range of programs across various faculties and schools.

Faculties and Schools

• HEALTH
  • Lyon Est Faculty of Medicine
  • Lyon Sud Faculty of Medicine and Midwifery - Charles Mérieux
  • Faculty of Odontology
  • Institute of Pharmaceutical and Biological Sciences
  • Institute of Rehabilitation Sciences and Techniques
• SCIENCE AND TECHNOLOGY
  • National Higher Institute of Teaching and Education
  • University Institute of Technology Lyon 1
  • Institute of Financial Science and Insurance
  • Lyon Observatory
  • Polytech Lyon
  • UFR STAPS (Sciences and Techniques of Physical and Sports Activities)
  • UFR FS (Chemistry, Mathematics, Physics)
  • UFR Biosciences (Biology, Biochemistry)
  • GEP (Electrical Process Engineering - Component Department)
  • IT (Component Department)
  • Mechanics (Component Department)

Diplomas and Degrees

The university offers various diplomas and degrees, including:

• Diploma diagram
• License
• Master
• Doctorate
• PURPOSE: University Bachelor of Technology
• Professional License
• DES: State Diploma in Health
• DEUST: S&T University Studies Diploma
• DI: Engineering degree
• DIU: Inter-University Diploma
• DU: University diploma
• AEU: Certificate of University Studies

Unit of Teaching: Database 2

Description

The Teaching Unit "Database 2" is a course that aims to present advanced aspects of databases to students. The objective is to introduce students to other facets, more complex, on the presentation, design, and interrogation of data.

Program

The program of this unit will cover the following topics:

• Distributed databases (Fragmentation, Decomposition, Replication, Integration, Allocation, distributed DBMS)
• Object databases: Two approaches
  • Object DBMS (design of an object database and its querying via SQL3)
  • From relational to Object programming via ORM (Object Relational Mapping)
• XML databases (design, query, XPath, XQuery)

Details

• Number of credits: 2 ECTS
• Apogee code: I3020IF
• Type of teaching: Lectures (CM), Directed Work (TD), Practical Work (TP), Duration of independent project (PRJ), Personal tutored activity (student), Supervised tutored activity (teacher)
• Prerequisites and objectives: Relational algebra, set theory, SQL query language
• Targeted intermediate learning outcomes and skills: Master advanced databases, new concepts and paradigms