Lectures related to AQP and Modern DBMS

Explores optimizing recursive queries in database systems using Datalog and semirings, discussing the challenges and solutions in data analytics.

Covers data wrangling techniques using Hadoop, focusing on row versus column-oriented databases, popular storage formats, and HBase-Hive integration.

Explores the evolution and taxonomy of memories, focusing on SRAM and DRAM differences, memory layout, and functional taxonomy.

Covers data wrangling techniques using Apache Hive for efficient big data management.

Covers Spark Data Frames, distributed collections of data organized into named columns, and the benefits of using them over RDDs.

Delves into advanced Spark optimization techniques, emphasizing data partitioning, shuffle operations, and memory management.

Explains the design model for managing interactions in small games with actors.

Explores static analysis techniques like AST-based analysis and taint analysis applied to the Amy language.

Explores managing large codebases, higher abstraction levels, CodeDB, Datalog queries, and program analysis.

Explores query optimization principles, challenges in cardinality estimation, and the impact of errors on plan selection.

Explores code generation, performance optimization, and compilation trade-offs in DBMS.

Explores database query optimization, discussing static versus dynamic optimization, scan sharing, and the impact on DBMS performance.

Discusses materialization challenges in databases, query execution strategies, and performance implications.

Explores optimizing storage with NVMe arrays in DBMS, comparing in-memory and on-disk operations.

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

Explores cost-based query optimization in database systems, covering cost estimation, selectivity estimation, and join cardinality.

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

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

Covers the basics of storage technologies and database system architecture.

Covers efficient GPU-accelerated join optimization for complex queries, focusing on improving optimization times and heuristic plan quality.