Introduction to Data Management
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.
Remote quarter: This quarter is mandated to have fully online instruction with no in-person meetings permitted. So long as the staff internet connections permit, we will still be holding synchronous lecture/section meetings so that students have the opportunity to ask questions and work together - please do attend and participate! Lecture recordings will be posted if you need to access them asynchronously.
Questions and Comments: If you have any questions or comments about lecture, sections, assignments, quizzes, 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.
For all Zoom links (lecture, section, office hours), please see the Canvas calendar.
CSE 344 Staff
cse344-staff @ cs
Alyssa Pittman (instructor)
smooo @ cs
OH: Wednesday 4:00 pm
Abhishek Shah
ars56 @ cs
OH: Friday 5:00 pm
Eric Yeh
yehe @ cs
OH: Thursday 3:00 pm
Jerome Paliakkara
jeromp @ cs
OH: Wednesday 9:30 am
Khang Phan
kphan000 @ cs
OH: Monday 8pm
Matt Tenczar
mtenczar @ cs
OH: Thursday 10:30 am
Raden Roy Pradana
rrp2901 @ cs
OH: Friday 9:20 am
Samuel Oh
mnkloip @ cs
OH: Tuesday 1:00 pm
Stella Zhang
zhangxru @ cs
OH: Tuesday 9pm
Instruction
Note that all instruction for the quarter is remote. Links to the Zoom meetings and lecture recordings can be found on Canvas.
(Lecture) MWF, 1:30-2:20 (cse344a_sp20 @ uw)
Alyssa
(Section AA) Th, 8:30 – 9:20 AM (cse344aa_sp20 @ uw)
Matt and Raden
(Section AB) Th, 9:30 – 10:20 AM (cse344ab_sp20 @ uw)
Khang and Abhishek
(Section AC) Th, 12:30 – 1:20 PM (cse344ac_sp20 @ uw)
Stella and Eric
(Section AD) Th, 1:30 – 2:20 PM (cse344ad_sp20 @ uw)
Sam and Jerome
Quizzes
Quiz dates are listed on the calendar below. Each one may be completed any time that day.
Learn more about quiz logistics and study resources here.
Calendar
Date
Slides
Reading
Assignments
Wed April 29
16.4.4, optional reading for reference: 15.1,.3,.4.8,.5
Fri May 1
Lecture cancelled - happy "no midterm" day!
Fri May 15
Key-Value and Semi-Structured Data
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)
Week 9
Mon May 25
Memorial Day Holiday
Thurs June 4
Section - Open office hours
Other Resources
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