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 [2021/09/22 13:41] gdejaege [Active databases] |
teaching:infoh415:tp [2021/12/14 09:45] gdejaege [Spatial databases (PostGIS)] |
||
|---|---|---|---|
| Line 19: | Line 19: | ||
| * {{:teaching:infoh415:2021_adb_tp1_slides.pdf|Slides: Intro + recap}} | * {{:teaching:infoh415:2021_adb_tp1_slides.pdf|Slides: Intro + recap}} | ||
| * {{:teaching:infoh415:2021_adb_tp1_exercices.pdf|Exercises + Solutions}} | * {{:teaching:infoh415:2021_adb_tp1_exercices.pdf|Exercises + Solutions}} | ||
| - | * {{teaching:infoh415:sdi_actives_phd_scripts.zip|SQL Server Scripts}} | + | * {{:teaching:infoh415:2021_adb_tp1_sql.zip|SQL Server Scripts}} |
| - | * This exercice sessions will normally take place in UB4.130 | + | |
| ==== Sessions 2 and 3 : Exercises "Employees Departments Projects" ==== | ==== Sessions 2 and 3 : Exercises "Employees Departments Projects" ==== | ||
| + | | ||
| * {{:teaching:infoh415:2021_adb_tp02_03_slides.pdf|Recap}} | * {{:teaching:infoh415:2021_adb_tp02_03_slides.pdf|Recap}} | ||
| * {{:teaching:infoh415:2021_adb_exercices.pdf|Exercises + Solutions}} | * {{:teaching:infoh415:2021_adb_exercices.pdf|Exercises + Solutions}} | ||
| - | * {{teaching:infoh415:sdi_actives_constraints_scripts.zip|SQL Server Scripts}} | + | * {{:teaching:infoh415:2021_adb_tp02_03sql.zip|SQL Server Scripts}} |
| + | * {{:teaching:infoh415:sql.zip|New scripts}} | ||
| + | * The second exercise session will take place the 30/09 14h-16h in S.UB4.126 | ||
| + | ===== Temporal databases ===== | ||
| + | ==== Sessions 4, 5 and 6 ==== | ||
| + | |||
| + | * {{:teaching:infoh415:2021_infoh415_tp04_05_06_slides.pdf|Recap}} | ||
| + | * {{:teaching:infoh415:temporal_difference_explained_example.pdf| Drawing temporal difference}} **Attention: this drawing is not totally correct, an update version should be posted soon** | ||
| + | * {{: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 4: Exercice 1 (relational schema) and queries 1 to 5 | ||
| + | * Session 5: Queries 6 to 8 and constraints | ||
| + | * Session 6: Queries 9 to 13 | ||
| ===== Graph databases ===== | ===== Graph databases ===== | ||
| - | ==== Sessions 4, 5, 6 ==== | + | ==== Sessions 7, 8, 9 ==== |
| + | {{: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. | ||
| + | |||
| + | /* | ||
| The commands needed to start the server are written here under. Do not forget to first select the correct databasa as written in the assignment. | The commands needed to start the server are written here under. Do not forget to first select the correct databasa as written in the assignment. | ||
| Line 53: | Line 77: | ||
| * {{:teaching:infoh415:assigment_graph.pdf|Exercices on Graph Databases}} | * {{:teaching:infoh415:assigment_graph.pdf|Exercices on Graph Databases}} | ||
| - | /* * {{:teaching:infoh415:data.zip| databases used}} */ | ||
| * {{:teaching:infoh415:graph_databases_updated.zip| databases used UPDATED}} | * {{:teaching:infoh415:graph_databases_updated.zip| databases used UPDATED}} | ||
| * {{:teaching:infoh415:part_3_-_neo4j-practice.pdf| introductory slides }} | * {{:teaching:infoh415:part_3_-_neo4j-practice.pdf| introductory slides }} | ||
| - | /* * {{:teaching:infoh415:graph_db_solutions_1819.pdf|Corrections}} */ | ||
| - | ===== Temporal databases ===== | + | */ |
| - | + | ||
| - | ==== Sessions 7, 8 and 9 ==== | + | |
| - | + | ||
| - | * {{:teaching:infoh415:infoh415_tp04_05_06_slides1.pdf|Recap}} | + | |
| - | * {{:teaching:infoh415:temporal_difference_explained_example.pdf| Drawing temporal difference}} | + | |
| - | * {{:teaching:infoh415:temporal_join_example.pdf| Drawing temporal join}} | + | |
| - | * {{:teaching:infoh415:traduction_ea.pdf| Traduction of EA schemas}} | + | |
| - | * {{:teaching:infoh415: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}} | + | |
| Line 94: | Line 105: | ||
| ===== Spatial databases (PostGIS) ===== | ===== 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]] | ||
| + | |||
| + | 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. | ||
| ==== Session 10 ==== | ==== Session 10 ==== | ||
| - | * {{:teaching:infoh415:infoh415_tp_10_exercices_solutions_2018.pdf|Exercises}} | + | * {{:teaching:infoh415:tp10.zip|TP10}} |
| - | * {{:teaching:infoh415:infoh415_postgis_insertion.zip|}} | + | |
| - | * {{:teaching:infoh415:shapefiles.zip}} | + | |
| - | * {{:teaching:infoh415:tp_10_txt_corrections.zip|}} | + | |
| - | * {{:teaching:infoh415:shapefiles.tar.gz}} | + | |
| - | * [[http://postgis.net/docs/index.html|On-line PostGIS documentation]] | + | |
| - | * [[http://postgis.net/docs/reference.html#Management_Functions|On-line PostGIS documentation - Command reference]] | + | |
| ==== Session 11 ==== | ==== Session 11 ==== | ||
| - | * {{:teaching:infoh415:infoh415_postgis_bel_alt.zip|bel_alt.vrt}} | + | |
| - | * {{:teaching:infoh415:infoh415_postgis_generate.sql.zip|}} | + | * {{:teaching:infoh415:tp11.zip|TP11}} |
| - | * {{:teaching:infoh415:infoh415_tp11_exercices.pdf|Exercices}} | + | |
| - | * {{:teaching:infoh415:infoh415_tp11_slides.pdf|Slides}} | + | |
| - | * {{:teaching:infoh415:infoh415_tp11_commands_and_corrections.zip|Corrections and commands}} | + | |
| ==== Session 12 ==== | ==== Session 12 ==== | ||
| - | * {{:teaching:infoh415:infoh415_2018_tp12_exercices.pdf|Exercices}} | + | * {{:undefined:tp12.zip|TP12}} |
| - | * {{:teaching:infoh415:initialisation.zip|Initialisation script}} | + | * [[[[https://drive.google.com/file/d/1eefHvPWexMu7Pns3eblzOLzpv0hosHKS|database file]]]] |
| - | * {{:teaching:infoh415:spatial_reference_guide.pdf|References}} | + | |