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:tp [2022/09/28 08:09] gdejaege [Active databases] |
teaching:infoh415:tp [2023/09/20 14:32] ezimanyi |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ====== INFO-H-415 : Exercises ====== | ====== INFO-H-415 : Exercises ====== | ||
| - | ===== Active databases ===== | + | ===== Spatial databases (PostGIS) ===== |
| + | For the spatial databases exercises, you will to install the following tool on your computer: | ||
| + | * [[https://www.postgresql.org/ | PostgreSQL]] | ||
| + | * [[http://www.postgis.net/ | PostGIS]] | ||
| + | * [[https://www.qgis.org/en/site/ | QGIS]] | ||
| - | ==== Before Session 1 ==== | + | The two first exercise sessions will both be devided into a lab part and an exercise part. During the lab part, we will show you how to use the different tools and what we can do with them. This part will not be covered during the exam. During the exercise part, you will need to write some spatial databases requests. This part will be covered during the examination. PostgreSQL and PostGIS should be easy to install and are the two software necessary to perform the exercises. QGIS will only be used for the lab part of the sessions. |
| - | If you are planning on working on your own laptop/computer (which is strongly advised given the state of the computers in the computer rooms), please download and install the following before the first exercise session. | + | |
| - | * For windows: | + | |
| - | * [[https://docs.microsoft.com/en-us/sql/azure-data-studio/download-azure-data-studio?view=sql-server-ver15| Azure studio]] or [[https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-2017|SQL Server Management Studio]] | + | |
| - | * [[https://www.microsoft.com/en-us/sql-server/sql-server-downloads|SQL Server Express]] | + | |
| - | * For mac: | + | |
| - | * [[https://database.guide/how-to-install-sql-server-on-a-mac/|Follow this tutorial]]. Note that I could not verify if this tutorial works by myself. | + | |
| - | * For linux: | + | |
| - | * [[https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-overview?view=sql-server-ver15&viewFallbackFrom=azuresqldb-current|SQL Server]]. While choosing the "edition", please select the free "Express" edition. | + | |
| - | * [[https://docs.microsoft.com/en-us/sql/azure-data-studio/download-azure-data-studio?view=sql-server-ver15| Azure studio]]. To connect to your SQL Server express, please indicate server: "localhost", login: "SA" and the password selected during the installation of SQL Server. | + | |
| + | ==== Session 1 ==== | ||
| - | ==== Session 1 : Exercises "PhD" ==== | + | * {{:teaching:infoh415:tp10.zip|TP1}} |
| - | * {{:teaching:infoh415:2021_adb_tp1_slides.pdf|Slides: Intro + recap}} | ||
| - | * {{:teaching:infoh415:2021_adb_tp1_exercices.pdf|Exercises + Solutions}} | ||
| - | * {{:teaching:infoh415:2021_adb_tp1_sql.zip|SQL Server Scripts}} | ||
| + | ==== Session 2 ==== | ||
| + | |||
| + | * {{:teaching:infoh415:tp11.zip|TP2}} | ||
| - | ==== Sessions 2 and 3 : Exercises "Employees Departments Projects" ==== | + | ==== Session 3 ==== |
| - | | + | |
| - | * {{:teaching:infoh415:2021_adb_tp02_03_slides.pdf|Recap}} | + | * {{:undefined:tp12.zip|TP3}} |
| - | * {{:teaching:infoh415:2021_adb_exercices.pdf|Exercises + Solutions}} | + | * [[https://drive.google.com/file/d/1eefHvPWexMu7Pns3eblzOLzpv0hosHKS/view?usp=sharing|Database File]] |
| - | * {{:teaching:infoh415:2021_adb_tp02_03sql.zip|SQL Server Scripts}} | + | |
| - | * {{:teaching:infoh415:sql.zip|New scripts}} | + | |
| - | | + | |
| - | ===== Temporal databases ===== | + | ===== Mobility databases ===== |
| - | ==== Sessions 4, 5 and 6 ==== | + | ==== Sessions 4, 5, 6 ==== |
| - | * {{:teaching:infoh415:2021_infoh415_tp04_05_06_slides.pdf|Recap}} | + | {{:teaching:infoh415:graphdb-ulb-2021.zip|Material for Graph databases sessions}} |
| - | * {{:teaching:infoh415:difference_full.pdf| Drawing temporal difference}} | + | |
| - | * {{:teaching:infoh415:temporal_join_example.pdf| Drawing temporal join}} | + | |
| - | * {{:teaching:infoh415:2021_translationea.pdf| Traduction of EA schemas}} | + | |
| - | * {{:teaching:infoh415:2021_infoh415_tp04_05_06_exercices.pdf|Exercises and solutions}} | + | |
| - | * {{:teaching:infoh415:infoh415_1415_tp04_05_06_scripts.zip|SQL Server Scripts}} | + | |
| - | * {{:teaching:infoh415:infoh415_tp05_ex10.pdf|Explanation of 10th query exercise}} | + | |
| - | * {{:teaching:infoh415:ex10_aggregation_step_by_step.pdf|10th query step by step drawing}} | + | |
| - | * Planning: | + | The slides and exercise sessions are available here above. The actual database dumps for the third exercise session are too large for this website and are available on the UV. |
| - | * Session 4: Exercice 1 (relational schema) and queries 1 to 5 | + | Please note that you should download and use Neo4j 4.2.19. |
| - | * Session 5: Queries 6 to 8 and constraints | + | Solutions: |
| - | * Session 6: Queries 9 to 13 | + | - {{:teaching:infoh415:graphdb_solutions.zip|}} |
| - | ===== Graph databases ===== | ||
| - | ==== Sessions 7, 8, 9 ==== | + | /*{{:teaching:infoh415:introduction_to_graph_databases_-_ulb.zip|}} |
| - | + | ||
| - | {{:teaching:infoh415:graphdb-ulb-2021.zip|Material for Graph databases sessions}} | + | |
| Please be sure to install the correct version of Neo4J as indicated in the installation document. | Please be sure to install the correct version of Neo4J as indicated in the installation document. | ||
| Line 82: | Line 64: | ||
| */ | */ | ||
| + | ===== Active databases ===== | ||
| + | |||
| + | ==== Before Session 1 ==== | ||
| + | If you are planning on working on your own laptop/computer (which is strongly advised given the state of the computers in the computer rooms), please download and install the following before the first exercise session. | ||
| + | * For windows: | ||
| + | * [[https://docs.microsoft.com/en-us/sql/azure-data-studio/download-azure-data-studio?view=sql-server-ver15| Azure studio]] or [[https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-2017|SQL Server Management Studio]] | ||
| + | * [[https://www.microsoft.com/en-us/sql-server/sql-server-downloads|SQL Server Express]] | ||
| + | * For mac: | ||
| + | * [[https://database.guide/how-to-install-sql-server-on-a-mac/|Follow this tutorial]]. Note that I could not verify if this tutorial works by myself. | ||
| + | * For linux: | ||
| + | * [[https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-overview?view=sql-server-ver15&viewFallbackFrom=azuresqldb-current|SQL Server]]. While choosing the "edition", please select the free "Express" edition. | ||
| + | * [[https://docs.microsoft.com/en-us/sql/azure-data-studio/download-azure-data-studio?view=sql-server-ver15| Azure studio]]. To connect to your SQL Server express, please indicate server: "localhost", login: "SA" and the password selected during the installation of SQL Server. | ||
| + | |||
| + | |||
| + | ==== Session 7 : Exercises "PhD" ==== | ||
| + | |||
| + | * {{:teaching:infoh415:2021_adb_tp1_slides.pdf|Slides: Intro + recap}} | ||
| + | * {{:teaching:infoh415:2021_adb_tp1_exercices.pdf|Exercises + Solutions}} | ||
| + | * {{:teaching:infoh415:2021_adb_tp1_sql.zip|SQL Server Scripts}} | ||
| + | |||
| + | |||
| + | |||
| + | ==== Sessions 8 and 9 : Exercises "Employees Departments Projects" ==== | ||
| + | | ||
| + | |||
| + | * {{:teaching:infoh415:2021_adb_tp02_03_slides.pdf|Recap}} | ||
| + | * {{:teaching:infoh415:2021_adb_exercices.pdf|Exercises + Solutions}} | ||
| + | * {{:teaching:infoh415:2021_adb_tp02_03sql.zip|SQL Server Scripts}} | ||
| + | * {{:teaching:infoh415:sql.zip|New scripts}} | ||
| /* | /* | ||
| ===== Object databases ===== | ===== Object databases ===== | ||
| - | ==== Session 7 : LINQ (SQL) ==== | + | ==== Session 10 : LINQ (SQL) ==== |
| * {{:teaching:infoh415:sdi_object_linq_sql_slides.pdf|Slides}} | * {{:teaching:infoh415:sdi_object_linq_sql_slides.pdf|Slides}} | ||
| * {{:teaching:infoh415:sdi_object_linq_sql.pdf|Exercises and solutions}} | * {{:teaching:infoh415:sdi_object_linq_sql.pdf|Exercises and solutions}} | ||
| - | ==== Session 8 : LINQ (XML) ==== | + | ==== Session 11 : LINQ (XML) ==== |
| * {{:teaching:infoh415:infoh415_tp08_linq-xml_slides.pdf|Slides}} | * {{:teaching:infoh415:infoh415_tp08_linq-xml_slides.pdf|Slides}} | ||
| * {{:teaching:infoh415:infoh415_tp08_linq-xml_exercises.pdf|Exercises and solutions}} | * {{:teaching:infoh415:infoh415_tp08_linq-xml_exercises.pdf|Exercises and solutions}} | ||
| * {{:teaching:infoh415:dblp-100k.zip|DPLP Xml file}} | * {{:teaching:infoh415:dblp-100k.zip|DPLP Xml file}} | ||
| - | ==== Session 9 : Object relational databases (Oracle) ==== | + | ==== Session 12 : Object relational databases (Oracle) ==== |
| * {{:teaching:infoh415:sdi_object_slides_oracle.pdf|Slides}} | * {{:teaching:infoh415:sdi_object_slides_oracle.pdf|Slides}} | ||
| Line 103: | Line 114: | ||
| */ | */ | ||
| - | ===== Spatial databases (PostGIS) ===== | + | ===== Temporal databases ===== |
| - | For the spatial databases exercises, you will to install the following tool on your computer: | + | |
| - | * [[https://www.postgresql.org/ | PostgreSQL]] | + | |
| - | * [[http://www.postgis.net/ | PostGIS]] | + | |
| - | * [[https://www.qgis.org/en/site/ | QGIS]] | + | |
| - | The two first exercise sessions will both be devided into a lab part and an exercise part. During the lab part, we will show you how to use the different tools and what we can do with them. This part will not be covered during the exam. During the exercise part, you will need to write some spatial databases requests. This part will be covered during the examination. PostgreSQL and PostGIS should be easy to install and are the two software necessary to perform the exercises. QGIS will only be used for the lab part of the sessions. | + | ==== Sessions 10, 11 and 12 ==== |
| - | ==== Session 10 ==== | + | * {{:teaching:infoh415:2021_infoh415_tp04_05_06_slides.pdf|Recap}} |
| - | + | * {{:teaching:infoh415:difference_full.pdf| Drawing temporal difference}} | |
| - | * {{:teaching:infoh415:tp10.zip|TP10}} | + | * {{:teaching:infoh415:temporal_join_example.pdf| Drawing temporal join}} |
| + | * {{:teaching:infoh415:2021_translationea.pdf| Traduction of EA schemas}} | ||
| + | * {{:teaching:infoh415:2021_infoh415_tp04_05_06_exercices.pdf|Exercises and solutions}} | ||
| + | * {{:teaching:infoh415:infoh415_1415_tp04_05_06_scripts.zip|SQL Server Scripts}} | ||
| + | * {{:teaching:infoh415:infoh415_tp05_ex10.pdf|Explanation of 10th query exercise}} | ||
| + | * {{:teaching:infoh415:ex10_aggregation_step_by_step.pdf|10th query step by step drawing}} | ||
| - | + | * Planning: | |
| - | ==== Session 11 ==== | + | * Session 10: Exercice 1 (relational schema) and queries 1 to 5 |
| - | + | * Session 11: Queries 6 to 8 and constraints | |
| - | + | * Session 12: Queries 9 to 13 | |
| - | * {{:teaching:infoh415:tp11.zip|TP11}} | + | |
| - | + | ||
| - | ==== Session 12 ==== | + | |
| - | + | ||
| - | * {{:undefined:tp12.zip|TP12}} | + | |
| - | * [[https://drive.google.com/file/d/1eefHvPWexMu7Pns3eblzOLzpv0hosHKS/view?usp=sharing|Database File]] | + | |