Introduction to Database Design (CS 6360) 
 
   Time and Location :  F 10:00am-12:[email protected] 2.305
     
Instructor                             :   Murat Kantarcioglu
Office Hours & Location :   Friday 3:00-5:[email protected] 3.225
 
       Teaching Assistant           :  Yang Jin, e-mail: [email protected]        
Office Hours & Location : Tuesday 1:00-3:[email protected] Clark Center 1.202C

Prerequisites                  :   CS 5343
            
                        

Grading:

  •   Homework %15 (4 homework, each worth 3.75%)
  •   Project         %20 (Group project (up to 3 people) that requires programming)
  •   Midterm       %25
  •   Final            %40 (All topics covered included)
  •   Class Part.  %5   (Bonus for Class Participation)

 

   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.

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

 Course Outline:

 

08.29.14

09.05.14

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

09.12.14

09.19.14

  • Overview of  Storage and Indexing(slides)
  • Parameters of Disks
  • Project Description is now available on elearning.
  • Please follow the deadlines given in the project description

09.26.14

  • Tree Indexes (slides)
  • Homework One is available on elearning,  due 10/5/14 midnight.

10.03.14

10.10.14

  • MIDTERM in Class.

10.17.14

  • 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.24.14

  • Overview of Transaction Management (slides)
  • Homework Two is available on elearning,  due 11.08.14, 11:59pm.

10.31.14

11.07.14

  • Crash Recovery (slides)
  • Homework Three is available on elearning, due 11.21.14, 11:59pm.

11.14.14

  • Schema Refinement (slides)
  • Homework Four is available on elearning,  due 12.02.14, 11:59pm.

11.21.14

11.28.14

  • Thanksgiving Holiday

12.05.14

12.05.14

  • FINAL exam will be administered during the last class. 
  • To comply with university regulations, I will schedule an additional class sometime in November. Date and location will be announced.