Introduction to Database Design (CS 6360) 
 
 Time and Location :  F 4:00pm-6:45pm@GR 2.530

 
       Instructor    : Murat Kantarcioglu
        Office Hours & Location  :   Friday 2:45pm-3:45pm @ Online or by appointment

 
       Teaching Assistant  : TBD  

  Prerequisites                   : CS 5343
 
 

 Grading:

• Homework   % 10 (4 homework, each worth 2.5%)
•   Project         % 30 (Group project (up to 4 people) that requires programming)
•   Midterm       % 30  
•   Final            % 30 (All topics covered included)
•   Class attendance %5 (Bonus)
  

   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.25.23	Introduction (slides) ER Model    (slides) The Relational Model and SQL DDL (slides) ER Model Example (slides)
09.01.23	The Relational Model and SQL DDL Relational Algebra (slides) Relational Algebra Example (slides)
09.08.23	SQL (slides) Advanced Sql (slides) SQL examples (slides) (queries) JDBC and Spring Framework: (slides) (code samples)
09.15.23	Overview of  Storage and Indexing(slides) Parameters of Disks
09.22.23	Tree Indexes (slides)
09.29.23	External Sorting (slides) Evaluation of Join Operations (slides)
10.06.23	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.23	Overview of Transaction Management (slides)
10.20.23	Midterm !!!!
10.27.23	Query optimization discussion  (slides) Concurrency Control (slides) Concurrency Example (slides)
11.03.23	Crash Recovery (slides)
11.10.23	Schema Refinement (slides) Functional Dependency Examples (slides)
11.17.23	Security (slides) SQL Injection attacks (slides) Apache Spark (overview paper) (slides for the paper) SnowFlake (overview paper), (Video discussing the paper) (Slides)
11.24.23	Thanksgiving Holiday. Happy thanksgiving.
12.01.23	FINAL exam.