EECS 339: Introduction to Database Systems, Fall 2015

Instructor:Peter A. Dinda (Office Hours: Thursdays 2-5, Tech L463)
Teaching Assistant:Akhil Guliani (Office hours: Tuesdays and Fridays, 10-12, Wilkinson Lab)
Time:Fall 2015, MWF 4-4:50
Optional recitation:Mondays, 5pm (9/28 and 12/7: Tech L440; other dates Tech M152)
Location:Tech M152
Course number:EECS 339
Enrollment Limit:40 (currently 48)

Getting in

The class enrollment was limited to 40 students due to resource limits. There are currently 48 students enrolled with 21 on the waiting list (which hit the limit of 50). This course will not be expanded. As students drop, students in the waiting list will be let in, with first priority given to CS and CE undergraduates.

Communication

We will use Canvas to disseminate grades, but for nothing else.

We will use Piazza for class discussions: EECS 339 Piazza Site

Directing your questions to Piazza will likely produce the fastest response, and everyone else in the class will also benefit.

I will occasionally send emails to everyone registered using CAESAR. These emails will go to the addresses that CAESAR has.

General Handouts

  • Syllabus
  • Using Databases in the Web of Things Environment
  • Gentle Introduction to SQL
  • Perl in a Nutshell
  • JavaScript Model in a Nutshell
  • JavaScript Tutorial
  • The T-Lab and Wilkinson Lab
    If you do not already have a T-Lab/Wilkinson Lab Linux and Windows account, you should get one now. You will these labs convenient places to work, especially with partners.
  • We recommend you use ssh (remote login) or VNC (remote graphical desktop) to access the class servers. To get started with VNC, ssh into the server and run ~pdinda/339/HANDOUT/vnc.pl.
  • Pointers to videos on getting started are available on Piazza.
  • Projects

  • Red, White, and Blue (pdf) Due on October 14
  • Financial Portfolio (pdf) Due on November 11 (revised date)
  • BTrees (pdf) Due on December 2
  • Homeworks

  • HW 1: Entity-Relationship data model (pdf) Due on October 19
  • HW 2: Relational data model (pdf) Due on October 28
  • HW 3: Relational algebra (pdf) Due on November 13
  • Exams

  • Midterm (Thursday, October 29, Tech A110, 6pm - 90 minute exam)
  • Final (Thursday, December 10, Tech M152, 7pm-9pm - 90 minute exam, not cummulative)
  • Useful Additional Content

  • Phillip Greenspun's SQL For Web Nerds Book, which we will make use of early in the class.
  • A Gentle Introduction to SQL, which has tutorials and examples of the slight differences in SQL from RDBMS to RDBMS.
  • Introduction to Unix (Peter Dinda) (video, part 1, video, part 2) (use your netid to accesss)
  • Fabian Bustamante's List of C and Unix Resources, which may help you if you are unfamiliar with getting around on Unix.
  • Cloud Computing and Google Spanner (Kyle Hale and Maciej Sweich) (pdf)
  • PHP for Active Content (David Choffnes) (slides, video, (code (intro.php and serveImage)) (use your netid to accesss)
  • Java Servlets and Server Pages (Andrew Simpson) (slides, video) (use your netid to accesss)
  • Peer-to-Peer Databases Lecture (Ashish Gupta, David Huber, Jay Bruins) (slides-1, slides-2, Real) (use your netid to accesss)
  • Comer's Ubiquitous B-Tree Paper
  • E.F. Codd's seminal paper on the relational data model
  • Johan Vromans's Perl Reference Guide
  • An older version of JavaScript: The Definitive Guide, appears to be available for free online as part of the Web Programming CD Bookshelf 1.0

  • Peter Dinda
    Last modified: Wed Nov 11 18:22:48 CST 2015