Vizier

Juliana Freire, Heiko Mueller @ NYU

Oliver Kennedy @ UB

Boris Glavic, @ IIT

I'm a database researcher

I don't use databases.

Data in my life...

  • Grading: Ruby/Rake + Numbers
  • Graphing: Ruby/Rake/iRuby
  • Log Parsing: Ruby + Java

Where's the SQL?

Grading

  • I can't take the exam, I have a family emergency!
  • Can uhh I get an extension?
  • The rubric for question 4 was wrong!
  • I think I've seen your submission before...

Tons of corner cases

The same happens in ETL, Data Exploration, Data Vis, etc...

SQL


	SELECT student_id, SUM(assignment * weight) / 45
	FROM grades;

SQL


	SELECT student_id, SUM(assignment * weight) / 45
	FROM grades;

Now ignore Bob's grade for assignment 2.

Spreadsheet

StudentA1A2A3
Alice151512
Bob14-15
Carol131514
Dave131511
StudentA1A2A3Average
Alice151512
=AVG(B2:B4)
Bob14-15
=AVG(C2:C4)
Carol131514
=AVG(D2:D4)
Dave131511
=AVG(E2:E4)
StudentA1A2A3Average
Alice151512=AVG(B2:B4)
Bob14-15
=AVG(C2, C4)
Carol131514=AVG(D2:D4)
Dave131511=AVG(E2:E4)

Making spreadsheets lot more like...

The Exception That Improves The Rule

We need to make the same thing easier for SQL!

See how at the demo session!