Embedded Files
Description: In this course, we will introduce the basics of modern data management. You will learn about schema design, data modeling, query languages, building database applications, transactions, and many other topics. Through lectures, sections, and assignments, you will learn about and understand how real-world data management systems work, and how they touch upon many aspects of our daily lives.
Questions and Comments: If you have any questions or comments about lecture, sections, assignments, exams, or whatever, post on Piazza. This is the fastest way to get in contact with the 344 staff and your peers. You can post privately to just the staff and anonymously to the whole class if you want to. Please note that when signing up for Piazza, Piazza specifies an option (default is to agree) to share your contact information with companies for recruiting purposes. Opt out of this option if you wish. If you need to talk about anything personal or offline, see us during office hours or email the instructor (smooo @ cs) to set up a meeting. And we love feedback! If you have any concerns, comments, or suggestions let us know through this anonymous feedback tool.
For additional details about the class, please refer to the syllabus.
CSE 344 Staff
CSE 344 Staff
cse344-staff @ cs
Alyssa Pittman (instructor)
Alyssa Pittman (instructor)
smooo @ cs
OH: Wed 3:00 - 4:00, CSE 216
Andrew Guterman
Andrew Guterman
anguterm @ cs
OH: Thu 4:30 - 5:30, CSE2 153
Jack Khuu
Jack Khuu
jackkhuu @ cs
OH: Mon 5:30 - 6:30, CSE2 121
Matthew Liu
Matthew Liu
liux44 @ cs
OH: Fri 2:30-3:20 pm, CSE2 150 [Zoom]
Phong Ly
Phong Ly
pdly @ cs
OH: Tue 12:00-1:00pm, CSE2 151
Samuel Oh
Samuel Oh
mnkloip @ cs
OH: Wed 11:00 - 12:00 CSE2 151
Khang Phan
Khang Phan
kphan000 @ cs
OH: Mon 2:30-3:30 CSE2 153
Matt Tenczar
Matt Tenczar
mtenczar @ cs
OH: Th 11:00-12:00, CSE2 153
Eric Yeh
Eric Yeh
yehe @ cs
OH: Tues 10:00-11:00am, CSE2 150
Stella Zhang
Stella Zhang
zhangxru @ cs
OH: Tues 3:30-4:30, CSE2 153
(Lecture) MWF, 1:30-2:20, Kane 220 (cse344a_wi20 @ uw)
Alyssa
(Section AA) Th, 12:30-1:20, MGH 251 (cse344aa_wi20 @ uw)
Andrew
(Section AB) Th, 1:30-2:20, MGH 241 (cse344ab_wi20 @ uw)
Eric, Khang, Matt
(Section AC) Th, 2:30-3:20, JHN 026 (cse344ac_wi20 @ uw)
Jack, Stella
(Section AD) Th, 3:30-4:20, MEB 242 (cse344ad_wi20 @ uw)
Matthew, Phong, Sam
Lecture Resources:
Lecture Resources:
- Jan 6 - Introduction (slides) Reading: 2.1-3
- Jan 8 - SQL basics (slides, demo) Reading: 6.1-2
- Jan 10 - Aggregates (slides, demo) Reading: 6.4
- Jan 13 - Groups (slides)
- Jan 15 - Subqueries (slides) Reading: 6.3
- Jan 17 - SQL wrap up + Relational Algebra (slides, worksheet, solutions) Reading: 2.4, 5.1-2
- Jan 22 - Relational Algebra (slides, worksheet, solutions)
- Jan 24 - Design with E/R Diagrams (slides) Reading: 4.1-6
- January 27 - Design theory (slides) Reading: 3.1-5
- January 29 - Practical data management (slides)
- January 31 - Transactions: Serializability (slides) Reading: 18.1-2
- February 3- Transactions: Locks (slides) Reading: 18.3, optional reading for reference: 18.4
- February 5 - Transactions: Isolation Levels (slides) Reading: 18.4.1-3
- February 7 - Data integrity (slides)
- February 10 - Midterm
- February 12 - Query cost estimation (slides) Reading: 16.4.4, optional reading for reference: 15.1,.3,.4.8,.5
- February 14 - Tuning & indexing (slides) Reading: 8.3-4,14.1-1.7, optional reading for reference 14.2-3
- February 19 - Tuning & indexing (slides) Reading: 15.6
- February 21 - Parallel Processing (slides) Reading: 20.1
- February 24 - MapReduce & Spark (slides) Reading: 20.2
- February 26 - NoSQL (slides)
- February 28 - Key Value, Semi-Structured Data (slides) Reading: https://aws.amazon.com/nosql/ (No need to follow links or read about Dynamo), optional reading: JSON modeling for RDBMS users (skip the "Transforming staging data with N1QL" section at the end, we won't be using CouchDB)
- March 2 - SQL++ (slides) Reading: AsterixDB 101
- March 4 - SQL++ (slides, demo)
- March 6 - Graph DBs (slides, demo)
- March 9 - Graph DBs (slides, demo)
- March 11 - Wide Column Stores (slides)
- March 13 - cancelled
Sections Resources:
Sections Resources:
- Jan 9 - Git and SQLite (slides)
- Jan 16 - Join, Group, Witnessing problem (slides, Worksheet: AA, AB/AC, AD Sol: AA, AB/AC, AD)
- Jan 23 - RA (slides, worksheet, solution)
- Jan 29 - BCNF, Views, and ER (slides, worksheet, solution)
- Feb 6 - Transactions and Isolation Levels (slides, worksheet, solution)
- Feb 13 - Locking (slides)
- Feb 20 - Cost Estimation (slides, worksheet, solution, cost sheet)
- Feb 27 - Parallel Processing and Spark (slides, worksheet, solution)
- Mar 5 - NoSQL, SQL++ (slides, worksheet, solution)
- Mar 12 - cancelled
Assignments
Assignments
Homework
Homework
- HW1 - SQLite - due January 13 11 pm
- HW2 - More SQL - due January 21 11 pm
- HW3 - Advanced SQL - due January 30, 11 pm
- HW4 - Database Design - due February 7, 11 pm
- HW5 - Flight App - milestone 1: due February 18, 11 pm
full app: due February 25, 11 pm
Exams
Exams
There will be a midterm (Monday February 10th in class) and a final (Monday March 16, 2:30-4:20 pm, normal meeting room) for this course. You may have handwritten notes for both exams. For the midterm you will be allowed 1 sheet of notes (front and back). For the final you will be allowed 2 sheets of notes (front and back).
Midterm exam resources
Midterm exam resources
Final exam resources
Final exam resources
Other Resources
Other Resources
Textbook
Textbook
Database Systems: The Complete Book (2nd Edition) <errata>
The library has the following that you might find useful if you require another explanation of a topic.
- Fundamentals of database systems by Elsmasri and Navathe
- Database management systems by Raghu Ramakrishnan and Johannes Gehrke
- Foundations of database systems by Abiteboul, Hull and Vianu
Report abuse