{"id":1316,"date":"2021-09-13T18:32:20","date_gmt":"2021-09-13T16:32:20","guid":{"rendered":"https:\/\/dbdmg.polito.it\/dbdmg_web\/?p=1316"},"modified":"2022-02-24T20:36:04","modified_gmt":"2022-02-24T19:36:04","slug":"data-management-and-visualization-2021-22","status":"publish","type":"post","link":"https:\/\/dbdmg.polito.it\/dbdmg_web\/2021\/data-management-and-visualization-2021-22\/","title":{"rendered":"Data Management and Visualization (2021-22)"},"content":{"rendered":"\n<h1 class=\"eplus-wrapper wp-block-heading\" id=\"general-information\">General Information<\/h1>\n\n\n\n<p class=\"eplus-wrapper wp-block-paragraph\"><strong>Lecturers<\/strong>: Daniele Apiletti, Silvia Chiusano, Diego Monti<\/p>\n\n\n\n<p class=\"eplus-wrapper wp-block-paragraph\"><strong>Teaching staff<\/strong>: Eliana Pastor, Alessandro Fiori, 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 rel=\"noreferrer noopener\" href=\"https:\/\/didattica.polito.it\/pls\/portal30\/gap.pkg_guide.viewGap?p_cod_ins=01TXASM&amp;p_a_acc=2022&amp;p_header=S&amp;p_lang=EN\" target=\"_blank\">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 style=\"font-size: revert;\" href=\"https:\/\/piazza.com\/polito.it\/fall2021\/01txasm\">https:\/\/piazza.com\/polito.it\/fall2021\/01txasm<\/a><\/p>\n\n\n\n\n\n<hr class=\"wp-block-separator 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-15a4b4\"><li>27 September 2021: the 21-22 edition of the course begins! See the <a href=\"https:\/\/www.swas.polito.it\/dotnet\/orari_lezione_pub\/RicercaAvanzata.aspx\">official timetable<\/a>.<\/li><li>We are using Piazza for class discussion, we invite all students to <a href=\"https:\/\/piazza.com\/polito.it\/fall2021\/01txasm\">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><\/ul>\n\n\n<hr class=\"wp-block-separator eplus-wrapper\"\/>\n\n\n\n<h1 class=\"eplus-wrapper wp-block-heading\" id=\"exam\">Exam<\/h1>\n\n\n\n<p class=\"eplus-wrapper wp-block-paragraph\">This section will provide the text and solution of the exams.<\/p>\n\n\n<ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-84410d\"><li>Feb 1st, 2021<ul><li>Text + DW and NOSQL solutions (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2021\/02\/DMV_Exam2021_02_01_draft_sol.pdf\">pdf<\/a>)<\/li><li>Data visualization solutions (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2021\/02\/VizExamSheet_sol.pdf\">pdf<\/a>)<\/li><\/ul><\/li><li>Feb 15th, 2021<ul><li>Text + DW and NOSQL solutions (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2021\/02\/DMV-Exam-15-February-2021-text-and-solutions.pdf\">pdf<\/a>)<\/li><li>Data visualization solutions (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2021\/02\/VizExamSheet_sol-1.pdf\">pdf<\/a>)<\/li><\/ul><\/li><li>June 17th, 2021<ul><li>Text + DW and NOSQL solutions (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2021\/06\/DMV-Exam-17-June-2021-text-solutions-from-Exam.pdf\">pdf<\/a>)<\/li><li>Data visualization solution (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2021\/06\/DMV_2021-06-17_VizExamSheet_sol.pdf\">pdf<\/a>)<\/li><\/ul><\/li><li>September 1st, 2021 <ul><li>Text + DW and NOSQL solutions (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2021\/09\/DMV-Exam-1-September-2021-text.pdf\">pdf<\/a>)<\/li><li>Data visualization solutions (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2021\/09\/DMV-2021-09-01-VizExamSheet_sol.pdf\">pdf<\/a>)<\/li><\/ul><\/li><li>January 28th, 2022<ul><li>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><li>Data visualization solutions (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2022\/02\/VizExamSheet_20220128.pdf\">pdf<\/a>)<\/li><\/ul><\/li><li>February 17th, 2022<ul><li>Text + DW and NoSQL solutions (available soon)<\/li><li>Data visualization solutions (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2022\/02\/VizExamSheet_20220217.pdf\">pdf<\/a>)<\/li><\/ul><\/li><\/ul>\n\n\n<hr class=\"wp-block-separator 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 wp-block-paragraph\">Course introduction (<a href=\"http:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/09\/0-DMV-intro-21-22.pdf\">slides<\/a>) <\/p>\n\n\n\n<p class=\"eplus-wrapper wp-block-paragraph\"><\/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-abf9f4\"><li>Introduction (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/09\/1-DWIntroduction-1per.pdf\">slides<\/a>)<\/li><li>Conceptual and logical design (<a href=\"http:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/09\/DSTBD_3-DWprogConcLog-EN.pdf\">slides<\/a>) &#8211; slides updated on Oct, 1st, 2021 (minor revision)<\/li><li>Data analysis, OLAP, extended SQL (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2018\/10\/4-DWquery-EN.pdf\">slides<\/a>)<\/li><li>ETL process (<a href=\"http:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/10\/DMV_6-DW-ETL-1per.pdf\">slides<\/a>)<\/li><li>Materialized view (<a href=\"http:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/10\/DMV_3-DW-materializedview-1per.pdf\">slides<\/a>)<\/li><li>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><li>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><\/ul>\n\n\n<h3 class=\"eplus-wrapper wp-block-heading\" id=\"exercises\">Exercises<\/h3>\n\n\n\n<p class=\"eplus-wrapper wp-block-paragraph\">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>)<\/p>\n\n\n\n<p class=\"eplus-wrapper wp-block-paragraph\">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>)<\/p>\n\n\n\n<p class=\"eplus-wrapper wp-block-paragraph\">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>)<\/p>\n\n\n\n<p class=\"eplus-wrapper wp-block-paragraph\">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>)<\/p>\n\n\n\n<p class=\"eplus-wrapper wp-block-paragraph\">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>)<\/p>\n\n\n\n<p class=\"eplus-wrapper wp-block-paragraph\">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>)<\/p>\n\n\n\n<p class=\"eplus-wrapper wp-block-paragraph\"> 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>) <\/p>\n\n\n\n<p class=\"eplus-wrapper wp-block-paragraph\">Additional exercises:<\/p>\n\n\n<ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-0aa66e\"><li>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><li>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><li>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><li>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><li>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\/wordpress\/wp-content\/uploads\/2021\/01\/Food_delivery_DW_draft_sol.pdf\">draft solution<\/a>) <\/li><\/ul>\n\n\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-3df82f\"><li>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><li>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><li>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><li>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><li>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><li>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><li>Distributed transactions (<a href=\"http:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/09\/08a-Distributed-Transactions-2PC.pdf\">slides<\/a>)<\/li><li>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><li>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><li>MongoDB query exercises (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/09\/07-MongoDB-query-exercises.pdf\">slides<\/a>)<\/li><li>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>) &#8211; updated Dec 13, 2021 with solutions<\/li><li>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><li>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><li>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><li>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><\/ul>\n\n\n<p class=\"eplus-wrapper wp-block-paragraph\">Additional exercises:<\/p>\n\n\n<ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-7020de\"><li>MongoDB design pattern exercises (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2021\/01\/MongoDB_design_pattern-exercises-v3-text-only.pdf\">text<\/a>,\u00a0<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2021\/01\/MongoDB_design_pattern-exercises-v3-text-and-solutions.pdf\">solutions<\/a>)<\/li><li>MongoDB query exercises (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2021\/01\/MongoDB_query-exercises-v1-text-only.pdf\">text<\/a>,\u00a0<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2021\/01\/MongoDB_query-exercises_sol.pptx.pdf\">solutions<\/a>)<\/li><\/ul>\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-ce40af\"><li>What is visualization (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/11\/DV01-DataVisualization.pdf\">slides<\/a>)<\/li><li>Visual perception (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/11\/DV02-VisualPerception.pdf\">slides<\/a>)<\/li><li>Graph construction (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/12\/DV03-GraphConstruction.pdf\">slides<\/a>)<\/li><li>Data quality (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/12\/DV04-DataQuality.pdf\">slides<\/a>)<\/li><li>Past exams (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2022\/01\/DV05-PastExams.pdf\">slides<\/a>)<\/li><\/ul>\n\n\n<h2 class=\"eplus-wrapper wp-block-heading\" id=\"seminars\">Seminars<\/h2>\n\n\n\n<p class=\"eplus-wrapper wp-block-paragraph\">Docsity data lineage (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/09\/Docsity-data-lineage-2022-01-13.pdf\">slides<\/a>)<\/p>\n\n\n\n<hr class=\"wp-block-separator 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 wp-block-paragraph\">Lab practices start on Tuesday, October 19th, 2021.<\/p>\n\n\n\n<p class=\"eplus-wrapper wp-block-paragraph\"><meta http-equiv=\"content-type\" content=\"text\/html; charset=utf-8\"><strong>LAB SCHEDULE.&nbsp;<\/strong><br>TEAM A (FROM A TO K) on Tuesday from 1 pm to 2:30 pm<br>TEAM B (FROM L TO Z) on <meta http-equiv=\"content-type\" content=\"text\/html; charset=utf-8\">Tuesday from 2:30 pm to 4pm<\/p>\n\n\n\n<p class=\"eplus-wrapper wp-block-paragraph\"><meta http-equiv=\"content-type\" content=\"text\/html; charset=utf-8\"><strong>Lab 1: Extended SQL<\/strong><\/p>\n\n\n<ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-381f0f\"><li>Text (<a href=\"http:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/10\/Lab1_ExtendedSQL.pdf\">pdf<\/a>) <\/li><li>Data warehouse tables in csv format (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/10\/DW_Phones_EN.zip\">zip<\/a>)<\/li><li>SQL Developer is already available at LABINF. If you want to practise at home, you can follow these tutorials<\/li><li>Installing <strong>Oracle Database 18c Express Edition <\/strong>and<strong> SQL Developer<\/strong><ul><li>To download and install Oracle Express Edition:\u00a0<a rel=\"noreferrer noopener\" href=\"https:\/\/www.oracle.com\/it\/database\/technologies\/appdev\/xe.html\" target=\"_blank\">home page<\/a><\/li><li>To download and install SQL Developer:\u00a0<a rel=\"noreferrer noopener\" href=\"https:\/\/www.oracle.com\/it\/database\/technologies\/appdev\/xe.html\" target=\"_blank\">home page<\/a><\/li><li>Tutorial<ul><li>Installation Guide for\u00a0<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/10\/TutorialWindowsOracleDB_ENG.pdf\">Windows<\/a><\/li><li>Installation Guide for\u00a0<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/10\/TutorialUbuntuOracleDB_ENG.pdf\">Ubuntu<\/a><\/li><li>Installation Guide for\u00a0<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/10\/TutorialMACOsOracleDB_ENG.pdf\">Mac OS<\/a><\/li><\/ul><\/li><\/ul><\/li><\/ul>\n\n<ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-65a6e2\"><li>Import Database and Tables: <a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/10\/ImportDatabaseSQL_ENG.pdf\">Tutorial<\/a><\/li><\/ul>\n\n<ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-3bc3e9\"><li>In the case, you want to practice at home and you have problems in using Oracle Database and SQL Developer, you can consider <a href=\"https:\/\/livesql.oracle.com\/\">Oracle Live SQL<\/a>.<ul><li>You can add tables using SQL scripts (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/10\/DW_CELLS_sql.zip\">zip<\/a>)<\/li><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\" data-type=\"URL\" data-id=\"http:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/10\/Import_Oracle_Live_SQL.docx.pdf\">pdf<\/a>)<\/li><\/ul><\/li><\/ul>\n\n\n<p class=\"eplus-wrapper wp-block-paragraph\">Draft solution (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/10\/star_schema_callDW_Sol.pdf\">star schema<\/a>, <a href=\"http:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/10\/Lab1_ExtendedSQL_Sol.pdf\">queries<\/a>)<\/p>\n\n\n\n<p class=\"eplus-wrapper wp-block-paragraph\"><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-82feee\"><li>Text \u2013 Additional queries\u00a0(<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/10\/Lab2_ExtendedSQL.pdf\">pdf<\/a>)<\/li><li>Draft solution (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/11\/Lab2_ExtendedSQL_sol.pdf\">pdf<\/a>)<\/li><\/ul>\n\n\n<p class=\"eplus-wrapper wp-block-paragraph\"><strong>Lab 3: Data Studio<\/strong><\/p>\n\n\n<ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-df5637\"><li>Text (<a rel=\"noreferrer noopener\" href=\"http:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/11\/Lab3_DataStudio.pdf\" target=\"_blank\">pdf<\/a>)<\/li><\/ul>\n\n\n<p class=\"eplus-wrapper wp-block-paragraph\"><strong>Lab 4: MongoDB Compass<\/strong><\/p>\n\n\n<ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-af69bf\"><li>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><li>Data (<a rel=\"noreferrer noopener\" href=\"https:\/\/drive.google.com\/drive\/folders\/1FQl8HRbZDTXR4279ZEsfUEm1fIdpOs1E?usp=sharing\" target=\"_blank\">link<\/a>)<\/li><li>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><\/ul>\n\n\n<p class=\"eplus-wrapper wp-block-paragraph\"><strong>Lab 5: MongoDB replica set<\/strong><\/p>\n\n\n<ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-f32224\"><li>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><li>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><li>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><li>Draft solution (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2022\/02\/DMV_Lab5_MongoDB_solution.pdf\" target=\"_blank\" rel=\"noreferrer noopener\">pdf<\/a>)<\/li><\/ul>\n\n\n<p class=\"eplus-wrapper wp-block-paragraph\"><strong>Lab 6: Visualization analysis<\/strong><\/p>\n\n\n<ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-7095e2\"><li>Text (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/11\/Lab6.pdf\">pdf<\/a>)<\/li><li>Data (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/11\/Lab6.xlsx\">xlsx<\/a>)<\/li><li>Solution (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/12\/Lab6_sol.xlsx\" data-type=\"URL\" data-id=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/12\/Lab6_sol.xlsx\">xlsx<\/a>)<\/li><\/ul>\n\n\n<p class=\"eplus-wrapper wp-block-paragraph\"><strong>Lab 7: Redesign with Tableau<\/strong><\/p>\n\n\n<ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-64078e\"><li>Text (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/11\/Lab7.pdf\">pdf<\/a>)<\/li><li>Solution (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/12\/Lab7_sol.zip\">zip<\/a>)<\/li><\/ul>\n\n\n<p class=\"eplus-wrapper wp-block-paragraph\"><strong>Lab 8: Visualization of a dataset<\/strong><\/p>\n\n\n<ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-fc853d\"><li>Text (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/12\/Lab8.pdf\">pdf<\/a>)<\/li><li>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><li>Solution (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/12\/Lab8_sol.zip\">zip<\/a>)<\/li><\/ul>\n\n\n<p class=\"eplus-wrapper wp-block-paragraph\"><strong>Lab 9: Intervals and dashboards<\/strong><\/p>\n\n\n<ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-bc9366\"><li>Text (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/12\/Lab9-1.pdf\">pdf<\/a>)<\/li><li>Data (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/12\/Kickstarter.zip\">zip<\/a>)<\/li><li>Solution (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/12\/Lab9_sol.zip\">zip<\/a>)<\/li><\/ul>\n\n\n<p class=\"eplus-wrapper wp-block-paragraph\"><strong>Lab 10: Geographic roles and maps<\/strong><\/p>\n\n\n<ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-b053ec\"><li>Text (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/12\/Lab10-1.pdf\">pdf<\/a>)<\/li><li>Data (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/12\/Lab10.zip\">zip<\/a>)<\/li><li>Solution (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2021\/12\/Lab10_sol.zip\">zip<\/a>)<\/li><\/ul>\n\n\n<p class=\"eplus-wrapper wp-block-paragraph\"><strong>Lab 11: Dataviz exam simulation<\/strong><\/p>\n\n\n<ul class=\"eplus-wrapper wp-block-list eplus-styles-uid-94e52f\"><li>Text (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2022\/01\/Lab11.pdf\">pdf<\/a>)<\/li><li>Visualization (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2022\/01\/BrandZ.jpg\">jpg<\/a>)<\/li><li>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><\/ul>","protected":false},"excerpt":{"rendered":"<p>General Information Lecturers: Daniele Apiletti, Silvia Chiusano, Diego Monti Teaching staff: Eliana Pastor, 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: https:\/\/piazza.com\/polito.it\/fall2021\/01txasm News 27 September 2021: the 21-22 edition of the course begins! See the official &hellip;<\/p>\n","protected":false},"author":6,"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-1316","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\/1316","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\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-json\/wp\/v2\/comments?post=1316"}],"version-history":[{"count":73,"href":"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-json\/wp\/v2\/posts\/1316\/revisions"}],"predecessor-version":[{"id":4668,"href":"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-json\/wp\/v2\/posts\/1316\/revisions\/4668"}],"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=1316"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-json\/wp\/v2\/categories?post=1316"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-json\/wp\/v2\/tags?post=1316"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}