CP465 DATABASES II, WINTER 2011, WLU

Course Description

The course covers advanced database system design principles and techniques.

Prerequisites

CP363 Databases I

Instructor

Dr. Ilias S. Kotsireas
Office: N2076A, Office Hours: 24/7 and by appointment, Phone: 884-0710 ext. 2218, E-Mail: ikotsireATwlu.ca

Important Course Information


Lecture Topics (corresponding to the 12 weeks schedule)

  1. Introduction, Relational Algebra, SQL
  2. Query Processing, Query Optimization
  3. Lexical Analysis, Syntactic Analysis, BNF Grammars, LEX/YACC
  4. Object Databases, Object Database Management Systems, (ODBMSs), ODMG, Object Definition Language (ODL), Object Query Language (OQL)
  5. Data Mining I, Introduction and Basic Concepts, KDD, Learning, Decision Trees, Association Rules
  6. Data Mining II, ID3 Algorithm (Iterative Dichotomizer), C4.5 Algorithm, Apriori Algorithm
  7. Data Mining III, k-Means Clustering, Genetic Clustering, FP-Growth Algorithm
  8. Web Databases, PHP, HITS/PageRank Algorithms
  9. XML, well-formed documents, Document Type Definitions (DTDs), XML Schemas, XML Documents, XML Databases, XML Query Languages (XPath,XQuery)
  10. Data Mining IV, Logic-based approaches
  11. Data Storage, Indexing Structures for Files, Distributed Databases, Deductive Databases
  12. Research Projects Presentations

Class Schedule, Winter Semester Timetable

            |     Tue     |     Thu
            | 16:00-17:20 | 16:00-17:20
            | Room BA112  | Room BA112
____________|_____________|_____________
            |             |             
Week 1:     |  Jan 04     |    Jan 06   
Week 2:     |  Jan 11     |    Jan 13   
Week 3:     |  Jan 18     |    Jan 20   
Week 4:     |  Jan 25     |    Jan 27   
Week 5:     |  Feb 01     |    Feb 03   
Week 6:     |  Feb 08     |    Feb 10   
Week 7:     |  Feb 15     |    Feb 17 (M)
____________|_____________|_____________

Reading Week Feb 21 - Feb 25  No Courses
________________________________________
            |             |             
Week 8:     |  Mar 01     |   Mar 03 
Week 9:     |  Mar 08     |   Mar 10   
Week 10:    |  Mar 15     |   Mar 17    
Week 11:    |  Mar 22     |   Mar 24    
Week 12:    |  Mar 29     |   Mar 31    
____________|_____________|_____________
            |             |             

Course Mailing List

Send e-mail to the course instructor, to be added to the course mailing list.
Subject: add me to the CP465 Mailing List

Course Requirements/Student Evaluation