Multidimensional OLAP Cubes for Business Intelligence

What does OLAP stand for?

• Online Latency And Process

• Online Analytical Processing

• Ontario Lawyers' Assistance Program

• Online Asynchronous Processing

Who's Edgar Codd?

• A database legend

• A character from Tintin

• A corrupted computer scientist

• A former student from Centrale Paris

• The inventor of the term OLAP

What does OLTP stand for?

• Over-speed Transparent Processing

• Orthotopic Liver Transplantation

• Online Transaction Program

• Online Transactional Processing

To record a transaction I should use...

• an OLTP database

• an OLAP database

• either OLAP or OLTP database

• a piece of paper

What are the OLAP challenges?

• Interactive report

• Massive amount of data

• Complex measures

• Curse of dimensionality

What is the "curse of dimensionality" for OLAP database?

• Some witchcraft

• More columns means a lot more possible aggregations

• More rows means an increase of computational time

• Non linear aggregative measures runs in exponential time

Name some OLAP optimizations

• Row store

• Column store

• SSD Computing

• Bitmap Index

• Dictionary Encoding

What is Moore's law?

• The number of transistors on a microchip doubles about every two years

• The CPU performance mark doubles about every two years

• The RAM cost increases about every two years

• The RAM cost decreases about every two years

How much did it cost in 1993 to buy 1GB of RAM?

• $1.000.000

• $100.000

• $10.000

• $1.000

• $100

RAM throughput is at least ______ times faster than SSD SATA

• 2

• 5

• 10

• 100