What are the different types of storage modes?

141
7598

There are three standard storage modes in OLAP applications.

1) MOLAP

2) ROLAP

3) HOLAP

When ever the cube process is going on then it process leaf level data(detailed data) and creates Aggregations based on the Aggregation design defined in the cube. Now lets see about these in detail –

MOLAP – Stores Detailed data and Aggregations in the form of binary files and these are completely separate from relational database.

ROLAP – Stores Detailed data and Aggregations in the relational database.

HOLAP – Stores Detailed data in relational database and Aggregations in the form of binary files.

PFB the difference between these three –

Storage Mode Storage Location for Detail Data Storage Location for Summary/ Aggregations Storage space requirement Query Response Time Processing Time Latency
MOLAP Multidimensional Format Multidimensional Format MediumBecause detail data is stored in compressed format. Fast Fast High
HOLAP Relational Database Multidimensional Format Small Fast for aggregated data and Slow when trying to read Leaf level data. Fast Medium
ROLAP Relational Database Relational Database Large Slow Slow Low

There is one main difference between ROLAP and MOLAP i.e ROLAP supports REAL TIME Data where as MOLAP doesn’t. Real time in the sense when a record is inserted into fact table then it should be immediately available for analysis. It doesnot happen if you use MOLAP storage mode and to pull newly added record in MOLAP storage mode we need to process cube. In ROLAP as the data is storing in relational databases, when ever a record is inserted into table it will be available for analysis.

Regards,

Roopesh Babu V

141 COMMENTS

  1. Incredible all kinds of terrific info.
    canadian pharmacy no prescription needed [url=https://canadianpharmacylist.com]online order medicine[/url] online pharmacy no prescription needed

  2. Whoa tons of amazing knowledge!
    common college essay prompts [url=https://writingthesistops.com]https://writingthesistops.com/[/url] university essay writing service

  3. Helpful data. Thank you!
    how to write a literary analysis essay [url=https://quality-essays.com]https://quality-essays.com/[/url] executive resume writing services chicago

  4. Appreciate it! Lots of postings.
    canadian pharmacy uk delivery [url=https://canadianpharmacyonlinedb.com]online pharmacy without a prescription[/url] pharmacies near me

  5. Incredible a good deal of good info.
    online discount pharmacy [url=https://canadianonlinepharmacybase.com]safe canadian online pharmacies[/url] cialis from canada

  6. Thanks a lot. Numerous data.
    write essays for scholarships [url=https://topswritingservices.com]https://topswritingservices.com/[/url] help with writing assignments

  7. Thank you! Awesome information.
    legit essay writing services [url=https://englishessayhelp.com]buy an essay cheap[/url] professional cv and resume writing services

  8. Thank you, Terrific information.
    help on writing an essay [url=https://englishessayhelp.com]how to write an intro paragraph for an essay[/url] writing services online

  9. ly 3xtS6ng Karijssa and kritina shannon nudee ssex Bdsm dungeon llos angeles Rash vagina nose pimples Sexxy flrencia dee saracho. side effects of doxycycline When deciding to test for a given condition, whether it be LB or any other disease, it is important not to only take into consideration what the technical performance of a test is, but to also consider the pre- test probability that the patient has the disease 155.

  10. You revealed that very well!
    how to write a law essay [url=https://englishessayhelp.com]how to write a good essay for a scholarship[/url] help writing a personal statement

  11. Fantastic facts. Cheers!
    canadian pharcharmy online no precipitation [url=https://canadianpharmacylist.com]fda approved canadian online pharmacies[/url] pills viagra pharmacy 100mg

  12. You said it adequately.!
    thesis statement for college essay [url=https://dissertationwritingtops.com]https://dissertationwritingtops.com/[/url] high quality article writing service

  13. Appreciate it! A good amount of data.
    cheap viagra online canadian pharmacy [url=https://rxpharmacyteam.com]online pharmacies canada[/url] order prescriptions online without doctor

  14. Amazing a lot of useful material.
    essays for college admission [url=https://dissertationwritingtops.com]https://dissertationwritingtops.com/[/url] dissertation ghostwriter

  15. You stated that adequately!
    i need help with writing an essay [url=https://homeworkcourseworkhelps.com]https://homeworkcourseworkhelps.com/[/url] write my report for me

  16. You expressed this adequately!
    most reliable canadian pharmacies [url=https://canadianpharmacyonlinedb.com]safe canadian online pharmacies[/url] buy viagra pharmacy 100mg

LEAVE A REPLY

Please enter your comment!
Please enter your name here

− 2 = 7