Visión general | In-Memory Data Management

Las unidades de aprendizaje listadas pertenecen al curso In-Memory Data Management. ¿Desea acceder a todo el contenido del curso?

Inscríbase usted mismo

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

Texto

Course Start Survey

Encuesta

History of Enterprise Computing

Vídeo

Self Test: History of Enterprise Computing

Prueba de autoevaluación

Enterprise Application Characteristics

Vídeo

Self Test: Enterprise Application Characteristics

Prueba de autoevaluación

Changes in Hardware

Vídeo

Self Test: Changes in Hardware

Prueba de autoevaluación

Changes in Hardware 2

Vídeo

Self Test: Changes in Hardware2

Prueba de autoevaluación

Changes in Hardware 3

Vídeo

Self-Test: Changes in Hardware 3

Prueba de autoevaluación

Changes in Hardware - GPU Computing

Vídeo

Self-Test: Changes in Hardware - GPU Computing

Prueba de autoevaluación

Dictionary Encoding

Vídeo

Self Test: Dictionary Encoding

Prueba de autoevaluación

Architecture Blueprint of SanssouciDB

Vídeo

Self Test: Architecture Blueprint of SanssouciDB

Prueba de autoevaluación

Material

Texto

Assignment Week 1

Prueba evaluada

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

Vídeo

Self Test: Compression

Prueba de autoevaluación

Data Layout

Vídeo

Self Test: Data Layout

Prueba de autoevaluación

Row vs. Column Layout (Excursion)

Vídeo

Partitioning

Vídeo

Self Test: Partitioning

Prueba de autoevaluación

Insert

Vídeo

Self Test: Insert

Prueba de autoevaluación

Update

Vídeo

Self Test: Update

Prueba de autoevaluación

Delete

Vídeo

Self Test: Delete

Prueba de autoevaluación

Insert-Only

Vídeo

Self Test: Insert Only

Prueba de autoevaluación

Material

Texto

Assignment Week 2

Prueba evaluada

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

Vídeo

Self Test: Select

Prueba de autoevaluación

Tupel Reconstruction

Vídeo

Self Test: Tuple Reconstruction

Prueba de autoevaluación

Scan Performance

Vídeo

Self Test: Scan Performance

Prueba de autoevaluación

Materialization Strategies

Vídeo

Self Test: Materialization Strategies

Prueba de autoevaluación

Differential Buffer

Vídeo

Self Test: Differential Buffer

Prueba de autoevaluación

Merge

Vídeo

Self Test: Merge

Prueba de autoevaluación

Join

Vídeo

Self Test: Join

Prueba de autoevaluación

Excursion: Hash-based Radix Partition Join

Vídeo

Material

Texto

Assignment Week 3

Prueba evaluada

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

Vídeo

Query Optimization

Vídeo

Self Test: Query Optimization

Prueba de autoevaluación

Query Scheduling

Vídeo

Self Test: Query Scheduling

Prueba de autoevaluación

Indices

Vídeo

Self Test: Indices

Prueba de autoevaluación

Aggregate Functions

Vídeo

Self Test: Aggregate Functions

Prueba de autoevaluación

Aggregate Cache

Vídeo

Self Test: Aggregate Cache

Prueba de autoevaluación

Material

Texto

Assignment Week 4

Prueba evaluada

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

Vídeo

Logging Approaches

Vídeo

Logging Details

Vídeo

Self Test: Logging

Prueba de autoevaluación

Recovery

Vídeo

Self Test: Recovery

Prueba de autoevaluación

Replication

Vídeo

Self Test: Replication

Prueba de autoevaluación

Replication Approaches (Excursion)

Vídeo

Workload Management and Scheduling

Vídeo

Self Test: Workload Management and Scheduling

Prueba de autoevaluación

Multiversion Concurrency Control (MVCC)

Vídeo

Self Test: Multiversion Concurrency Control

Prueba de autoevaluación

Implications on Application Development

Vídeo

Self Test: Implications on Application Development

Prueba de autoevaluación

Predictive Maintenance (Excursion)

Vídeo

Material

Texto

Assignment Week 5

Prueba evaluada

User survey - Video subtitles

Encuesta

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

Vídeo

Self Test: Database-Driven Data Aging

Prueba de autoevaluación

Actual and Historical Partitions

Vídeo

Self Test: Actual and Historical Partitions

Prueba de autoevaluación

What's in it for Enterprises (Excursion)

Vídeo

Genome Analysis

Vídeo

Self Test: Genome Analysis

Prueba de autoevaluación

Showcase: Virtual Patient Explorer (Excursion)

Vídeo

Introduction to Blockchain Technology

Vídeo

Crypto Currencies (Excursion)

Vídeo

Use Cases for Blockchain Technology

Vídeo

What is Machine Learning? (Excursion)

Vídeo

State-of-the-Art in Machine Learning (Excursion)

Vídeo

Reinforcement Learning (Excursion)

Vídeo

Material

Texto

Assignment Week 6

Prueba evaluada

Exam

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

Exam Welcome

Texto

Exam

Prueba evaluada

Survey

Encuesta

Course Statistics

Texto