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

 
       Instructor    : Murat Kantarcioglu
        Office Hours & Location  :   Friday 3pm-5pm@ECSS 3.225 

 
       Teaching Assistant  :  Mohammadsaleh  Hosseini  <sxh175430@utdallas.edu>        
       Office Hours & Location  :   Monday 1:45pm-3:45pm@ ECSS 2.104 A1

  Prerequisites                   : CS 5343
 
 

Grading:

• Homework   % 16 (4 homework, each worth 4%)
•   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.24.18	Introduction (slides) ER Model    (slides) The Relational Model and SQL DDL (slides) ER Model Example (slides)
08.31.18	The Relational Model and SQL DDL Relational Algebra (slides) Relational Algebra Example (slides)
09.07.18	SQL (slides) Advanced Sql (slides) SQL examples (slides) (queries) JDBC and Spring Framework: (slides) (code samples)
09.14.18	Overview of  Storage and Indexing(slides) Parameters of Disks
09.21.18	Tree Indexes (slides) Homework One is available on elearning,  due 10/5/18 midnight
09.28.18	External Sorting (slides) Evaluation of Join Operations (slides)
10.12.18	Evaluation of Other Operations (slides) Homework Two is available on elearning, Due 10/26/18 midnight Project Description is now available on elearning. Please follow the deadlines given in the project description
10.19.18	Midterm !!!!
10.26.18	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) Overview of Transaction Management (slides) Concurrency Control (slides)
11.02.18	Crash Recovery (slides) Homework Three is available on elearning, due 11/19/18,  midnight.
11.09.18	Schema Refinement (slides)
11.16.18	Security (slides) SQL Injection attacks. Homework Four is available on elearning,  due 11/30/18, midnight.
11.23.18	Thanksgiving Holiday
11.30.18	In-memory databases and column stores Sap Hana, (overview paper), (slides from SAP) Key-value Stores Big table (overview paper)
12.01.18	Extra Class Today at  10am Map-reduce (overview paper), (slides) In-memory distributed data processing Apache Spark (overview paper) (slides for the paper)
12.07.18	FINAL exam will be administered during the last class.  To comply with university regulations, I will schedule an additional class on December 1 st.