HiveBrain v1.2.0
Get Started
← Back to all entries
patternMinor

What advantages does in-memory OLAP have over traditional systems with significant memory?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
traditionalwhatadvantageswithsystemsolapdoesmemoryoverhave

Problem

Do in-memory OLAP engines have advantages over the traditional OLAP engines backed by enough RAM to contain the entire cube(s)?

For example, if I use a MOLAP engine (SSAS) and GB / TB of RAM where the entire cube (or even star-schema) is RAM resident, what is the difference compared to something like TM1 / SAP HANA?

Solution

Databases designed with the assumption that they will be entirely resident in main memory can use structures such as T-tree indexes. But the real advantage is, IMDBs are just simpler. They do less (as they don't have to worry about managing a cache, or serializing writes for consistency, or anything to do with ACID-compliant I/O at all) so they execute fewer instructions on the hardware to carry out the same "work". A general-purpose database has to be all things to all people; like a Leatherman has a dozen tools, but sometimes you just need a cutting edge, so you buy a blade from Cold Steel, and no-one debates that it is a better knife!

Context

StackExchange Database Administrators Q#7600, answer score: 5

Revisions (0)

No revisions yet.