OLAP Queries and Optimizations

In course

Ea ut id non irure reprehenderit est sit sunt dolor consectetur adipisicing sint. Aliqua consectetur anim pariatur laborum fugiat do sit aliquip velit consectetur ad. Deserunt duis nisi elit nisi ex pariatur tempor ad non officia officia enim. Fugiat enim velit veniam aute. Laboris aliqua adipisicing labore labore est et amet deserunt cupidatat.

Description

This lecture covers OLAP queries, a combination of SQL and spreadsheets for data analysis, including examples of comparisons, multidimensional ratios, ranking, and custom consolidation. It also explains roll-up, pivoting, drill-down operations, and the CUBE operator for computing super-aggregates. The instructor discusses optimizations such as bitmap indexes, join indexes, and star joins to enhance query performance.

Instructor

minim ipsum consequat

Ullamco cupidatat mollit aute esse. Culpa officia consequat velit mollit sit. Non elit mollit ea eiusmod sint ullamco. Pariatur non magna voluptate reprehenderit non consectetur minim. Tempor velit nisi laboris commodo. Ullamco veniam ex in dolor.

Official source

https://mediaspace.epfl.ch/media/0_3nu8n442

About this result

This page is automatically generated and may contain information that is not correct, complete, up-to-date, or relevant to your search query. The same applies to every other page on this website. Please make sure to verify the information with EPFL's official sources.

Ontological neighbourhood

Computer engineering

Databases: Relational databases, Data warehouses

Computer programming: Compilers

Related lectures (48)