загальне уявлення | In-Memory Data Management

Перераховані навчальні одиниці належать до курсу In-Memory Data Management. Бажаєте отримати доступ до всього вмісту курсу?

Запишіться самі

Week 1

The first week will give you an understanding of origins of enterprise computing. It is vital to know the historic development which lead to the emergence of current hardware as we know it now in order to understand the decisions made in the past. Many characteristics of current applications, like materialized aggregates and a reduction of detail in the stored information, have their roots in the past. While these measures were helpful in former systems, they form an obstacle which has to be overcome now in order to allow for new, dynamic applications.

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

Within the second week, the differences between a horizontal, row oriented layout and a columnar layout are discussed. Concepts like compression and partitioning are introduced. Based on that, you will get an explanation of the internal steps performed inside the database to carry out the fundamental relational operations insert, update and delete. The week concludes with a fundamental difference of SanssouciDB to most other databases: the insert only approach. Following this concept, we circumvent several pitfalls concerning referential integrity and additionally gain the foundation for a gap-less time travel feature.

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

The content of week 3 focuses on more advanced structures and operations within the database. The differential buffer, a means to prevent frequent resorting of the dictionaries and rewriting of the attribute vectors, is explained in further detail. Subsequently, also the merge process, which incorporates the changes from the differential buffer into the main store, is illustrated. The retrieval of information via the select statement, as well as related concepts like tuple reconstruction, early and late materialization, or a closer examination of the achieved scan speed, are also part of this week's schedule. The description of the join operation, which is used to connect information from different tables, concludes this week.

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

Week 4 is all about aggregation. Aggregations are the centerpiece of every business analytics application. Given that huge impact of aggregates on all parts of a business, it is of great importance to understand what aggregate functions are, why we remove all materialized aggregates and go for aggregation on the fly. You will further learn how to greatly reduce the costs of this on demand approach by using the aggregate cache and understand its connection to the differential buffer and the merge process.

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

Week 5 sheds light on some more inner mechanisms of the database. What happens in emergency situations, when for example the power is turned off? Logging and recovery are vital parts to know in order to understand why an in-memory database is as secure as a traditional disk based one. Further, the benefits of replicas are explained. We conclude the week with an outlook onto the implications that arise with the tremendously increased speed at hands.

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

Week 6 will give some insights going further than the internal workings of a database. We will have a look into trending topics such as machine learning and cryptocurrencies and will relate these recent trends to databases and their applicability within (enterprise) computing.

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

The final exam will cover all content from the previous weeks and test your understanding of the course as a whole.

Exam Welcome

Текст

Exam

Оцінюваний тест

Survey

Опитування

Course Statistics

Текст