Database II

Information

Teacher coordinator	Géraldine Del Mondo
Teacher(s)	Géraldine Del Mondo, Pierrick Tranouez
Language	French
Credits	2.5
Teaching	Lectures : 10.5h Exercises : 21h
Web site	http://moodle.insa-rouen.fr/course/view.php?id=31

Aim and objective

Deal with the relational data base physical concepts (storage) and implementation of a data base in a Java application. We use SQL extensions and Object Relational Mapping (ORM) concepts. Two courses aim to introduce to particular databases (geographical data, noSQL).

This EC aims to :

Know the principles of data storage in a relational database (e.g. index), deepen your skills in the optimization of SQL queries
Know how to implement a Java application using JDBC
Understand the principle of the patterns related to the mapping between a relational database and an object-oriented application
Understand the specificities of spatial data and its implementation in a geographical database
Understand the specificities of the noSQL databases and their uses for relational databases

Outcome learning

INSA reference data :
- Adapter un modèle en fonction de contraintes (physiques, systèmes, temps, complexité, etc.) [1P]
- Maîtriser un langage d'interrogation de base de données [3P]
CNISF reference data :
- J40B [3P]

1 - Notion, 2 - Concept, 3 - Application, I - fully, P - incomplete

Course description

Relational database development
- Storage
- An example of a particular type of information: geographical database
- Inheritance
- Object Relational Mapping (ORM)
- Evolution of databases: preview of an emergent model (noSQL)

Prerequisites

Data bases 1,

Algorithm

Bibliography

Bases de Données : Objet et relationnelle, G. Gardarin, Eyrolles, (Partie relationnelle)

Assessment

Final exam: 100%