{"id":199,"date":"2010-12-27T10:53:33","date_gmt":"2010-12-27T09:53:33","guid":{"rendered":"http:\/\/dbdmg.polito.it\/wordpress\/?page_id=199"},"modified":"2012-09-10T08:16:53","modified_gmt":"2012-09-10T07:16:53","slug":"data-warehousing-and-data-mining","status":"publish","type":"page","link":"https:\/\/dbdmg.polito.it\/wordpress\/teaching\/data-warehousing-and-data-mining\/","title":{"rendered":"Data Warehousing and Data Mining"},"content":{"rendered":"<p><strong>General information<\/strong><\/p>\n<ul style=\"list-style-type: disc;\">\n<li>ECTS: 5<\/li>\n<li>Professor: <a href=\"https:\/\/dbdmg.polito.it\/wordpress\/people\/silvia-chiusano\/\">Silvia Chiusano<\/a><\/li>\n<li>Assistant lecturers: <a href=\"https:\/\/dbdmg.polito.it\/wordpress\/people\/alessandro-fiori\/\">Alessandro Fiori<\/a><\/li>\n<\/ul>\n<p>Schedule<\/p>\n<table border=\"0\" cellspacing=\"1\" cellpadding=\"1\">\n<thead>\n<tr>\n<td>Type<\/td>\n<td>Day of the week<\/td>\n<td>Time<\/td>\n<td>Classroom<\/td>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>Lecture<\/td>\n<td>Monday<\/td>\n<td>14:30-17:30<\/td>\n<td>10<\/td>\n<\/tr>\n<tr>\n<td>Lecture<\/td>\n<td>Thursday<\/td>\n<td>13:00-16:00<\/td>\n<td>10<\/td>\n<\/tr>\n<tr>\n<td>Practice<\/td>\n<td>Friday<\/td>\n<td>8:30-10:00<\/td>\n<td>LABINF<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong><span style=\"background-color: #ffffff;\">Announcements<\/span><\/strong><\/p>\n<p><strong>Results for written exam\u00a0of September 7st, 2012<\/strong><\/p>\n<ul>\n<li><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/examResultsDWDM_20120907.pdf\">Results<\/a>\u00a0for written part<\/li>\n<li>The exam discussion and the mandatory oral exam will be Wednesday, September 12th 2012, at\u00a0<strong>13:00<\/strong><\/li>\n<li><strong>Students who want to reject the exam grade must send an email to Silvia Chiusano and Alessandro Fiori by Friday, September 14th, 2012.<\/strong><\/li>\n<\/ul>\n\n<p><strong>Materials<\/strong><\/p>\n<p><em>Data warehousing<\/em><\/p>\n<ol>\n<li>Introduction (<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/1-DWintro2.pdf\">2 slides per page<\/a>, <a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/1-DWintro6.pdf\">6 slides per page<\/a>)<\/li>\n<li>Conceptual design (<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/2-DWprogI-2.pdf\">2 slides per page<\/a>, <a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/2-DWprogI-6.pdf\">6 slides per page<\/a>)<\/li>\n<li>Logical design (<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/3-DWprogII-2.pdf\">2 slides per page<\/a>, <a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/3-DWprogII-6.pdf\">6 slides per page<\/a>)<\/li>\n<li>OLAP analysis (<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/4-OLAP-2.pdf\">2 slides per page<\/a>, <a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/4-OLAP-6.pdf\">6 slides per page<\/a>)<\/li>\n<li>Physical design (<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/5-DWprogIII-2.pdf\">2 slides per page<\/a>, <a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/5-DWprogIII-6.pdf\">6 slides per page<\/a>)<\/li>\n<li>ETL process (<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/6-DWETL-2.pdf\">2 slides per page<\/a>,\u00a0<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/6-DWETL-6.pdf\">6 slides per page<\/a>)<\/li>\n<\/ol>\n<p><em>Oracle<\/em><\/p>\n<ol>\n<li>Extended SQL (<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/Oracle-extended-SQL_x2.pdf\">2 slides per page<\/a>, <a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/Oracle-extended-SQL_x6.pdf\">6 slides per page<\/a>)<\/li>\n<\/ol>\n<p><em>Data mining<\/em><\/p>\n<ol>\n<li>Introduction to data mining (<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/chap1_intro-2.pdf\">2 slides per page<\/a>,\u00a0<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/chap1_intro-61.pdf\">6 slides per page<\/a>)<\/li>\n<li>Data (<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/chap2_data_x2.pdf\">2 slides per page<\/a>,\u00a0<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/chap2_data_x6.pdf\">6 slides per page<\/a>) <span style=\"background-color: #ffff00;\">NEW Additional slides on data preparation <\/span>(<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/5-DMintro-ENG-2.pdf\">2 slides per page<\/a>, <a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/5-DMintro-ENG-6.pdf\">6 slides per page<\/a>)<\/li>\n<li>Clustering (<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/chap8_basic_cluster_analysis_2.pdf\">2 slides per page<\/a>,\u00a0<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/chap8_basic_cluster_analysis_6.pdf\">6 slides per page<\/a>)<\/li>\n<li>\n<div id=\"_mcePaste\">Association Rules\u00a0Fundamentals (<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/2-DMassrules-2.pdf\">2 slides per page<\/a>, <a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/2-DMassrules-6.pdf\">6 slides per page<\/a>)<\/div>\n<\/li>\n<li>\n<div>Classification I (<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/chap4_basic_classification_2.pdf\">2 slides per page<\/a>, <a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/chap4_basic_classification_6.pdf\">6 slides per page<\/a>)<\/div>\n<\/li>\n<li>\n<div>Classification II ( <a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/chap5_alternative_classification_2.pdf\">2 slides per page<\/a>, <a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/chap5_alternative_classification_6.pdf\">6 slides per page<\/a>)<\/div>\n<\/li>\n<li>\n<div>Classification III (<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/7-DMclass_2.pdf\">2 slides per page<\/a>, <a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/7-DMclass_6.pdf\">6 slides per page<\/a>)<\/div>\n<\/li>\n<\/ol>\n<p><em>Additional material (prerequisites)<\/em><\/p>\n<ol>\n<li><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/BD01eng.pdf\">Introduction<\/a><\/li>\n<li><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/BD02eng.pdf\">The Relation Model<\/a><\/li>\n<li><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/BD03eng.pdf\">Relational algebra and calculus<\/a><\/li>\n<li>SQL language fundamentals (<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/SQL-TC-x2.pdf\">2 slides per page<\/a>, <a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/SQL-TC-x6.pdf\">6 slides per page<\/a>)\n<ul style=\"list-style-type: circle;\">\n<li>other <a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/BD04eng.pdf\">slides<\/a><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/SQL-Exercises.pdf\">Basic SQL language exercises<\/a><\/li>\n<\/ol>\n<h3><strong>Exercises<\/strong><\/h3>\n<ul style=\"list-style-type: disc;\">\n<li>Data Warehouse &#8211; Exercise 1 (XtraSport) <a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/exercise-01-XtraSport.pdf\">exercise<\/a>\n<ul style=\"list-style-type: circle;\">\n<li><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/exercise-01-XtraSport_sol.pdf\">Draft Solution<\/a><\/li>\n<\/ul>\n<\/li>\n<li>Extended SQL &#8211; Exercise 1 <a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/ExtendedSQL_ENG.pdf\">exercise<\/a>\n<ul>\n<li><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/ExtendedSQL-draft_solution.pdf\">Draft solution<\/a><\/li>\n<\/ul>\n<\/li>\n<li>Data Warehouse &#8211; Exercise 2 (Telco) <a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/casestudy-telco.pdf\">exercise<\/a><\/li>\n<li>Data Warehouse &#8211; Exercise 3 (Parcels service)\u00a0<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/DW-project-parcels_service.pdf\">exercise<\/a>\n<ul>\n<li><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/DW-project-parcels_service_solution.pdf\">Draft Solution<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h3><span style=\"font-size: medium;\">Exercises from written exams<\/span><\/h3>\n<ul>\n<li><span style=\"font-size: x-small;\"><span style=\"font-size: small;\">Data Warehouse &#8211; Exercise 4 (Italian household)\u00a0<span style=\"background-color: #ffff00;\">NEW<\/span><\/span><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/DW-project-Italian_household.pdf\"><span style=\"font-size: small;\">exercise<\/span><\/a><span style=\"font-size: small;\"> Remark: Write all queries from (a) to (f)<\/span><\/span>\n<ul>\n<li><span style=\"font-size: x-small;\"><span style=\"font-size: small;\"><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/DW-project-Italian_household_draft-solution.pdf\">Draft solution<\/a> <\/span><\/span><\/li>\n<\/ul>\n<\/li>\n<li><span style=\"font-size: small;\">Data Warehouse &#8211; Exercise 5 (SearchingYourHouse)\u00a0<span style=\"background-color: #ffff00;\">NEW<\/span> <\/span><span style=\"font-size: small;\"><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/DW-project-SearchingYourHouse.pdf\">exercise<\/a> <\/span>\n<ul>\n<li><span style=\"font-size: small;\"><span style=\"font-size: 13px;\"><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/DW-project-SearchingYourHouse-draft_solution.pdf\">Draft solution<\/a><\/span><\/span><\/li>\n<\/ul>\n<\/li>\n<li>Data Warehouse \u2013 Exercise 6 (Hotel chain)\u00a0<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/DW-project-hotel_chain.pdf\">exercise<\/a>\n<ul>\n<li><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/DW-project-hotel_chain_draft_solution.pdf\">Draft solution<\/a><\/li>\n<\/ul>\n<\/li>\n<li>Data Warehouse \u2013 Exercise 7 (PC store)\u00a0<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/DW-project-PC_store.pdf\">exercise<\/a>\n<ul>\n<li><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/DW-project-PC_store_draft_solution.pdf\">Draft solution<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h3><span style=\"font-size: 13px; font-weight: normal;\">\u00a0<\/div>\n<br class=\"fixfloat\" \/>","protected":false},"excerpt":{"rendered":"<p>General information ECTS: 5 Professor: Assistant lecturers: Schedule Type Day of the week Time Classroom Lecture Monday 14:30-17:30 10 Lecture Thursday 13:00-16:00 10 Practice Friday 8:30-10:00 LABINF Announcements Results for written exam\u00a0of September 7st, 2012 Results\u00a0for written part The exam discussion and the mandatory oral exam will be Wednesday, September 12th 2012, at\u00a013:00 Students who<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/teaching\/data-warehousing-and-data-mining\/\">[&#8230;]<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"parent":96,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-199","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/dbdmg.polito.it\/wordpress\/wp-json\/wp\/v2\/pages\/199","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbdmg.polito.it\/wordpress\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/dbdmg.polito.it\/wordpress\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/dbdmg.polito.it\/wordpress\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/dbdmg.polito.it\/wordpress\/wp-json\/wp\/v2\/comments?post=199"}],"version-history":[{"count":100,"href":"https:\/\/dbdmg.polito.it\/wordpress\/wp-json\/wp\/v2\/pages\/199\/revisions"}],"predecessor-version":[{"id":3921,"href":"https:\/\/dbdmg.polito.it\/wordpress\/wp-json\/wp\/v2\/pages\/199\/revisions\/3921"}],"up":[{"embeddable":true,"href":"https:\/\/dbdmg.polito.it\/wordpress\/wp-json\/wp\/v2\/pages\/96"}],"wp:attachment":[{"href":"https:\/\/dbdmg.polito.it\/wordpress\/wp-json\/wp\/v2\/media?parent=199"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}