Advanced Data Bases

Pre-requisites: II.1101
Level: Fundamental
Organization: Lectures + Tutorials + labs + presentations
Assessment: Exam (50%) + Presentation (20%) + Reports (30%)

Overview

Complex systems implementation often requires creation, use or consolidation of structured data in order to save, search, or interact with other systems. This module provides a set of skills that complement those acquired during the first-year and aims to design and manage complex databases.

Learning Objectives

Skills

The module aims to prepare future engineers to design and administrate relational database.
Emphasis is placed on :
•    The use of a methodology for designing database.
•    Control of physical and logical architecture of a relational database.
•    The process of optimizing a database.
•    The administration of a database.
•    Managing concurrency.

The module discusses the limitations of the relational model and introduces the post-relational models.

Knowledge

Concepts

  • Relational model
    • Relational Algebra
    • Normal form
    • PL/SQL Language
  • Integrity and Transaction
  • Indexation
  • Queries Optimization 
  • JDBC

Know-how

  • Design a normalized relational schema
  • Formulation of queries in relational algebra
  • Implementation of an Oracle database and using SQL and PL/SQL: development, management, concurrency, etc.
  • Administration and optimization of a database

Teaching method

The module will run in lectures, tutorials and labs. Tutorials start from the second session of lectures and are used to practice modeling and designing relational databases. Labs sessions are used to implement and administer an Oracle database. During the last lab session students will use JDBC in order to connect a JAVA program to a database.

Bibliography

•    Bases de données objet & relationnel. Paris: Eyrolles. Gardarin, G.(1999).
•    Conception des bases de données relationnelles - En pratique (Vuibert, 2001), AKOKA, COMYN-WATTIAU
•    Gestion et administration des bases de données (Dunod, 2003), BOUJLIDA
•    Date, CJ (2000). An Introduction to Database Systems (7th ed.). Reading, MA: Addison-Wesley.
•    http://georges.gardarin.free.fr/Cours_Total/IndexTotal.html