INTRODUCTION
slides
recording
RELATIONAL MODEL & SQL
SimpleDB OVERVIEW
DBMS ARCHITECTURE
STORAGE
INDEXING
Additional Office Hours / Review
B+ TREE INDEXING
Martin Luther King Jr. Day
BASIC JOIN ALGORITHMS
INDEXING WALKTHROUGH
ADVANCED JOIN ALGORITHMS
QUERY OPTIMIZATION SETUP
add. notes, recording has no audio
QUERY OPTIMIZATION ALGORITHMS
OPERATOR ALGORITHMS
SELINGER OPTIMIZER
TRANSACTION SCHEDULES
TRANSACTION LOCKING
QUERY OPTIMIZATION
TIMESTAMP OPTIMISTIC CC
ALTERNATE OPTIMISTIC CC
UNDO LOGGING
TRANSACTIONS
REDO LOGGING
ARIES CRASH RECOVERY
slides, extra notes
PARALLEL DBMS
UNDO / REDO RECOVERY
DISTRIBUTED EXECUTION
Presidents' Day
USER DEFINED FUNCTIONS
ARIES ALGORITHM
SPARK
TWO-PHASE COMMIT
REPLICATION
PARALLEL PROCESSING
NoSQL INTERNALS
STREAMING DATABASES
NoSQL AND NewSQL SYSTEMS
DISTRIBUTED MANAGEMENT
Class Cancelled