Introduction to Database Design (CS 6360) 
 
 Time and Location :  F 10:00am-12:45pm@ECSS 2306

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

 
       Teaching Assistant  :  Mestan Firat (MestanFirat.Celiktug@UTDallas.edu)     
       Office Hours & Location  :   ?

  Prerequisites                   : CS 5343
 
 

 Grading:

• Homework   %20 (4 homework, each worth 5%)
•   Project        % 25 (Group project (up to 4 people) that requires programming)
•   Midterm       % 20  
•   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.27.21	Introduction (slides) ER Model    (slides) The Relational Model and SQL DDL (slides) ER Model Example (slides)
09.03.21	The Relational Model and SQL DDL Relational Algebra (slides) Relational Algebra Example (slides)
09.10.21	SQL (slides) Advanced Sql (slides) SQL examples (slides) (queries) JDBC and Spring Framework: (slides) (code samples)
09.17.21	Overview of  Storage and Indexing(slides) Parameters of Disks
09.24.21	Tree Indexes (slides)
10.01.21	External Sorting (slides) Evaluation of Join Operations (slides)
10.08.21	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.15.21	Overview of Transaction Management (slides)
10.22.21	Midterm !!!!
10.29.21	Query optimization discussion  (slides) Concurrency Control (slides) Concurrency Example (slides)
11.05.21	Crash Recovery (slides)
11.12.21	Schema Refinement (slides) Functional Dependency Examples (slides)
11.19.21	Security (slides) SQL Injection attacks (slides).
11.26.21	Thanksgiving Holiday
11.29.2021	Map-reduce (overview paper), (slides) Apache Spark (overview paper) (slides for the paper) SnowFlake (overview paper), (Video discussing the paper) (Slides)
12.03.21	FINAL exam will be administered during the last class.  To comply with university regulations, I will schedule an additional class on 11.29.2021 5pm.