{"id":9875,"date":"2024-09-19T18:31:29","date_gmt":"2024-09-19T16:31:29","guid":{"rendered":"https:\/\/dbdmg.polito.it\/dbdmg_web\/?p=9875"},"modified":"2025-06-06T10:46:06","modified_gmt":"2025-06-06T08:46:06","slug":"data-management-and-visualization-2024-25","status":"publish","type":"post","link":"https:\/\/dbdmg.polito.it\/dbdmg_web\/2024\/data-management-and-visualization-2024-25\/","title":{"rendered":"Data Management and Visualization (2024-25)"},"content":{"rendered":"\n<h1 class=\" wp-block-heading eplus-wrapper\" id=\"general-information\">General Information<\/h1>\n\n\n\n<p class=\" eplus-wrapper\"><strong>Lecturers<\/strong>: Daniele Apiletti, Diego Monti<\/p>\n\n\n\n<p class=\" eplus-wrapper\"><strong>Teaching staff<\/strong>: Simone Monaco<\/p>\n\n\n\n<p class=\" eplus-wrapper\"><strong>SSD<\/strong>: ING-INF\/05 &#8211; <strong>CFU<\/strong>: 8 &#8211; <a href=\"https:\/\/didattica.polito.it\/pls\/portal30\/gap.pkg_guide.viewGap?p_cod_ins=01TXASM&amp;p_a_acc=2024&amp;p_header=S&amp;p_lang=IT&amp;multi=N\" target=\"_blank\" rel=\"noreferrer noopener\">course details from the official student guide<\/a><\/p>\n\n\n\n<p class=\" eplus-wrapper\">Q&amp;A teaching <strong>assistance <\/strong>on Piazza: <a href=\"https:\/\/piazza.com\/polito.it\/fall2024\/01txasm\">piazza.com\/polito.it\/fall2024\/01txasm<\/a><\/p>\n\n\n\n\n\n<hr class=\" wp-block-separator has-css-opacity eplus-wrapper\"\/>\n\n\n\n<h2 class=\" wp-block-heading eplus-wrapper\" id=\"news\">\ud83d\udcf0 News<\/h2>\n\n\n<ul class=\" wp-block-list eplus-wrapper eplus-styles-uid-db12ac\">\n<li class=\" eplus-wrapper\">We are using Piazza for class discussion. We invite all students to <a href=\"https:\/\/piazza.com\/polito.it\/fall2024\/01txasm\">join the course Piazza<\/a>. Piazza is highly suggested to get help fast and efficiently from classmates and teachers. Rather than emailing questions to the teaching staff, students are invited to post their questions on Piazza.<\/li>\n<\/ul>\n\n\n<hr class=\" wp-block-separator has-css-opacity eplus-wrapper\"\/>\n\n\n\n<h2 class=\" wp-block-heading eplus-wrapper\" id=\"teaching-material\">\ud83d\udcd2 Teaching material<\/h2>\n\n\n\n<p class=\" eplus-wrapper\"><strong>Course introduction <\/strong>(<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/09\/0-DMV-intro-24-25.pdf\">slides<\/a>)<\/p>\n\n\n\n<div class=\"wp-block-ep-tabs ep_tabs_wrapper__c3973efd-af5b-4586-b0d0-a3c18d56721b\"><div class=\"ep_tabs_root ep_tabs_top\" data-autoplay=\"false\" data-delay=\"1000\"><div class=\"ep_tabs_header \"><a href=\"#ep_tab_wrapper__f92e6245-7b2c-41a9-9f6a-3977c277188c\" class=\"ep_label_main\"><span class=\"ep_label\">Data Warehouse<\/span><\/a><a href=\"#ep_tab_wrapper__5a1505c9-354f-4c94-aee3-f5d7bfedcddc\" class=\"ep_label_main\"><span class=\"ep_label\">NoSQL<\/span><\/a><a href=\"#ep_tab_wrapper__221035e5-ec37-44c7-b7b3-8f924499cb4e\" class=\"ep_label_main\"><span class=\"ep_label\">Data Visualization<\/span><\/a><\/div><div class=\"ep_tabs_wrapper undefined\">\n<div id=\"ep_tab_wrapper__f92e6245-7b2c-41a9-9f6a-3977c277188c\" class=\"ep_tab_item_wrapper ep_tab_wrapper__f92e6245-7b2c-41a9-9f6a-3977c277188c undefined\"><ul class=\" wp-block-list eplus-wrapper eplus-styles-uid-9defd6\">\n<li class=\" eplus-wrapper\">Introduction (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/09\/1-DWIntroduction-ENG_2023.pdf\">slides<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Conceptual and logical design (<a href=\"http:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/09\/DSTBD_3-DWprogConcLog-EN.pdf\">slides<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Data analysis, OLAP, extended SQL (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2025\/02\/4-DWquery-EN.pdf\">slides<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">ETL process (<a href=\"http:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/10\/DMV_6-DW-ETL-1per.pdf\">slides<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Data Lakes and ELT (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/09\/6-DataLakesELT.pdf\">slides<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Materialized view (<a href=\"http:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/10\/DMV_3-DW-materializedview-1per.pdf\">slides<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Data warehousing in Oracle (<a href=\"http:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/09\/Oracle-extended-SQL-2021.pdf\">slides<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Data warehousing: physical design (<a href=\"http:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/10\/DMV_2-DW-physical-design-1per.pdf\">slides<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Conceptual schema: textual formalism (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/11\/DW-Formalismo2023.pdf\">slides<\/a>)<\/li>\n<\/ul><\/div>\n\n\n\n<div id=\"ep_tab_wrapper__5a1505c9-354f-4c94-aee3-f5d7bfedcddc\" class=\"ep_tab_item_wrapper ep_tab_wrapper__5a1505c9-354f-4c94-aee3-f5d7bfedcddc undefined\"><ul class=\" wp-block-list eplus-wrapper eplus-styles-uid-e1fe44\">\n<li class=\" eplus-wrapper\">Non-relational databases for data management &#8211; introduction (<a href=\"http:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/09\/01-NoSQL-intro-and-document-DB.pdf\">slides<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Introduction to MongoDB, collections, create, delete, GUI (<a href=\"http:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/09\/02-MongoDB-intro-GUI.pdf\">slides<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">MongoDB, querying data, find operator, aggregation pipeline (<a href=\"http:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/09\/03-MongoDB-operations-find.pdf\">slides<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">MongoDB aggregation examples, indexes (<a href=\"http:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/09\/04-MongoDB-aggregation-indexes.pdf\">slides<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Distributed Data Management, replication, and the CAP theorem (<a href=\"http:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/09\/05-Distributed-Data-Management-Replication-CAP-Conflicts.pdf\">slides<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">MongoDB replica set (<a href=\"http:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/09\/06-MongoDB-replication.pdf\">slides<\/a>, updated Nov 18)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Distributed transactions (<a href=\"http:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/09\/08a-Distributed-Transactions-2PC.pdf\">slides<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Distributed data processing and Map Reduce (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/09\/10-MapReduce.pdf\">slides<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">NoSQL design recipe (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/09\/11-NoSQL-Transaction-Design-Recipe.pdf\">slides<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">MongoDB design patterns part 1 (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/09\/12-MongoDB-design-patterns-part-1.pdf\">slide<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">MongoDB design patterns part 2 (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/09\/13-MongoDB-design-patterns-part-2.pdf\">slide<\/a>)<\/li>\n<\/ul><\/div>\n\n\n\n<div id=\"ep_tab_wrapper__221035e5-ec37-44c7-b7b3-8f924499cb4e\" class=\"ep_tab_item_wrapper ep_tab_wrapper__221035e5-ec37-44c7-b7b3-8f924499cb4e undefined\"><ul class=\" wp-block-list eplus-wrapper eplus-styles-uid-60994d\">\n<li class=\" eplus-wrapper\">What is visualization (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/11\/DV01-DataVisualization.pdf\">slides<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Visual perception (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/11\/DV02-VisualPerception.pdf\">slides<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Graph construction (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/12\/DV03-GraphConstruction.pdf\">slides<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Data quality (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/12\/DV04-DataQuality.pdf\">slides<\/a>)<\/li>\n<\/ul><\/div>\n<\/div><style>.eplus_styles .ep_tabs_wrapper__c3973efd-af5b-4586-b0d0-a3c18d56721b .ep_tabs_header {\n                \n                flex-basis: 15% ;\n            }.eplus_styles .ep_tabs_wrapper__c3973efd-af5b-4586-b0d0-a3c18d56721b .ep_tabs_root {\n                \n                gap: 0px ;\n            }.eplus_styles .ep_tabs_wrapper__c3973efd-af5b-4586-b0d0-a3c18d56721b .ep_label {\n                \n                color: #1e1e1e;\nfont-size: 17px ;\n            }\n            \n\n        \n\n         \n\n        \n        \n      .eplus_styles  .ep_label_main:hover .ep_label {\n        color: #ffffff;\n      }.eplus_styles .ep_tabs_wrapper__c3973efd-af5b-4586-b0d0-a3c18d56721b .ep_sub_label {\n                \n                color: #1e1e1e;\nfont-size: 15px ;\n            }\n            \n\n        \n\n         \n\n        \n        \n      .eplus_styles  .ep_label_main:hover .ep_sub_label {\n        color: #ffffff;\n      }.eplus_styles .ep_tabs_wrapper__c3973efd-af5b-4586-b0d0-a3c18d56721b .ep_active_tab .ep_label {\n                \n                color: #ffffff;\n            }.eplus_styles .ep_tabs_wrapper__c3973efd-af5b-4586-b0d0-a3c18d56721b .ep_active_tab .ep_sub_label {\n                \n                color: #ffffff;\n            }.eplus_styles .ep_tabs_wrapper__c3973efd-af5b-4586-b0d0-a3c18d56721b .ep_label_main {\n                \n                background-image: linear-gradient(#f0f0f0, #f0f0f0);\n            }\n            \n\n        \n\n         \n\n        \n            .eplus_styles .ep_tabs_wrapper__c3973efd-af5b-4586-b0d0-a3c18d56721b .ep_label_main:hover {\n                background-image: linear-gradient(#007cba, #007cba);\n            }.eplus_styles .ep_tabs_wrapper__c3973efd-af5b-4586-b0d0-a3c18d56721b .ep_active_tab {\n                \n                background-image: linear-gradient(#007cba, #007cba);\n            }.eplus_styles .ep_tabs_wrapper__c3973efd-af5b-4586-b0d0-a3c18d56721b .ep_tab_item_wrapper {\n                \n                background-image: linear-gradient(#f0f0f0, #f0f0f0);\n            }.eplus_styles .ep_tabs_wrapper__c3973efd-af5b-4586-b0d0-a3c18d56721b .ep_label_main {\n                \n                padding-top: 15px ;\npadding-right: 15px ;\npadding-bottom: 15px ;\npadding-left: 15px ;\n            }.eplus_styles .ep_tabs_wrapper__c3973efd-af5b-4586-b0d0-a3c18d56721b .ep_tab_item_wrapper {\n                \n                padding-top: 15px ;\npadding-right: 15px ;\npadding-bottom: 15px ;\npadding-left: 15px ;\n            }.eplus_styles .ep_tabs_wrapper__c3973efd-af5b-4586-b0d0-a3c18d56721b .ep_tabs_header {\n                \n                gap: 5px ;\n            }.eplus_styles .ep_tabs_wrapper__c3973efd-af5b-4586-b0d0-a3c18d56721b .ep_tabs_header {\n                \n                justify-content: flex-start;\n            }<\/style><\/div><\/div>\n\n\n\n<p class=\" eplus-wrapper\"><\/p>\n\n\n\n<h2 class=\" wp-block-heading eplus-wrapper\" id=\"exercises\">\ud83d\uddd2\ufe0f Exercises<\/h2>\n\n\n\n<div class=\"wp-block-ep-tabs ep_tabs_wrapper__a86d4b15-b1bc-4cf9-b7e3-318f9400e367\"><div class=\"ep_tabs_root ep_tabs_top\" data-autoplay=\"false\" data-delay=\"1000\"><div class=\"ep_tabs_header \"><a href=\"#ep_tab_wrapper__6ffaeb2e-eff7-45f0-8309-ed3e98712e40\" class=\"ep_label_main\"><span class=\"ep_label\">Data Warehouse<\/span><\/a><a href=\"#ep_tab_wrapper__2e54d7dd-8d7f-4939-8cfb-595f3514625c\" class=\"ep_label_main\"><span class=\"ep_label\">NoSQL<\/span><\/a><a href=\"#ep_tab_wrapper__e854f2ba-75bc-4333-9428-13131223859b\" class=\"ep_label_main\"><span class=\"ep_label\">Data Visualization<\/span><\/a><\/div><div class=\"ep_tabs_wrapper undefined\">\n<div id=\"ep_tab_wrapper__6ffaeb2e-eff7-45f0-8309-ed3e98712e40\" class=\"ep_tab_item_wrapper ep_tab_wrapper__6ffaeb2e-eff7-45f0-8309-ed3e98712e40 undefined\"><ul class=\" wp-block-list eplus-wrapper eplus-styles-uid-13d8c6\">\n<li class=\" eplus-wrapper\">Exercise extended SQL, customers (<a href=\"http:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/09\/ExtendedSQL-Exercise-1-text-2021.pdf\">text<\/a>,\u00a0<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2025\/02\/ExtendedSQLDraftSolutionCustomer.pdf\">solution<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Exercise extended SQL, rentals (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2025\/02\/ExtendedSQL_ENG.pdf\">text<\/a>,\u00a0<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2025\/02\/ExtendedSQL-draft_solution.pdf\">solution<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Exercise DW design, hotels (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2025\/02\/05-DW-project-hotel-text.pdf\">text<\/a>,\u00a0<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2025\/02\/DW-project-hotel_chain_draft_solution.pdf\">solution<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Exercise DW design, storehouses (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2025\/02\/03-DW-project-household-text.pdf\">text<\/a>,\u00a0<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2025\/02\/DW-project-Italian_household_draft-solution.pdf\">solution<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Exercise DW design, rentals (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2025\/02\/04-DW-project-HouseSearch-text.pdf\">text<\/a>,\u00a0<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2025\/02\/DW-project-SearchingYourHouse-draft_solution-1.pdf\">solution<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Exercise DW design, parcels (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2025\/02\/06-DW-project-parcels-text.pdf\">text<\/a>,\u00a0<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2025\/02\/DW_Parcels_Schema.pdf\">solution<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Exercise DW design, computer (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2025\/02\/07-DW-project-PC-text.pdf\">text<\/a>,\u00a0<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2022\/01\/DW_PCStore_DraftSol.pdf\">solution<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Exercise DW design, vehicle rental (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2025\/02\/Vehicle_rental_DW_text.pdf\">text<\/a>,\u00a0<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2025\/02\/Vehicle_rental_DW_text_draft_sol-1.pdf\">solution<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Exercise DW design, versioning services (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2025\/02\/Versioning_services_DW_text.pdf\">text<\/a>,\u00a0<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2025\/02\/Versioning_services_DW_draft_sol.pdf\">solution<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Exercise DW design, craft beer (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2025\/02\/Craft_beer_DW_text.pdf\">text<\/a>,\u00a0<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/12\/Craft_beer_DW_draft_sol_v2.pdf\">solution<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Exercise DW design, tickets (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2025\/02\/Tickets_DW_text.pdf\">text<\/a>,\u00a0<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2025\/02\/Tickets_DW_draft_sol.pdf\">solution<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Exercise DW design, food delivery (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2025\/02\/Food_delivery_DW_text.pdf\">text<\/a>,\u00a0<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2022\/12\/Food_delivery_DW_draft_sol.pdf\">solution<\/a>)<\/li>\n<\/ul><\/div>\n\n\n\n<div id=\"ep_tab_wrapper__2e54d7dd-8d7f-4939-8cfb-595f3514625c\" class=\"ep_tab_item_wrapper ep_tab_wrapper__2e54d7dd-8d7f-4939-8cfb-595f3514625c undefined\"><ul class=\" wp-block-list eplus-wrapper eplus-styles-uid-065320\">\n<li class=\" eplus-wrapper\">MongoDB query exercises (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/09\/07-MongoDB-query-exercises.pdf\">slides<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">MongoDB query exercises IMDB (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/09\/09-MongoDB-exercises-IMDB-database-with-solutions.pdf\">slides<\/a>,\u00a0<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/09\/imdb.json.zip\">IMDB database<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">MongoDB design pattern exercises 1 (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/09\/14-MongoDB-design-patterns-exercises-part-1.pdf\">slide<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">MongoDB design pattern exercises 2 (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/09\/15-MongoDB-design-patterns-exercises-part-2.pdf\">slide<\/a>)<\/li>\n<\/ul><\/div>\n\n\n\n<div id=\"ep_tab_wrapper__e854f2ba-75bc-4333-9428-13131223859b\" class=\"ep_tab_item_wrapper ep_tab_wrapper__e854f2ba-75bc-4333-9428-13131223859b undefined\">\n<div class=\"wp-block-group eplus-wrapper\"><div class=\"wp-block-group__inner-container is-layout-constrained wp-block-group-is-layout-constrained\"><ul class=\" wp-block-list eplus-wrapper eplus-styles-uid-dd0085\">\n<li class=\" eplus-wrapper\">Past exams (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2022\/01\/DV05-PastExams.pdf\">slides<\/a>)<\/li>\n<\/ul><\/div><\/div>\n<\/div>\n<\/div><style>.eplus_styles .ep_tabs_wrapper__a86d4b15-b1bc-4cf9-b7e3-318f9400e367 .ep_tabs_header {\n                \n                flex-basis: 15% ;\n            }.eplus_styles .ep_tabs_wrapper__a86d4b15-b1bc-4cf9-b7e3-318f9400e367 .ep_tabs_root {\n                \n                gap: 0px ;\n            }.eplus_styles .ep_tabs_wrapper__a86d4b15-b1bc-4cf9-b7e3-318f9400e367 .ep_label {\n                \n                color: #1e1e1e;\nfont-size: 17px ;\n            }\n            \n\n        \n\n         \n\n        \n        \n      .eplus_styles  .ep_label_main:hover .ep_label {\n        color: #ffffff;\n      }.eplus_styles .ep_tabs_wrapper__a86d4b15-b1bc-4cf9-b7e3-318f9400e367 .ep_sub_label {\n                \n                color: #1e1e1e;\nfont-size: 15px ;\n            }\n            \n\n        \n\n         \n\n        \n        \n      .eplus_styles  .ep_label_main:hover .ep_sub_label {\n        color: #ffffff;\n      }.eplus_styles .ep_tabs_wrapper__a86d4b15-b1bc-4cf9-b7e3-318f9400e367 .ep_active_tab .ep_label {\n                \n                color: #ffffff;\n            }.eplus_styles .ep_tabs_wrapper__a86d4b15-b1bc-4cf9-b7e3-318f9400e367 .ep_active_tab .ep_sub_label {\n                \n                color: #ffffff;\n            }.eplus_styles .ep_tabs_wrapper__a86d4b15-b1bc-4cf9-b7e3-318f9400e367 .ep_label_main {\n                \n                background-image: linear-gradient(#f0f0f0, #f0f0f0);\n            }\n            \n\n        \n\n         \n\n        \n            .eplus_styles .ep_tabs_wrapper__a86d4b15-b1bc-4cf9-b7e3-318f9400e367 .ep_label_main:hover {\n                background-image: linear-gradient(#007cba, #007cba);\n            }.eplus_styles .ep_tabs_wrapper__a86d4b15-b1bc-4cf9-b7e3-318f9400e367 .ep_active_tab {\n                \n                background-image: linear-gradient(#007cba, #007cba);\n            }.eplus_styles .ep_tabs_wrapper__a86d4b15-b1bc-4cf9-b7e3-318f9400e367 .ep_tab_item_wrapper {\n                \n                background-image: linear-gradient(#f0f0f0, #f0f0f0);\n            }.eplus_styles .ep_tabs_wrapper__a86d4b15-b1bc-4cf9-b7e3-318f9400e367 .ep_label_main {\n                \n                padding-top: 15px ;\npadding-right: 15px ;\npadding-bottom: 15px ;\npadding-left: 15px ;\n            }.eplus_styles .ep_tabs_wrapper__a86d4b15-b1bc-4cf9-b7e3-318f9400e367 .ep_tab_item_wrapper {\n                \n                padding-top: 15px ;\npadding-right: 15px ;\npadding-bottom: 15px ;\npadding-left: 15px ;\n            }.eplus_styles .ep_tabs_wrapper__a86d4b15-b1bc-4cf9-b7e3-318f9400e367 .ep_tabs_header {\n                \n                gap: 5px ;\n            }.eplus_styles .ep_tabs_wrapper__a86d4b15-b1bc-4cf9-b7e3-318f9400e367 .ep_tabs_header {\n                \n                justify-content: flex-start;\n            }<\/style><\/div><\/div>\n\n\n\n<hr class=\" wp-block-separator has-alpha-channel-opacity eplus-wrapper\"\/>\n\n\n\n<h2 class=\" wp-block-heading eplus-wrapper\" id=\"laboratory-material\">\ud83d\udcbb Laboratory material<\/h2>\n\n\n\n\n\n<figure class=\" wp-block-table eplus-wrapper\"><table><tbody><tr><td><strong>Students group<\/strong><\/td><td><strong>Time<\/strong><\/td><td><strong>Room<\/strong><\/td><\/tr><tr><td>TEAM 1 (FROM A TO K)<\/td><td>Tuesday, 13:00 &#8211; 14:30<\/td><td>LAIB3B<\/td><\/tr><tr><td>TEAM 2 (FROM L TO Z)<\/td><td>Tuesday, 14:30 &#8211; 16:00<\/td><td>LAIB3B<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\" eplus-wrapper\">For Labs 1 and 2, you must run <strong>Extended SQL<\/strong> on <strong>Oracle databases<\/strong>. The suggested tool for these Labs is <a href=\"https:\/\/livesql.oracle.com\/\">Oracle Live SQL<\/a>. To configure the environment you can add tables using SQL scripts. A short guide on how to import them and query the DB is available (<a href=\"http:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/10\/Import_Oracle_Live_SQL.docx.pdf\">pdf<\/a>)<\/p>\n\n\n\n<div class=\"wp-block-ep-tabs ep_tabs_wrapper__9d984280-a6e3-4269-9afa-ba057cc2cc0f\"><div class=\"ep_tabs_root ep_tabs_top\" data-autoplay=\"false\" data-delay=\"1000\"><div class=\"ep_tabs_header \"><a href=\"#ep_tab_wrapper__4296b4e8-f3d2-4d46-88c0-19590e649a3e\" class=\"ep_label_main\"><span class=\"ep_label\">Lab 1<\/span><\/a><a href=\"#ep_tab_wrapper__6e4119de-5c35-45cb-8e60-3810f2a45961\" class=\"ep_label_main\"><span class=\"ep_label\">Lab 2<\/span><\/a><a href=\"#ep_tab_wrapper__87c88631-9c9a-425f-b4c5-a5fff242c13f\" class=\"ep_label_main\"><span class=\"ep_label\">Lab 3<\/span><\/a><a href=\"#ep_tab_wrapper__5c51a99a-4735-4e46-b613-54b6e84afa9f\" class=\"ep_label_main\"><span class=\"ep_label\">Lab 4<\/span><\/a><a href=\"#ep_tab_wrapper__53fd1df6-58ec-4864-9d27-a2b89d5f754c\" class=\"ep_label_main\"><span class=\"ep_label\">Lab 5<\/span><\/a><a href=\"#ep_tab_wrapper__dd1b0217-488e-4766-8495-369f926dd4fc\" class=\"ep_label_main\"><span class=\"ep_label\">Lab 6<\/span><\/a><a href=\"#ep_tab_wrapper__f56d791a-3885-4649-9cae-31b224945de3\" class=\"ep_label_main\"><span class=\"ep_label\">Lab 7<\/span><\/a><a href=\"#ep_tab_wrapper__26f9b594-deac-4824-9b9f-f4d541f0c403\" class=\"ep_label_main\"><span class=\"ep_label\">Lab 8<\/span><\/a><a href=\"#ep_tab_wrapper__688489fd-5c63-43b4-b47a-a0284bf09ec0\" class=\"ep_label_main\"><span class=\"ep_label\">Lab 9<\/span><\/a><a href=\"#ep_tab_wrapper__df1ee091-5695-494b-9917-ee345b56f85a\" class=\"ep_label_main\"><span class=\"ep_label\">Lab 10<\/span><\/a><a href=\"#ep_tab_wrapper__0c37f808-d3a7-4c3c-9fab-57b63da9f37f\" class=\"ep_label_main\"><span class=\"ep_label\">Lab 11<\/span><\/a><\/div><div class=\"ep_tabs_wrapper undefined\">\n<div id=\"ep_tab_wrapper__4296b4e8-f3d2-4d46-88c0-19590e649a3e\" class=\"ep_tab_item_wrapper ep_tab_wrapper__4296b4e8-f3d2-4d46-88c0-19590e649a3e undefined\">\n<p class=\" eplus-wrapper\"><strong>Lab 1: Extended SQL<\/strong><\/p>\n\n\n\n<p class=\" eplus-wrapper\">Text (\ud83d\udcc4<a href=\"http:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/10\/Lab1_ExtendedSQL.pdf\">pdf<\/a>)<br>Data warehouse tables (\ud83d\uddc3\ufe0f<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/10\/DW_Phones_EN.zip\">CSV<\/a>, \ud83d\uddc3\ufe0f<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/10\/DW_CELLS_sql.zip\">SQL<\/a>)<br>Solution (\ud83d\udcc4<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/10\/star_schema_callDW_Sol.pdf\">star schema<\/a>, \ud83d\udcc4<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2022\/10\/Lab1_ExtendedSQL_Sol.pdf\">queries<\/a>)<\/p>\n<\/div>\n\n\n\n<div id=\"ep_tab_wrapper__6e4119de-5c35-45cb-8e60-3810f2a45961\" class=\"ep_tab_item_wrapper ep_tab_wrapper__6e4119de-5c35-45cb-8e60-3810f2a45961 undefined\">\n<p class=\" eplus-wrapper\"><strong>Lab 2: Extended SQL<\/strong><\/p>\n\n\n\n<p class=\" eplus-wrapper\">Text \u2013 Additional queries&nbsp;(\ud83d\udcc4<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/10\/Lab2_ExtendedSQL.pdf\">pdf<\/a>)<br>Solution (\ud83d\udcc4<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/11\/Lab2_ExtendedSQL_sol.pdf\">pdf<\/a>)<\/p>\n<\/div>\n\n\n\n<div id=\"ep_tab_wrapper__87c88631-9c9a-425f-b4c5-a5fff242c13f\" class=\"ep_tab_item_wrapper ep_tab_wrapper__87c88631-9c9a-425f-b4c5-a5fff242c13f undefined\">\n<p class=\" eplus-wrapper\"><strong>Lab 3: Looker Studio<\/strong><\/p>\n\n\n\n<p class=\" eplus-wrapper\">Text (\ud83d\udcc4<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/11\/Lab3_DataStudio_v2024.pdf\" target=\"_blank\" rel=\"noreferrer noopener\">pdf<\/a>)<\/p>\n<\/div>\n\n\n\n<div id=\"ep_tab_wrapper__5c51a99a-4735-4e46-b613-54b6e84afa9f\" class=\"ep_tab_item_wrapper ep_tab_wrapper__5c51a99a-4735-4e46-b613-54b6e84afa9f undefined\">\n<p class=\" eplus-wrapper\"><strong>Lab 3: NoSQL with PyMongo<\/strong><\/p>\n\n\n\n<p class=\" eplus-wrapper\">Text (\ud83d\udcc4<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/11\/DataManagement_lab4_2024-25.pdf\" target=\"_blank\" rel=\"noreferrer noopener\">pdf<\/a>)<br>Data (\ud83d\uddc2\ufe0f<a href=\"https:\/\/drive.google.com\/drive\/folders\/1FQl8HRbZDTXR4279ZEsfUEm1fIdpOs1E?usp=sharing\">link<\/a>)<br>Notebook (\ud83d\udcd2<a href=\"https:\/\/colab.research.google.com\/drive\/1nu3785xgJeSe3EMxk1xCh5JIVvSuBxNn#scrollTo=tQ4uBOR-q1ms\">colab<\/a>)<\/p>\n\n\n\n<p class=\" eplus-wrapper\">Solution (<a href=\"https:\/\/colab.research.google.com\/drive\/1OsDcix2M-Kxb2a4lXdx86MInmj73ELDe?usp=sharing\">\ud83d\udcd2colab<\/a>)<\/p>\n<\/div>\n\n\n\n<div id=\"ep_tab_wrapper__53fd1df6-58ec-4864-9d27-a2b89d5f754c\" class=\"ep_tab_item_wrapper ep_tab_wrapper__53fd1df6-58ec-4864-9d27-a2b89d5f754c undefined\">\n<p class=\" eplus-wrapper\"><strong>Lab 5: MongoDB replica set<\/strong><\/p>\n\n\n\n<p class=\" eplus-wrapper\">Text (\ud83d\udcc4<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/11\/DataManagement_lab5_2024-25.pdf\">pdf<\/a>)<br>Notebook (\ud83d\udcd2<a href=\"https:\/\/colab.research.google.com\/drive\/1l1ymlexh1JOju4RqDKzKhc8MN125MFk4\">colab<\/a>)<br>Docker Compose (\ud83d\udcdc<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/11\/docker-compose.yml_.zip\" target=\"_blank\" rel=\"noreferrer noopener\">file<\/a>)<\/p>\n\n\n\n<p class=\" eplus-wrapper\">\u2b50 Solution (\ud83d\udcd2<a href=\"https:\/\/colab.research.google.com\/drive\/1Eutb1YBAs1Wf4D_XM1UpIgOOWqtpn1oe\">colab<\/a>)<\/p>\n<\/div>\n\n\n\n<div id=\"ep_tab_wrapper__dd1b0217-488e-4766-8495-369f926dd4fc\" class=\"ep_tab_item_wrapper ep_tab_wrapper__dd1b0217-488e-4766-8495-369f926dd4fc undefined\">\n<p class=\" eplus-wrapper\"><strong>Lab 6: Visualization analysis<\/strong><\/p>\n\n\n\n<p class=\" eplus-wrapper\">Text (\ud83d\udcc4<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/11\/Lab6.pdf\">pdf<\/a>)<br>Data (\ud83d\uddc2\ufe0f<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/11\/Lab6.xlsx\">xlsx<\/a>)<\/p>\n\n\n\n<p class=\" eplus-wrapper\">Solution (\ud83d\uddc2\ufe0f<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/12\/Lab6_sol.xlsx\">xlsx<\/a>)<\/p>\n<\/div>\n\n\n\n<div id=\"ep_tab_wrapper__f56d791a-3885-4649-9cae-31b224945de3\" class=\"ep_tab_item_wrapper ep_tab_wrapper__f56d791a-3885-4649-9cae-31b224945de3 undefined\">\n<p class=\" eplus-wrapper\"><strong>Lab 7: Redesign with Tableau<\/strong><\/p>\n\n\n\n<p class=\" eplus-wrapper\">Text (\ud83d\udcc4<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/11\/Lab7.pdf\">pdf<\/a>)<br>Data (\ud83d\uddc2\ufe0f<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/11\/Lab7.xlsx\">xlsx<\/a>)<\/p>\n\n\n\n<p class=\" eplus-wrapper\">Solution (\ud83d\uddc3\ufe0f<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/12\/Lab7_sol.zip\">zip<\/a>)<\/p>\n<\/div>\n\n\n\n<div id=\"ep_tab_wrapper__26f9b594-deac-4824-9b9f-f4d541f0c403\" class=\"ep_tab_item_wrapper ep_tab_wrapper__26f9b594-deac-4824-9b9f-f4d541f0c403 undefined\">\n<p class=\" eplus-wrapper\"><strong>Lab 8: Visualization of a dataset<\/strong><\/p>\n\n\n\n<p class=\" eplus-wrapper\">Text (\ud83d\udcc4<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/12\/Lab8.pdf\">pdf<\/a>)<br>Data (\ud83d\uddc3\ufe0f<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/12\/f1db_csv.zip\">zip<\/a>;\ud83d\udcc4<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/12\/f1db_user_guide.txt\">txt<\/a>)<\/p>\n\n\n\n<p class=\" eplus-wrapper\">Solution (\ud83d\uddc3\ufe0f<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/12\/Lab8_sol.zip\">zip<\/a>)<\/p>\n<\/div>\n\n\n\n<div id=\"ep_tab_wrapper__688489fd-5c63-43b4-b47a-a0284bf09ec0\" class=\"ep_tab_item_wrapper ep_tab_wrapper__688489fd-5c63-43b4-b47a-a0284bf09ec0 undefined\">\n<p class=\" eplus-wrapper\"><strong>Lab 9: Intervals and dashboards<\/strong><\/p>\n\n\n\n<p class=\" eplus-wrapper\">Text (\ud83d\udcc4<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/12\/Lab9-1.pdf\">pdf<\/a>)<br>Data (\ud83d\uddc3\ufe0f<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/12\/Kickstarter.zip\">zip<\/a>)<\/p>\n\n\n\n<p class=\" eplus-wrapper\">Solution (\ud83d\uddc3\ufe0f<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/12\/Lab9_sol.zip\">zip<\/a>)<\/p>\n<\/div>\n\n\n\n<div id=\"ep_tab_wrapper__df1ee091-5695-494b-9917-ee345b56f85a\" class=\"ep_tab_item_wrapper ep_tab_wrapper__df1ee091-5695-494b-9917-ee345b56f85a undefined\">\n<p class=\" eplus-wrapper\"><strong>Lab 10: Geographic roles and maps<\/strong><\/p>\n\n\n\n<p class=\" eplus-wrapper\">Text (\ud83d\udcc4<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/12\/Lab10-1.pdf\">pdf<\/a>)<br>Data (\ud83d\uddc3\ufe0f<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/12\/Lab10.zip\">zip<\/a>)<\/p>\n\n\n\n<p class=\" eplus-wrapper\">Solution (\ud83d\uddc3\ufe0f<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/12\/Lab10_sol.zip\">zip<\/a>)<\/p>\n<\/div>\n\n\n\n<div id=\"ep_tab_wrapper__0c37f808-d3a7-4c3c-9fab-57b63da9f37f\" class=\"ep_tab_item_wrapper ep_tab_wrapper__0c37f808-d3a7-4c3c-9fab-57b63da9f37f undefined\">\n<p class=\" eplus-wrapper\"><strong>Lab 11: Dataviz exam simulation<\/strong><\/p>\n\n\n\n<p class=\" eplus-wrapper\">Text (\ud83d\udcc4<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2022\/01\/Lab11.pdf\">pdf<\/a>)<br>Visualization (\ud83d\udcca<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2022\/01\/BrandZ.jpg\">jpg<\/a>)<\/p>\n\n\n\n<p class=\" eplus-wrapper\">Solution (\ud83d\udcc4<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2022\/01\/Lab11_sol.pdf\">pdf<\/a>,&nbsp;\ud83d\uddc3\ufe0f<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2022\/01\/Lab11_sol.zip\">zip<\/a>)<\/p>\n<\/div>\n<\/div><style>.eplus_styles .ep_tabs_wrapper__9d984280-a6e3-4269-9afa-ba057cc2cc0f .ep_tabs_header {\n                \n                flex-basis: 15% ;\n            }.eplus_styles .ep_tabs_wrapper__9d984280-a6e3-4269-9afa-ba057cc2cc0f .ep_tabs_root {\n                \n                gap: 0px ;\n            }.eplus_styles .ep_tabs_wrapper__9d984280-a6e3-4269-9afa-ba057cc2cc0f .ep_label {\n                \n                color: #1e1e1e;\nfont-size: 17px ;\n            }\n            \n\n        \n\n         \n\n        \n        \n      .eplus_styles  .ep_label_main:hover .ep_label {\n        color: #ffffff;\n      }.eplus_styles .ep_tabs_wrapper__9d984280-a6e3-4269-9afa-ba057cc2cc0f .ep_sub_label {\n                \n                color: #1e1e1e;\nfont-size: 15px ;\n            }\n            \n\n        \n\n         \n\n        \n        \n      .eplus_styles  .ep_label_main:hover .ep_sub_label {\n        color: #ffffff;\n      }.eplus_styles .ep_tabs_wrapper__9d984280-a6e3-4269-9afa-ba057cc2cc0f .ep_active_tab .ep_label {\n                \n                color: #ffffff;\n            }.eplus_styles .ep_tabs_wrapper__9d984280-a6e3-4269-9afa-ba057cc2cc0f .ep_active_tab .ep_sub_label {\n                \n                color: #ffffff;\n            }.eplus_styles .ep_tabs_wrapper__9d984280-a6e3-4269-9afa-ba057cc2cc0f .ep_label_main {\n                \n                background-image: linear-gradient(#f0f0f0, #f0f0f0);\n            }\n            \n\n        \n\n         \n\n        \n            .eplus_styles .ep_tabs_wrapper__9d984280-a6e3-4269-9afa-ba057cc2cc0f .ep_label_main:hover {\n                background-image: linear-gradient(#007cba, #007cba);\n            }.eplus_styles .ep_tabs_wrapper__9d984280-a6e3-4269-9afa-ba057cc2cc0f .ep_active_tab {\n                \n                background-image: linear-gradient(#007cba, #007cba);\n            }.eplus_styles .ep_tabs_wrapper__9d984280-a6e3-4269-9afa-ba057cc2cc0f .ep_tab_item_wrapper {\n                \n                background-image: linear-gradient(#f0f0f0, #f0f0f0);\n            }.eplus_styles .ep_tabs_wrapper__9d984280-a6e3-4269-9afa-ba057cc2cc0f .ep_label_main {\n                \n                padding-top: 15px ;\npadding-right: 15px ;\npadding-bottom: 15px ;\npadding-left: 15px ;\n            }.eplus_styles .ep_tabs_wrapper__9d984280-a6e3-4269-9afa-ba057cc2cc0f .ep_tab_item_wrapper {\n                \n                padding-top: 15px ;\npadding-right: 15px ;\npadding-bottom: 15px ;\npadding-left: 15px ;\n            }.eplus_styles .ep_tabs_wrapper__9d984280-a6e3-4269-9afa-ba057cc2cc0f .ep_tabs_header {\n                \n                gap: 5px ;\n            }.eplus_styles .ep_tabs_wrapper__9d984280-a6e3-4269-9afa-ba057cc2cc0f .ep_tabs_header {\n                \n                justify-content: flex-start;\n            }<\/style><\/div><\/div>\n\n\n\n<hr class=\" wp-block-separator has-alpha-channel-opacity eplus-wrapper\"\/>\n\n\n\n<h2 class=\" wp-block-heading eplus-wrapper\" id=\"exam\">\ud83d\udcc4 Past Exams<\/h2>\n\n\n\n<p class=\" eplus-wrapper\">More exams are available on <a href=\"https:\/\/moodle.polito.it\/\">moodle.polito.it<\/a>.<\/p>\n\n\n\n<figure class=\" wp-block-table eplus-wrapper\"><table class=\"has-fixed-layout\"><thead><tr><th>Title<\/th><th>Text<\/th><th>Solutions<\/th><\/tr><\/thead><tbody><tr><td><strong>February 13th, 2025<\/strong><\/td><td>\ud83d\udcdd<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2025\/03\/DMV13-02.pdf\">Text and Solution<\/a><\/td><td><\/td><\/tr><tr><td><strong>January 29th, 2025<\/strong><\/td><td>\ud83d\udcdd<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2025\/06\/DMV_20250129.pdf\">Text and Solution<\/a><\/td><td><\/td><\/tr><tr><td><strong>September 16th, 2024<\/strong><\/td><td>\ud83d\udcdd<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/11\/exam2024-09-16.pdf\">Text + DW and NoSQL solutions<\/a><\/td><td><\/td><\/tr><tr><td><strong>September 20th, 2023<\/strong><\/td><td>\ud83d\udcdd<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/10\/DMV-Exam-20-September-2023.pdf\">Text + DW and NoSQL solutions<\/a><\/td><td><\/td><\/tr><tr><td><strong>June 21th, 2023<\/strong><\/td><td>\ud83d\udcdd<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/12\/DMV-Exam-29-June-2022.pdf\">Text + DW and NoSQL solutions<\/a><\/td><td><\/td><\/tr><tr><td><strong>February 22th, 2023<\/strong><\/td><td>\ud83d\udcdd<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/03\/DMV-Exam-22-February-2023.pdf\">Text + DW and NoSQL solutions<\/a><\/td><td>\ud83d\udcd1<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/03\/VizExamSheet_20230222.pdf\">Data visualization solutions<\/a><br>\ud83d\udcd1<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/11\/conceptual_230222.pdf\">Conceptual design<\/a><\/td><\/tr><tr><td><strong>February 7th, 2023<\/strong><\/td><td>\ud83d\udcdd<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/02\/DMV-Exam-7-February-2023.pdf\">Text + DW and NoSQL solutions<\/a><\/td><td>\ud83d\udcd1<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/02\/VizExamSheet_20230207.pdf\">Data visualization solutions<\/a><br>\ud83d\udcd1<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/11\/conceptual_230207.pdf\">Conceptual design<\/a><\/td><\/tr><tr><td><strong>June 29th, 2022<\/strong><\/td><td>\ud83d\udcdd<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/12\/DMV-Exam-29-June-2022.pdf\">Text + DW and NoSQL solutions<\/a><\/td><td><\/td><\/tr><tr><td><strong>February 17th, 2022<\/strong><\/td><td>\ud83d\udcdd<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2022\/12\/17feb_sol.pdf\">Text + DW and NoSQL solutions<\/a><\/td><td>\ud83d\udcd1<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2022\/02\/VizExamSheet_20220217.pdf\">Data visualization solutions<\/a><br>\ud83d\udcd1<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/11\/conceptual_230222.pdf\">Conceptual design<\/a><\/td><\/tr><tr><td><strong>January 28th, 2022<\/strong><\/td><td>\ud83d\udcdd<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2022\/02\/DMV-Exam-28-January-2022-textsolution.pdf\">Text + DW and NoSQL solutions<\/a><\/td><td>\ud83d\udcd1<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2022\/02\/VizExamSheet_20220128.pdf\">Data visualization solutions<\/a><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\" eplus-wrapper\"><\/p>\n\n\n\n\n\n<p class=\" eplus-wrapper\"><\/p>\n\n\n\n<p class=\" eplus-wrapper\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>General Information Lecturers: Daniele Apiletti, Diego Monti Teaching staff: Simone Monaco SSD: ING-INF\/05 &#8211; CFU: 8 &#8211; course details from the official student guide Q&amp;A teaching assistance on Piazza: piazza.com\/polito.it\/fall2024\/01txasm \ud83d\udcf0 News \ud83d\udcd2 Teaching material Course introduction (slides) \ud83d\uddd2\ufe0f Exercises \ud83d\udcbb Laboratory material Students group Time Room TEAM 1 (FROM &hellip;<\/p>\n","protected":false},"author":11,"featured_media":1340,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"editor_plus_copied_stylings":"{}","footnotes":""},"categories":[37],"tags":[],"class_list":["post-9875","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-courses"],"_links":{"self":[{"href":"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-json\/wp\/v2\/posts\/9875","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-json\/wp\/v2\/comments?post=9875"}],"version-history":[{"count":77,"href":"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-json\/wp\/v2\/posts\/9875\/revisions"}],"predecessor-version":[{"id":12789,"href":"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-json\/wp\/v2\/posts\/9875\/revisions\/12789"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-json\/wp\/v2\/media\/1340"}],"wp:attachment":[{"href":"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-json\/wp\/v2\/media?parent=9875"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-json\/wp\/v2\/categories?post=9875"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-json\/wp\/v2\/tags?post=9875"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}