Welcome to the Data Mining course, COSC-4412, for winter term 2003. Materials, instructions, and notices for the course will accumulate here over the semester.

• Check grades and grade break-down via courseInfo.

  % courseInfo 4412 2003-04 W

• Preparation Guide for Final Exam.

• Midterm w/ answers up as a study guide.

• Syllabus
• Class news group: york.cs.course.4412
• Lecture Notes
  (Notes are only accessable from a cs.yorku.ca address. Apologies, but I do not have permissions to redistribute freely some of the materials beyond the students due to copyright.)
  1. Introduction:
     PS, PS (2-per), PDF, & PDF (2-per).
  2. Data Warehousing & OLAP
     
     • Textbook chapter 2 slides (v2):
       PS, PS (2-per), PDF, & PDF (2-per).
     • OLAP in (DB2 UDB v8.1) SQL
       • OLAP Functions (pp. 84-108, Graeme Birchall © 2003):
         PS, PS (2-per), PDF, & PDF (2-per).
       • OLAP Functions (pp. 143-156, Graeme Birchall © 2003):
         PS, PS (2-per), PDF, & PDF (2-per).
       These thanks to Graeme Birchall. See his DB2 Cookbooks for the complete set of these slides and the book form. He has written an excellent reference guide for DB2 SQL, repleat with examples, and it is free!
  3. Data Preparation
     Textbook chapter 3 slides:
     PS, PS (2-per), PDF, & PDF (2-per).
  4. Concept Description
     Textbook chapter 5 slides:
     PS, PPT
     Sorry, I couldn't get a clean PDF! I provide the PS and the original textbook PPT here.
  5. Association Rule Mining
     Textbook chapter 6 slides:
     PS, PDT

• Projects
  1. Project 1: OLAP Jeopardy
  2. Project 2: Apriori Mining for Frequent Itemsets
     • FAQ
     • A Perl program, apriori, that I wrote implementing the ideas we discussed in class for the project.

• Tests
  • Midterm
    • Preparation Guide
    • Test w/ answers: PS, PDF.
  • Final Exam
    • Date & Time: 15:30-18:30 Wednesday 21 April 2004
    • Location: CLH E
    • Preparation Guide

• Associated materials with the textbook.
• Graeme Birchall's DB2 Cookbooks
• DB2
  • Local DB2 Notes (DB2 at CS/York).
  • Online DB2 Reference (locally hosted)
  • SQL, courtesy of IBM (DB2-oriented)
    • IBM: SQL, Getting Started (for DB2)
    • IBM: SQL Reference