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 [2018/09/17 16:59] ezimanyi [Topics for the current academic year] |
teaching:infoh415 [2020/10/01 11:20] ezimanyi [Objectives] |
||
---|---|---|---|
Line 32: | Line 32: | ||
The course is given during the first semester | The course is given during the first semester | ||
- | * Lectures on Thursdays from 2 pm to 4 pm at the room S.UA4.218 | + | * 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** |
- | * Exercises on Mondays from 4 pm to 6 pm at the room S.UB4.130 | + | * 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** |
- | + | </del> | |
- | /* | + | |
- | {{:teaching:infoh415:infoh415-1415-courseplan-rev.1.pdf|Schedule}} | + | |
- | */ | + | |
/* | /* | ||
+ | {{:teaching:infoh415:infoh415schedule2018.pdf|Schedule}} | ||
+ | |||
* [[http://www.google.com/calendar/embed?src=dug2eihu8tqtnkjhmtuupj0je0%40group.calendar.google.com&ctz=Europe/Brussels|Online schedule]] | * [[http://www.google.com/calendar/embed?src=dug2eihu8tqtnkjhmtuupj0je0%40group.calendar.google.com&ctz=Europe/Brussels|Online schedule]] | ||
*/ | */ | ||
+ | |||
+ | |||
+ | |||
===== Objectives ===== | ===== Objectives ===== | ||
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. | 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. | ||
+ | |||
+ | |||
+ | ===== Objectives New ===== | ||
+ | |||
+ | Test and test | ||
===== Content ===== | ===== Content ===== | ||
Line 56: | Line 62: | ||
Temporal data and applications. Time ontology. Conceptual modeling of temporal aspects. Manipulation of temporal data with standard SQL. | Temporal data and applications. Time ontology. Conceptual modeling of temporal aspects. Manipulation of temporal data with standard SQL. | ||
- | ==== Object Databases ==== | + | ==== Graph Databases ==== |
- | Object-oriented model. Object Persistance. ODMG standard: Object Definition Language and Object Query Language. | + | ... |
==== Spatial Databases ==== | ==== Spatial Databases ==== | ||
Line 78: | Line 84: | ||
* Jim Melton and Alan R. Simon, SQL: 1999 - Understanding Relational Language Components, Morgan Kaufmann, 2001 | * 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 | * Jim Melton, Advanced SQL: 1999 - Understanding Object-Relational and Other Advanced Features, Morgan Kaufmann, 2002 | ||
- | * R.G.G. Cattel et al., The Object Database Standard: ODMG 3.0, Morgan Kaufmann, 2000 ({{:teaching:odmg.pdf|version pdf}}) | + | * Ian Robinson, Jim Webber, Emil Eifrem, Graph Databases, 2nd Edition, O'Reilly Media, 2015 |
* Philippe Rigaux, Michel Scholl, Agnès Voisard, Spatial Databases: With Application to GIS, Morgan Kaufmann, 2001 | * Philippe Rigaux, Michel Scholl, Agnès Voisard, Spatial Databases: With Application to GIS, Morgan Kaufmann, 2001 | ||
Line 88: | Line 94: | ||
* E. Zimányi, Temporal Aggregates and Temporal Universal Quantifiers in Standard SQL, SIGMOD Record, 35(2):16-21, 2006. ({{http://code.ulb.ac.be/dbfiles/Zim2006article.pdf|version pdf}}) | * E. Zimányi, Temporal Aggregates and Temporal Universal Quantifiers in Standard SQL, SIGMOD Record, 35(2):16-21, 2006. ({{http://code.ulb.ac.be/dbfiles/Zim2006article.pdf|version pdf}}) | ||
* Krishna Kulkarni, Jan-Eike Michels, Temporal features in SQL:2011, SIGMOD Record, 41(3):34-43, 2012. ({{teaching:infoh415:TempFeaturesSQL2011.pdf|version pdf}}) | * Krishna Kulkarni, Jan-Eike Michels, Temporal features in SQL:2011, SIGMOD Record, 41(3):34-43, 2012. ({{teaching:infoh415:TempFeaturesSQL2011.pdf|version pdf}}) | ||
- | * Gregory Sannik, Fred Daniels, Enabling the Temporal Data Warehouse, Teradata White paper. ({{teaching:infoh415:teradata_enabling_temporal.pdf|version pdf}}) | + | * Michael H. Böhlen, Anton Dignös, Johann Gamper, Christian S. Jensen, Temporal Data Management: An Overview, Proc. of the 7th European Summer School on Business Intelligence and Big Data, eBISS 2017, Bruxelles, Belgium, LNBIP 324, Springer 2018. ({{teaching:infoh415:bohlen.pdf|version pdf}}) * Gregory Sannik, Fred Daniels, Enabling the Temporal Data Warehouse, Teradata White paper. ({{teaching:infoh415:teradata_enabling_temporal.pdf|version pdf}}) |
* Richard T. Snodgrass, A Case Study of Temporal Data, Teradata White paper. ({{teaching:infoh415:teradata_temporal_case_study.pdf|version pdf}}) | * Richard T. Snodgrass, A Case Study of Temporal Data, Teradata White paper. ({{teaching:infoh415:teradata_temporal_case_study.pdf|version pdf}}) | ||
* Teradata, Temporal Table Support. ({{teaching:infoh415:teradata_temporal_support.pdf|version pdf}}) | * Teradata, Temporal Table Support. ({{teaching:infoh415:teradata_temporal_support.pdf|version pdf}}) | ||
Line 108: | Line 114: | ||
* [[http://www.fresher.com/|Matisse]] | * [[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 113: | Line 121: | ||
* {{teaching:infoh415:activenotes.pdf|Active databases}} | * {{teaching:infoh415:activenotes.pdf|Active databases}} | ||
* {{teaching:infoh415:temporalnotes.pdf|Temporal databases}} | * {{teaching:infoh415:temporalnotes.pdf|Temporal databases}} | ||
- | * {{teaching:infoh415:objectnotes.pdf|Object databases}} | + | /* * {{teaching:infoh415:objectnotes.pdf|Object databases}} */ |
+ | * {{:teaching:infoh415:graph_databases_notes.zip|Graph Notes}} | ||
* {{teaching:infoh415:spatialnotes.pdf|Spatial databases}} | * {{teaching:infoh415:spatialnotes.pdf|Spatial databases}} | ||
Line 142: | Line 151: | ||
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 18, 2017**. | + | The project must be submitted by **Monday, December 16, 2019**. |
===== Examples of topics from the previous academic year ===== | ===== 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 | ||
* Cloud databases and Microsoft Azure | * Cloud databases and Microsoft Azure | ||
* Column stores and Cassandra, Hbase, ... | * Column stores and Cassandra, Hbase, ... | ||
- | * Database Security and Oracle | + | * Data warehouses and Apache Hive |
* Deductive Databases and XSB | * Deductive Databases and XSB | ||
* Distributed databases and SQL Server, DynamoDB, ... | * Distributed databases and SQL Server, DynamoDB, ... | ||
* Document stores and Cloudant, Couchbase, CouchDB, MongoDB, RavenDB, RethinkDB, ... | * Document stores and Cloudant, Couchbase, CouchDB, MongoDB, RavenDB, RethinkDB, ... | ||
* Embedded databases and BerkeleyDB | * Embedded databases and BerkeleyDB | ||
- | * Graph Databases and Neo4J, OrientDB, ... | + | * In-memory databases and Kdb+, MemSQL, Oracle TimesTen, Memcached, .... |
- | * In-memory databases and Kdb+, MemSQL, Oracle TimesTen, .... | + | |
* Key-value stores and Redis, Voldermort, ... | * Key-value stores and Redis, Voldermort, ... | ||
* Multimedia databases and Oracle | * Multimedia databases and Oracle | ||
Line 161: | Line 171: | ||
* NewSQL databases and VoltDB | * NewSQL databases and VoltDB | ||
* Object-oriented databases and db4o | * Object-oriented databases and db4o | ||
- | * Object-relational mappings and Entity Framework, Hibernate, Java Data Objects, ... | ||
* Real-time databases and Firebase | * Real-time databases and Firebase | ||
- | * Spatial databases and SQL Server | + | * Search engines and Solr, ElasticSearch, Sphinx ... |
- | * Spatial 3D Databases and PostgreSQL | + | * Spatial raster databases and Rasdaman |
+ | * Stream databases and Apache Kafka | ||
+ | * 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 ===== | ||
- | /* | + | |
- | * Kaïs Albichari, Tanguy d'Hose: {{:teaching:mongodb_2017.pdf|Document stores and MongoDB}} | + | * Cloud databases and Microsoft Azure: Michel Nguyen-Khan and Soufian El Bakkali Tamara |
- | * Alexis Reynouard, Rémy Detobel: {{:teaching:elasticsearch_2017.pdf|Search engines and Elastic Search}} | + | * Column stores and Cassandra: Wassil Choujaa and Ismaila Abdoulahi Adamou |
- | * Tiffany Ong Lopez, Sergio Ruiz Sainz: {{:teaching:ignite_2017.pdf|In-memory databases and Apache Ignite}} | + | * Document stores and MongoDB: Beata Janiak and Astrid Asoumoy |
- | * Sofia Yfantidou, Noor Zehra: {{:teaching:influxdb_2017.pdf|Time series DBs and InfluxDB}} | + | * Key-value databases and BerkeleyDB: Mohamed Amchemer and <TBD> |
- | * Todi Thanasi, Lev Denisov: {{:teaching:cassandra_2017.pdf|NoSQL databases and Cassandra}} | + | * Multimedia databases and Oracle: Fan Chen and <TBD> |
- | * Mi Zhou, Prabhdeep Minhas: {{:teaching:basex_2017.pdf|XML Databases and BaseX}} | + | * Object-oriented databases and Perst: Nicolas Boucher and Romain Perret |
- | * Lucie Bauwin, Nicolas Baudoux: {{:teaching:firebase_2017.pdf|Real-time databases and Firebase}} | + | * Real-time databases and Firebase: Ali Dhanani and Cleis Kounalis |
- | * Antoine Vandevenne, Akira Baes: {{:teaching:rethinkdb_2017.pdf|Document stores and RethinkDB}} | + | * Search engines and Solr, ElasticSearch: Tatiana Millan Poveda and Erick Escobar Gallardo |
- | * Marc Garnica, Batuhan Tuter: {{:teaching:pipelinedb_2017.pdf|Stream databases and PipelineDB}} | + | * Stream databases and Apache Kafka, Event Stores: Alexandre Libert and Antoine De Selys |
- | * Maksim Hrytsenia, Rui Liu: {{:teaching:hbase_2017.pdf|Column stores and HBase}} | + | * Time series databases and InfluxDB: Nada Elghazouani and Jean-Charles Nsangolo |
- | * Kumar Kshitij, Tran Quang Duy: {{:teaching:streamsql_2017.pdf|Stream Processing with StreamSQL and Apache Kafka}} | + | |
- | * Ozge Koroglu, Anna Turu Pi: {{:teaching:neo4jj_2017.pdf|Graph databases and Neo4J}} | + | |
- | * Kashif Rabbani, Ivan Putera Masli: {{:teaching:cockroachdb_2017.pdf|NewSQL Databases and CockroachDB}} | + | |
- | * Jayanthi Kambayatughar, Marie Elisabeth Heinrich: {{:teaching:azure_2017.pdf|Cloud databases and Microsoft Azure}} | + | |
- | * Dagoberto Herrera, Keneth Ubeda: {{:teaching:opentsdb_2017.pdf|Time series databases and OpenTSDB}} | + | |
- | * Bruno Baldez Correa, Yue Wang: {{:teaching:hibernate_2017.pdf|Object-relational mapping and Hibernate}} | + | |
- | * Raisa Uku, Fatemeh Shafiee: {{:teaching:redis_2017.pdf|Key-value stores and Redis}} | + | |
- | * Anastasiia Zavolozhina, Ferdiansyah Dolot: {{:teaching:db4o_2017.pdf|Object oriented databases and Db4o}} | + | |
- | * Batra Shubham, Liccardo Nathan: {{:teaching:berkeleydb_2017.pdf|Embedded databases and BerkeleyDB}} | + | |
- | * Yasin Arslan, Jacky Trinh: {{:teaching:ravendb_2017.pdf|Document stores and RavenDB}} | + | |
- | * Alex Buléon: {{:teaching:orientdb_2017.pdf|Multi-model databases and OrientDB}} | + | |
- | * Beyens Ziad, Nougba Hamza: {{:teaching:couchdb_2017.pdf|Document stores and CouchDB}} | + | |
- | * Aleksei Karetnikov, David Pieschacon: {{:teaching:arangodb_2017.pdf|Graph stores and ArangoDB}} | + | |
- | * Dany-Simone Efila Efila, Michel Noucha: {{:teaching:cloudant_2017.pdf|Document stores and Cloudant}} | + | |
- | * George Kagramanyan, Léni Poliseno: {{:teaching:couchbase_2017.pdf|Document stores and Couchbase}} | + | |
- | * Hajji Issam, Toure Ibrahim: {{:teaching:nuodb_2017.pdf|newSQL databases and nuoDB}} | + | |
- | * Madrane Sofiane, Pierre-Alexandre Bourdais: {{:teaching:perst_2017.pdf|Object-oriented embedded database and Perst}} | + | |
- | * Kirubel Yaekob, Yasmine Daoud: {{:teaching:sqlserversecurity_2017.pdf|Database security and SQL Server}} | + | |
- | * Bubacarr Jallow, Shafagh Kashef: {{:teaching:entityframework_2017.pdf|Object Relational Mapping and Entity Framework}} | + | |
- | */ | + | |