Introduction to Database Design (CS 6360) 
 
   Time and Location :  F 10:00am-12:[email protected] 12.210
     
Instructor                             :   Murat Kantarcioglu
Office Hours & Location :   Friday 9am-10am, [email protected] 3.225
 
       Teaching Assistant           :    Nidhi Solanki    
Office Hours & Location : Thursday/Friday 1:00 pm - 3:00 [email protected] 1.202 D

Prerequisites                  :   CS 5343
            
                        

Grading:

  •   Homework   %16 (4 homework, each worth 3.75%)
  •   Project         %24 (Group project (up to 3 people) that requires programming)
  •   Midterm       %25
  •   Final            %35 (All topics covered included)

 

   Course Topics: (tentative)
Methods, principles, and concepts that are relevant to the practice of database software design
including: Database system architecture; conceptual database models; relational and 
object-oriented databases; database system implementation; query processing and optimization; 
transaction processing concepts, concurrency, and recovery; security.
Please see the course syllabus for my details.

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

 Course Outline:

 

08.28.15

09.04.15

  • The Relational Model and SQL DDL
  • Relational Algebra (slides)

09.11.15

09.18.15

09.25.15

10.02.15

  • External Sorting (slides)
  • Evaluation of Join Operations (slides)
  • Homework One is available on elearning,  due 10/16/15 midnight
  • Project Description is now available on elearning.
  • Please follow the deadlines given in the project description

10.09.15

  • Evaluation of Other Operations (slides)
  • A typical relational optimizer (slides)
  • Additional Reading:
    • A query optimization survey (pdf) (INCLUDED in the FINAL !)
    • An overview of query optimization in oracle (pdf)
    • A detailed discussion of query optimization in oracle (pdf)
10.16.15
  • Midterm !!!!
  • Homework Two is available on elearningdue 10/30/15 noon.
10.23.15
  • Overview of Transaction Management (slides)

10.30.15

11.06.15

  • Crash Recovery (slides)
  • Homework Three is available on elearning, due 11/20/15, midnight.

11.13.15

11.20.15

  • Security (slides)
  • SQL Injection attacks.
  • Homework Four is available on elearning,  due 12/02/15, midnight.
11.21.15

11.27.15

  • Thanksgiving Holiday

12.04.15

  • FINAL exam will be administered during the last class. 
  • To comply with university regulations, I will schedule an additional class on November 21st.