CSSE533 Database Systems

Spring 2015

Week by week schedule (2 sessions / week, as shown)!

Week Session Topics/Slides Preparation Project Work Due
1 Tues & Thurs, Mar 10 & 12, 2015

What's in the course?

Intro to all 3 main topics!

Look at the Syllabus

First night - Intro slides

Suggest - for second night - Think of a project to talk about...
   

Second night - Discussion of possible projects - continued

And - MongoDB Intro, plus 2 short presentations on Moodle

And - Using the DB's on Mike's server

Read a bit into the MongoDB book! A sketch of the project?
2 All on Tues, Mar 17, this week MongoDB - 1: Learning to use it

MongoDB book - Ch 3 - 8

Read about Hadoop - See Moodle "Hadoop from Data Science Book"

 
         
3 All on Thurs, Mar 26, in Indy, this week MongoDB - 2: Working on it with real data

MongoDB book - Ch 9 - 15

That would divide the rest of it in half, would cover Replication and all of Sharding except admin.

Followup - Look at Byzantine Generals

Project progress report - Discuss the requirements / architecture
         
4 Tues & Thurs, Mar 31 & Apr 2

MongoDB - 3: Finish last week's discussion - sharding, etc.

Applying it to data mining (discussion)

MongoDB book - Ch 16 - 23

That's all the Admin stuff

Project progress report

Try 1-minute installation of a sharded cluster (p 232).

         
5 Tues & Thurs, Apr 7 & 9 PostgreSQL - 1: Learning to use it

PostgreSQL book - Ch 1 - 5

Plus - look at Colorado State PostgreSQL intro slides, on Moodle.

Project progress report - How to set up the DB using PostgreSQL?
         
6 Tues & Thurs, Apr 14 & 16 PostgreSQL - 2: Working on it with real data PostgreSQL book - Ch 6 - 10  
         
7 Tues & Thurs, Apr 21 & 23 PostgreSQL - 1: Applying it to data mining Links - see same slides as last week, additional refs at the end.  
         
8 Tues & Thurs, Apr 28 & 30 PostgreSQL - 1: Applying it to your project    
         
9 Tues & Thurs, May 5 & 7      
         
10 Tues & Thurs, May 12 & 14 Project demos and lessons learned