541 SYLLABUS

1st Week: Introduction& ER model
2nd Week: Relational Model
3rd Week: Project Description + SQL
4th Week: Advanced Topics: Data Mining and OLAP (*)
5th Week: Advanced Topics: Data Mining and OLAP (*)
6th Week: Advanced Topics: Data Mining and OLAP (*)
7th Week Relational Database Design
8th Week: Midterm
9th Week: Query Processing
10th Week: Query processing and Query Optimization
11th Week Query Optimization
12th Week: Advanced Topics: XML and Semantic Web (*)
13th Week: Advanced Topics: XML and Semantic Web
14th Week: Project Review
15th Week: Final Exam

Power points

For regular (nonadvanced topics from the textbook Silberschatz et el) are available here

Tutorial on data mining . short version used in class. Here are the papers covered in the tutorial:

 AIS paper 
Apriori paper 
SDB and OLAP
paper 
Sampling
paper  
MaxMiner
Cube operator paper 

Correlation
rules 

Cubegrade paper  


 Evaluation: Midterm 25%, Final: 35%, Project: 40% 

Student records project (to be posted shortly) 

Class Notes 

Examples of Data Mining Problems 


 Examples of queries - part 1 (answers will be posted later, try to do it by yourself first) 

Queries