année académique
2024-2025

Titulaire(s) du cours

Esteban ZIMANYI (Coordonnateur)

Crédits ECTS

5

Langue(s) d'enseignement

anglais

Contenu du cours

Active Databases

Taxonomy of concepts. Applications of active databases: integrity maintenance, derived data, replication. Design of active databases: termination, confluence, determinism, modularisation.

Temporal Databases

Temporal data and applications. Time ontology. Conceptual modeling of temporal aspects. Manipulation of temporal data with standard SQL.

Object Databases

Object-oriented model. Object Persistance. ODMG standard: Object Definition Language and Object Query Language.

Spatial Databases

Spatial data and applications. Space ontology. Conceptual modeling of spatial aspects. Manipulation of spatial data with standard SQL.

Objectifs (et/ou acquis d'apprentissages spécifiques)

Today, databases are moving away from typical management applications, and address new application areas. For this, databases must consider (1) recent developments in computer technology, as the object paradigm and distribution, and (2) management of new data types such as spatial or temporal data. This course introduces the concepts and techniques of some innovative database applications.

Pré-requis et Co-requis

Cours ayant celui-ci comme co-requis

Méthodes d'enseignement et activités d'apprentissages

Lectures are accompanied with laboratory exercices realized on computer rooms.

Références, bibliographie et lectures recommandées

  • C. Zaniolo et al., Advanced Database Systems, Morgan Kaufmann, 1997

  • R.T. Snodgrass, Developing Time-Oriented Database Applications in SQL, Morgan Kaufmann, 2000 (version pdf)

  • R.G.G. Cattel et al., The Object Database Standard: ODMG 3.0, Morgan Kaufmann, 2000

  • Jim Melton and Alan R. Simon, SQL: 1999 - Understanding Relational Language Components, Morgan Kaufmann, 2001

  • Jim Melton, Advanced SQL: 1999 - Understanding Object-Relational and Other Advanced Features, Morgan Kaufmann, 2002

  • Philippe Rigaux, Michel Scholl, Agnès Voisard, Spatial Databases: With Application to GIS, Morgan Kaufmann, 2001

Autres renseignements

Contacts

ezimanyi@ulb.ac.be

Evaluation

Méthode(s) d'évaluation

  • Autre

Autre

Written examination covering the topics taught in the course.

Further, students, in groups of two, will realize a project in a topic relevant to advanced databases. Each group will study a database technology and illustrate it with an application developed in a database management system to be chosen (e.g., Oracle, PostgreSQL, DB2, SQL Server, mySQL, etc..). The topic should be addressed in a technical way, to explain the underlying technologies. The application must use the specific technology manipulated.

Langue(s) d'évaluation

  • anglais

Programmes