Comp 305-001/488-305: Database Administration

Spring 2016: Tuesdays, 4:15-6:45, Corboy L08

Week 10

Read in Elmasri & Navathe (EN). Chapters are labeled (7th edition)/(6th edition)
Homework 2, due Tuesday, March 1 (next week)
    EN6 chapter 5 / EN7 chapter 7:
    exercises 5, 6, 7, 8


News story: These unlucky people have names that break computers

One of them is Mrs Jennifer Null.

But how does this even happen? What programmer sees the string "Null" as data input and assumes that represents a Null value?


A rather more obscure news story: rhaas.blogspot.com/2016/03/no-more-full-table-vacuums.html
 
This describes a rather technical fix to Postgres transaction processing. The interesting aspect, to us, isn't what it does, but rather that there is a great deal of interest in using Postgres to handle transaction counts in excess of 2 billion. MySQL? I doubt Oracle would allow it.



Files and Indexes

Continue with secondary indexes (non-clustering)

Query Trees and Query optimization

Explain

Normalization