OLAP: Overview and Queries

Related lectures (32)

Page 1 of 4

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.