Font size
WorksheetsMultidimensional OLAP Cubes for Business Intelligence
Total questions: 14
Worksheet time: 9mins
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
Bitmap index...
encodes each values into binary format
is used to speed up calculations
has been created by Edgar Codd
is used for OLTP databases
Multidimensional cubes are used to...
summarize data
detect outliers
make decisions
drill down on data
What kind of output I can get with a cube?
Pivot Table
Slides
Image
Tableau Croise Dynamique
Which one of those examples are easily done with cubes?
Percent Of Parent
Totals and Subtotals
Sum and Average
Marginal Calculation
