Introduction to Database Design (CS 6360) 
 
   Time and Location :  F 10:00am-12:[email protected] 1.2
     
Instructor                             :   Murat Kantarcioglu
Office Hours & Location :   Friday [email protected] 3.225
 
       Teaching Assistant           :    None   
Office Hours & Location : None

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.25.17

09.01.17

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

09.08.17

09.15.17

09.22.17

09.29.17

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

10.06.17

  • 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.13.17
10.20.17
  • Midterm !!!!
  • Homework Two is available on elearningdue 11/03/17 midnight.

10.27.17

11.03.17

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

11.10.17

11.17.17

  • Security (slides)
  • SQL Injection attacks.
  • Homework Four is available on elearning,  due 11/28/17, midnight.
11.18.17

11.24.17

  • Thanksgiving Holiday

12.01.17

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