Lecture

Adaptive HTAP: Elastic Resource Scheduling

Graph Chat

Chat with Graph Search

Ask any question about EPFL courses, lectures, exercises, research, news, etc. or try the example questions below.

DISCLAIMER: The Graph Chatbot is not programmed to provide explicit or categorical answers to your questions. Rather, it transforms your questions into API requests that are distributed across the various IT services officially administered by EPFL. Its purpose is solely to collect and recommend relevant references to content that you can explore to help you answer your questions.

Description

This lecture discusses Adaptive Hybrid Transactional/Analytical Processing (HTAP) through Elastic Resource Scheduling, focusing on the trade-offs in static HTAP designs, hybrid accesses vs copying fresh data, and the use of elastic compute for fresh data locality. It also covers fresh data-driven adaptivity, experimental setup details, and the concept of Adaptive HTAP with predictable interference. The instructor emphasizes the importance of maximizing fresh data locality while managing interference effectively by scheduling workload based on the amount of fresh data.

This video is available exclusively on Mediaspace for a restricted audience. Please log in to MediaSpace to access it if you have the necessary permissions.

Watch on Mediaspace

Official source

Related concepts (13)

Interference (communication)

In telecommunications, an interference is that which modifies a signal in a disruptive manner, as it travels along a communication channel between its source and receiver. The term is often used to refer to the addition of unwanted signals to a useful signal. Common examples include: Electromagnetic interference (EMI) Co-channel interference (CCI), also known as crosstalk Adjacent-channel interference (ACI) Intersymbol interference (ISI) Inter-carrier interference (ICI), caused by doppler shift in OFDM modulation (multitone modulation).

Electromagnetic interference

Electromagnetic interference (EMI), also called radio-frequency interference (RFI) when in the radio frequency spectrum, is a disturbance generated by an external source that affects an electrical circuit by electromagnetic induction, electrostatic coupling, or conduction. The disturbance may degrade the performance of the circuit or even stop it from functioning. In the case of a data path, these effects can range from an increase in error rate to a total loss of the data.

Hybrid (biology)

In biology, a hybrid is the offspring resulting from combining the qualities of two organisms of different varieties, species or genera through sexual reproduction. Generally, it means that each cell has genetic material from two different organisms, whereas an individual where some cells are derived from a different organism is called a chimera. Hybrids are not always intermediates between their parents (such as in blending inheritance), but can show hybrid vigor, sometimes growing larger or taller than either parent.

Eukaryote hybrid genome

Eukaryote hybrid genomes result from interspecific hybridization, where closely related species mate and produce offspring with admixed genomes. The advent of large-scale genomic sequencing has shown that hybridization is common, and that it may represent an important source of novel variation. Although most interspecific hybrids are sterile or less fit than their parents, some may survive and reproduce, enabling the transfer of adaptive variants across the species boundary, and even result in the formation of novel evolutionary lineages.

Online transaction processing

Online transaction processing (OLTP) is a type of database system used in transaction-oriented applications, such as many operational systems. "Online" refers to that such systems are expected to respond to user requests and process them in real-time (process transactions). The term is contrasted with online analytical processing (OLAP) which instead focuses on data analysis (for example planning and management systems).

Related lectures (2)

Hybrid Transactional and Analytical Processing Systems Log in to Mediaspace to watch this video

Explores the challenges of combining OLTP and OLAP systems into a unified system, emphasizing the need for interference-aware resource management.

Micro-architectural Analysis of Database Workloads Log in to Mediaspace to watch this video