CS145 - Fall 2011
Introduction to Databases

Information About the Public Offering

• This website pertains to the Stanford student offering of CS145, not to the public Introduction to Databases class. The website for the public offering is here.

News

• Your final exam scores have been entered into Coursework, and your grades for the class have been entered into Axess. Starting January 3rd you may pick up your graded final exams and a sample solution from the course administrator, Marianne Siroker in Gates 435, between the hours of 10:00-11:00 and 1:30-3:30 most days. Enjoy your winter break.

• A big congratulations to the four winners of this year's AuctionBase Contest. It was an exceedingly competitive year, with many projects that would have won hands-down in past years not getting selected. Here are the winners listed alphabetically, with links to their running projects:

  • Rio Akasaka (grand prize winner)
  • Chris Lewis
  • Kevin Xu
  • Chenyu Yang

Schedule

subject to change

Week	Videos	Classes	Assignments
#1 Sept. 26 & 28	-- Introduction -- Relational Databases -- XML Data	Monday: Introduction to course Wednesday: Industry talks #1 - required    Data management challenges at Facebook & Twitter	Assignment #1 due Oct. 10
#2 Oct. 3 & 5	-- Relational Algebra	Monday: Schema design activity - required Wednesday: Relational algebra activity - optional
#3 Oct. 10 & 12	-- SQL	Monday: Stanford talks - required    Atul Butte (Biomedical Informatics), Josh Walker (Lex Machina) Wednesday: SQL help session - optional	Assignment #2 due Oct. 17
#4 Oct. 17 & 19	-- Relational Design Theory	Monday: SQL activity - optional Wednesday: Project help session - optional	Assignment #3 due Oct. 24
#5 Oct. 24 & 26	-- Querying XML	Monday: Design theory activity - optional Wednesday: Industry talks #2 - required    Data management challenges at Google & @WalmartLabs	Assignment #4 due Oct. 31
#6 Oct. 31 & Nov. 2	-- Unified Modeling Language -- Indexes	Monday: Midterm exam review session - optional Wednesday: Midterm exam - required	Assignment #5 due Nov. 14
#7 Nov. 7 & 9	-- Constraints and Triggers	Monday: SQL vs. XQuery bakeoff - required Wednesday: Research talk #1 - required    Managing uncertain data
#8 Nov. 14 & 16	-- Transactions	Monday: Triggers activity (samples) - optional Wednesday: Project help session - optional	Assignment #6 due Nov. 28
Nov. 21-25		Thanksgiving recess
#9 Nov. 28 & 30	-- Views -- Authorization -- Recursion	Monday: Transactions activity - optional Wednesday: Industry talks #3 - required	Assignment #7 due Dec. 8
#10 Dec. 5 & 7	-- On-Line Analytical Processing -- NoSQL Systems	Monday: Research talk #2 - required    Data provenance; Declarative crowdsourcing Wednesday: Exam review, student project demos - optional
#11 Dec. 12		Monday evening final exam