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 [2017/12/19 19:00] ezimanyi [Topics for the current academic year] |
teaching:infoh415 [2019/07/30 10:25] ezimanyi [Topics for the current academic year] |
||
---|---|---|---|
Line 10: | Line 10: | ||
===== Teaching Assistant ===== | ===== Teaching Assistant ===== | ||
- | * [[http://code.ulb.ac.be/code.people.php?id=1285|Dhananjay Ipparthi]] ([[dhananjay.ipparthi@ulb.ac.be ]]) | + | * [[Gilles.Dejaegere@ulb.ac.be|Gilles Dejaegere]] |
Line 35: | Line 35: | ||
* Exercises on Mondays from 4 pm to 6 pm at the room S.UB4.130 | * Exercises on Mondays from 4 pm to 6 pm at the room S.UB4.130 | ||
- | /* | + | {{:teaching:infoh415:infoh415schedule2018.pdf|Schedule}} |
- | {{:teaching:infoh415:infoh415-1415-courseplan-rev.1.pdf|Schedule}} | + | |
- | */ | + | |
Line 78: | Line 76: | ||
* 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 | + | * R.G.G. Cattel et al., The Object Database Standard: ODMG 3.0, Morgan Kaufmann, 2000 ({{:teaching:odmg.pdf|version pdf}}) |
* 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 86: | ||
* 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 142: | Line 140: | ||
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, ... | ||
Line 155: | Line 155: | ||
* Embedded databases and BerkeleyDB | * Embedded databases and BerkeleyDB | ||
* Graph Databases and Neo4J, OrientDB, ... | * Graph Databases and Neo4J, OrientDB, ... | ||
- | * In-memory databases and Kdb+, MemSQL, Oracle TimesTen, .... | + | * In-memory databases and Kdb+, MemSQL, Oracle TimesTen, Memcached, .... |
* Key-value stores and Redis, Voldermort, ... | * Key-value stores and Redis, Voldermort, ... | ||
* Multimedia databases and Oracle | * Multimedia databases and Oracle | ||
Line 161: | Line 161: | ||
* 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 databases and Rasdaman |
+ | * Stream databases and Apache Kafka | ||
+ | * Time series databases and Influx DB, Kdb+, ... | ||
* XML databases and BaseX | * XML databases and BaseX | ||
Line 170: | Line 171: | ||
===== 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}} | + | To be done |
- | * Alexis Reynouard, Rémy Detobel: {{:teaching:elasticsearch_2017.pdf|Search engines and Elastic Search}} | + | |
- | * Tiffany Ong Lopez, Sergio Ruiz Sainz: In-memory databases and Apache Ignite | + | |
- | * Sofia Yfantidou, Noor Zehra: Time series DBs and InfluxDB | + | |
- | * Todi Thanasi, Lev Denisov: NoSQL databases and Cassandra | + | |
- | * Mi Zhou, Prabhdeep Minhas: XML Databases and BaseX | + | |
- | * Lucie Bauwin, Nicolas Baudoux: Real-time databases and Firebase | + | |
- | * Antoine Vandevenne, Akira Baes: Document stores and RethinkDB | + | |
- | * Marc Garnica, Batuhan Tuter: Stream databases and PipelineDB | + | |
- | * Maksim Hrytsenia, Rui Liu: Column stores and HBase | + | |
- | * Kumar Kshitij, Arthur Valingot: Stream databases and StreamSQL | + | |
- | * Ozge Koroglu, Anna Turu Pi: {{:teaching:neo4jj_2017.pdf|Graph databases and Neo4J}} | + | |
- | * Kashif Rabbani, Ivan Putera Masli: NewSQL Databases and CockroachDB | + | |
- | * Jayanthi Kambayatughar, Marie Elisabeth Heinrich: Cloud databases and Microsoft Azure | + | |
- | * Dagoberto Herrera, Keneth Ubeda: {{:teaching:opentsdb_2017.pdf|Time series databases and OpenTSDB}} | + | |
- | * Bruno Baldez Correa, Yue Wang: Object-relational mapping tools and Hibernate | + | |
- | * Raisa Uku, Fatemeh Shafiee: Key-value stores and Redis | + | |
- | * Dany Efila: Multimedia databases and Oracle | + | |
- | * Anastasiia Zavolozhina, Ferdiansyah Dolot: Object oriented databases and Db4o | + | |
- | * Batra Shubham, Liccardo Nathan: Embedded databases and BerkeleyDB | + | |
- | * Yasin Arslan, Jacky Trinh: Document stores and RavenDB | + | |
- | * Alex Buléon, Antoine Chédin: Multi-model databases and OrientDB | + | |
- | * Beyens Ziad, Nougba Hamza: Document stores and CouchDB | + | |
- | * Aleksei Karetnikov, David Pieschacon: Graph stores and ArangoDB | + | |
- | * Dany-Simone Efila Efila, Michel Noucha: Document stores and Cloudant | + | |
- | * George Kagramanyan, Léni Poliseno: Document stores and Couchbase | + | |
- | * Hajji Issam, Toure Ibrahim: newSQL databases and nuoDB | + | |
- | * Madrane Sofiane, Pierre-Alexandre Bourdais: Object-oriented embedded database and Perst | + | |
- | * Kirubel Yaekob, Yasmine Daoud: {{:teaching:opentsdb_2017.pdf|Database security and SQL Server}} | + | |
- | + | ||
- | + | ||
+ | /* * {{:teaching:infoh415:student_projects:2019:azure.pdf|Cloud databases and Microsoft Azure}}: Sara Diaz, Buse Ozer */ | ||
===== Examinations from Previous Years ===== | ===== Examinations from Previous Years ===== | ||