TU/e

USI Module I3 - Database Technologies


Program: USI (PostMaster)

Lecturer: Mykola Pechenizkiy

Course materials can be found in Sakai eLearning environment. Please, create an account and register for the course here.

Course syllabus

Date, Time, and Room Lecture Title and Contents
2 Feb 2009
Monday
10:45 – 12:30
HG 3.02
Lecture 1: Introduction to the course
  • Course overview
  • Modern Database Technology and Applications
2 Feb 2009
Monday
13:30 – 15:15
HG 3.02
Lecture 2: ER-modelling
  • Requirements analysis
  • ER modeling: entities, hierarchies and relationships
  • Case study
3 Feb 2009
Tuesday
10:45 – 12:30
HG 3.02
Lecture 3: Transforming the conceptual data model to tables
  • Transformation rules and SQL constructs
  • Transformation steps
3 Feb 2009
Tuesday
13:30 – 15:15
HG 3.02
Lecture 4: Querying data with SQL
  • Basic Select
  • Nested queries
  • Aggregation functions
4 Feb 2009
Wednesday
10:45 – 12:30
HG 3.02
Lecture 5: Data Warehousing and OLAP
  • Conceptual and physical DW Modelling
  • Data cubes: a multi-dimensional data model
  • Basic OLAP operations
4 Feb 2009
Wednesday
13:30 - 15:15
HG 3.02
Discussion session
5 Feb 2009
Thursday
10:45 – 12:30
HG 3.02
Lecture 6: Data Mining
  • Classification
  • Clustering
  • Association analysis
5 Feb 2009
Thursday
13:30 - 15:15
HG 3.02
Tutorial on Data Mining in WEKA
  • Classification
  • Clustering
  • Association analysis
6 Feb 2009
Friday
10:45 – 12:30
HG 3.02
Lecture 7: Recommender Systems
  • Content-based filtering
  • Collaborative filtering
  • Hybrid approaches
6 Feb 2009
Friday
13:30 - 15:15
HG 3.02
Discussion of project assignments
9 Feb 2009
Monday
10:45 - 12:30
HG 3.02
Discussion/Q&A session
11 Feb 2009
Wednesday
10:45 - 12:30
HG 3.02
Discussion/Q&A session
13 Feb 2009
Friday
10:30 – 13:00
HG 3.02
Project presentations
13 Feb 2009
Friday
13:30 - 15:30
HG 3.02
Written exam or multiple-choice test
Final grade = 75% of your group assignments grade + 25% of your exam grade
For further questions, please contact