Lecture

HTAP Workload Spectrum

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 covers the concept of Hybrid Transactional/Analytical Processing (HTAP) workloads, focusing on the freshness requirements dictated by the workload type. Topics include ad-hoc analysis, query batches, freshness metrics, log-structured elastic snapshots, scan throughput, index management, and experimental setups. The speaker discusses the challenges and solutions in optimizing storage tiers, data classification, and snapshot creation for efficient HTAP systems.

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 (32)

Index fund

An index fund (also index tracker) is a mutual fund or exchange-traded fund (ETF) designed to follow certain preset rules so that the fund can replicate the performance ("track") of a specified basket of underlying investments. While index providers often emphasize that they are for-profit organizations, index providers have the ability to act as "reluctant regulators" when determining which companies are suitable for an index.

Passive management

Passive management (also called passive investing) is an investing strategy that tracks a market-weighted index or portfolio. Passive management is most common on the equity market, where index funds track a stock market index, but it is becoming more common in other investment types, including bonds, commodities and hedge funds. The most popular method is to mimic the performance of an externally specified index by buying an index fund.

Stock market index

In finance, a stock index, or stock market index, is an index that measures the performance of a stock market, or of a subset of a stock market. It helps investors compare current stock price levels with past prices to calculate market performance. Two of the primary criteria of an index are that it is investable and transparent: The methods of its construction are specified. Investors may be able to invest in a stock market index by buying an index fund, which is structured as either a mutual fund or an exchange-traded fund, and "track" an index.

Digital asset management

Digital asset management (DAM) and the implementation of its use as a computer application is required in the collection of digital assets to ensure that the owner, and possibly their delegates, can perform operations on the data files. The term media asset management (MAM) may be used in reference to Digital Asset Management when applied to the sub-set of digital objects commonly considered "media", namely audio recordings, photos, and videos.

Content management system

A content management system (CMS) is computer software used to manage the creation and modification of digital content (content management). A CMS is typically used for enterprise content management (ECM) and web content management (WCM). ECM typically supports multiple users in a collaborative environment by integrating document management, digital asset management, and record retention. Alternatively, WCM is the collaborative authoring for websites and may include text and embed graphics, photos, video, audio, maps, and program code that display content and interact with the user.

Related lectures (31)

Storage Hierarchy: Understanding Data Management Systems

Discusses the storage hierarchy and buffer management in data-intensive systems.

Storage: Tree Indexing

Explores storage layers, disk management, flash disks, and B+ tree indexing for efficient data retrieval.

Storage Technologies: Memory Hierarchy and Disk Storage

Explores memory hierarchy, CPU caches, SSD, HDD, and disk storage anatomy.

GPU Advanced: Memory Management and Optimization

Explores advanced GPU memory management, CUDA programming, and data-parallel computing for optimizing performance.

Database Systems: Data Storage