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

 
       Instructor    : Murat Kantarcioglu
        Office Hours & Location  :   Friday 8am-10am@ECSS 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	Introduction (slides) ER Model    (slides) The Relational Model and SQL DDL (slides) ER Model Example (slides)
09.01.17	The Relational Model and SQL DDL Relational Algebra (slides) Relational Algebra Example (slides)
09.08.17	SQL (slides) Advanced Sql (slides) SQL examples (slides) (queries) JDBC and Spring Framework: (slides) (code samples)
09.15.17	Overview of  Storage and Indexing(slides) Parameters of Disks
09.22.17	Tree Indexes (slides)
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	Overview of Transaction Management (slides)
10.20.17	Midterm !!!! Homework Two is available on elearning,  due 11/03/17 midnight.
10.27.17	Concurrency Control (slides)
11.03.17	Crash Recovery (slides) Homework Three is available on elearning, due 11/17/17, midnight.
11.10.17	Schema Refinement (slides)
11.17.17	Security (slides) SQL Injection attacks. Homework Four is available on elearning,  due 11/28/17, midnight.
11.18.17	Extra-class today at ?? at  ?? In-memory databases and column stores Sap Hana, (overview paper), (slides from SAP) Key-value Stores Big table (overview paper) Map-reduce (overview paper), (slides) In-memory distributed data processing Apache Spark (overview paper) (slides for the paper)
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.