{"id":16664,"date":"2020-09-28T08:43:36","date_gmt":"2020-09-28T07:43:36","guid":{"rendered":"https:\/\/dbdmg.polito.it\/wordpress\/?page_id=16664"},"modified":"2021-02-03T14:34:32","modified_gmt":"2021-02-03T13:34:32","slug":"data-science-and-database-technology-2020-2021","status":"publish","type":"page","link":"https:\/\/dbdmg.polito.it\/wordpress\/teaching\/data-science-and-database-technology-2020-2021\/","title":{"rendered":"Data Science and Database Technology (2020\/2021)"},"content":{"rendered":"<h3 id=\"tinyTOC\">Table of content<\/h3>\n<ul>\n<li><a href=\"#General-information-1\"><\/strong>General information<\/a><\/li>\n<li><a href=\"#Exams-1\">Exams<\/a><\/li>\n<li><a href=\"#Material-1\">Material<\/a>\n<ul>\n<li><a href=\"#Part-I-2\">Part I<\/a>\n<ul>\n<li><a href=\"#Oracle-3\">Oracle<\/a><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"#Part-II-2\">Part II<\/a>\n<ul>\n<li><a href=\"#Oracle-3\">Oracle<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<li><a href=\"#Exercises-1\">Exercises<\/a><\/li>\n<li><a href=\"#Exercises-from-written-exams-1\">Exercises from written exams<\/a><\/li>\n<li><a href=\"#-Other-exercises-1\"> Other exercises<\/a><\/li>\n<li><a href=\"#Tutoring-sessions-1\">Tutoring sessions<\/a><\/li>\n<li><a href=\"#Practices-1\">Practices<\/a><\/li>\n<li><a href=\"#Homework-to-be-delivered-1\">Homework to be delivered<\/a><\/li>\n<\/ul>\n<h3><strong><span id=\"General-information-1\"><\/strong>General information<\/span><\/h3>\n<ul style=\"list-style-type: disc;\">\n<li>ECTS: 8<\/li>\n<li>Professor: <a href=\"https:\/\/dbdmg.polito.it\/wordpress\/people\/silvia-chiusano\/\">Silvia Chiusano<\/a><\/li>\n<li>Assistant lecturer: <a href=\"https:\/\/flowygo.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">Alessandro Fiori<\/a>,\u00a0 Eliana Pastor<\/li>\n<li><strong>Exam rules A.Y. 2020\/2021 (Covid-19 Emergency)\u00a0 (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/12\/DSDBT_Exam_Rules_COVID_2020-2021.pdf\">pdf-rules)<\/a><\/strong><\/li>\n<\/ul>\n<h3><strong>Announcements<\/strong><\/h3>\n<ul>\n<li>[02-02-2021] We posted a recap of homework submissions.<\/li>\n<li>[21-11-2020]\u00a0 Homework 4 (deadline 7-01-2021) has been published in Section \u201cHomeworks to be delivered\u201d<\/li>\n<li>[27-11-2020]\u00a0 Homework 3 (deadline 7-12-2020) has been published in Section \u201cHomeworks to be delivered\u201d<\/li>\n<li>[13-11-2020]\u00a0 Homework 2 (deadline 23-11-2020) has been published in Section \u201cHomeworks to be delivered\u201d<\/li>\n<li>[29-10-2020] We posted an updated version of Homework 1 (Query b.ii )<\/li>\n<li>[29-10-2020] Calendar of tutoring sessions in November has been posted<\/li>\n<li>[29-10-2020] Calendar of laboratory practices has been posted<\/li>\n<li>[28-10-2020] Considering the problem with Virtual Classroom during the 1st lab (19th 2020), we have recorded the description of Practise #1 in Virtual Classroom. You will find it (soon, we already processed it on VC) as &#8220;Laboratory 1 &#8211; Lab description &#8220;. Please refer to this recording for the Lab#1.<\/li>\n<li>[28-10-2020]\u00a0 Homework 1 (deadline 8-11-2020) has been published in Section \u201cHomeworks to be delivered\u201d<\/li>\n<li>[16-10-2020] The first laboratory will be held on Monday October 19th 2020. The tutorial for the software install for Practice #1 (Extended SQL) is now available in Section \u201cPractices\u201d.\n<ul>\n<li>LAB SCHEDULE.<br \/>\nTEAM A (FROM A TO G) on Monday from 2.30pm to 4pm<br \/>\nTEAM B (FROM H TO Z) on Monday from 4pm to 5.30pm<\/li>\n<\/ul>\n<\/li>\n<li>[16-10-2020]\u00a0 Join us on <a href=\"http:\/\/piazza.com\/polito.it\/fall2020\/01sqjov\">Piazza<\/a>. You can register at Piazza whether you are already enrolled in the course or you are waiting for it. If you do not have an @studenti.polito.it address yet, drop an email to eliana.pastor@polito.it including your personal email address and your ID on the Polito website or the Apply procedure \u2013 it is in the format FXXXXX. The registration with your personal address is temporary: remember to add your educational address on Piazza as soon as you receive it.<\/li>\n<\/ul>\n\n<hr \/>\n<h2><\/h2>\n<h2><span id=\"Exams-1\">Exams<\/span><\/h2>\n<ul>\n<li><strong>Exam rules A.Y. 2020\/2021 (Covid-19 Emergency)\u00a0 (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/12\/DSDBT_Exam_Rules_COVID_2020-2021.pdf\">pdf-rules)<\/a><\/strong><\/li>\n<\/ul>\n<p><strong>Exam on January 26, 2021<\/strong><\/p>\n<ul>\n<li>Draft solution (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2021\/02\/Exam2021-01-26_draft_solution.pdf\">pdf<\/a>)<\/li>\n<\/ul>\n\n<hr \/>\n<h2><span id=\"Material-1\">Material<\/span><\/h2>\n<ul>\n<li>Course introduction (<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2018\/10\/0-IntroductionCourse.pdf\">slides<\/a>)<\/li>\n<\/ul>\n<h3><span id=\"Part-I-2\">Part I<\/span><\/h3>\n<ul>\n<li>Introduction to Big Data (<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2018\/10\/1-DSIntro.pdf\">slides<\/a>)<\/li>\n<li>Data warehouse: introduction (<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2018\/10\/2-DWintro-EN.pdf\">slides<\/a>)<\/li>\n<li>Data warehouse: design (<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2018\/10\/3-DWprog-EN.pdf\">slides<\/a>)<\/li>\n<li>Data warehouse: analysis (<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2018\/10\/4-DWquery-EN.pdf\">slides<\/a>)<\/li>\n<li>Data mining: introduction (<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2018\/10\/5-DMProcess.pdf\">slides)<\/a><\/li>\n<li>Data mining: data preprocessing (<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2018\/10\/6-DMPreProc.pdf\">slides<\/a>)<\/li>\n<li>Data mining: Association rules (<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2019\/10\/DSL-3-MassRules.pdf\">slides<\/a>).<\/li>\n<li>Data mining: classification (<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2018\/10\/8-DMClassification.pdf\">slides<\/a>, <a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2018\/10\/8-DMClassificationRandomForest.pdf\">slidesNew<\/a>)<\/li>\n<li>Data mining: classification, neural networks (<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2018\/11\/8-DMNeural-Networks.pdf\">slides<\/a>)<\/li>\n<li>Data mining: clustering (<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2018\/10\/9-DMClustering.pdf\">slides<\/a>)<\/li>\n<\/ul>\n<div>\n<h3><span id=\"Oracle-3\">Oracle<\/span><\/h3>\n<\/div>\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>&nbsp;<\/p>\n<h3><span id=\"Part-II-2\">Part II<\/span><\/h3>\n<ul>\n<li>Triggers (<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2018\/11\/10-Triggers.pdf\">slides<\/a>)<\/li>\n<li>Introduction to DBMS (<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2018\/11\/11-IntroductionDBMS.pdf\">slides<\/a>)<\/li>\n<li>Buffer Manager (<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2018\/11\/12-BufferManager.pdf\">slides<\/a>)<\/li>\n<li>Physical access to data\u00a0(<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2018\/11\/13-PhysicalAccess.pdf\">slides<\/a>)<\/li>\n<li>Query optimization (<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2018\/11\/14-QueryOptimization.pdf\">slides<\/a>)<\/li>\n<li>Physical Design (<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2018\/11\/15-PhysicalDesign.pdf\">slides<\/a>)<\/li>\n<li>Concurrency Control\u00a0 (<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2018\/11\/16-ConcurrencyControl.pdf\">slides<\/a>)<\/li>\n<li>Reliability Management\u00a0(<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2018\/11\/17-Recovery.pdf\">slides<\/a>)<\/li>\n<li>Distributed databases\u00a0\u00a0(<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/9-DistributedDatabases-x2.pdf\">slides<\/a>)<\/li>\n<li>Beyond relational databases (<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2018\/12\/Beyond-relational-databases-18-12.pdf\">slides<\/a>)<\/li>\n<li>Intro to MongoDB (<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/01\/02-MongoDB-query.pdf\">part1<\/a>, <a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/01\/03-MongoDB-operations.pdf\">part2<\/a>)<\/li>\n<\/ul>\n<div>\n<h3><span id=\"Oracle-3\">Oracle<\/span><\/h3>\n<\/div>\n<ol>\n<li>Oracle Optimizer\n<ol>\n<li>Baseline version (<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/OracleOptimizer-v4_x2.pdf\">2 slides per page<\/a>,\u00a0<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/OracleOptimizer-v4_x6.pdf\">6 slides per page<\/a>)<\/li>\n<li>Extended version with examples (<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/OracleOptimizer-v4_x2_vEstesa.pdf\">2 slides per page<\/a>,<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/OracleOptimizer-v4_x6_vEstesa1.pdf\">6 slides per page<\/a>)<\/li>\n<\/ol>\n<\/li>\n<li>Hints (<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/Hint-v4_x21.pdf\">2 slides per page<\/a>,\u00a0<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/Hint-v4_x61.pdf\">6 slides per page<\/a>)<\/li>\n<li>Documentation\n<ul>\n<li><a href=\"http:\/\/www.oracle.com\/pls\/db10g\/portal.portal_demo3?selected=1\" target=\"_top\" rel=\"noopener noreferrer\">Oracle Database 10g documentation library<\/a><\/li>\n<li><a href=\"http:\/\/download.oracle.com\/docs\/cd\/B14117_01\/server.101\/b10752\/toc.htm\" target=\"_top\" rel=\"noopener noreferrer\">Oracle Database Performance Tuning Guide<\/a><\/li>\n<li><a href=\"http:\/\/download.oracle.com\/docs\/cd\/B14117_01\/server.101\/b10752\/optimops.htm#721\" target=\"_top\" rel=\"noopener noreferrer\">The Query Optimizer<\/a><\/li>\n<li><a href=\"http:\/\/download.oracle.com\/docs\/cd\/B14117_01\/server.101\/b10755\/statviews_1059.htm#REFRN20360\" target=\"_top\" rel=\"noopener noreferrer\">Statistics about indices<\/a>, meaning of the columns in the statistics table (e.g., <code>CLUSTERING_FACTOR<\/code>)<\/li>\n<li><a href=\"http:\/\/download.oracle.com\/docs\/cd\/B14117_01\/server.101\/b10755\/statviews_1003.htm#REFRN20003\" target=\"_top\" rel=\"noopener noreferrer\">Statistics about tables<\/a>,\u00a0meaning of the columns in the statistics table (es. <code>EMPTY_BLOCKS<\/code>)<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<h2><\/h2>\n<hr \/>\n<h2>\u00a0<span id=\"Exercises-1\">Exercises<\/span><\/h2>\n<p>Data warehouse<\/p>\n<table style=\"border-color: #000000;\" border=\"1\" data-darkreader-inline-border-top=\"\" data-darkreader-inline-border-right=\"\" data-darkreader-inline-border-bottom=\"\" data-darkreader-inline-border-left=\"\">\n<tbody>\n<tr>\n<td><strong>Exercise\u00a0<\/strong><\/td>\n<td><strong>Text<\/strong><\/td>\n<td><strong>Draft solution<\/strong><\/td>\n<\/tr>\n<tr>\n<td>Extended SQL\u00a0(Customer )<\/td>\n<td><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2017\/11\/ExtendedSQLCustomerText.pdf\">text<\/a><\/td>\n<td><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2017\/11\/ExtendedSQLDraftSolutionCustomer.pdf\">Draft solution<\/a><\/td>\n<\/tr>\n<tr>\n<td>Extended SQL (Rental )<\/td>\n<td><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/ExtendedSQL_ENG.pdf\">text<\/a><\/td>\n<td><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/ExtendedSQL-draft_solution.pdf\">Draft solution<\/a><\/td>\n<\/tr>\n<tr>\n<td>Data warehouse design (Italian household)<\/td>\n<td><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/DW-project-Italian_household.pdf\">exercise<\/a><\/td>\n<td><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/DW-project-Italian_household_draft-solution.pdf\">Draft solution<\/a><\/td>\n<\/tr>\n<tr>\n<td>Data warehouse design (SearchingYourHouse)<\/td>\n<td><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/DW-project-SearchingYourHouse.pdf\">exercise<\/a><\/td>\n<td><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/DW-project-SearchingYourHouse-draft_solution.pdf\">Draft solution<\/a><\/td>\n<\/tr>\n<tr>\n<td>Data warehouse design (Hotel chain)<\/td>\n<td><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/DW-project-hotel_chain.pdf\">exercise<\/a><\/td>\n<td><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/DW-project-hotel_chain_draft_solution.pdf\">Draft solution<\/a><\/td>\n<\/tr>\n<tr>\n<td>Data warehouse design (Parcels service)<\/td>\n<td><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2018\/12\/DW-project-parcels_service.pdf\">exercise<\/a><\/td>\n<td><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p>Triggers<\/p>\n<table style=\"border-color: #000000; height: 100px; width: 97.8061%;\" border=\"1\" width=\"631\" data-darkreader-inline-border-top=\"\" data-darkreader-inline-border-right=\"\" data-darkreader-inline-border-bottom=\"\" data-darkreader-inline-border-left=\"\">\n<tbody>\n<tr style=\"height: 13px;\">\n<td style=\"width: 33.0065%; height: 13px;\"><strong>Exercise<\/strong><\/td>\n<td style=\"width: 23.366%; height: 13px;\"><strong>Text<\/strong><\/td>\n<td style=\"width: 42.1569%; height: 13px;\"><strong>Draft solution<\/strong><\/td>\n<\/tr>\n<tr style=\"height: 21px;\">\n<td style=\"width: 33.0065%; height: 19px;\">Exercise 1 (Athlete)<\/td>\n<td style=\"width: 23.366%; height: 19px;\"><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2018\/11\/trigger_ranking_dsdbtech_text.pdf\">exercise<\/a><\/td>\n<td style=\"width: 42.1569%; height: 19px;\"><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2018\/11\/trigger_ranking_dsdbtech.pdf\">Draft solution<\/a><\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.0065%; height: 23px;\">Exercise 2 (Greenhouse)<\/td>\n<td style=\"width: 23.366%; height: 23px;\"><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2018\/11\/trigger_greenhouse_dsdbtech_text.pdf\">exercise<\/a><\/td>\n<td style=\"width: 42.1569%; height: 23px;\"><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2018\/11\/trigger_greenhouse_dsdbtech_sol_example.pdf\">Draft solution<\/a><\/td>\n<\/tr>\n<tr style=\"height: 25px;\">\n<td style=\"width: 33.0065%; height: 25px;\">Exercise 3 (Student grant)<\/td>\n<td style=\"width: 23.366%; height: 25px;\"><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2018\/11\/trigger_scholarship_dsdbtech_text.pdf\">exercise<\/a><\/td>\n<td style=\"width: 42.1569%; height: 25px;\"><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2018\/11\/trigger_scholarship_dsdbtech_sol.pdf\">Draft solution<\/a><\/td>\n<\/tr>\n<tr style=\"height: 20px;\">\n<td style=\"width: 33.0065%; height: 20px;\">Exercise 4 (Boat rental)<\/td>\n<td style=\"width: 23.366%; height: 20px;\"><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2018\/11\/trigger_rental_dsdbtech_text.pdf\">exercise<\/a><\/td>\n<td style=\"width: 42.1569%; height: 20px;\"><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/trigger_rental1.pdf\">DraftSolBoatRental<\/a>\u00a0(<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2018\/02\/timecondition.pdf\">timecondition<\/a>)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Optimizer<\/p>\n<table style=\"border-color: #000000;\" border=\"1\" data-darkreader-inline-border-top=\"\" data-darkreader-inline-border-right=\"\" data-darkreader-inline-border-bottom=\"\" data-darkreader-inline-border-left=\"\">\n<tbody>\n<tr>\n<td style=\"width: 222px;\"><strong>Exercise\u00a0<\/strong><\/td>\n<td style=\"width: 239px;\"><strong>Text<\/strong><\/td>\n<td style=\"width: 116px;\"><strong>Draft solution<\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 222px;\">Exercise 1 (Fine)<\/td>\n<td style=\"width: 239px;\"><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/ex_fine_x2.pdf\">2 slides per page<\/a>\u00a0<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/ex_fine_x6.pdf\">6 slides per page<\/a><\/td>\n<td style=\"width: 116px;\"><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/ex1_solution.pdf\">Draft Solution<\/a><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 222px;\">Exercise 2 (Students, Projects)<\/td>\n<td style=\"width: 239px;\"><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/exercise2_x2.pdf\">2 slides per page<\/a>\u00a0<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/exercise2_x6.pdf\">6 slides per page<\/a><\/td>\n<td style=\"width: 116px;\"><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/ex2_solution.pdf\">Draft Solution<\/a><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 222px;\">Exercise 3 (Discs)<\/td>\n<td style=\"width: 239px;\"><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/DBMS_ex4.pdf\">exercise<\/a><\/td>\n<td style=\"width: 116px;\"><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/DBMS_ex4_draftsol.pdf\">Draft Solution<\/a><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 222px;\">Exercise 4 (Athletes, Members)<\/td>\n<td style=\"width: 239px;\"><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/exercise3_x2.pdf\">2 slides per page<\/a>\u00a0<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/exercise3_x6.pdf\">6 slides per page<\/a><\/td>\n<td style=\"width: 116px;\">\u00a0<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/ex3_solution.pdf\">Draft Solution<\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n<h2><span id=\"Exercises-from-written-exams-1\">Exercises from written exams<\/span><\/h2>\n\n<p style=\"padding-left: 30px;\">AA 2015-2016<\/p>\n<table style=\"padding-left: 30px; width: 64.9234%;\" border=\"1\" cellspacing=\"2\" cellpadding=\"0\">\n<thead style=\"padding-left: 30px;\">\n<tr style=\"padding-left: 30px;\">\n<td style=\"padding-left: 30px; width: 43.5115%;\"><strong>Exam<\/strong><\/td>\n<td style=\"padding-left: 30px; width: 72.7712%;\"><strong>Draft solution<\/strong><\/td>\n<\/tr>\n<tr style=\"padding-left: 30px;\">\n<td style=\"padding-left: 30px; width: 43.5115%;\"><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/Exam23-02-2016text.pdf\">Exam (23-02-2016)<\/a><\/td>\n<td style=\"padding-left: 30px; width: 72.7712%;\"><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/2016-02-23-EN-SOL.pdf\">optimizer, dw, trigger<\/a><\/td>\n<\/tr>\n<tr style=\"padding-left: 30px;\">\n<td style=\"padding-left: 30px; width: 43.5115%;\"><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/2016-01-27.pdf\">Exam (2016-01-27<\/a>)<\/td>\n<td style=\"padding-left: 30px; width: 72.7712%;\"><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/OPT27-1-2016SOL.pdf\">optimizer, dw, trigger<\/a><\/td>\n<\/tr>\n<\/thead>\n<\/table>\n<p style=\"padding-left: 30px;\">AA 2011-2012<\/p>\n<table style=\"padding-left: 30px; width: 65.1056%; height: 120px;\" border=\"1\" cellspacing=\"2\" cellpadding=\"0\">\n<thead style=\"padding-left: 30px;\">\n<tr style=\"padding-left: 30px;\">\n<td style=\"padding-left: 30px; height: 24px; width: 44.5019%;\"><strong>Exam<\/strong><\/td>\n<td style=\"padding-left: 30px; height: 24px; width: 127.583%;\"><strong>Draft solution<\/strong><\/td>\n<\/tr>\n<tr style=\"padding-left: 30px;\">\n<td style=\"padding-left: 30px; height: 24px; width: 44.5019%;\"><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/2012-02-06-DBMS_exam.pdf\">Exam (2012-02-06)<\/a><\/td>\n<td style=\"padding-left: 30px; height: 24px; width: 127.583%;\"><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/2012-02-06-DBMS_exam_draftsol_opt_dw.pdf\">optimizer and dw<\/a>,\u00a0<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/2012-02-06-DBMS_exam_triggerdraftsol.pdf\">trigger<\/a><\/td>\n<\/tr>\n<tr style=\"padding-left: 30px;\">\n<td style=\"padding-left: 30px; height: 24px; width: 44.5019%;\"><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/2012-02-28-DBMS_exam.pdf\">Exam (2012-02-28)<\/a><\/td>\n<td style=\"padding-left: 30px; height: 24px; width: 127.583%;\"><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/2012-02-28-DBMS_exam_draftsol_opt_dw.pdf\">optimizer and dw<\/a><\/td>\n<\/tr>\n<tr style=\"padding-left: 30px;\">\n<td style=\"padding-left: 30px; height: 24px; width: 44.5019%;\"><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/2012-06-21-DBMS_exam.pdf\">Exam (2012-06-21)<\/a><\/td>\n<td style=\"padding-left: 30px; height: 24px; width: 127.583%;\"><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/2012-06-21-DBMS_exam_draftsol_opt_dw.pdf\">optimizer and dw<\/a>,\u00a0<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/2012-06-21-DBMS_trigger-draftsol.pdf\">trigger<\/a><\/td>\n<\/tr>\n<tr style=\"padding-left: 30px;\">\n<td style=\"padding-left: 30px; height: 24px; width: 44.5019%;\"><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/2012-09-07-DBMS_exam.pdf\">Exam (2012-09-07)<\/a><\/td>\n<td style=\"padding-left: 30px; height: 24px; width: 127.583%;\"><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/2012-09-07-DBMS_exam_draftsol_opt_dw.pdf\">optimizer and dw<\/a><\/td>\n<\/tr>\n<\/thead>\n<\/table>\n<p style=\"padding-left: 30px;\">AA 2010-2011<\/p>\n<table style=\"padding-left: 30px; width: 65.7259%;\" border=\"1\" cellspacing=\"2\" cellpadding=\"0\">\n<thead style=\"padding-left: 30px;\">\n<tr style=\"padding-left: 30px;\">\n<td style=\"padding-left: 30px; width: 43.257%;\"><strong>Exam<\/strong><\/td>\n<td style=\"padding-left: 30px; width: 73.7913%;\"><strong>Draft solution<\/strong><\/td>\n<\/tr>\n<tr style=\"padding-left: 30px;\">\n<td style=\"padding-left: 30px; width: 43.257%;\"><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/2011-02-07_Eng_DMS.pdf\">Exam (2011-02-07)<\/a><\/td>\n<td style=\"padding-left: 30px; width: 73.7913%;\"><a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/12\/2011-02-07_Eng_DBMS_sol_new.pdf\">optimizer-trigger-dw<\/a> <\/td>\n<\/tr>\n<tr style=\"padding-left: 30px;\">\n<td style=\"padding-left: 30px; width: 43.257%;\"><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/DBMS_exam_SocialNetworks.pdf\">Exam (2011-02-22)<\/a><\/td>\n<td style=\"padding-left: 30px; width: 73.7913%;\"><\/td>\n<\/tr>\n<tr style=\"padding-left: 30px;\">\n<td style=\"padding-left: 30px; width: 43.257%;\"><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/2011-07-08-DBMS_exam.pdf\">Exam (2011-07-08)<\/a><\/td>\n<td style=\"padding-left: 30px; width: 73.7913%;\"><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/2011-07-08-DBMS_exam_draft_solution_part1.pdf\">optimizer<\/a>, <a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/2011-07-08-DBMS_exam-draft-solution-trigger.pdf\">trigger<\/a><\/td>\n<\/tr>\n<tr style=\"padding-left: 30px;\">\n<td style=\"padding-left: 30px; width: 43.257%;\"><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/2011-09-21-DBMS_exam.pdf\">Exam (2011-09-21)<\/a><\/td>\n<td style=\"padding-left: 30px; width: 73.7913%;\"><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/2011-09-21-DBMS_exam_draft_solution_part1.pdf\">optimizer<\/a>, <a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/2011-09-21-DBMS_exam-trigger-draftsol.pdf\">trigger<\/a><\/td>\n<\/tr>\n<\/thead>\n<\/table>\n<h2><\/p>\n<div id=\"Laboratori\"><\/div>\n<p>&nbsp;<\/p>\n<h2><\/h2>\n<hr style=\"padding-left: 30px;\" \/>\n<h2><span id=\"Tutoring-sessions-1\">Tutoring sessions<\/span><\/h2>\n<ul>\n<li class=\"moz-quote-pre\">In tutoring sessions teachers are available to answer questions on homework, exercises and topics presented in lessons.<\/li>\n<li class=\"moz-quote-pre\">The calendar of the tutoring sessions in November is the following:\n<ul>\n<li>Monday 2\/11 \u2013 2:30-3pm\u00a0 4-4:30pm &#8211; Virtual classroom<\/li>\n<li>Friday 16\/11 \u2013 2:30-3pm\u00a0 4-4:30pm &#8211; Virtual classroom<\/li>\n<li>Thursday 30\/11 \u2013 2:30-3pm\u00a0 4-4:30pm &#8211; Virtual classroom<\/li>\n<\/ul>\n<\/li>\n<li>During the lab session (2:30-5:30 pm) the scholarship holder will be also available to answer questions on homeworks<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n\n<hr style=\"padding-left: 30px;\" \/>\n<h2><span id=\"Practices-1\">Practices<\/span><\/h2>\n<p><strong>LAB SCHEDULE.\u00a0<\/strong><br \/>\nTEAM A (FROM A TO G) on Monday from 2.30pm to 4pm<br \/>\nTEAM B (FROM H TO Z) on Monday from 4pm to 5.30pm<\/p>\n<p>Lab calendar<\/p>\n<table style=\"width: 54.595%; height: 471px;\" border=\"1\">\n<tbody>\n<tr style=\"height: 23px;\">\n<td style=\"border-color: #000000; width: 36.833%; text-align: left; height: 23px;\" data-darkreader-inline-border-top=\"\" data-darkreader-inline-border-right=\"\" data-darkreader-inline-border-bottom=\"\" data-darkreader-inline-border-left=\"\"><strong>Topic<\/strong><\/td>\n<td style=\"border-color: #000000; width: 20.4186%; text-align: left; height: 23px;\" data-darkreader-inline-border-top=\"\" data-darkreader-inline-border-right=\"\" data-darkreader-inline-border-bottom=\"\" data-darkreader-inline-border-left=\"\"><strong>Team A (2:30-4pm)<\/strong><\/p>\n<p><strong>Team B (4-5:30pm)<\/strong><\/td>\n<td style=\"border-color: #000000; width: 25.0202%; text-align: left; height: 23px;\" data-darkreader-inline-border-top=\"\" data-darkreader-inline-border-right=\"\" data-darkreader-inline-border-bottom=\"\" data-darkreader-inline-border-left=\"\"><strong>Lab Assistance<\/strong><\/td>\n<\/tr>\n<tr style=\"border-color: #000000;\" data-darkreader-inline-border-top=\"\" data-darkreader-inline-border-right=\"\" data-darkreader-inline-border-bottom=\"\" data-darkreader-inline-border-left=\"\">\n<td style=\"border-color: #000000; width: 36.833%; height: 10px;\" data-darkreader-inline-border-top=\"\" data-darkreader-inline-border-right=\"\" data-darkreader-inline-border-bottom=\"\" data-darkreader-inline-border-left=\"\"><span style=\"text-decoration: underline;\"><strong>Practice #1:\u00a0<\/strong><\/span><span style=\"text-decoration: underline;\"><strong>Extended SQL in Oracle<\/strong><\/span><\/td>\n<td style=\"border-color: #000000; width: 20.4186%; height: 10px;\" data-darkreader-inline-border-top=\"\" data-darkreader-inline-border-right=\"\" data-darkreader-inline-border-bottom=\"\" data-darkreader-inline-border-left=\"\">\u00a019\/10\/2020<\/td>\n<td style=\"border-color: #000000; width: 25.0202%; height: 10px;\" data-darkreader-inline-border-top=\"\" data-darkreader-inline-border-right=\"\" data-darkreader-inline-border-bottom=\"\" data-darkreader-inline-border-left=\"\">assistant lecturer<\/td>\n<\/tr>\n<tr style=\"border-color: #000000;\" data-darkreader-inline-border-top=\"\" data-darkreader-inline-border-right=\"\" data-darkreader-inline-border-bottom=\"\" data-darkreader-inline-border-left=\"\">\n<td style=\"border-color: #000000; width: 36.833%; height: 10px;\" data-darkreader-inline-border-top=\"\" data-darkreader-inline-border-right=\"\" data-darkreader-inline-border-bottom=\"\" data-darkreader-inline-border-left=\"\"><span style=\"text-decoration: underline;\"><strong>Practice #2:\u00a0Data warehousing<\/strong><\/span><\/td>\n<td style=\"border-color: #000000; width: 20.4186%; height: 10px;\" data-darkreader-inline-border-top=\"\" data-darkreader-inline-border-right=\"\" data-darkreader-inline-border-bottom=\"\" data-darkreader-inline-border-left=\"\">\u00a026\/10\/2020<\/td>\n<td style=\"border-color: #000000; width: 25.0202%; height: 10px;\" data-darkreader-inline-border-top=\"\" data-darkreader-inline-border-right=\"\" data-darkreader-inline-border-bottom=\"\" data-darkreader-inline-border-left=\"\">assistant lecturer<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"border-color: #000000; width: 36.833%; height: 23px;\"><span style=\"text-decoration: underline;\"><strong>Lab for Homework #1 &#8211; \u00a0Data warehousing + Tutoring session<\/strong><\/span><\/td>\n<td style=\"border-color: #000000; width: 20.4186%; height: 23px;\">\u00a02\/11\/2020<\/td>\n<td style=\"border-color: #000000; width: 25.0202%; height: 23px;\">scholarship holder<\/td>\n<\/tr>\n<tr style=\"border-color: #000000;\" data-darkreader-inline-border-top=\"\" data-darkreader-inline-border-right=\"\" data-darkreader-inline-border-bottom=\"\" data-darkreader-inline-border-left=\"\">\n<td style=\"border-color: #000000; width: 36.833%; text-align: left; height: 47px;\" data-darkreader-inline-border-top=\"\" data-darkreader-inline-border-right=\"\" data-darkreader-inline-border-bottom=\"\" data-darkreader-inline-border-left=\"\"><span style=\"text-decoration: underline;\"><strong>Practice #3:\u00a0Data mining with Rapidminer<\/strong><\/span><\/td>\n<td style=\"border-color: #000000; width: 20.4186%; text-align: left; height: 47px;\" data-darkreader-inline-border-top=\"\" data-darkreader-inline-border-right=\"\" data-darkreader-inline-border-bottom=\"\" data-darkreader-inline-border-left=\"\">\u00a09\/11\/2020<\/td>\n<td style=\"border-color: #000000; width: 25.0202%; text-align: left; height: 47px;\" data-darkreader-inline-border-top=\"\" data-darkreader-inline-border-right=\"\" data-darkreader-inline-border-bottom=\"\" data-darkreader-inline-border-left=\"\">assistant lecturer<\/td>\n<\/tr>\n<tr style=\"height: 47px;\">\n<td style=\"border-color: #000000; width: 36.833%; text-align: left; height: 47px;\" data-darkreader-inline-border-top=\"\" data-darkreader-inline-border-right=\"\" data-darkreader-inline-border-bottom=\"\" data-darkreader-inline-border-left=\"\"><strong><span style=\"text-decoration: underline;\">Lab for Homework #2 on data mining with Rapidminer + Tutoring session<\/span><\/strong><\/td>\n<td style=\"border-color: #000000; width: 20.4186%; text-align: left; height: 47px;\" data-darkreader-inline-border-top=\"\" data-darkreader-inline-border-right=\"\" data-darkreader-inline-border-bottom=\"\" data-darkreader-inline-border-left=\"\">\u00a016\/11\/2020<\/td>\n<td style=\"border-color: #000000; width: 25.0202%; text-align: left; height: 47px;\" data-darkreader-inline-border-top=\"\" data-darkreader-inline-border-right=\"\" data-darkreader-inline-border-bottom=\"\" data-darkreader-inline-border-left=\"\">scholarship holder<\/td>\n<\/tr>\n<tr style=\"border-color: #000000;\" data-darkreader-inline-border-top=\"\" data-darkreader-inline-border-right=\"\" data-darkreader-inline-border-bottom=\"\" data-darkreader-inline-border-left=\"\">\n<td style=\"border-color: #000000; width: 36.833%; text-align: left; height: 47px;\" data-darkreader-inline-border-top=\"\" data-darkreader-inline-border-right=\"\" data-darkreader-inline-border-bottom=\"\" data-darkreader-inline-border-left=\"\"><span style=\"text-decoration: underline;\"><strong>Practice #4: Oracle triggers<\/strong><\/span><\/td>\n<td style=\"border-color: #000000; width: 20.4186%; text-align: left; height: 47px;\" data-darkreader-inline-border-top=\"\" data-darkreader-inline-border-right=\"\" data-darkreader-inline-border-bottom=\"\" data-darkreader-inline-border-left=\"\">\u00a023\/11\/2020<\/td>\n<td style=\"border-color: #000000; width: 25.0202%; text-align: left; height: 47px;\" data-darkreader-inline-border-top=\"\" data-darkreader-inline-border-right=\"\" data-darkreader-inline-border-bottom=\"\" data-darkreader-inline-border-left=\"\">assistant lecturer<\/td>\n<\/tr>\n<tr style=\"height: 47px;\">\n<td style=\"border-color: #000000; width: 36.833%; text-align: left; height: 47px;\" data-darkreader-inline-border-top=\"\" data-darkreader-inline-border-right=\"\" data-darkreader-inline-border-bottom=\"\" data-darkreader-inline-border-left=\"\"><span style=\"text-decoration: underline;\"><strong>Lab for Homework #3 on triggers in Oracle + Tutoring session<\/strong><\/span><\/td>\n<td style=\"border-color: #000000; width: 20.4186%; text-align: left; height: 47px;\" data-darkreader-inline-border-top=\"\" data-darkreader-inline-border-right=\"\" data-darkreader-inline-border-bottom=\"\" data-darkreader-inline-border-left=\"\">\u00a030\/11\/2020<\/td>\n<td style=\"border-color: #000000; width: 25.0202%; text-align: left; height: 47px;\" data-darkreader-inline-border-top=\"\" data-darkreader-inline-border-right=\"\" data-darkreader-inline-border-bottom=\"\" data-darkreader-inline-border-left=\"\">scholarship holder<\/td>\n<\/tr>\n<tr style=\"border-color: #000000;\" data-darkreader-inline-border-top=\"\" data-darkreader-inline-border-right=\"\" data-darkreader-inline-border-bottom=\"\" data-darkreader-inline-border-left=\"\">\n<td style=\"border-color: #000000; width: 36.833%; height: 47px;\" data-darkreader-inline-border-top=\"\" data-darkreader-inline-border-right=\"\" data-darkreader-inline-border-bottom=\"\" data-darkreader-inline-border-left=\"\"><span style=\"text-decoration: underline;\"><strong>Practice #5: Oracle optimizer<\/strong><\/span><\/td>\n<td style=\"border-color: #000000; width: 20.4186%; height: 47px;\" data-darkreader-inline-border-top=\"\" data-darkreader-inline-border-right=\"\" data-darkreader-inline-border-bottom=\"\" data-darkreader-inline-border-left=\"\">\u00a014\/12\/2020<\/td>\n<td style=\"border-color: #000000; width: 25.0202%; height: 47px;\" data-darkreader-inline-border-top=\"\" data-darkreader-inline-border-right=\"\" data-darkreader-inline-border-bottom=\"\" data-darkreader-inline-border-left=\"\">assistant lecturer<\/td>\n<\/tr>\n<tr style=\"border-color: #000000;\" data-darkreader-inline-border-top=\"\" data-darkreader-inline-border-right=\"\" data-darkreader-inline-border-bottom=\"\" data-darkreader-inline-border-left=\"\">\n<td style=\"border-color: #000000; width: 36.833%; height: 47px;\" data-darkreader-inline-border-top=\"\" data-darkreader-inline-border-right=\"\" data-darkreader-inline-border-bottom=\"\" data-darkreader-inline-border-left=\"\"><b><u>Practice #6: MongoDB<\/u><\/b><\/td>\n<td style=\"border-color: #000000; width: 20.4186%; height: 47px;\" data-darkreader-inline-border-top=\"\" data-darkreader-inline-border-right=\"\" data-darkreader-inline-border-bottom=\"\" data-darkreader-inline-border-left=\"\">\u00a011\/01\/2021<\/td>\n<td style=\"border-color: #000000; width: 25.0202%; height: 47px;\" data-darkreader-inline-border-top=\"\" data-darkreader-inline-border-right=\"\" data-darkreader-inline-border-bottom=\"\" data-darkreader-inline-border-left=\"\">assistant lecturer<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><strong>Lab 1: Extended SQL<\/strong><\/p>\n<ul>\n<li>Text (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/10\/Lab1_ExtendedSQL2021.pdf\">pdf<\/a>)<\/li>\n<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>\n<li>Import Database and Tables\n<ul>\n<li><a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/10\/ImportDatabaseSQL_ENG.pdf\">Tutorial<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul>\n<li>Installing Oracle Database 18c Express Edition and SQL Developer\n<ul>\n<li>To download and install Oracle Express Edition: <a href=\"https:\/\/www.oracle.com\/it\/database\/technologies\/appdev\/xe.html\" target=\"_blank\" rel=\"noopener noreferrer\">home page<\/a><\/li>\n<li>To download and install SQL Developer: <a href=\"https:\/\/www.oracle.com\/it\/database\/technologies\/appdev\/xe.html\" target=\"_blank\" rel=\"noopener noreferrer\">home page<\/a><\/li>\n<li>Tutorial\n<ul>\n<li>Installation Guide for <a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/10\/TutorialWindowsOracleDB_ENG.pdf\">Windows<\/a><\/li>\n<li>Installation Guide for <a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/10\/TutorialUbuntuOracleDB_ENG.pdf\">Ubuntu<\/a><\/li>\n<li>Installation Guide for <a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/10\/TutorialMACOsOracleDB_ENG.pdf\">Mac OS<\/a><\/li>\n<\/ul>\n<\/li>\n<li>If you have problems with the installation, please use <a href=\"http:\/\/piazza.com\/polito.it\/fall2020\/01sqjov\">Piazza<\/a> (folder oraclexesql)<\/li>\n<li>Draft solution of queries 1-5 and materialized view (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/10\/Lab1_ExtendedSQL_Sol.pdf\">pdf<\/a>) and <a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2018\/10\/star_schema_callDW_Sol.pdf\">DW design<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><strong>Lab 2: Data-warehouse analytics and reporting with Google Data Studio<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/10\/Lab2_DataStudio_ENG.pdf\">Text of Practise 2<\/a><\/li>\n<\/ul>\n<p><strong>Lab 3: Data mining &#8211; Rapid Miner\u00a0\u00a0<\/strong><\/p>\n<ul style=\"padding-left: 30px;\">\n<li style=\"list-style-type: none;\">\n<ul style=\"padding-left: 30px;\">\n<li style=\"padding-left: 30px;\"><a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/11\/Lab3_DataMiningEN.pdf\">Text Practice 3<\/a><\/li>\n<li>\u00a0 \u00a0 \u00a0 \u00a0 Dataset (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/11\/Users.xls\">Users.xls<\/a>)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul style=\"padding-left: 30px;\">\n<li style=\"list-style-type: none;\">\n<ul style=\"padding-left: 30px;\">\n<li style=\"padding-left: 30px;\"><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul style=\"padding-left: 30px;\">\n<li style=\"padding-left: 30px;\">Supporting material\n<ul>\n<li style=\"list-style-type: none;\">\n<ul style=\"padding-left: 30px;\">\n<li style=\"padding-left: 30px;\">Rapid Miner 5.0 Community Edition Guide (<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/rapidminer-5.0-manual-english_v1.0.pdf\">rapidminer-5.0-manual-english_v1.0<\/a>)<\/li>\n<li>\u00a0 \u00a0 \u00a0 \u00a0Rapid Miner download <a href=\"http:\/\/rapidminer.com\/products\/rapidminer-studio\/\">http:\/\/rapidminer.com\/products\/rapidminer-studio\/<\/a>\n<ul style=\"padding-left: 30px;\">\n<li>Free Community Edition<\/li>\n<\/ul>\n<\/li>\n<li>\u00a0 \u00a0 \u00a0 \u00a0Introduction to\u00a0RapidMiner (<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/Rapidminer_x2.pdf\">2 slides per page<\/a>,\u00a0<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/Rapidminer_x3.pdf\">3 slides per page<\/a>,\u00a0<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/Rapidminer_x6.pdf\">6 slides per page<\/a>)<\/li>\n<li>\u00a0 \u00a0 \u00a0 \u00a0Examples (<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/ExampleProcesses.zip\">download<\/a>)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><strong>Lab 4: Triggers<\/strong><\/p>\n<ul>\n<li>Text (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/11\/Lab4_Trigger_EN.pdf\">pdf<\/a>)<\/li>\n<li>scripts for creating DBs (<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2018\/11\/EsTriggerScripts.zip\">create_db scripts<\/a>)<\/li>\n<li>Screenshots of the database after the trigger executions: <a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2018\/11\/Lab4_Trigger_EN_Results.pdf\">Results<\/a><\/li>\n<li>Draft solution (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/11\/Lab4_Trigger_ENG_Sol.pdf\">pdf<\/a>) <strong>[UPDATE (Ex. 3) ]<\/strong><\/li>\n<\/ul>\n<p><strong>Lab 5: The Oracle Optimizer<\/strong><\/p>\n<ul style=\"padding-left: 30px;\">\n<li>Text (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/12\/Lab5_Optimizer_ENG.pdf\">pdf<\/a>)<\/li>\n<li>Scripts for creating DBs (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/12\/Lab5Database.zip\">Lab5Database_OPT<\/a>)<\/li>\n<li>Useful\u00a0<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/scripts.zip\">scripts<\/a><\/li>\n<li>Documentation and description of the <a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/OracleGuide-ExplainPlan.pdf\">execution plan operations<\/a><\/li>\n<li>Draft solution (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/12\/Lab5_Optimizer_ENG_Sol.pdf\">pdf<\/a>)<\/li>\n<\/ul>\n<p><strong>Lab 6: NoSQL in MongoDB<\/strong><\/p>\n<ul>\n<li>Text (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2021\/01\/Lab6_MongoDB_DSDBT.pdf\">pdf<\/a>)<\/li>\n<li>Collections &#8211; restaurants (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2021\/01\/restaurants_collection.txt\">txt<\/a>)<\/li>\n<li>Draft solutions (<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2021\/01\/Lab6_MongoDB_DSDBT_VC_draft_sol_mongodb_compass_part1.pdf\">part 1<\/a>, <a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2021\/01\/Lab6_MongoDB_DSDBT_VC_draft_sol_mongodb_part2.pdf\">part 2<\/a>)<\/li>\n<\/ul>\n\n<h2><\/h2>\n<hr style=\"padding-left: 30px;\" \/>\n<h2><span id=\"Homework-to-be-delivered-1\">Homework to be delivered<\/span><\/h2>\n<p>&nbsp;<\/p>\n<p>To obtain the points associated\u00a0with the homeworks, students have to observe the following terms:<\/p>\n<ul style=\"padding-left: 30px;\">\n<li style=\"list-style-type: none;\">\n<ul style=\"padding-left: 30px;\">\n<li style=\"padding-left: 30px;\">Complete all the points of the exercises in the homework text.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul style=\"padding-left: 30px;\">\n<li style=\"list-style-type: none;\">\n<ul style=\"padding-left: 30px;\">\n<li style=\"padding-left: 30px;\">Prepare one file in PDF, DOC or ODT format with the solution of the homework.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul style=\"padding-left: 30px;\">\n<li style=\"list-style-type: none;\">\n<ul style=\"padding-left: 30px;\">\n<li style=\"padding-left: 30px;\">Name the file as: <strong>HomeworkN_Surname_Name_StudentId.XXX\u00a0<\/strong>where\n<ul style=\"padding-left: 30px;\">\n<li style=\"list-style-type: none;\">\n<ul style=\"padding-left: 30px;\">\n<li style=\"padding-left: 30px;\">StudentId, Surname and Name should be substituted with student information<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul style=\"padding-left: 30px;\">\n<li style=\"list-style-type: none;\">\n<ul style=\"padding-left: 30px;\">\n<li style=\"padding-left: 30px;\">the N character following Homework should be substituted with the number of the submitted homework<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul style=\"padding-left: 30px;\">\n<li style=\"list-style-type: none;\">\n<ul style=\"padding-left: 30px;\">\n<li style=\"padding-left: 30px;\">the filename extension XXX depends on the file type chosen for the submission (PDF, DOC or ODT).<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul style=\"padding-left: 30px;\">\n<li style=\"list-style-type: none;\">\n<ul style=\"padding-left: 30px;\">\n<li style=\"padding-left: 30px;\">DOCX format is not supported.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul style=\"padding-left: 30px;\">\n<li style=\"padding-left: 30px;\"><span style=\"color: #ff0000;\" data-mce-mark=\"1\" data-darkreader-inline-color=\"\">Since uploaded files are automatically processed, naming the file with a wrong name implies the cancellation of the related homework submission.<\/span><\/li>\n<li>\u00a0For example, for homework 1 and extension pdf, the student with name and surname Mario Rossi and id s123456 will upload Homework1_Rossi_Mario_s123456.pdf<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul style=\"padding-left: 30px;\">\n<li style=\"list-style-type: none;\">\n<ul style=\"padding-left: 30px;\">\n<li style=\"padding-left: 30px;\">Load the file on the didactic portal (Portale della didattica) in the section Work Submission (Elaborati) before the deadline.\n<ul style=\"padding-left: 30px;\">\n<li style=\"list-style-type: none;\">\n<ul style=\"padding-left: 30px;\">\n<li style=\"padding-left: 30px;\">Multiple loadings for the same student and\/or for the same homework are not allowed.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul style=\"padding-left: 30px;\">\n<li style=\"list-style-type: none;\">\n<ul style=\"padding-left: 30px;\">\n<li style=\"padding-left: 30px;\">The upload date show on the didactic portal is considered for the evaluation.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul style=\"padding-left: 30px;\">\n<li style=\"padding-left: 30px;\"><span style=\"color: #ff0000;\" data-mce-mark=\"1\" data-darkreader-inline-color=\"\">Since uploaded files are automatically processed, the upload after the deadline implies the cancellation of the related homework submission.<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul style=\"padding-left: 30px;\">\n<li style=\"list-style-type: none;\">\n<ul style=\"padding-left: 30px;\">\n<li style=\"padding-left: 30px;\">During the upload procedure a description (&#8220;Descrizione&#8221;) field is requested. Insert the same name of the file according to the rules described above.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul style=\"padding-left: 30px;\">\n<li style=\"list-style-type: none;\">\n<ul style=\"padding-left: 30px;\">\n<li style=\"padding-left: 30px;\">Only the students without the access to the course page on the didactic portal can submit the homework before the deadline by sending an email to the assistant lecturer (eliana dot pastor at polito dot it)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul style=\"padding-left: 30px;\">\n<li style=\"padding-left: 30px;\">Discuss the homework with a positive evaluation on the fixed date (announcement will be published).<\/li>\n<\/ul>\n<p style=\"padding-left: 30px;\"><strong>Homework discussion<\/strong>: Students attending the written exam must bring the following items:<\/p>\n<ul style=\"padding-left: 30px;\">\n<li style=\"padding-left: 30px;\">for Homeworks #1 &#8211; #4:\n<ul style=\"padding-left: 30px;\">\n<li style=\"padding-left: 30px;\">a hard-copy of the submitted reports<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><strong>Homework deliveries<\/strong>:<\/p>\n<p><a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2021\/02\/DSDBT_Homework_submissions_2021.pdf\">Homework submissions<\/a> : list of delivered submissions. In case of any incongruencies or missing delivery, send an email to eliana.pastor@polito.it.<\/p>\n<p>&nbsp;<\/p>\n<table style=\"height: 235px; width: 75.3821%;\" border=\"3\">\n<tbody>\n<tr style=\"height: 47px;\">\n<td style=\"height: 47px; width: 22.1687%; text-align: center;\"><strong>Homework<\/strong><\/td>\n<td style=\"text-align: center; height: 47px; width: 11.4458%;\"><strong>Material<\/strong><\/td>\n<td style=\"text-align: center; height: 47px; width: 52.4096%;\"><strong>Deadline<\/strong><\/td>\n<td style=\"text-align: center; height: 47px; width: 12.4096%;\"><strong>Homework deliveries<\/strong><\/td>\n<\/tr>\n<tr style=\"height: 47px;\">\n<td style=\"height: 47px; width: 22.1687%;\">Homework #1: Data warehouse<\/td>\n<td style=\"height: 47px; width: 11.4458%;\"><a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/10\/Homework1_DW_ENG.pdf\">HW text (pdf)<\/a><\/p>\n<p><strong>[NEW] Updated (b) ii<\/strong><\/td>\n<td style=\"height: 47px; width: 52.4096%;\">to be delivered by Sunday, <strong>November 08<\/strong><strong>th, 2020<\/strong>\u00a0at 11.59 PM (UTC\/GMT+1)<\/td>\n<td style=\"height: 47px; width: 12.4096%;\"><\/td>\n<\/tr>\n<tr style=\"height: 47px;\">\n<td style=\"height: 47px; width: 22.1687%;\">Homework #2: Data Mining<\/td>\n<td style=\"height: 47px; width: 11.4458%;\"><a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/11\/Homework2_DataMining_ENG.pdf\">HW text (pdf)<\/a>\u00a0&#8211; Dataset (<a href=\"http:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2010\/12\/breast.xlsx\">breast.xls<\/a>)<\/td>\n<td style=\"height: 47px; width: 52.4096%;\">to be delivered by Monday, <strong>November 23<\/strong><strong>th, 2020<\/strong>\u00a0at 11.59 PM (UTC\/GMT+1)<\/td>\n<td style=\"height: 47px; width: 12.4096%;\"><\/td>\n<\/tr>\n<tr style=\"height: 47px;\">\n<td style=\"height: 47px; width: 22.1687%;\">Homework #3: Triggers<\/td>\n<td style=\"height: 47px; width: 11.4458%;\"><a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/11\/Homework3_Trigger_2020_ENG.pdf\">HW text (pdf)<\/a>\u00a0&#8211;\u00a0\u00a0<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2020\/11\/create_db_telefoni_en.sql.zip\">scripts.<\/a><\/td>\n<td style=\"height: 47px; width: 52.4096%;\">to be delivered by Monday, <strong>December 7<\/strong><strong>th, 2020<\/strong>\u00a0at 11.59 PM (UTC\/GMT+1)<\/td>\n<td style=\"height: 47px; width: 12.4096%;\"><\/td>\n<\/tr>\n<tr style=\"height: 47px;\">\n<td style=\"width: 22.1687%; height: 47px;\">Homework #4: Query Optimization<\/td>\n<td style=\"width: 11.4458%; height: 47px;\"><a href=\"https:\/\/dbdmg.polito.it\/wordpress\/wp-content\/uploads\/2021\/01\/Homework_4_OPT_ENG.pdf\">HW text (pdf)<\/a> [Updated having COUNT(*)&gt;1]<\/td>\n<td style=\"width: 52.4096%; height: 47px;\">to be delivered by Thursday, <strong>January 7<\/strong><strong>th, 2021<\/strong>\u00a0at 11.59 PM (UTC\/GMT+1)<\/td>\n<td style=\"width: 12.4096%; height: 47px;\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n<p style=\"padding-left: 30px;\"><a href=\"https:\/\/mail.polito.it\/Redirect\/B5876D82\/Anchor\/Argomenti-del-corso-1\/dbdmg.polito.it\/wordpress\/teaching\/basi-di-dati\/\" target=\"_blank\" rel=\"noopener noreferrer\">\u00a0<\/a><\/p>\n<br class=\"fixfloat\" \/>","protected":false},"excerpt":{"rendered":"<p>Table of content General information Exams Material Part I Oracle Part II Oracle Exercises Exercises from written exams Other exercises Tutoring sessions Practices Homework to be delivered General information ECTS: 8 Professor: Assistant lecturer: Alessandro Fiori,\u00a0 Eliana Pastor Exam rules A.Y. 2020\/2021 (Covid-19 Emergency)\u00a0 (pdf-rules) Announcements [02-02-2021] We posted a recap of homework submissions. [21-11-2020]\u00a0<a href=\"https:\/\/dbdmg.polito.it\/wordpress\/teaching\/data-science-and-database-technology-2020-2021\/\">[&#8230;]<\/a><\/p>\n","protected":false},"author":26,"featured_media":0,"parent":96,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-16664","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/dbdmg.polito.it\/wordpress\/wp-json\/wp\/v2\/pages\/16664","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\/26"}],"replies":[{"embeddable":true,"href":"https:\/\/dbdmg.polito.it\/wordpress\/wp-json\/wp\/v2\/comments?post=16664"}],"version-history":[{"count":68,"href":"https:\/\/dbdmg.polito.it\/wordpress\/wp-json\/wp\/v2\/pages\/16664\/revisions"}],"predecessor-version":[{"id":17655,"href":"https:\/\/dbdmg.polito.it\/wordpress\/wp-json\/wp\/v2\/pages\/16664\/revisions\/17655"}],"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=16664"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}