Material

Please enable Javascript in your browser!!

Learning Material Week 3

On this page, you will find the links to download all material of week 3.

Slides

Go to overview

Week 1
- Welcome
- Course Start Survey
- History of Enterprise Computing
- Self Test: History of Enterprise Computing
- Enterprise Application Characteristics
- Self Test: Enterprise Application Characteristics
- Changes in Hardware
- Self Test: Changes in Hardware
- Changes in Hardware 2
- Self Test: Changes in Hardware2
- Changes in Hardware 3
- Self-Test: Changes in Hardware 3
- Changes in Hardware - GPU Computing
- Self-Test: Changes in Hardware - GPU Computing
- Dictionary Encoding
- Self Test: Dictionary Encoding
- Architecture Blueprint of SanssouciDB
- Self Test: Architecture Blueprint of SanssouciDB
- Material
- Assignment Week 1
Week 2
- Compression
- Self Test: Compression
- Data Layout
- Self Test: Data Layout
- Row vs. Column Layout (Excursion)
- Partitioning
- Self Test: Partitioning
- Insert
- Self Test: Insert
- Update
- Self Test: Update
- Delete
- Self Test: Delete
- Insert-Only
- Self Test: Insert Only
- Material
- Assignment Week 2
Week 3
- Select
- Self Test: Select
- Tupel Reconstruction
- Self Test: Tuple Reconstruction
- Scan Performance
- Self Test: Scan Performance
- Materialization Strategies
- Self Test: Materialization Strategies
- Differential Buffer
- Self Test: Differential Buffer
- Merge
- Self Test: Merge
- Join
- Self Test: Join
- Excursion: Hash-based Radix Partition Join
- Material
- Assignment Week 3
Week 4
- Query Processing
- Query Optimization
- Self Test: Query Optimization
- Query Scheduling
- Self Test: Query Scheduling
- Indices
- Self Test: Indices
- Aggregate Functions
- Self Test: Aggregate Functions
- Aggregate Cache
- Self Test: Aggregate Cache
- Material
- Assignment Week 4
Week 5
- Overview: Logging and Recovery
- Logging Approaches
- Logging Details
- Self Test: Logging
- Recovery
- Self Test: Recovery
- Replication
- Self Test: Replication
- Replication Approaches (Excursion)
- Workload Management and Scheduling
- Self Test: Workload Management and Scheduling
- Multiversion Concurrency Control (MVCC)
- Self Test: Multiversion Concurrency Control
- Implications on Application Development
- Self Test: Implications on Application Development
- Predictive Maintenance (Excursion)
- Material
- Assignment Week 5
- User survey - Video subtitles
Week 6
- Database-Driven Data Aging
- Self Test: Database-Driven Data Aging
- Actual and Historical Partitions
- Self Test: Actual and Historical Partitions
- What's in it for Enterprises (Excursion)
- Genome Analysis
- Self Test: Genome Analysis
- Showcase: Virtual Patient Explorer (Excursion)
- Introduction to Blockchain Technology
- Crypto Currencies (Excursion)
- Use Cases for Blockchain Technology
- What is Machine Learning? (Excursion)
- State-of-the-Art in Machine Learning (Excursion)
- Reinforcement Learning (Excursion)
- Material
- Assignment Week 6
Exam
- Exam Welcome
- Exam
- Survey
- Course Statistics