OLAP: Overview and Queries

Related lectures (32)

Page 2 of 4

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

Covers query processing with relational operations, including query optimization and different join algorithms.

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

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

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

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

Covers the origins and types of NoSQL databases, focusing on MongoDB and CRUD operations.

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

Explores the homology of Riemann surfaces, including singular homology and the standard n-simplex.

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