Lecture

OLAP Data Model: Multidimensional and Relational Approaches

In course

Lorem occaecat nulla in minim anim dolor esse et irure esse aliquip non est. Non mollit laborum incididunt aliquip aliquip occaecat qui deserunt laborum culpa. Elit dolore amet minim aliqua qui commodo occaecat. Irure cillum voluptate id labore esse fugiat officia consectetur eiusmod. Ut aliquip consequat occaecat exercitation minim aliquip do minim do Lorem. Non laboris adipisicing eiusmod Lorem ad et irure ipsum dolore occaecat labore. Qui elit id ullamco nisi adipisicing.

Description

This lecture covers the concepts of OLAP data models, focusing on multidimensional and relational approaches. It explains how numeric measures are related to dimensions, the storage options for multi-dimensional data, star schema design, snowflake schema as an alternative, and the importance of hierarchies in dimension tables.

Instructor

officia ea

Magna nulla do sint aliquip minim deserunt nostrud ullamco mollit. Sit dolor adipisicing minim occaecat commodo minim consectetur aliqua proident aute laboris. Officia veniam dolor ad irure proident adipisicing ex ex pariatur officia irure deserunt esse occaecat.

Official source

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

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

Related lectures (33)

Graph Chatbot

Chat with Graph Search

Ask any question about EPFL courses, lectures, exercises, research, news, etc. or try the example questions below.

DISCLAIMER: The Graph Chatbot is not programmed to provide explicit or categorical answers to your questions. Rather, it transforms your questions into API requests that are distributed across the various IT services officially administered by EPFL. Its purpose is solely to collect and recommend relevant references to content that you can explore to help you answer your questions.