Introduction to Database Systems (CS/SE 4347) 
 
    Time and Location :  MW 5:30pm-6:[email protected] 2.305
     

     
Instructor                          :    Murat Kantarcioglu

     
Office Hours & Location  :    Monday/Thursday 4:00pm-5:00pm @ECSS 3.225

 

 
     Teaching Assistant          :   Raymond Heatherly, [email protected]

     
Office Hours & Location  :   Wed/Thur 3pm - 5pm @ ECSS 4.209
 
     Prerequisites                    :   CS 3345
            
                        

      Grading:

  •   Homeworks %15 (4 homeworks, each worth 3.75%)
  •   Project         %20 (Group project (up to 3 people) that requires programming)
  •   Midterm       %30
  •   Final            %35
  •   Class Part.  %5   (Bonus for Class Participation)

 

     Course Topics: 

      
   Please see the course syllabus for further details (pdf)

 

       

         
         Textbook:    
         
Database Management Systems, Ramakrishnan and Gehrke, Third Edition       
                

Course Outline:

 

08.23.10

08.25.10

  • The Relational Model and SQL DDL (slides)

08.30.10

  • The Relational Model and SQL DDL

09.01.10

09.06.10

  • Labor day no class.

09.08.10

09.13.10

  • SQL cont.

09.15.10

  • SQL cont.

09.20.10

  • Overview of  Storage and Indexing (slides)
    • We will cover chapter 8 and Chapter 10.3-10.7

09.22.10

  • Overview of Storage and Indexing cond

09.27.10

  • Overview of Storage and Indexing cond

09.29.10

  • Overview of Storage and Indexing cond.

10.04.10

  • MIDTERM in CLASS
  • Project Description is now available on Webct.
    • Please follow the deadlines given in the project description.

10.06.10

10.11.10

  • Overview of Query Evaluation cont.

10.13.10

  • Overview of Transaction Processing (slides)

10.18.10

  • Overview of Transaction Processing cont.

10.20.10

  • Concurency Control (Chapter 17.1-17.4) (slides)

10.25.10

  • Concurrency Control (Chapter 17.1-17.4) cont. (slides)

10.27.10

  • Schema Refinement (Chapter 19.1-19.7) (slides)

11.01.10

  • Schema Refinement (Chapter 19.1-19.7) cont. (slides)

11.03.10

  • Schema Refinement (Chapter 19.1-19.7) cont.

11.08.10

  • Security and Authorization (Chapter 21)  (slides)

11.10.10

  • Security and Authorization cont.

11.15.10

11.17.10

  • SQL Injection attacks cont.

11.22.10

11.24.10

  • Map-reduce

11.29.10

  • Map-reduce cont

12.01.10

  • Other map-reduce based cloud computing tools

12.03.10

  • @TI Auditorium, ECSS 2.102 at 9am
  • Review lecture hand written notes (pdf)
12.06.10
  • !!! FINAL EXAM IN CLASS !!!!