Differenze

Queste sono le differenze tra la revisione selezionata e la versione attuale della pagina.

--- mds:lbi:start [04/06/2026 alle 16:01 (4 settimane fa)] – Anna Monreale
+++ mds:lbi:start [12/06/2026 alle 09:24 (3 settimane fa)] (versione attuale) – Anna Monreale
@@ Linea 37: / Linea 37: @@
   * Recordings of each lecture will be made available for non-attending students.
 ===== Past Exams =====
+For preparing yourself for the practical test can use these past exam doing exercises on: programming (using Python instead of Java), SSIS and MDX.
   * {{ :mds:lbi:2016midterm1text.pdf |2016/17 text}}, {{ :mds:lbi:2015fallmidterm1text.pdf | 2015/16 text}} and {{ :mds:lbi:2015wintermidterm1.zip | 2015/16 solution}}, {{:mds:lbi:2015midterm1text.pdf | 2014/15 text}} and {{ :mds:lbi:2015midterm1.zip |2014/2015 solution}}, {{ :mds:lbi:2014midterm1text.pdf | 2013/14 text}},{{ :mds:lbi:2013midterm1.pdf | 2012/13 text }} and {{ :mds:lbi:2013midterm1.zip |2012/13 solution}}.
@@ Linea 56: / Linea 57: @@
   * [[https://start.unipi.it/help-ict/vpn/ | Unipi VPN ]]
   * [[https://autenticazione.unipi.it/auth/auth.signin | Unipi Authentication]] to access the VPN, make sure that network access services are enabled on your profile. Follow this link to access your Unipi profile.
+  * Access to the SQL server: please write an email to the teachers to get the info
 ====== Class calendar - (2025-2026) ======
 ^N. ^ Day  ^Room ^ Topic ^Lecture Material ^ Video Lectures ^ Refs ^
@@ Linea 61: / Linea 63: @@
 |2.|02.10| |File data access. Python Recap. | {{ :mds:lbi:2025-lds.04.python_no_hint.pdf | Python Recap}} {{ :mds:lbi:2024-lds.04_supplementary.code.zip | supplementary code}} | [[https://unipiit.sharepoint.com/:v:/s/a__td_69781/IQDpwaIIRE7kR59OFasMQnGrARRFlLnNYNHuccTtZXQ6vdU?e=3nhEFt|File data access]] [[https://tinyurl.com/337t8hxf|Python Recap (from previous years)]] |  - **File Formats:** [[http://www.stat.auckland.ac.nz/~paul/ItDT | Introduction to data technologies(Chps. 5, 6)]],  [[http://weka.wikispaces.com/ARFF+(stable+version)|Weka ARFF Format]], [[http://weka.wikispaces.com/XRFF|XRFF Format]] - **Python reference:** [[https://www.spronck.net/pythonbook/ | Free python book with exercises]] |
 |3.|22.10| |Project Presentation + Python Excercises + File Access in Python |{{ :mds:lbi:2025-lds.05.fileaccess-python.pdf |}} {{ :mds:lbi:2025-10-23-code.zip |}} |[[https://unipiit.sharepoint.com/:v:/s/a__td_69781/IQB5nDV9rjo7SrjShEp85YBPAbPYpxpTrq7LGKmthX-kE6w?e=KrlfP9|Project Presentation]] [[https://unipiit.sharepoint.com/:v:/s/a__td_69781/IQBEFtKr75UVQYDVYHjE7LHYAbL0XEMoA2aCGHvphTEg73Q?e=M8fUNQ|File access Py]]|
-|4.|29.10| |Python File Access + Exercises | same slides used in the previous lecture{{ :mds:lbi:data1.zip | Data ex files}} | [[https://unipiit.sharepoint.com/:v:/s/a__td_69781/IQDMPfG7S6G0QKu3-hvN1pRNAZiDPUVuXhHlDjeQlD6-qX8?e=W2T6zj|Video]]  |
+|4.|29.10| |Python File Access + Exercises | same slides used in the previous lecture{{ :mds:lbi:data1.zip | Data ex files}} {{ :mds:lbi:lds04_solutions.zip | LDS04 sol}} | [[https://unipiit.sharepoint.com/:v:/s/a__td_69781/IQDMPfG7S6G0QKu3-hvN1pRNAZiDPUVuXhHlDjeQlD6-qX8?e=W2T6zj|Video]]  |
 | |30.10| |Lecture canceled  |  |
 |5.|04.11| |RDBMS access protocols + Python DB Access | {{ :mds:lbi:2024-lds.06.relational_data_access.pdf | Slides}} |
@@ Linea 73: / Linea 75: @@
 |13.|21.11|Lab H  | SCD workflow for update customers +  SSIS practice |{{ :mds:lbi:ssis_dissimilarity_idx.pdf |Dissimilarity}} {{ :mds:lbi:2015midterm1text.pdf | MPD}} | [[https://unipiit.sharepoint.com/:v:/s/a__td_69781/IQD2Bb5-iJQaTorx40XlgsHjAdO_so2YLUVHCub0JIvp_5Y?e=mOReyv|Video]]|
 |14.|25.11|Lab H  | SSIS practice + Solutions of Dissimilarity and MPD| | [[https://unipiit.sharepoint.com/:v:/s/a__td_69781/IQAS8i9_GYxyTax_x1t8OdgJARZVvDauNw62C8e4gdPN9zo?e=JcJ7ma|Video]]|
-|15.|26.11|Lab I  | CDC Process  |  | |
+|15.|26.11|Lab I  | CDC Process  | {{ :mds:lbi:lds-ssis-projects-full.zip |}} | |
 |16.|27.11|Fib C  | Introduction to SSAS + DW | {{ :mds:lbi:2024-lds.09.dwandolap.pdf | SSAS Intro}} | |1) SSAS (olap): documentation; 2) S. Harinath et al. Professional Microsoft SQL Server Analysis Services 2012 with MDX and DAX, Wrox publisher, 2012. Chps. 4-6 |
 |17.|28.11|Lab H  | Olap Cube| {{ :mds:lbi:2024-lds.09.ssas.pdf |slides}}{{ :mds:lbi:foodmart_monreale_full_2025.zip |}} Instructions for the SSAS project: to avoid conflicts in deployment/process follow this steps once the solution is opened: (1) rename the project as <your account>_foodmart (2) from project properties select 'Deployment', then rename the database as <your account>_foodmart; (3) click on the button “show all files” just above “Solution explorer” right click on “view code” on the .database file that is visualized, and then change the ID from current name into <your account>_foodmart, and finally save the file. (4) change the credentials of connection to database on SQL Server.|
@@ Linea 91: / Linea 93: @@
 The lab project has to be submitted within the specified deadline that will be communicated asap.
-If the project is not submitted within the deadline, a practical test and a discussion on the topics of the second module will be required for the exam instead.
+If the project is not submitted within the deadline, **a practical test and a discussion on the topics of the second module will be required for the exam instead**.
@@ Linea 110: / Linea 112: @@
 Please indicate in the notes "Only Lab" for doing only the discussion of the lab project; "Only DSD" for doing only the written+oral part of the DSD module; or "DSD+Lab" for doing both.
 **Important:** The date of the discussion of the lab project will be communicated to you by the instructors. The dates reported in the
 [[https://esami.unipi.it/esami2/|registration website]] refear **only** the written part of the DSD module.
-**Oral Exam Date for LDS during the Winter Sessions:** TBD
+**How to book a slot for the pratical test?** For students who need to do the practical test during the exam session because they did not deliver the project, they must report their studentID in the dates listed in this shared document: [[https://docs.google.com/spreadsheets/d/1Gt-FQOY9EWt0rO82EnP97SAhks_bg78TL8Dq7X2vtQk/edit?gid=0#gid=0|Pratical Test booking]]. Avaulable dates are: 5th June 20206, 19th June 2026, 7th July 2026. If you have important issues with these dates please write asap an email to the teachers.
 =====Past Editions =====