Material Week 4

Please enable Javascript in your browser!!

Links to all slides and videos of this week can be found here so that you can download them from one page if you have not yet used the links on the individual video pages.

Slides:

Parallel Data Processing
Indices Updated on September 26th, fixed Figures for Chapter in Reading Material.
Join Updated on October 21, fixed Table caption (from valueID to recID)
Aggregate Functions
Parallel Select

Videos:

Go to overview

Week 1
- Welcome to the openHPI Course Archive
- Introduction
- Introduction - Self Test
- New Requirements for Enterprise Computing
- New Requirements for Enterprise Computing - Self Test
- Enterprise Application Characteristics
- Enterprise Application Characteristics - Self Test
- Changes in Hardware
- Changes in Hardware - Self Test
- A Blueprint of SanssouciDB
- A Blueprint of SanssouciDB - Self Test
- Material Week 1
Week 2
- Welcome Week 2
- Dictionary Encoding
- Dictionary Encoding - Self Test
- Compression
- Compression - Self Test
- Data Layout in Main Memory
- Data Layout in Main Memory - Self Test
- Partitioning
- Partitioning - Self Test
- Delete
- Delete - Self Test
- Insert
- Insert - Self Test
- Update
- Update - Self Test
- Tuple Reconstruction
- Tuple Reconstruction - Self Test
- Scan Performance
- Scan Performance - Self Test
- Material Week 2
Week 3
- Select
- Select - Self Test
- Materialization Strategies
- Materialization Strategies - Self Test
- Differential Buffer
- Differential Buffer - Self Test
- Insert-only
- Insert-only - Self Test
- Merge
- Merge - Self Test
- Material Week 3
Week 4
- Parallel Data Processing
- Parallel Data Processing - Self Test
- Indices
- Indicies - Self Test
- Join
- Join - Self Test
- Aggregate Functions
- Aggregate Functions - Self Test
- Parallel Select
- Parallel Select - Self Test
- Material Week 4
Week 5
- Workload Management and Scheduling
- Workload Management and Scheduling - Self Test
- Parallel Join
- Parallel Join - Self Test
- Parallel Aggregation
- Parallel Aggregation - Self Test
- Logging
- Logging - Self Test
- Recovery
- Recovery - Self Test
- On-the-fly Database Reorganization
- On-the-fly Database Reorganization - Self Test
- Material Week 5
Week 6
- Implications On Application Development
- Implications On Application Development - Self Test
- Views
- Views - Self Test
- Bypass Solution
- Bypass Solution - Self Test
- Handling Business Objects
- Handling Business Objects - Self Test
- Excursus 2: Point of Sale Explorer
- Excursus 1: Aggregate Caching
- Material Week 6
Exam
- Course Statistics