This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
|
teaching:infoh415 [2020/12/04 15:04] ezimanyi [Topics for the current academic year] |
teaching:infoh415 [2021/09/21 15:40] gdejaege |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ====== INFO-H-415: Advanced Databases ====== | ====== INFO-H-415: Advanced Databases ====== | ||
| + | |||
| + | ===== Last important announcment ==== | ||
| + | |||
| + | 21/09/2021: | ||
| + | Hello everyone, | ||
| + | |||
| + | The first exercise session will take place Thursday from 14:00-16:00 in the UB4.130 computer room. It is however strongly advised to bring your own computer and to install the required applications as indicated on the webpage of the exercise sessions (https://cs.ulb.ac.be/public/teaching/infoh415/tp, Before Session 1). | ||
| + | |||
| + | See you on Thursday, | ||
| + | |||
| + | Gilles | ||
| ===== Lecturer ===== | ===== Lecturer ===== | ||
| Line 32: | Line 43: | ||
| The course is given during the first semester | The course is given during the first semester | ||
| - | * Lectures on Mondays from 4 pm to 6 pm at the room S.AY2.108 **except 14/10/2019 which is a practical session in S.UB4.130** | + | * Lectures on Mondays from 4 pm to 6 pm |
| - | * Exercises on Thursdays from 2 pm to 4 pm at the room S.UB4.130 <del>**except 24/10/2019 which is a lecture in S.UD2.119** | + | * Exercises on Thursdays from 2 pm to 4 pm |
| - | </del> | + | |
| /* | /* | ||
| Line 98: | Line 108: | ||
| * IBM, A Matter of Time: Temporal Data Management in DB2 for z/OS. ({{teaching:infoh415:a_matter_of_time.pdf|version pdf}}) | * IBM, A Matter of Time: Temporal Data Management in DB2 for z/OS. ({{teaching:infoh415:a_matter_of_time.pdf|version pdf}}) | ||
| ===== Links ===== | ===== Links ===== | ||
| - | * Temporal databases | + | * Spatial databases |
| - | * [[http://timecenter.cs.aau.dk/|TimeCenter]], an international research centre for temporal databases. | + | * [[https://postgis.net/workshops/postgis-intro/|Introduction to PostGIS]] |
| - | * [[http://www.timeconsult.com/Software/Software.html|TimeDB]], a temporal relational database | + | * [[https://learn.crunchydata.com/postgis|Crunchy Data Interactive PostGIS Learning Portal]] |
| + | * Spatio-temporal (or mobility) databases | ||
| + | * [[https://mobilitydb.com/|MobilityDB]] | ||
| * Object databases | * Object databases | ||
| * [[http://www.odbms.org/|ODBMS.ORG]], portal of ressources about object databases. | * [[http://www.odbms.org/|ODBMS.ORG]], portal of ressources about object databases. | ||
| - | * [[http://www.db4o.com/|db4o]], an open source object database. | ||
| * [[http://www.objectstore.com/datasheet/index.ssp|ObjectStore]], an object database | * [[http://www.objectstore.com/datasheet/index.ssp|ObjectStore]], an object database | ||
| * [[http://www.objectivity.com|Objectivity]], an object database | * [[http://www.objectivity.com|Objectivity]], an object database | ||
| - | * [[http://www.versant.com/|Versant]], an object database | ||
| - | * [[http://www.jade.co.nz/jade/|Jade]], an object database | ||
| - | * [[http://sourceforge.net/projects/ozone/|Ozone]], an object database | ||
| * Post-relationnal databases | * Post-relationnal databases | ||
| - | * [[http://www.fresher.com/|Matisse]] | ||
| * [[http://www.intersystems.com/cache/index.html|Caché]] | * [[http://www.intersystems.com/cache/index.html|Caché]] | ||
| - | * Spatial databases | ||
| - | * [[https://postgis.net/workshops/postgis-intro/|Introduction to PostGIS]] | ||
| ===== Course Slides ===== | ===== Course Slides ===== | ||
| Line 135: | Line 140: | ||
| */ | */ | ||
| - | Students, in groups of two, will realize a project in a topic relevant to advanced databases. Examples of topics are given in the next section of this document. | + | Students, in groups of two, will realize a project in a topic relevant to advanced databases. Examples of topics are given in the next section of this document. Please notice that the template for these topics is "<Technology> and <Tool>". |
| Each group will study a database technology and illustrate it with an application developed in a database management system to be chosen (e.g., SQL Server, PostgreSQL, MongoDB, etc.). The topic should be addressed in a technical way, to explain the foundations of the underlying technology. The application must use the chosen technology. | Each group will study a database technology and illustrate it with an application developed in a database management system to be chosen (e.g., SQL Server, PostgreSQL, MongoDB, etc.). The topic should be addressed in a technical way, to explain the foundations of the underlying technology. The application must use the chosen technology. | ||
| Line 150: | Line 155: | ||
| The project will count for 25% of the final grade. | The project will count for 25% of the final grade. | ||
| - | The project must be submitted by **Monday, December 14, 2020**. | + | The project must be submitted by **Monday, December 13, 2021**. |
| - | + | ||
| - | ===== Examples of topics from the previous academic year ===== | + | |
| - | + | ||
| - | You can take a look at the [[https://db-engines.com/en/|DB-Engines]] web site to get an idea of the currently available technologies and tools. Examples of previous topics are given next: | + | |
| * Analytical databases and Endeca | * Analytical databases and Endeca | ||
| Line 165: | Line 166: | ||
| * Embedded databases and BerkeleyDB | * Embedded databases and BerkeleyDB | ||
| * In-memory databases and Kdb+, MemSQL, Oracle TimesTen, Memcached, .... | * In-memory databases and Kdb+, MemSQL, Oracle TimesTen, Memcached, .... | ||
| - | * Key-value stores and Redis, Voldermort, ... | + | * Key-value stores and BerkeleyDB, DynamoDB, Redis, Voldermort, ... |
| * Multimedia databases and Oracle | * Multimedia databases and Oracle | ||
| * Multi-model databases and MarkLogic | * Multi-model databases and MarkLogic | ||
| * NewSQL databases and VoltDB | * NewSQL databases and VoltDB | ||
| - | * Object-oriented databases and db4o | + | * Object-oriented databases and ObjectBox, Perst |
| * Real-time databases and Firebase | * Real-time databases and Firebase | ||
| * Search engines and Solr, ElasticSearch, Sphinx ... | * Search engines and Solr, ElasticSearch, Sphinx ... | ||
| * Spatial raster databases and Rasdaman | * Spatial raster databases and Rasdaman | ||
| - | * Stream databases and Apache Kafka | + | * Stream databases and Apache Kafka, Event Stores |
| * Time series databases and Influx DB, Kdb+, ... | * Time series databases and Influx DB, Kdb+, ... | ||
| * XML databases and BaseX | * XML databases and BaseX | ||
| - | |||
| ===== Topics for the current academic year ===== | ===== Topics for the current academic year ===== | ||
| - | * Analytical databases and Endeca: Ndele-A-Mulenghe Mashini | + | * Cloud databases and Microsoft Azure SQL: Davide Rendina, Margarita Hernandez |
| - | * Cloud databases and Microsoft Azure: Michel Nguyen-Khan and Soufian El Bakkali Tamara | + | * Column stores and Cassandra: Md Jamiur Rahman Rifat, Khushnur Binte Jahangir |
| - | * Column stores and Cassandra: Wassil Choujaa and Ismaila Abdoulahi Adamou | + | * Datawarehouses and Apache Hive: Nicole Zafalón, Andrés Espinal |
| - | * Distributed databases and SQL Server: Yasmina El Oudghiri | + | * Distributed databases and SQL Server: Asha Seif, Kainaat Amjid |
| - | * Document stores and MongoDB: Beata Janiak and Astrid Asoumoy | + | * Document stores and MongoDB: Hang Yu, Zhiyang Guo |
| - | * Key-value databases and BerkeleyDB: Mohamed Amchemer and Frank Jordan Kuete Kamta | + | * In-memory databases and Memcached: Diogo Repas and Sandra Hillergren |
| - | * Key-value databases and DynamoDB: Abdeslam Bakkali Taheri and <TBD> | + | * Key-value databases with Cloud bigtable and Redis: Luiz Fonseca, Zyrako Musaj, Yanjian Zhang and Zhicheng Luo |
| - | * Key-value databases and Redis: Yahya Bakkali and Maxime Hauwaert | + | * Multimedia databases and Oracle: Wassim Belgada, Imestir Ibrahim |
| - | * Multimedia databases and Oracle: Fan Chen and Noëmie Muller | + | * Object-oriented databases and ObjectBox: Filip Sotiroski, Niccolo Morabito |
| - | * NewSQL databases and VoltDB: Sid Ahmed Bouzouidja and Louis-Maxime Piton | + | * Object-oriented databases and Perst: Andrea Gonzato, Pietro Ferrazi |
| - | * Object-oriented databases and Perst: Nicolas Boucher and Romain Perret | + | * Real-time databases and Firebase: Himanshu Choudhary, Sergio Postigo, Tejaswini dhuppad |
| - | * Object-oriented databases and ObjectBox: Ajouaou Soufiane and El Achouchi Iliass | + | * Spatial raster databases and Rasdaman: Adam Broniewski, Victor Divi |
| - | * Real-time databases and Firebase: Ali Dhanani and Cleis Kounalis | + | * Stream databases and Apache Kafka: Vlada Kylynnyk, Mahmut Asım Onat |
| - | * Search engines and Solr, ElasticSearch: Tatiana Millan Poveda and Erick Escobar Gallardo | + | * Time series databases with Influx DB and Kdb+: Mohammad Zain Abbas, Muhammad Ismail, Yi Wu, Zhonghan Li |
| - | * Stream databases and Apache Kafka, Event Stores: Alexandre Libert and Antoine De Selys | + | * Search engines and ElasticSearch: Alexandre Chapelle, Nicolas Dardenne |
| - | * Time series databases and InfluxDB: Nada Elghazouani and Jean-Charles Nsangolo | + | |
| - | * XML databases and BaseX: Sara Bouglam | + | |