====== DBDM: Databases and Data Mining ======


  * **2018-01-31** {{:enseignement:dbdm:dbdm-01.pdf|Course 1}}: Introduction, relational model, SQL
  * **2018-02-01**  [[enseignement:dbdm:tp1|SQLite practice]]
  * **2018-02-07**  {{:enseignement:dbdm:dbdm-02.pdf|Course slides}}: Functional dependencies: an introduction to normalization
  * **2018 -02-07**+**2018-02-14** [[http://liris.cnrs.fr/romuald.thion/files/Enseignement/DBDM/TPCSV_2017.pdf |Real-life dataset case study]]: from a CSV file to a normalized schema, [[http://liris.cnrs.fr/romuald.thion/files/Enseignement/DBDM/|resources folder]]
  * [[https://perso.liris.cnrs.fr/emmanuel.coquery/dbdm/DBDM-2018-project.html|DB Project]]
  * **2018-03-14** [[https://perso.liris.cnrs.fr/marc.plantevit/ENS/M1_ENS/18/M1_ENS_2018_PatternMining.pdf|Constraint based pattern mining (Course)]] and [[https://perso.liris.cnrs.fr/marc.plantevit/ENS/M1_ENS/18/Patterns_ENS_TD1.pdf|Exercises]] 
  * **2018-03-21**[[https://perso.liris.cnrs.fr/marc.plantevit/ENS/M1_ENS/18/PatternSamplingTP1.pdf|Practice: Sampling (frequent) patterns]] [[http://www.philippe-fournier-viger.com/spmf/index.php?link=datasets.php| (other datasets)]]
  * **2018-03-22** Clustering: [[https://perso.liris.cnrs.fr/marc.plantevit/ENS/M1_ENS/18/clustering_overview.pdf|Overview]], and [[https://perso.liris.cnrs.fr/marc.plantevit/ENS/M1_ENS/18/clustering.pdf|algorithms]] 
  * **2018-03-28** [[https://perso.liris.cnrs.fr/marc.plantevit/ENS/M1_ENS/18/TP_Event.pdf|Detection  and characterization of POI and Events in social media]] -- [[https://www.knime.com/downloads/download-knime|Link to Knime]] (TP can be done in Python but with much effort, Knime offers the possibility to focus on the concepts. )
  * **2018-03-29** [[https://perso.liris.cnrs.fr/marc.plantevit/ENS/M1_ENS/18/TD_Clustering.pdf|Exercices -- K-Means, Hierarchical Clustering  ]] and back to patterns.
  * **2018-04-04**  End of TP on event/POI detection and characterization
  * **2018-04-05** [[https://perso.liris.cnrs.fr/marc.plantevit/ENS/M1_ENS/18/Preference_Based_PM.pdf|Interactive pattern mining]] and [[https://perso.liris.cnrs.fr/marc.plantevit/ENS/M1_ENS/18/M1_ENS_2018_other_Patterns.pdf|other pattern languages]].
  * **2018-04-11** TP: [[https://perso.liris.cnrs.fr/marc.plantevit/ENS/M1_ENS/18/preference_learning.pdf|Learning user preferences in interactive pattern mining]]
  * **2018-04-12** [[https://perso.liris.cnrs.fr/marc.plantevit/ENS/M1_ENS/18/supervised_pattern_mining.pdf|Supervised pattern mining and exploration methods]].  
===== 2016-2017 =====

  * **2017-03-09** {{ :enseignement:dbdm:dbdm-03.pdf |Slides on TRC & Relational Algebra}}
  * **2017-03-13** {{ :enseignement:dbdm:td-ens_2016p-correction.pdf |Exercice sheet (+answers in french)}}
  * **2017-03-20** and **2017-03-27** {{ :enseignement:dbdm:ens-dbdm-tp-prog.pdf |DB Project}}, {{ :enseignement:dbdm:2017-normalization.zip |material}}
  * **2017-03-30** [[http://liris.cnrs.fr/marc.plantevit/ENS/M1_ENS/M1DBDM_ENS_2017_C1.pdf|Introduction to constraint based pattern mining ]] 
  * **2017-04-03**[[http://liris.cnrs.fr/~mplantev/ENS/M1_ENS/Patterns_ENS_TD1.pdf|Exercice sheet ]]
  * **2017-04-06** Constraint-based pattern mining (part II)
  * **2017-04-10** Introduction to [[https://www.knime.org/|Knime]] and presention of the [[http://liris.cnrs.fr/marc.plantevit/doku/doku.php?id=m1ens2017_project|DM Project]]
  * **2017-04-13** [[http://liris.cnrs.fr/~mplantev/ENS/M1_ENS/clustering_overview.pdf|Clustering (pb, assessment, distances and similarities)]] and  [[http://liris.cnrs.fr/~mplantev/ENS/M1_ENS/clustering.pdf| main algorithms]].
  * **2017-04-24** Data Mining project
  * **2017-04-25** [[http://liris.cnrs.fr/marc.plantevit/ENS/M1_ENS/TD_Clustering.pdf|Clustering -- Exercice sheet]]
  * **2017-04-27** [[http://liris.cnrs.fr/marc.plantevit/ENS/M1_ENS/slidesPreferenceBasePM-tutorial.pdf|Toward Interactive Pattern Mining]]
  * **2017-05-04** [[http://liris.cnrs.fr/mehdi.kaytoue/files/dbdm-may04.pdf|Discriminant pattern mining and MCTS]]

Additional resources: 
  * Online book: [[http://webdam.inria.fr/Alice/|Foundations of Databases]]