Things to Note ...

• Prac P01 now available ... install PostgreSQL
  • special consultation 2-4 tommorrow for install problems (K17-410)
• Quiz 1 ... out next Monday ... due next Friday
• Assignment 1 released soon ... form groups

In This Lecture ...

• Database catalogs (E17, G9.2, R12.1, S11.8)
• PostgreSQL architecture
• Storage: disks and files (E5.2, G15.7, R9.4, S11.5)

Coming Up ...

• Storage: buffer pool/cache (E5.4, G15.7, R9.4, S11.5)
• Storage: page internals (E?, G8.3, R12.1, S11.8)
• Storage: representing tuples (E5.5, G12, R9.6-7, S11.7)
• Relops: scan, sort, project (E5.7-9, G15, R13,14.3, S13.4,6)
• Implementation of relational algebra operations