{"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 wp-block-paragraph\"><strong>Lecturers<\/strong>: Daniele Apiletti, Diego Monti<\/p>\n\n\n\n<p class=\"eplus-wrapper wp-block-paragraph\"><strong>Teaching staff<\/strong>: Simone Monaco<\/p>\n\n\n\n<p class=\"eplus-wrapper wp-block-paragraph\"><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 wp-block-paragraph\">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 wp-block-paragraph\"><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 wp-block-paragraph\"><\/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 wp-block-paragraph\">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 wp-block-paragraph\"><strong>Lab 1: Extended SQL<\/strong><\/p>\n\n\n\n<p class=\"eplus-wrapper wp-block-paragraph\">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 wp-block-paragraph\"><strong>Lab 2: Extended SQL<\/strong><\/p>\n\n\n\n<p class=\"eplus-wrapper wp-block-paragraph\">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 wp-block-paragraph\"><strong>Lab 3: Looker Studio<\/strong><\/p>\n\n\n\n<p class=\"eplus-wrapper wp-block-paragraph\">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 wp-block-paragraph\"><strong>Lab 3: NoSQL with PyMongo<\/strong><\/p>\n\n\n\n<p class=\"eplus-wrapper wp-block-paragraph\">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 wp-block-paragraph\">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 wp-block-paragraph\"><strong>Lab 5: MongoDB replica set<\/strong><\/p>\n\n\n\n<p class=\"eplus-wrapper wp-block-paragraph\">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 wp-block-paragraph\">\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 wp-block-paragraph\"><strong>Lab 6: Visualization analysis<\/strong><\/p>\n\n\n\n<p class=\"eplus-wrapper wp-block-paragraph\">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 wp-block-paragraph\">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 wp-block-paragraph\"><strong>Lab 7: Redesign with Tableau<\/strong><\/p>\n\n\n\n<p class=\"eplus-wrapper wp-block-paragraph\">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 wp-block-paragraph\">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 wp-block-paragraph\"><strong>Lab 8: Visualization of a dataset<\/strong><\/p>\n\n\n\n<p class=\"eplus-wrapper wp-block-paragraph\">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 wp-block-paragraph\">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 wp-block-paragraph\"><strong>Lab 9: Intervals and dashboards<\/strong><\/p>\n\n\n\n<p class=\"eplus-wrapper wp-block-paragraph\">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 wp-block-paragraph\">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 wp-block-paragraph\"><strong>Lab 10: Geographic roles and maps<\/strong><\/p>\n\n\n\n<p class=\"eplus-wrapper wp-block-paragraph\">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 wp-block-paragraph\">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 wp-block-paragraph\"><strong>Lab 11: Dataviz exam simulation<\/strong><\/p>\n\n\n\n<p class=\"eplus-wrapper wp-block-paragraph\">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 wp-block-paragraph\">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 wp-block-paragraph\">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 wp-block-paragraph\"><\/p>\n\n\n\n\n\n<p class=\"eplus-wrapper wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"eplus-wrapper wp-block-paragraph\"><\/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}]}}