{"id":16652,"date":"2020-09-28T07:39:50","date_gmt":"2020-09-28T06:39:50","guid":{"rendered":"https:\/\/dbdmg.polito.it\/wordpress\/?page_id=16652"},"modified":"2021-09-15T15:10:45","modified_gmt":"2021-09-15T14:10:45","slug":"data-management-and-visualization-2020-2021","status":"publish","type":"page","link":"https:\/\/dbdmg.polito.it\/wordpress\/teaching\/data-management-and-visualization-2020-2021\/","title":{"rendered":"Data management and visualization (2020\/2021)"},"content":{"rendered":"<h3 id=\"tinyTOC\">Table of content<\/h3>\n<ul>\n<li><a href=\"#General-information-1\">General information<\/a><\/li>\n<li><a href=\"#Material-1\">Material<\/a>\n<ul>\n<li><a href=\"#Data-Warehousing-2\">Data Warehousing<\/a><\/li>\n<li><a href=\"#Non-relational-Databases-2\">Non-relational Databases<\/a><\/li>\n<li><a href=\"#Data-Visualization-2\">Data Visualization<\/a><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"#-Exercises--1\"> Exercises <\/a><\/li>\n<li><a href=\"#Laboratory-practices-1\">Laboratory practices<\/a><\/li>\n<\/ul>\n<h3><span id=\"General-information-1\">General information<\/span><\/h3>\n<ul style=\"list-style-type: disc;\">\n<li>ECTS: 8<\/li>\n<li>Professors: Daniele Apiletti, Silvia Chiusano, Diego Monti<\/li>\n<li>Assistant lecturers: Eliana Pastor,\u00a0 Alessandro Fiori, Diego Monti<\/li>\n<\/ul>\n<h3>Announcements<\/h3>\n<ul>\n<li>[15-10-2020] The first laboratory will be held on October 21 and October 22, 2020 on the Virtual Classroom.\n<ul>\n<li>LAB SCHEDULE.<br \/>\nTEAM A (FROM A TO G) on Wednesday from 1 pm to 2:30 pm<br \/>\nTEAM B (FROM H TO Z) on Thursday from 16pm to 17.30pm<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n<hr \/>\n<h3>Exams<\/h3>\n<ul>\n<li><a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/09\/Exam-rules-DMV-2021.pdf\">Exam rules<\/a><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul>\n<li>February 1st, 2021\n<ul>\n<li>Text + DW and NOSQL solutions (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2021\/02\/DMV_Exam2021_02_01_draft_sol.pdf\">pdf<\/a>)<\/li>\n<li>Data visualization solutions (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2021\/02\/VizExamSheet_sol.pdf\">pdf<\/a>)<\/li>\n<\/ul>\n<\/li>\n<li>February 15, 2021\n<ul>\n<li>Text + DW and NOSQL solutions (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2021\/02\/DMV-Exam-15-February-2021-text-and-solutions.pdf\">pdf<\/a>)<\/li>\n<li>Data visualization solutions (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2021\/02\/VizExamSheet_sol-1.pdf\">pdf<\/a>)<\/li>\n<\/ul>\n<\/li>\n<li>June 17, 2021\n<ul>\n<li>Text + DW and NOSQL solutions (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2021\/06\/DMV-Exam-17-June-2021-text-solutions-from-Exam.pdf\">pdf<\/a>)<\/li>\n<li>Data visualization solution (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2021\/06\/DMV_2021-06-17_VizExamSheet_sol.pdf\">pdf<\/a>)<\/li>\n<\/ul>\n<\/li>\n<li>September 1st, 2021\n<ul>\n<li>Text + DW and NOSQL solutions (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2021\/09\/DMV-Exam-1-September-2021-text.pdf\">pdf<\/a>)<\/li>\n<li>Data visualization solutions (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2021\/09\/DMV-2021-09-01-VizExamSheet_sol.pdf\">pdf<\/a>)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n<hr \/>\n<h2><span id=\"Material-1\">Material<\/span><\/h2>\n<ul>\n<li>Course introduction (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/09\/0-DMV-intro-20-21.pdf\">slides<\/a>) &#8211; slightly updated on Tuesday, September 29, 2020 at 12:20 CEST<\/li>\n<\/ul>\n<h3><span id=\"Data-Warehousing-2\">Data Warehousing<\/span><\/h3>\n<ul>\n<li>Data warehouse: introduction (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/09\/1-DWIntroduction-1per.pdf\">slides<\/a>)<\/li>\n<li>Data warehouse: conceptual and logical design (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/09\/2-DW-conceptual-logical-design-1per.pdf\">slides<\/a>)<\/li>\n<li>Data warehouse: analysis (<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2018\/10\/4-DWquery-EN.pdf\">slides<\/a>)<\/li>\n<li>Data warehouse: materialized view (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/10\/3-DW-materializedview-1per.pdf\">slides<\/a>)<\/li>\n<li>Data warehouse: ETL process (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/10\/6-DW-ETL-1per.pdf\">slides<\/a>)<\/li>\n<li>Data warehouse: Extended SQL in Oracle (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/10\/00-Oracle-extended-SQL.pdf\">slides<\/a>)<\/li>\n<li>Data warehouse: physical design (<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2019\/10\/2-DW-physical-design-1per.pdf\">slides<\/a>)<\/li>\n<\/ul>\n\n<h3>Data Warehousing exercises<\/h3>\n<table style=\"border-color: #000000; width: 61%; height: 184px;\" border=\"1\">\n<tbody>\n<tr style=\"height: 23px;\">\n<td style=\"width: 51.4914%; height: 23px;\">Exercise<\/td>\n<td style=\"width: 9.89011%; height: 23px;\">Text<\/td>\n<td style=\"width: 37.2057%; height: 23px;\">Draft solution<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 51.4914%; height: 23px;\">Extended SQL (Customers)<\/td>\n<td style=\"width: 9.89011%; height: 23px;\"><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2017\/11\/ExtendedSQLCustomerText.pdf\">text<\/a><\/td>\n<td style=\"width: 37.2057%; height: 23px;\"><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2017\/11\/ExtendedSQLDraftSolutionCustomer.pdf\">Draft solution<\/a><\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 51.4914%; height: 23px;\">Extended SQL (Rentals) &#8211; updated 10-10-2019<\/td>\n<td style=\"width: 9.89011%; height: 23px;\"><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/ExtendedSQL_ENG.pdf\">text<\/a><\/td>\n<td style=\"width: 37.2057%; height: 23px;\"><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/ExtendedSQL-draft_solution.pdf\">Draft solution<\/a><\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 51.4914%; height: 23px;\">Data warehouse design (storehouses)<\/td>\n<td style=\"width: 9.89011%; height: 23px;\"><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2019\/10\/03-DW-project-household-text.pdf\">text<\/a><\/td>\n<td style=\"width: 37.2057%; height: 23px;\">\u00a0<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/DW-project-Italian_household_draft-solution.pdf\">Draft solution<\/a><\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 51.4914%; height: 23px;\">Data warehouse design (SearchingYourHouse)<\/td>\n<td style=\"width: 9.89011%; height: 23px;\"><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2019\/10\/04-DW-project-HouseSearch-text.pdf\">text<\/a><\/td>\n<td style=\"width: 37.2057%; height: 23px;\"><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/DW-project-SearchingYourHouse-draft_solution.pdf\">Draft solution<\/a><\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 51.4914%; height: 23px;\">Data warehouse design (Hotel chain)<\/td>\n<td style=\"width: 9.89011%; height: 23px;\"><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2019\/12\/05-DW-project-hotel-text.pdf\">text<\/a><\/td>\n<td style=\"width: 37.2057%; height: 23px;\"><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/DW-project-hotel_chain_draft_solution.pdf\">Draft solution<\/a><\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 51.4914%; height: 23px;\">Data warehouse design (Parcels service)<\/td>\n<td style=\"width: 9.89011%; height: 23px;\"><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2019\/12\/06-DW-project-parcels-text.pdf\">text<\/a><\/td>\n<td style=\"width: 37.2057%; height: 23px;\"><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/01\/DW_Parcels_Schema.pdf\">Draft solution<\/a><\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 51.4914%; height: 23px;\">Data warehouse design (PC store)<\/td>\n<td style=\"width: 9.89011%; height: 23px;\"><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2019\/12\/07-DW-project-PC-text.pdf\">text<\/a><\/td>\n<td style=\"width: 37.2057%; height: 23px;\"><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/01\/DW_PCStore_DraftSol.pdf\">Draft solution<\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<h3><span id=\"Non-relational-Databases-2\">Non-relational Databases<\/span><\/h3>\n<ul>\n<li>NoSQL introduction and document-based DBMS (<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2019\/11\/01-NoSQL-intro-and-document-based.pdf\">slides<\/a>)<\/li>\n<li>MongoDB intro and query (<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2019\/11\/02-MongoDB-query.pdf\">slides<\/a>)<\/li>\n<li>MongoDB operations (<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2019\/11\/03-MongoDB-operations.pdf\">slides<\/a>)<\/li>\n<li>MongoDB query recap (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/11\/03b-MongoDB-recap.pdf\">slides<\/a>)<\/li>\n<li>Distributed Data Management &#8211; replication, CAP, and conflicts (<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2019\/11\/07-Distributed-Data-Management-Replication-CAP-Conflicts.pdf\">slides<\/a>)<\/li>\n<li>Distributed transactions (<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2019\/11\/05-Distributed-Transactions-2PC.pdf\">slides<\/a>)<\/li>\n<li>MongoDB replication (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/11\/06-MongoDB-replication.pdf\">slides<\/a>)<\/li>\n<li>MongoDB aggregation pipeline with examples (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/11\/05-MongoDB-aggregation-pipeline-with-examples.pdf\">slides<\/a>) &#8211; updated on Nov 19, 2020<\/li>\n<li>MongoDB query exercises (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/11\/06-MongoDB-query-exercises.pdf\">slides<\/a>) &#8211; updated on Nov 19, 2020<\/li>\n<li>Map Reduce (<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2019\/11\/04-MapReduce.pdf\">slides<\/a>)<\/li>\n<li>A NoSQL design recipe (<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2019\/11\/07-NoSQL-Transaction-Design-Recipe.pdf\">slides<\/a>)<\/li>\n<li>NoSQL design patterns, part 1 (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/12\/12-MongoDB-design-patterns-part-1.pdf\">slides<\/a>)<\/li>\n<li>NoSQL design patterns, part 2 (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/12\/13-MongoDB-design-patterns-part-2.pdf\">slides<\/a>)<\/li>\n<\/ul>\n\n<p>&nbsp;<\/p>\n<h3><span id=\"Data-Visualization-2\">Data Visualization<\/span><\/h3>\n<ul>\n<li>What is Visualization (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/11\/DV01-DataVisualization.pdf\">slides<\/a>)<\/li>\n<li>Visual perception (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/11\/DV02-VisualPerception.pdf\">slides<\/a>)<\/li>\n<li>Graph construction (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/12\/DV03-GraphConstruction.pdf\">slides<\/a>)<\/li>\n<li>Data Quality (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/12\/DV04-DataQuality.pdf\">slides<\/a>)<\/li>\n<li>Past exams (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2021\/01\/DV05-PastExams-2.pdf\">pdf<\/a>) [Updated]<\/li>\n<\/ul>\n\n<p>&nbsp;<\/p>\n<hr \/>\n<h2><span id=\"-Exercises--1\"> Exercises <\/span><\/h2>\n<p>Collection of exercises from practices and past exams. For doubts, question or reporting, use Piazza or write to eliana.pastor@polito.it<\/p>\n<p>Data Warehousing<\/p>\n<ul>\n<li>Vehicle rental (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/12\/Vehicle_rental_DW_text.pdf\">Text<\/a>, <a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/12\/Vehicle_rental_DW_text_draft_sol-1.pdf\">draft solution<\/a>) [Updated 30\/12]<\/li>\n<li>Versioning services(<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/12\/Versioning_services_DW_text.pdf\">text<\/a>, <a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/12\/Versioning_services_DW_draft_sol.pdf\">draft solution<\/a>)<\/li>\n<li>Craft beer (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/12\/Craft_beer_DW_text.pdf\">text<\/a>, <a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2021\/01\/Craft_beer_DW_draft_sol.pdf\">draft solution<\/a>) [Updated]<\/li>\n<li>Tickets (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/12\/Tickets_DW_text.pdf\">text<\/a>, <a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2021\/01\/Tickets_DW_draft_sol.pdf\">draft solution<\/a>)<\/li>\n<li>Food delivery (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/12\/Food_delivery_DW_text.pdf\">text<\/a>, <a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2021\/01\/Food_delivery_DW_draft_sol.pdf\">draft solution<\/a>) [Updated]<\/li>\n<\/ul>\n<p>NoSQL<\/p>\n<ul>\n<li>MongoDB design pattern exercises (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2021\/01\/MongoDB_design_pattern-exercises-v3-text-only.pdf\">text<\/a>, <a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2021\/01\/MongoDB_design_pattern-exercises-v3-text-and-solutions.pdf\">solutions<\/a>) &#8211; updated 2021-01-21<\/li>\n<li>MongoDB query exercises (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2021\/01\/MongoDB_query-exercises-v1-text-only.pdf\">text<\/a>, <a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2021\/01\/MongoDB_query-exercises_sol.pptx.pdf\">solutions<\/a>) &#8211; updated 2021-01-21<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<hr \/>\n<h2><span id=\"Laboratory-practices-1\">Laboratory practices<\/span><\/h2>\n<p>The laboratories will start next week (21 and 22 October). You are divided into two teams by the initial letter of your surname.<br \/>\n&#8211; Team A: surname in the range [A-G]<br \/>\n&#8211; Team B: surname in the range [H-Z]<\/p>\n<p>We will have two laboratory sessions. Each team is assigned to one session as follows:<br \/>\n&#8211; Session 1 on Wednesday at 1-2:30 PM for Team A*<br \/>\n&#8211; Session 2 on Thursday at 4-5:30 PM for Team B<\/p>\n<p>During this semester, the laboratories will be entirely virtual on Virtual Classroom. As such, we will record and publish each session.<br \/>\nDuring the laboratories, <a href=\"http:\/\/piazza.com\/polito.it\/fall2020\/01txasm\">Piazza<\/a> will be used as a support for Live Question&amp;Answer. In case of pre-enroll students, send an email to eliana.pastor@polito.it to ask for joining.<\/p>\n<p>Exception: January 6 there will be no lesson for Team A, it will delayed on Thursday 7, as follows<br \/>\nJanuary 7 Thursday at 4-5:30 PM for Team B<br \/>\nJanuary 7 Thursday at 5:30-7 PM for Team A*<\/p>\n<p>&nbsp;<\/p>\n<p>Lab 1: Extended SQL<\/p>\n<ul>\n<li>Text (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/10\/Lab1_ExtendedSQL2021-1.pdf\">pdf<\/a>)<\/li>\n<li>Data warehouse tables in csv format (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/10\/DW_Phones_EN.zip\">zip<\/a>)<\/li>\n<li>Import Database and Tables\n<ul>\n<li><a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/10\/ImportDatabaseSQL_ENG.pdf\">Tutorial<\/a><\/li>\n<\/ul>\n<\/li>\n<li>Installing Oracle Database 18c Express Edition and SQL Developer\n<ul>\n<li>To download and install Oracle Express Edition: <a href=\"https:\/\/www.oracle.com\/it\/database\/technologies\/appdev\/xe.html\" target=\"_blank\" rel=\"noopener noreferrer\">home page<\/a><\/li>\n<li>To download and install SQL Developer: <a href=\"https:\/\/www.oracle.com\/it\/database\/technologies\/appdev\/xe.html\" target=\"_blank\" rel=\"noopener noreferrer\">home page<\/a><\/li>\n<li>Tutorial\n<ul>\n<li>Installation Guide for <a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/10\/TutorialWindowsOracleDB_ENG.pdf\">Windows<\/a><\/li>\n<li>Installation Guide for <a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/10\/TutorialUbuntuOracleDB_ENG.pdf\">Ubuntu<\/a><\/li>\n<li>Installation Guide for <a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/10\/TutorialMACOsOracleDB_ENG.pdf\">Mac OS<\/a><\/li>\n<\/ul>\n<\/li>\n<li>If you have problems with the installation, please use <a href=\"http:\/\/piazza.com\/polito.it\/fall2020\/01txasm\">Piazza<\/a> (folder oraclexesql)<\/li>\n<\/ul>\n<\/li>\n<li>Draft solution of queries 1-5 and materialized view (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/10\/Lab1_ExtendedSQL_Sol.pdf\">pdf<\/a>) and <a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2018\/10\/star_schema_callDW_Sol.pdf\">DW design<\/a><\/li>\n<\/ul>\n<p>Lab 2: Extended SQL<\/p>\n<ul style=\"padding-left: 30px;\">\n<li style=\"padding-left: 30px;\">Text &#8211; Additional queries\u00a0 \u00a0(<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/10\/Lab2_ExtendedSQL2021.pdf\">pdf<\/a>)<\/li>\n<\/ul>\n<p>Lab 3: Data-warehouse analytics and reporting with Google Data Studio<\/p>\n<ul style=\"padding-left: 30px;\">\n<li style=\"padding-left: 30px;\">Text (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/11\/Lab3_DataStudio_ENG.pdf\">pdf<\/a>)<\/li>\n<\/ul>\n<p>Lab 4: NoSQL in MongoDB Compass<\/p>\n<ul>\n<li>Text (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/11\/DataManagement_compass.pdf\">pdf<\/a>)<\/li>\n<li><a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2021\/01\/DataManagement_compass_sol.pdf\">Solution<\/a><\/li>\n<\/ul>\n<p>Lab 5: Create a replica set and query a MongoDB database<\/p>\n<ul>\n<li>Text (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/11\/DMV_Lab5_MongoDB_text.pdf\">pdf<\/a>)<\/li>\n<li>database dump (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/11\/restaurants_collection.txt\">restaurants_collection<\/a>)<\/li>\n<li>docker file (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/11\/docker-compose.yml_.zip\">docker-compose.yml<\/a>)<\/li>\n<li><a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2021\/01\/DMV_Lab5_MongoDB_solution.pdf\">Solution<\/a><\/li>\n<\/ul>\n<p>Lab 6: Visualization analysis<\/p>\n<ul>\n<li>Text (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/11\/Lab6.pdf\">pdf<\/a>)<\/li>\n<li>Data (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/11\/Lab6.xlsx\">xlsx<\/a>)<\/li>\n<li><a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/12\/Lab6_sol.xlsx\">Solution<\/a><\/li>\n<\/ul>\n<p>Lab 7: Redesign with Tableu<\/p>\n<ul>\n<li>Text (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/12\/Lab7.pdf\">pdf<\/a>)<\/li>\n<li><a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/12\/Lab7_sol.zip\">Solution<\/a><\/li>\n<\/ul>\n<p>Lab 8: Visualization of a dataset<\/p>\n<ul>\n<li>Text (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/12\/Lab8.pdf\">pdf<\/a>)<\/li>\n<li><a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/12\/Lab8_sol.zip\">Solution<\/a><\/li>\n<\/ul>\n<p>Lab 9: Intervals and dashboards<\/p>\n<ul>\n<li>Text (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/12\/Lab9.pdf\">pdf<\/a>)<\/li>\n<li>Dataset (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/12\/Kickstarter.zip\">zip<\/a>)<\/li>\n<li><a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2021\/01\/Lab9_sol.zip\">Solution<\/a><\/li>\n<\/ul>\n<p>Lab 10: Geographic roles and maps<\/p>\n<ul>\n<li>Text (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2021\/01\/Lab10.pdf\">pdf<\/a>)<\/li>\n<li>Dataset (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2021\/01\/Lab10.zip\">zip<\/a>)<\/li>\n<li><a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2021\/01\/Lab10_sol.zip\">Solution<\/a><\/li>\n<\/ul>\n<p>Lab 11: Exam simulation Dataviz<\/p>\n<ul>\n<li>Solution (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2021\/01\/Lab11_sol-1.pdf\">pdf<\/a>, <a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2021\/01\/Lab11_sol.zip\">zip<\/a>)<\/li>\n<\/ul>\n<br class=\"fixfloat\" \/>","protected":false},"excerpt":{"rendered":"<p>Table of content General information Material Data Warehousing Non-relational Databases Data Visualization Exercises Laboratory practices General information ECTS: 8 Professors: Daniele Apiletti, Silvia Chiusano, Diego Monti Assistant lecturers: Eliana Pastor,\u00a0 Alessandro Fiori, Diego Monti Announcements [15-10-2020] The first laboratory will be held on October 21 and October 22, 2020 on the Virtual Classroom. LAB SCHEDULE.<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/teaching\/data-management-and-visualization-2020-2021\/\">[&#8230;]<\/a><\/p>\n","protected":false},"author":26,"featured_media":0,"parent":96,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-16652","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/dbdmg.polito.it\/wordpress\/wp-json\/wp\/v2\/pages\/16652","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbdmg.polito.it\/wordpress\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/dbdmg.polito.it\/wordpress\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/dbdmg.polito.it\/wordpress\/wp-json\/wp\/v2\/users\/26"}],"replies":[{"embeddable":true,"href":"https:\/\/dbdmg.polito.it\/wordpress\/wp-json\/wp\/v2\/comments?post=16652"}],"version-history":[{"count":74,"href":"https:\/\/dbdmg.polito.it\/wordpress\/wp-json\/wp\/v2\/pages\/16652\/revisions"}],"predecessor-version":[{"id":18341,"href":"https:\/\/dbdmg.polito.it\/wordpress\/wp-json\/wp\/v2\/pages\/16652\/revisions\/18341"}],"up":[{"embeddable":true,"href":"https:\/\/dbdmg.polito.it\/wordpress\/wp-json\/wp\/v2\/pages\/96"}],"wp:attachment":[{"href":"https:\/\/dbdmg.polito.it\/wordpress\/wp-json\/wp\/v2\/media?parent=16652"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}