Advanced Database Systems

(Graduate / Upper-level elective for undergraduates)

Fall 2014
http://www.cs.iusb.edu/~raman/adb

Last Updated: December 10, 2014 11:48 PM

Instructor Information Course Information

Dr. Raman Adaikkalavan


NS 329, CS, IUSB.
Email: canvas.iu.edu Message

CSCI B561

Lectures: NS 204, MW 5.30 - 6.45 p
Office Hours: MW 4.15 :- 5.15 p or by appt.

 

Resources

  • Library Resources (link to ACM Digital Library, Books 24x7)
  • IUCAT (link)
  • Oracle Documentation (link)
  • Buffering (1, 2, 3, 4, 5, 6)

Announcements

 

Hi All,

I have posted your final exam, project, and participation scores. You should be able to see my comments under each assignment submission and also your grade percentage via Canvas.

If you have any questions you should resolve it by Dec 11 @ 2 pm, as announced earlier. All grading issues MUST be resolved by that time by sending a message via Canvas. I CANNOT CHANGE YOUR GRADE AFTER THAT.

Hope you enjoyed the course and learned database implementation.

Happy Holidays.

Raman

 

 

Topics*

*Thanks to Dr. Hossein Hakimzadeh for helping with MiniDB

Tentative Schedule

 

Date

Tests

Lectures/Reading

Video

Recordings

Assignments Posted Date

Assignments Due Dates

8/25

        
8/27  
  • Ch10 : Storage and File Structure (zip)
  • Database Systems Review (Cont.)
   Phase 1  
9/1 Labor Day No Class
9/3  
  • Phase 1
  • Ch10 : Storage and File Structure
      
9/8  
  • Phase 1
  • Ch10 : Storage and File Structure
  • DB Review
      
9/10  
  • DB Review
  • Phase 1
  • Ch11 : Indexing and Hashing
     Phase 1
9/15

Quiz 1

(Ch 10)
  • Ch11 : Indexing and Hashing
     Phase 1
9/17  
  • Ch11 : Indexing and Hashing
  • Phase 2
  • Quiz 1 Solution
   Phase 2  
  Attendance Reporting (9/20)      
9/22  
  • Ch11 : Indexing and Hashing
  • Phase 2
      
9/24  
  • Ch11 : Indexing and Hashing (zip)
  • Phase 2
      
9/29 Exam 1
  • Ch10, Ch11 (11.1-11.6)
      
10/1  
  • Exam 1 Solution
  • Project Phases
  

Phase 3

Phase 5

Phase 6

 Phase 2
  Application for Graduation Deadline (10/1)      
10/6  
  • Ch 11
  • Ch 12
      
10/8  
  • Ch 12
  • Phases 5 and 6
  • Phase 3
      
10/13  
  • Ch 12 (Part 1 zip)
  • Phases 5 and 6
  • Phase 3
     Phase 5 Pre Proposal
10/15

Quiz 2

(Ch 11.7 till end, Ch 12 part 1)
  • Ch 12 (Part 1 & 2 zip)
  • Phase 4
  • Problem Set 1 due 10/20 (pdf)
   Phase 4 Phase 3
  MidTerm Reports (10/18)      
10/20  
  • Ch 12
  • Quiz Solution
  • Project Phases
      
10/22  
  • Ch 12
  • Project Phases
  • Phase 3 Grading
      
10/27  
  • Ch 12
  • Homework 1 Ch 12 Practice Exercises
  • Phases 4 and 5
     Phase 5
10/29 Exam 2
  • Every thing after Exam 1 till 10/27
      
  Last to Withdraw via E-drop (11/2)
11/3  
  • Phase 4 Discussion
  • Ch 13 Intro
     Phase 4
11/5  
  • Exam 2 Solution
  • Ch 13 (zip)
     Phase 4 (Nov 7 @ 11.59 PM)
11/10  
  • Ch 13
  • Phase 5 and 6
      
11/12  
  • Ch 13
  • Phase 5 and 6
      
11/17  
  • Ch 13
      
11/19  
  • Video Lectures are in SWF format. You need a browser with Falsh Player. Use Firefox. You have to login with your IU credentials (e.g., Canvas Username and Password)
  • Ch14 : Transactions (zip) (Online Video Lecture)
      
11/24        
11/26  
  • Ch15
      
12/1        
12/3  
  • Course Review
     Phase 6
12/8 Final Exam (Ch 13 - 16)