{"id":4613,"date":"2022-09-26T16:52:33","date_gmt":"2022-09-26T14:52:33","guid":{"rendered":"https:\/\/dbdmg.polito.it\/dbdmg_web\/?p=4613"},"modified":"2023-03-08T19:27:59","modified_gmt":"2023-03-08T18:27:59","slug":"data-management-and-visualization-2022-23","status":"publish","type":"post","link":"https:\/\/dbdmg.polito.it\/dbdmg_web\/2022\/data-management-and-visualization-2022-23\/","title":{"rendered":"Data Management and Visualization (2022-23)"},"content":{"rendered":"\n<h1 class=\"eplus-wrapper wp-block-heading\" id=\"general-information\">General Information<\/h1>\n\n\n\n<p class=\" eplus-wrapper\"><strong>Lecturers<\/strong>: Daniele Apiletti, Silvia Chiusano, Diego Monti<\/p>\n\n\n\n<p class=\" eplus-wrapper\"><strong>Teaching staff<\/strong>: Alessandro Fiori, 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=2023&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=\"http:\/\/piazza.com\/polito.it\/fall2022\/01txasm\/\">piazza.com\/polito.it\/fall2022\/01txasm\/<\/a><\/p>\n\n\n\n\n\n<hr class=\" wp-block-separator has-css-opacity eplus-wrapper\"\/>\n\n\n\n<h1 class=\"eplus-wrapper wp-block-heading\" id=\"news\">News<\/h1>\n\n\n<ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-4ca7e8\">\n<li class=\" eplus-wrapper\">5 December 2022: the Lab practice originally scheduled for December 16th is canceled. It will be held on December 20th in classroom 2P (please bring your laptop): team A from 10:00 to 11:30, team B from 11:30 to 13:00.<\/li>\n\n\n\n<li class=\" eplus-wrapper\">10 October 2022: the lecture on Tuesday, October 11, 2022 will be held only online (not in presence) via virtual classroom. The lecture will be recorded.<\/li>\n\n\n\n<li class=\" eplus-wrapper\">9 October 2022: the lesson on Monday, October 10, 2022 will be held only online (not in presence) via virtual classroom. The lesson will be recorded.<\/li>\n\n\n\n<li class=\" eplus-wrapper\">27 September 2023: the 22-23 edition of the course begins! See the <a href=\"https:\/\/www.swas.polito.it\/dotnet\/orari_lezione_pub\/RicercaAvanzata.aspx\">official timetable<\/a>.<\/li>\n\n\n\n<li class=\" eplus-wrapper\">We are using Piazza for class discussion, we invite all students to <a href=\"http:\/\/piazza.com\/polito.it\/fall2022\/01txasm\/home\">join the course Piazza<\/a>. Piazza is highly catered to getting help fast and efficiently from both 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<h1 class=\"eplus-wrapper wp-block-heading\" id=\"teaching-material\">Teaching material<\/h1>\n\n\n\n<p class=\" eplus-wrapper\">Course introduction (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2022\/09\/0-DMV-intro-22-23.pdf\">slides<\/a>) &#8211; <em>errata corrige on October 21, 2022: the Rector has informed us that teaching activities will be regularly provided on <strong>Friday, December 9th, 2022<\/strong>, hence please note that our <strong>Lab practice<\/strong> will be held on that day from 8:30 to 11:30, as in the standard weekly timetable of the course<\/em><\/p>\n\n\n\n<h2 class=\"eplus-wrapper wp-block-heading\" id=\"data-warehousing\">Data Warehousing<\/h2>\n\n\n<ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-b8be3d\">\n<li class=\" eplus-wrapper\">Introduction (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/09\/1-DWIntroduction-1per.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\/wordpress\/wp-content\/uploads\/2018\/10\/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\">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<\/ul>\n\n\n<div class=\"wp-block-group eplus-wrapper\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<h4 class=\"eplus-wrapper wp-block-heading\" id=\"exercises\">Exercises<\/h4>\n\n\n<\/div><\/div>\n\n\n<ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-fa3d5a\">\n<li class=\" eplus-wrapper\">ESERCIZI CON SOLUZIONI<\/li>\n\n\n\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>, <a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2017\/11\/ExtendedSQLDraftSolutionCustomer.pdf\">draft solution<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Exercise extended SQL, rentals (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/ExtendedSQL_ENG.pdf\">text<\/a>, <a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/ExtendedSQL-draft_solution.pdf\">draft solution<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Exercise DW design, hotels (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2019\/12\/05-DW-project-hotel-text.pdf\">text<\/a>, <a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/DW-project-hotel_chain_draft_solution.pdf\">draft solution<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Exercise DW design, storehouses (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2019\/10\/03-DW-project-household-text.pdf\">text<\/a>, <a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/DW-project-Italian_household_draft-solution.pdf\">draft solution<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Exercise DW design, rentals (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2019\/10\/04-DW-project-HouseSearch-text.pdf\">text<\/a>, <a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/DW-project-SearchingYourHouse-draft_solution.pdf\">draft solution<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Exercise DW design, parcels (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2019\/12\/06-DW-project-parcels-text.pdf\">text<\/a>, <a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/01\/DW_Parcels_Schema.pdf\">draft solution<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\"> Exercise DW design, computer (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2019\/12\/07-DW-project-PC-text.pdf\">text<\/a>, <a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2022\/01\/DW_PCStore_DraftSol.pdf\">draft solution<\/a>) <\/li>\n\n\n\n<li class=\" eplus-wrapper\">Vehicle rental (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/12\/Vehicle_rental_DW_text.pdf\">text<\/a>,\u00a0<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/12\/Vehicle_rental_DW_text_draft_sol-1.pdf\">draft solution<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Versioning services (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/12\/Versioning_services_DW_text.pdf\">text<\/a>,\u00a0<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/12\/Versioning_services_DW_draft_sol.pdf\">draft solution<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Craft beer (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/12\/Craft_beer_DW_text.pdf\">text<\/a>,\u00a0<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2021\/01\/Craft_beer_DW_draft_sol.pdf\">draft solution<\/a>) <\/li>\n\n\n\n<li class=\" eplus-wrapper\">Tickets (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/12\/Tickets_DW_text.pdf\">text<\/a>,\u00a0<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2021\/01\/Tickets_DW_draft_sol.pdf\">draft solution<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Food delivery (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/12\/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\">draft solution<\/a>) <\/li>\n<\/ul>\n\n\n<div class=\"wp-block-group eplus-wrapper\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<h2 class=\"eplus-wrapper wp-block-heading\" id=\"nosql\">NoSQL<\/h2>\n\n\n<ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-f16c49\">\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 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>, <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 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\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><\/div>\n\n\n<ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-dfcebb\">\n<li class=\" eplus-wrapper\">Additional exercises:<ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-97e91d\">\n<li class=\" eplus-wrapper\">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>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">MongoDB query exercises (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2021\/01\/MongoDB_query-exercises-v1-text-only.pdf\">text<\/a>)<\/li>\n<\/ul><\/li>\n<\/ul>\n\n\n\n\n<h2 class=\"eplus-wrapper wp-block-heading\" id=\"data-visualization\">Data Visualization<\/h2>\n\n\n<ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-394e09\">\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\n\n\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>\n\n\n\n\n<p class=\" eplus-wrapper\"><\/p>\n\n\n\n<hr class=\" wp-block-separator has-css-opacity eplus-wrapper\"\/>\n\n\n\n<h1 class=\"eplus-wrapper wp-block-heading\" id=\"laboratory-material\">Laboratory material<\/h1>\n\n\n\n<p class=\" eplus-wrapper\">Lab practices start on <strong>Friday, October 14th, 2022<\/strong>.<\/p>\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 A (FROM A TO K)<\/td><td>Friday, 8:30 &#8211; 10:00 am<\/td><td>LAIB4<\/td><\/tr><tr><td>TEAM B (FROM L TO Z)<\/td><td>Friday, 10:00 &#8211; 11:30 am<\/td><td>LAIB4<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\" eplus-wrapper\"><\/p>\n\n\n\n<p class=\" eplus-wrapper\"><\/p>\n\n\n\n<p class=\" eplus-wrapper\">For Lab 1 and 2 you need to run <strong>Extended SQL<\/strong> on <strong>Oracle databases<\/strong>. SQL Developer is already available at LABINF. If you want to practise at home, you can follow one of these options:<\/p>\n\n\n\n<p class=\" eplus-wrapper\"><meta http-equiv=\"content-type\" content=\"text\/html; charset=utf-8\"><\/p>\n\n\n\n<figure class=\"wp-block-table eplus-wrapper\"><table><tbody>\n<tr>\n<td>Online version <strong>[SUGGESTED METHOD]<\/strong><\/td>\n<td>Installing Oracle Database 18c and SQL Developer <strong>[NOT RECOMMENDED]<\/strong><\/td>\n<\/tr>\n\n<tr>\n<td>Instead of installing Oracle Database and SQL Developer (not always straightforward to configure), you can consider <a href=\"https:\/\/livesql.oracle.com\/\">Oracle Live SQL<\/a>.\n<ul>\n<li>You can add tables using SQL scripts<\/li>\n<li>A short guide on how to import SQL scripts and query the DB in Oracle Live SQL is available (<a href=\"http:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/10\/Import_Oracle_Live_SQL.docx.pdf\">pdf<\/a>)<\/li>\n<\/ul>\n<\/td>\n<td>\n<ul>\n<li>To download and install Oracle Express Edition:&nbsp;<a rel=\"noreferrer noopener\" href=\"https:\/\/www.oracle.com\/it\/database\/technologies\/appdev\/xe.html\" target=\"_blank\">home page<\/a><\/li>\n<li>To download and install SQL Developer:&nbsp;<a rel=\"noreferrer noopener\" href=\"https:\/\/www.oracle.com\/it\/database\/technologies\/appdev\/xe.html\" target=\"_blank\">home page<\/a><\/li>\n<li>TutorialInstallation Guide for&nbsp;<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/10\/TutorialWindowsOracleDB_ENG.pdf\">Windows<\/a><\/li>\n<li>Installation Guide for&nbsp;<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2022\/10\/TutorialUbuntuOracleDBpdf.pdf\">Ubuntu<\/a><\/li>\n<li>Installation Guide for&nbsp;<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/10\/TutorialMACOsOracleDB_ENG.pdf\">Mac OS<\/a><\/li>\n<li>Import Database and Tables: <a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/10\/ImportDatabaseSQL_ENG.pdf\">Tutorial<\/a><\/li>\n<\/ul>\n<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\" eplus-wrapper\"><strong>Lab 1: Extended SQL<\/strong><\/p>\n\n\n<ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-e6d6e3\">\n<li class=\" eplus-wrapper\">Text (<a href=\"http:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/10\/Lab1_ExtendedSQL.pdf\">pdf<\/a>) <\/li>\n\n\n\n<li class=\" eplus-wrapper\">Data warehouse tables (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/10\/DW_Phones_EN.zip\">zip (CSV)<\/a>, <a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/10\/DW_CELLS_sql.zip\">zip (SQL)<\/a>)<\/li>\n<\/ul>\n\n<ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-44eb90\">\n<li class=\" eplus-wrapper\">Solution (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/10\/star_schema_callDW_Sol.pdf\">star schema<\/a>, <a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2022\/10\/Lab1_ExtendedSQL_Sol.pdf\">queries<\/a>)<\/li>\n<\/ul>\n\n\n<p class=\" eplus-wrapper\"><meta http-equiv=\"content-type\" content=\"text\/html; charset=utf-8\"><strong>Lab 2: Extended SQL<\/strong><\/p>\n\n\n<ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-5ad06c\">\n<li class=\" eplus-wrapper\">Text \u2013 Additional queries\u00a0(<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/10\/Lab2_ExtendedSQL.pdf\">pdf<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Solution (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/11\/Lab2_ExtendedSQL_sol.pdf\">pdf<\/a>)<\/li>\n<\/ul>\n\n\n<p class=\" eplus-wrapper\"><strong>Lab 3: Looker Studio<\/strong><\/p>\n\n\n<ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-e2790f\">\n<li class=\" eplus-wrapper\">Text (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2022\/10\/Lab3_DataStudio_v2022.pdf\" target=\"_blank\" rel=\"noreferrer noopener\">pdf<\/a>)<\/li>\n<\/ul>\n\n\n<p class=\" eplus-wrapper\"><strong>Lab 4: MongoDB Compass<\/strong><\/p>\n\n\n<ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-2f2b2a\">\n<li class=\" eplus-wrapper\">Text (<a rel=\"noreferrer noopener\" href=\"http:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/11\/Lab4-mongo_compass.pdf\" target=\"_blank\">pdf<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Data (<a rel=\"noreferrer noopener\" href=\"https:\/\/drive.google.com\/drive\/folders\/1FQl8HRbZDTXR4279ZEsfUEm1fIdpOs1E?usp=sharing\" target=\"_blank\">link<\/a>)<\/li>\n<\/ul>\n\n<ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-bb3cec\">\n<li class=\" eplus-wrapper\">Draft solution (<a rel=\"noreferrer noopener\" href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2022\/02\/DataManagement_compass_sol.pdf\" target=\"_blank\">pdf<\/a>)<\/li>\n<\/ul>\n\n\n<p class=\" eplus-wrapper\"><strong>Lab 5: MongoDB replica set<\/strong><\/p>\n\n\n<ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-55395e\">\n<li class=\" eplus-wrapper\">Text (<a rel=\"noreferrer noopener\" href=\"http:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/11\/DMV_Lab5_MongoDB_text_2procedures.pdf\" target=\"_blank\">pdf)<\/a><\/li>\n\n\n\n<li class=\" eplus-wrapper\">Data (<a rel=\"noreferrer noopener\" href=\"http:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/11\/restaurants_collection.txt\" target=\"_blank\">file<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Docker Compose (<a rel=\"noreferrer noopener\" href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/11\/docker-compose.yml_.zip\" target=\"_blank\">file<\/a>)<\/li>\n<\/ul>\n\n<ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-0d7413\">\n<li class=\" eplus-wrapper\">Draft solution (<a rel=\"noreferrer noopener\" href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2022\/02\/DMV_Lab5_MongoDB_solution.pdf\" target=\"_blank\">pdf<\/a>)<\/li>\n<\/ul>\n\n\n<p class=\" eplus-wrapper\"><strong>Lab 6: Visualization analysis<\/strong><\/p>\n\n\n<ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-14d419\">\n<li class=\" eplus-wrapper\">Text (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/11\/Lab6.pdf\">pdf<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Data (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/11\/Lab6.xlsx\">xlsx<\/a>)<\/li>\n<\/ul>\n\n<ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-64500d\">\n<li class=\" eplus-wrapper\">Solution (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/12\/Lab6_sol.xlsx\">xlsx<\/a>)<\/li>\n<\/ul>\n\n\n<p class=\" eplus-wrapper\"><strong>Lab 7: Redesign with Tableau<\/strong><\/p>\n\n\n<ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-d9ca15\">\n<li class=\" eplus-wrapper\">Text (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/11\/Lab7.pdf\">pdf<\/a>)<\/li>\n<\/ul>\n\n<ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-9fb1b6\">\n<li class=\" eplus-wrapper\">Solution (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/12\/Lab7_sol.zip\">zip<\/a>)<\/li>\n<\/ul>\n\n\n<p class=\" eplus-wrapper\"><strong>Lab 8: Visualization of a dataset<\/strong><\/p>\n\n\n<ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-7ce3ef\">\n<li class=\" eplus-wrapper\">Text (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/12\/Lab8.pdf\">pdf<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Data (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/12\/f1db_csv.zip\">zip<\/a>; <a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/12\/f1db_user_guide.txt\">txt<\/a>)<\/li>\n<\/ul>\n\n<ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-be9941\">\n<li class=\" eplus-wrapper\">Solution (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/12\/Lab8_sol.zip\">zip<\/a>)<\/li>\n<\/ul>\n\n\n<p class=\" eplus-wrapper\"><strong>Lab 9: Intervals and dashboards<\/strong><\/p>\n\n\n<ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-3c42e8\">\n<li class=\" eplus-wrapper\">Text (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/12\/Lab9-1.pdf\">pdf<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Data (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/12\/Kickstarter.zip\">zip<\/a>)<\/li>\n<\/ul>\n\n<ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-5bc518\">\n<li class=\" eplus-wrapper\">Solution (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/12\/Lab9_sol.zip\">zip<\/a>)<\/li>\n<\/ul>\n\n\n<p class=\" eplus-wrapper\"><strong>Lab 10: Geographic roles and maps<\/strong><\/p>\n\n\n<ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-a2ff5a\">\n<li class=\" eplus-wrapper\">Text (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/12\/Lab10-1.pdf\">pdf<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Data (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/12\/Lab10.zip\">zip<\/a>)<\/li>\n<\/ul>\n\n<ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-8523fb\">\n<li class=\" eplus-wrapper\">Solution (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/12\/Lab10_sol.zip\">zip<\/a>)<\/li>\n<\/ul>\n\n\n<p class=\" eplus-wrapper\"><strong>Lab 11: Dataviz exam simulation<\/strong><\/p>\n\n\n<ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-97664d\">\n<li class=\" eplus-wrapper\">Text (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2022\/01\/Lab11.pdf\">pdf<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Visualization (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2022\/01\/BrandZ.jpg\">jpg<\/a>)<\/li>\n<\/ul>\n\n<ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-7a5f21\">\n<li class=\" eplus-wrapper\">Solution (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2022\/01\/Lab11_sol.pdf\">pdf<\/a>, <a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2022\/01\/Lab11_sol.zip\">zip<\/a>)<\/li>\n<\/ul>\n\n\n<hr class=\" wp-block-separator has-alpha-channel-opacity eplus-wrapper\"\/>\n\n\n\n<h1 class=\"eplus-wrapper wp-block-heading\" id=\"exam\">Exam<\/h1>\n\n\n\n<div class=\"wp-block-group eplus-wrapper\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<p class=\" eplus-wrapper\">This section will provide the texts and solutions for the exams.<\/p>\n\n\n<ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-1029ad\">\n<li class=\" eplus-wrapper\"><strong>Feb 1st, 2021<\/strong><ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-e3835c\">\n<li class=\" eplus-wrapper\">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\n\n\n<li class=\" eplus-wrapper\">Data visualization solutions (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2021\/02\/VizExamSheet_sol.pdf\">pdf<\/a>)<\/li>\n<\/ul><\/li>\n\n\n\n<li class=\" eplus-wrapper\"><strong>Feb 15th, 2021<\/strong><ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-76c823\">\n<li class=\" eplus-wrapper\">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\n\n\n<li class=\" eplus-wrapper\">Data visualization solutions (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2021\/02\/VizExamSheet_sol-1.pdf\">pdf<\/a>)<\/li>\n<\/ul><\/li>\n\n\n\n<li class=\" eplus-wrapper\"><strong>June 17th, 2021<\/strong><ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-d8912b\">\n<li class=\" eplus-wrapper\">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\n\n\n<li class=\" eplus-wrapper\">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><\/li>\n\n\n\n<li class=\" eplus-wrapper\"><strong>September 1st, 2021<\/strong><ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-3cec8c\">\n<li class=\" eplus-wrapper\">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\n\n\n<li class=\" eplus-wrapper\">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><\/li>\n\n\n\n<li class=\" eplus-wrapper\"><strong>January 28th, 2022<\/strong><ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-8ad9be\">\n<li class=\" eplus-wrapper\">Text + DW and NoSQL solutions (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2022\/02\/DMV-Exam-28-January-2022-textsolution.pdf\">pdf<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Data visualization solutions (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2022\/02\/VizExamSheet_20220128.pdf\">pdf<\/a>)<\/li>\n<\/ul><\/li>\n\n\n\n<li class=\" eplus-wrapper\"><strong>February 17th, 2022<\/strong><ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-a02dbe\">\n<li class=\" eplus-wrapper\">Text + DW and NoSQL solutions (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2022\/12\/17feb_sol.pdf\">pdf<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Data visualization solutions (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2022\/02\/VizExamSheet_20220217.pdf\">pdf<\/a>)<\/li>\n<\/ul><\/li>\n\n\n\n<li class=\" eplus-wrapper\"><strong>February 7th, 2023<\/strong><ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-f4c2c3\">\n<li class=\" eplus-wrapper\">Text + DW and NoSQL solutions (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/02\/DMV-Exam-7-February-2023.pdf\">pdf<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Data visualization solutions (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/02\/VizExamSheet_20230207.pdf\">pdf<\/a>)<\/li>\n<\/ul><\/li>\n\n\n\n<li class=\" eplus-wrapper\"><strong>February 22th, 2023<\/strong><ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-cfc4a7\">\n<li class=\" eplus-wrapper\">Text + DW and NoSQL solutions (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/03\/DMV-Exam-22-February-2023.pdf\">pdf<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Data visualization solutions (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/03\/VizExamSheet_20230222.pdf\">pdf<\/a>)<\/li>\n<\/ul><\/li>\n<\/ul><\/div><\/div>\n","protected":false},"excerpt":{"rendered":"<p>General Information Lecturers: Daniele Apiletti, Silvia Chiusano, Diego Monti Teaching staff: Alessandro Fiori, 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\/fall2022\/01txasm\/ News Teaching material Course introduction (slides) &#8211; errata corrige on October 21, 2022: the Rector has &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-4613","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\/4613","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=4613"}],"version-history":[{"count":51,"href":"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-json\/wp\/v2\/posts\/4613\/revisions"}],"predecessor-version":[{"id":5889,"href":"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-json\/wp\/v2\/posts\/4613\/revisions\/5889"}],"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=4613"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-json\/wp\/v2\/categories?post=4613"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-json\/wp\/v2\/tags?post=4613"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}