Lectures related to Online analytical processing

Data Warehouses and Decision Support Systems

Explores data warehouses, decision support systems, OLAP, data lakes, multidimensional data models, and query optimizations.

Distributed Query Processing: Execution Models and Declustering Tradeoffs

Covers analytical query processing, declustering strategies, and distributed operations.

Hybrid Transactional and Analytical Processing Systems

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

Explores the micro-architectural analysis of modern DBMS, focusing on performance optimization and data cache stall mitigation.

OLAP Queries: Aggregations, Cube Operator, and Optimizations

Explores OLAP queries, cube operator, super-aggregates, and optimization techniques.

Views: Simplifying SQL Queries

Explores views in SQL, covering creation, materialization, maintenance, cube building, and top-k queries optimizations.

Data Warehousing and Decision Support

Explores data warehousing, decision support systems, and the importance of statistics in data analysis.

OLAP Queries and Optimizations

Covers OLAP queries, examples of comparisons, ranking, and optimizations for query performance.

Data-Intensive Applications and Systems: Overview

Covers the exponential growth of data, challenges in processing technology, data variety, cleaning, approximate query processing, multi-query analytics, and hybrid transaction processing.

Adaptive Sharing in Analytical Databases

Explores adaptive sharing in analytical databases to reduce costs and improve efficiency through novel execution paradigms.

OLAP Data Model: Multidimensional and Relational Approaches

Explains OLAP data models, focusing on multidimensional and relational approaches.

Data Warehousing: Overview and Challenges

Introduces data warehousing fundamentals, challenges, and the innovative concept of a 'lakehouse'.

Data Intensive Applications and Systems: HTAP Overview

Provides an overview of HTAP systems, covering concurrency control, data layout, consolidation trade-offs, and workload-driven snapshot efficiency.

PAX: Hybrid Solution for Efficient Data Storage

Presents PAX, a hybrid solution for efficient data storage, and Parquet, a columnar storage format for Hadoop.

Data Warehouses and Decision Support Systems

Explores views in data warehouses, materialization tradeoffs, top-k queries optimizations, and the impact of column stores.

OLAP: Overview and Queries

Introduces OLAP concepts, schemas, queries, and optimizations for efficient data analysis.

Resource-Efficient DBMS: Incremental Query Processing

Explores challenges in data growth for advertisers and introduces Crocodile DB for resource-efficient query processing.

Operational Analytics: Fresh Data Management Techniques

Covers operational analytics, focusing on the adaptive STEP system for efficient access to fresh data in analytical processing.

Data Management Challenges: Hardware and Query Optimization

Explores hardware changes, query optimization, workload distribution, and effective strategies for academia and work-life balance.

Data Warehouses and Data Lakes

Covers data warehouses, data lakes, OLTP vs. OLAP, data quality, and the Data Lakehouse concept.