Mediaspace scheduled maintenance: Aug 25, 2026 07:00 - 12:00 AM. During this time, videos will be temporarily unavailable. Check status updates.

Home

Lecture

OLAP Queries and Optimizations

About
Privacy
Disclaimer

Graph Chatbot

Related lectures (52)

Datalog Evaluation with Multi-Stage Programming Log in to Mediaspace to watch this video

Explores Datalog evaluation, DSL embedding, semantics, fixpoint algorithms, and multi-stage programming.

Query Operators: Part 1 Log in to Mediaspace to watch this video

Explores query processing steps, physical plans, pipelined execution, and hashing for projections and joins.

Dataflow: Execution Models for Distributed Computing Log in to Mediaspace to watch this video

Explores the data flow model for distributed computing using RDDs in Spark.

Data Warehouses and Data Lakes Log in to Mediaspace to watch this video

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

VLIW Architectures: Compilers and Instruction Level Parallelism Log in to Mediaspace to watch this video

Covers VLIW architectures and compilers, focusing on instruction level parallelism and optimization techniques.

Programming Models: Overview and Examples Log in to Mediaspace to watch this video

Explores programming models for big data processing, including Spark's RDDs and optimizations.

Data Cleaning Challenges: Optimizing Error Detection Log in to Mediaspace to watch this video

Addresses challenges in data cleaning for analysis, proposing optimizations to reduce processing time.

Algorithms: Efficiency Analysis Log in to Mediaspace to watch this video

Covers the analysis of algorithm efficiency and optimizing code for faster execution.

Query Optimization: Heuristics and Cost-Based Approach Log in to Mediaspace to watch this video

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

Shared-Work Systems: Optimization and Execution Scalability Log in to Mediaspace to watch this video

Explores scalability challenges in shared-work systems, emphasizing optimization and execution, experimental setups, data-query operators, and the impact of schema on learning.

Optimizing Library Interactions: Functionality and Modularity Log in to Mediaspace to watch this video

Explores optimizing library interactions, functionality challenges, and modularity in modern workloads, emphasizing strong boundaries between systems and instruction-level optimizations.

Query Processing: Relational Operations and Models Log in to Mediaspace to watch this video

Discusses query processing models and relational operations, focusing on selections, projections, and joins in data-intensive systems.

Database Management Systems: Overview Log in to Mediaspace to watch this video

Covers database management systems principles, design, implementation, and storage options like flat CSV files.

Materialization Problems in Database Systems Log in to Mediaspace to watch this video

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

Debugging and Optimization Log in to Mediaspace to watch this video

Covers types of errors in programming and emphasizes the importance of debugging and optimization techniques.

Physics-guided NMF for STEM/EDXS Data Analysis Log in to Mediaspace to watch this video

Explores Physics-guided NMF for STEM/EDXS data analysis, covering challenges, optimization, constraints, and advantages of the modelization.

VLIW: Dynamically Scheduled Processors Log in to Mediaspace to watch this video

Explores VLIW processors, focusing on scheduling complexity, ILP limitations, and code bloating.

Relational Query Optimization Log in to Mediaspace to watch this video

Covers relational query optimization, including logical and physical query plans, cost estimation, equivalences, and the System R strategy.

Data-Parallel Programming: Vector & SIMD Processors Log in to Mediaspace to watch this video

Explores data-parallel programming with vector processors and SIMD, and introduces MapReduce, Pregel, and TensorFlow.

Data Warehouses: Introduction and Challenges Log in to Mediaspace to watch this video

Covers the introduction and challenges of data warehouses, including integrating data, managing metadata, and optimizing query performance.

Page 2 of 3