Lectures related to OLAP: Overview and Queries

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

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

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

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

Explores how views simplify query writing and are key in data warehouses.

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

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

Covers aggregation queries and sorting of results in Geographic Information Systems.

Explores the support services and environment of Moodle at EPFL, including group modes, admin tools, course management, and user interactions.

Explores active learning in Group Theory, focusing on products, coproducts, adjunctions, and natural transformations.

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.