CS 4320: Introduction to Database Systems (Fall 2017)

Course Information (hide)

CS4320/CS5320 is an introduction to relational database systems, NoSQL systems, and Big Data. Topics covered include the relational model, SQL, query processing and optimization, transactions, recovery, NoSQL systems, database design, and Map Reduce. The accompanying practicum course is CS 4321/5321. The course policies are available here: http://www.cs.cornell.edu/courses/cs4320/2017fa/CoursePolicies.htm .

Announcements (hide)

No announcements have yet been posted.

Assignments (hide)

  Due Max High Mean Median Deviation Status
Homework 1 September 27, 2017 11:59PM 100 100.0 89.9 95.0 15.3 Graded
Homework 2 October 20, 2017 11:59PM 75 75.0 66.0 70.0 14.2 Graded
Homework 3 November 8, 2017 11:59PM 100 100.0 93.0 95.0 12.8 Graded
Prelim November 11, 2017 11:59PM 50 48.0 38.0 39.0 6.5 Graded
Homework 4 November 20, 2017 11:59PM 100 100.0 91.8 95.0 15.2 Graded
Homework 5 December 3, 2017 11:59PM 100 100.0 93.2 97.0 14.9 Graded
Final December 7, 2017 02:00PM 120 118.0 91.0 94.0 17.4 Graded
iCal Download
Click an assignment's name to see related files and other assignment-specific details.   

Surveys (hide)

No surveys are currently posted.


Slides (hide)

Date Slides Description
12/07/17 Final with Solution
11/30/17 Preparation for final
exam
11/29/17 MR Finalized
11/27/17   MR Ctd.
11/20/17 NewSQL + Map
Reduce
11/17/17 NewSQL
11/15/17 Eventual
Consistency
11/13/17 Distributed DBs
11/10/17   Recovery -ctd.
11/08/17 Recovery
11/06/17 Isolation Levels
11/01/17 Locking Ctd.
10/30/17 Locking
10/27/17 CC
10/25/17 CC
10/23/17 Transactions
10/16/17 FDs, Normal Forms
10/13/17 FDs
10/11/17 ERs ctd.
10/09/17   ERs
10/04/17 Operators + Query
Optimization
10/02/17   Relational Operators
Ctd.
09/29/17 Relational Operators
Ctd., Optimization
09/27/17 Join Operators
09/25/17 Relational Operators
09/22/17 External Sorting
09/18/17 Hash Indexing
09/15/17 Tree Indexes
09/13/17 Hardware Managers
09/11/17 Storage Hardware
09/08/17 Relational Algebra ctd.
09/06/17 Relational Algebra
09/01/17 SQL Examples
08/28 Even more on SQL
08/25/17 More on SQL
08/23/17 Intro to relational DBs and SQL