Term/Acronym dust-off

KPI for Key Performance Indicator

ROLAP - Relational Online Analytical Processing.

ROLAP tools access the data in a relational database and generate SQL queries to calculate information at the appropriate level when an end user requests it.

OLTP, OLAP

Multidimensional OLAP, or MOLAP:

Multidimensional structure is defined as “a variation of the relational model that uses multidimensional structures to organize data and express the relationships between data” (O'Brien & Marakas, 2009, pg 177). The structure is broken into cubes and the cubes are able to store and access data within the confines of each cube. “Each cell within a multidimensional structure contains aggregated data related to elements along each of its dimensions” (pg. 178).

MOLAP vs. ROLAP

Advantages of MOLAP

  • Fast query performance due to optimized storage, multidimensional indexing and caching.
  • Smaller on-disk size of data compared to data stored in relational database due to compression techniques.
  • Automated computation of higher level aggregates of the data.
  • It is very compact for low dimension data sets.
  • Array model provides natural indexing
  • Effective data extract achieved through the pre-structuring of aggregated data.

Disadvantages of MOLAP

  • The processing step (data load) can be quite lengthy, especially on large data volumes. This is usually remedied by doing only incremental processing, i.e., processing only the data which has changed (usually new data) instead of reprocessing the entire data set.
  • MOLAP tools traditionally have difficulty querying models with dimensions with very high cardinality (i.e., millions of members).
  • Some MOLAP products have difficulty updating and querying models with more than ten dimensions. This limit differs depending on the complexity and cardinality of the dimensions in question. It also depends on the number of facts or measures stored. Other MOLAP products can handle hundreds of dimensions.
  • MOLAP approach introduces data redundancy.

Streak, Day 5: 2.81 miles in 27'01" #twit2fit

Yesterday was a "tempo" day--a 1 mile tempo.  Maybe that's an interval.  Needless to say, I thought I could run a 7 minute mile, but I lost the pace at about 4/10 of a mile and struggled to keep a 7'20" mile.

Coming off of that effort with a little bit of pain, I had my physical therapy visit today.  Some of the pain was taken care of, but I still have a little nerve pain.  I still managed my "easy" run tonight, keeping with +0.1 mile per day progression and the +0.1 mph per 1/2 mile for treadmill runs.

Run time:  4/2/2009 6:10 PM

Course: 1% Sole F80

Distance: 2.81 miles

Duration: 27:01

Pace: 9:37 / mile

Shoe: ASICS Gel-1120 (AS12-1)

via RunningAHEAD - Strings_n_88keys's log: View Workout.