Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
teaching:infoh415:tp [2019/01/15 12:59]
gdejaege [Graph databases]
teaching:infoh415:tp [2024/02/15 11:03] (current)
ezimanyi [Temporal databases]
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]]
  
-==== Session 1 :  Exercises "​PhD"​ ====+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. ​
  
-  * {{:​teaching:​infoh415:​infoh415_tp01_slides_2018B.pdf|Slides:​ Intro + recap}} +==== Session 1 ====
-  * {{:​teaching:​infoh415:​infoh415_tp01_exercices_2018.pdf|Exercises + Solutions}} +
-  * {{teaching:​infoh415:​sdi_actives_phd_scripts.zip|SQL Server Scripts}}+
  
 +  * {{:​teaching:​infoh415:​tp10.zip|TP1}}
  
-==== Sessions 2 and 3 : Exercises "​Employees Departments Projects"​ ==== 
  
-  * {{:​teaching:​infoh415:​infoh415_tp02_03_slides.pdf|Recap}} +==== Session 2 ====
-  * {{:​teaching:​infoh415:​2018_infoh415_tp02_03_exercices_updated.pdf|Exercises + Solutions}} +
-  * {{teaching:​infoh415:​sdi_actives_constraints_scripts.zip|SQL Server Scripts}}+
  
 + 
 +  * {{:​teaching:​infoh415:​tp11.zip|TP2}}
 +
 +==== Session 3 ====
 +
 +  * {{:​undefined:​tp12.zip|TP3}}
 +  * [[https://​drive.google.com/​file/​d/​1YCOEZdshWATxWPru24vFtFyRyzcomXBd/​view?​usp=sharing|GeoNorthwind PostGIS 3 Database File]]
 +
 +
 +===== Mobility databases =====
 +
 +==== Sessions 4, 5, 6 ====
 +
 +...
 +
 +/*
 +{{:​teaching:​infoh415:​graphdb-ulb-2021.zip|Material for Graph databases sessions}}
 +
 +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.
 +Please note that you should download and use Neo4j 4.2.19.
 +Solutions:
 +- {{:​teaching:​infoh415:​graphdb_solutions.zip|}}
 +*/
 +
 +
 +/​*{{:​teaching:​infoh415:​introduction_to_graph_databases_-_ulb.zip|}}
 +
 +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.
 +
 +In Linux, login, then open a terminal window and type the following commands:
 +
 +$ cd /tmp
 +
 +$ tar xJf /​serveur/​neo4j.tar.xz
 +
 +$ cd neo4j
 +
 +$ ./bin/neo4j console
 +
 +
 +This will launch the server. The address where you can execute your queries should appear in the terminal.
 +
 +  * {{:​teaching:​infoh415:​assigment_graph.pdf|Exercices on Graph Databases}}
 +  * {{:​teaching:​infoh415:​graph_databases_updated.zip| databases used UPDATED}}
 +  * {{:​teaching:​infoh415:​part_3_-_neo4j-practice.pdf| introductory slides }}
 +
 +
 +*/
  
 ===== Temporal databases ===== ===== Temporal databases =====
  
-==== Sessions ​4, 5 and ==== +==== Sessions ​and ==== 
-  * {{:​teaching:​infoh415:​infoh415_tp04_05_06_slides1.pdf|Recap}} + 
-  * {{:​teaching:​infoh415:​infoh415_tp04_05_06_exercices.pdf|Exercises and solutions}} +  * {{:​teaching:​infoh415:​2021_infoh415_tp04_05_06_slides.pdf|Recap}} 
-  * {{:​teaching:​infoh415:​infoh415_1415_tp04_05_06_scripts.zip|SQL Server ​Scripts}}+  * {{:​teaching:​infoh415:​temporal_difference_example.pdf| Drawing temporal difference}} 
 +  * {{:​teaching:​infoh415:​temporal_join_example.pdf| Drawing temporal join}} 
 +  * {{:​teaching:​infoh415:​temporal_coalescing_example.pdf| Drawing temporal coalescing}} 
 +  * {{:​teaching:​infoh415:​2021_translationea.pdf| Traduction of EA schemas}} 
 +  * {{:​teaching:​infoh415:​temporal_database_exercises.pdf|Exercises and solutions}} 
 +  * {{:​teaching:​infoh415:​postgresql_scripts.zip|PostgreSQL ​Scripts}}
   * {{:​teaching:​infoh415:​infoh415_tp05_ex10.pdf|Explanation of 10th query exercise}}   * {{:​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}}   * {{:​teaching:​infoh415:​ex10_aggregation_step_by_step.pdf|10th query step by step drawing}}
  
 +  * Planning:
 +    * Session 7: Exercice 1 (relational schema) and queries 1 to 8
 +    * Session 8: Queries 9 to 13
  
-===== Graph databases =====+===== Active ​databases =====
  
-==== Sessions 7, 8 and 9 ====+==== Before Session ​9 ==== 
 +Please download and install the following before the first exercise session. 
 +    * For windows:  
 +      * Server: [[https://​www.microsoft.com/​en-us/​sql-server/​sql-server-downloads|SQL Server Express]] 
 +      * GUI: [[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]] or [[https://​www.jetbrains.com/​datagrip/​| DataGrip]] 
 +    * For mac: 
 +      * [[https://​database.guide/​how-to-install-sql-server-on-a-mac/​|Follow this tutorial]]. Note that for the GUI, you can also use [[https://​www.jetbrains.com/​datagrip/​| DataGrip]]. 
 +    * For linux: 
 +      * Server: [[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. 
 +      * GUI: [[https://​docs.microsoft.com/​en-us/​sql/​azure-data-studio/​download-azure-data-studio?​view=sql-server-ver15| Azure studio]] or [[https://​www.jetbrains.com/​datagrip/​| DataGrip]]. To connect to your SQL Server express, please indicate server: "​localhost",​ login: "​SA"​ and the password selected during the installation of SQL Server.  ​
  
-  * {{:​teaching:​infoh415:​graph_databases_assignment.pdf|Exercices on Graph Databases}} 
-  * {{:​teaching:​infoh415:​graph_db_solutions_1819.pdf|Corrections}} 
  
 +==== Session 9 :  Exercises "​PhD"​ ====
 +
 +  * {{:​teaching:​infoh415:​intro_active_databases.pdf|Slides:​ Intro}}
 +  * {{:​teaching:​infoh415:​2021_adb_tp1_exercices.pdf|Exercises + Solutions}}
 +  * {{:​teaching:​infoh415:​2021_adb_tp1_sql.zip|SQL Server Scripts}}
 +
 +
 +==== Sessions 10 and 11 : Exercises "​Employees Departments Projects"​ ====
 +  ​
 +
 +  * {{:​teaching:​infoh415:​2021_adb_tp02_03_slides.pdf|Recap}}
 +  * {{:​teaching:​infoh415:​2021_adb_exercices.pdf|Exercises + Solutions}}
 +  * {{:​teaching:​infoh415:​Adb_2_3.zip|New scripts}}
 +
 +==== Session 12 ====
 +  * {{:​teaching:​infoh415:​temporal_constraints_exercises.pdf|Exercises + Solutions}}
 +  * {{:​teaching:​infoh415:​infoh415_tp12_scripts.zip|TP12 scripts}}
  
 /* /*
 ===== Object databases ===== ===== Object databases =====
  
-==== Session ​: 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 ​: 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 ​: 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 54: Line 137:
   * [[https://​docs.oracle.com/​cd/​B28359_01/​appdev.111/​b28371/​toc.htm|On-line Oracle documentation]]   * [[https://​docs.oracle.com/​cd/​B28359_01/​appdev.111/​b28371/​toc.htm|On-line Oracle documentation]]
 */ */
- 
-===== Spatial databases (PostGIS) ===== 
- 
-==== Session 10 ==== 
- 
-  * {{:​teaching:​infoh415:​infoh415_tp_10_exercices_solutions_2018.pdf|Exercises}} 
-  * {{:​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 ==== 
- 
-  * {{:​teaching:​infoh415:​infoh415_postgis_bel_alt.zip|bel_alt.vrt}} 
-  * {{:​teaching:​infoh415:​infoh415_postgis_generate.sql.zip|}} 
-  * {{:​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 ==== 
- 
-  * {{:​teaching:​infoh415:​infoh415_2018_tp12_exercices.pdf|Exercices}} 
-  * {{:​teaching:​infoh415:​initialisation.zip|Initialisation script}} 
-  * {{:​teaching:​infoh415:​spatial_reference_guide.pdf|References}} 
 
teaching/infoh415/tp.1547553570.txt.gz · Last modified: 2019/01/15 12:59 by gdejaege